SAP Treasury and Risk Management Tables

Are you looking for the right table related to SAP Treasury and Risk Management Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Treasury and Risk Management (FIN-FSCM-TRM) module.

Top 10 tables in Treasury and Risk Management

TableDescription
TXV11Translation table for partner-partner relationship
TZC37Financial Assets Management status definition
TW14Table for storing offer reasons
TW08Fin.acctng group
TZ01Table for maintenance of ratings
TTCPOPrint parameters for each sub-application
TRPAT_INIT_CLASSAdjustment of Initial Classifier
TXV01Forms of address key translations
TW17Blocking flag
TTMC_COPY_ULTransfer Administration Fields to Excercise Transaction

List of tables in Treasury and Risk Management

TableDescription
TXV11Translation table for partner-partner relationship
TZC37Financial Assets Management status definition
TW14Table for storing offer reasons
TW08Fin.acctng group
TZ01Table for maintenance of ratings
TTCPOPrint parameters for each sub-application
TRPAT_INIT_CLASSAdjustment of Initial Classifier
TXV01Forms of address key translations
TW17Blocking flag
TTMC_COPY_ULTransfer Administration Fields to Excercise Transaction
TTXSADARWIN text interface: Document groups
TZ10Customer application type
TRPAC_DFLT_GRPDefault Type Group
TW50Table for possible deposit types
TW16References between product type and security classification
TWL3List Display Sequence (Position List)
TYC_BSPRD_MDBasis Spreads: Market Data
TZ10TCustomer application type (text)
TZV01Form-of-Address Key
TZUNICurrency units
TZD0BDarwin: Customer default values per co.cd/trn.type for KNB1
TZT01Derivation rules for tax flows
TRPAT_BM_DEFDefine the level of the Business Model
TZKVCorrespondence activities
TW18TText table for TW18 SCB indicators
TRPAS_BTC_PREVBustranscat Exceptions for Stage Transfer
TZB09Posting control table
TWL1TTexts for TWL1 (Sort sequence)
TRPAT_WRO_LA_VALIndicator for write-off and target loss allowance value
TW15Reference between product type and repayment type
TZ24Relationship key contracting party classification
TW08TFin. acctng group (Text)
TZD1Value table for intra-entity loan groups
TREAC_ATTR_MAttribute Values For Medium Attributes
AT15Treasury: Foreign exchange swap rates
FTR_FP_DEFFinancial Position Definition
TZRETExternal roles (Texts)
INDEXWIndex Values (Secur. Index)
ATCVOExchange Rate Volatilities
INDEXZAllocations for datafeed
TZ12TChanges in net assets (Text)
TRPAT_TARGET_STATarget stage for stage transfer
REGTS_F_DISTRIBF Distribution Table
TREAC_CLEAR_OPTTreasury: Cent.Clearing Option per Comp.Code/Prod.Tp/TransTp
FTR_FP_GRP_DEFFinancial Position Group Definition
TREAC_SR_UPD_TYPobsolete - TREA: Specify Update Types for Summary Statemts
TRPAC_POS_CLS_VLValue Table for Position Classifier
TW52Market sectors
TBACT_MIC_HANDPLAssignment of Exchange to Market Identifier Code
TREAC_DFLOWTYPETreasury: Specify Update Types for Central Clearing
FTR_FP_SELFinancial Poistions Selections
TREAT_SUBTOTAL_CTREA: Subtotal Components
TZPLPFinancial Assets Management Plausibility Checks
FXM_RP_SEL_PARAMRequest Parameter Selection Parameters
TZB0TFlow types text table
TOEC_DESIG_TYPEDesignation Type
TZRR0Treasury: Valuation Areas
ATPRATreasury: Clearing Account for Payment Requests
TZDEATrader register
TZRIInternal role of partner
TW03Details about structure of shareholding
TREAT_CASH_POSTREA: Cash Position
TREAT_MLM_CALRUNTreasury MLM Calculation Run
TYC_CSPRD_MDCredit Spreads: Market Data
TCURBExchange Rate Calculation Indicator
TZD1TText table for table TZD1
FXM_KF_GRP_DEFKey Figure Group Definition
TRPAC_REPLACEStage dependent replacement of Loss Allowance Update Types
SANO1Address-object relationship
TZKVTCorrespondence activities (texts)
TWBBBAllocation of program-internal flow types
TTXBFCorrespondence Interface: Definition of Letter Categories
TZB0IFlow type groups text table
THMBUC_HRSTRATDefault Hedge Strategy for Bucket in Hedge Management
TW20Security category
TREAC_UPTYP_SUSTTREA: Specify Update Types for Summary Statements
TXV02Translation for saluation key
TZRITPartner internal role (Texts)
TCRT_CTY_FWDRATEMarket Data for Forward Rates (obsolete)
VZSORTSort values for object
TZST1Reasons for reversal (Text table)
TZ02TLegal Entity (Text)
TREAT_CLEAR_ACCTreasury: Clearing Account Specific Data
TZB07Flow types relationship key
TRBAC_ASSIGN_TPossible values for field ASSIGNMENT (text table)
TREAC_MLM_SCNT_TTREA: Margin Limit Scenarios
TRPAC_DFLT_GRP_TDefault Type Group Text
TRPAC_PS_CL_ODRDefinition of Position Classifier Relevant Settings
TWL3TTexts for TWL3 (Position list output sequence)
TREATS_MLM_ACTGYTREA: Amount Categories for MLM Rules
TZWR1Valuation in sec.acct position
TZWR0Valuation in cross-depot
TZV04Key for partner share types in objects
TOET_TQ_UPDATEOverwrite Target Quota
VVWKN1OBSOLETE - Fields as factors for secondary data
TOET_LAYOUT_PERLayout (Periods Table)
TW04Legal form (Plc, Corp, Ltd...)
VZDFELDAttributes for output fields
ALERT_TAB_MAPOBSOLETE
TREAT_KEY_FIGUREProvides Key Figures for TREA
TREAT_MLM_PRCLOGTreasury: Margin Limit Result Procedure Log
TD05T_ATIS-IS: Texts for TD05_AT
VVWL8Output sequence
TZCURC_EUEMU Basket Currencies
VZBAVSTBAV data change - NOT USED
TZR3Application area / external role allocation
TZRGGrouping of external roles (in application)
TREAC_MLM_SCENTREA: Margin Limit Scenario Step
TZB10Flow type groups check table
ATVO2Descriptions of Volatility Types
TREATS_MLM_RULETREA: Margin Limit Rule Value
TOET_HA_HREQHA: Automated Hedge Request Settings
TW20TSecurity category (text)
TW50TTable for possible deposit types TEXT
TW01Classification of bonds
FXM_TCURL_DISPDisplay settings for Currency Pairs
TREAT_EXT_ACCTreasury: External Account General Master Data
TREAT_SUBTOTALTREA: Position Subtotal
TZRGTGrouping of external roles (Texts)
TOEC_TQ_TYPETarget Quota Type
TZV06Internal position/employee group
UAP_FAVORITESUser-Specific Settings
TTXSTISIS: Document groups (descriptive text)
TPIT_FULFILLMENTTrade Request incl. fulfilled transactions
TDZWTIS-IS: Payment terms with adjustment days
TZK07Condition type-dependent detailed description skopo
VVWKN7Charact.group - Secondary values alloc. (via the inv.no.)
TREAC_ATTR_SUFFAttribute Suffix
TW03TText table for TW03 (Investment structure)
JBC_CCURVE_TYPETCommodity Curve Type Text Table
TRCOCC_QUOTNAMCommodities: Quotation Names
TREAC_SR_BNDRTREA Summary Statement Customizing for Boundaries of Deltas
TREAC_DER_FTYPESTREA: "Derived" flowtypes for Aggregation/Netting
TRPAC_SUT_ASSGNUpdate Types for Classifier Transfer
TZ02Legal entity
TZV03Object categ.for objects which addresses can be assigned to
TREATS_MLM_CTGYTREA: Marging Limit Rule Category
TWL2SSpecial group key sort sequence
TZZKDIS-IS: Business trans./Role alloc. --> Doc.category
JBD1Yield Curve Types, Header Table
TFFILEUpload data file
TREAT_ASSIGNMENTTreasury: TREA Assignment
TZ12Changes in net assets
TWH01Stock exchange table
TW56TSecurity price type - Text table
TD21TReasons for generating incom.pmnts immed. (texts)
TREAC_MLM_COCODETREA: Activation of MLM for Company Code
VZWVACheck table for deadline monitoring
TZUNITCurrency Units - Texts
TZAFProduct categories
FXM_BSRBalance Sheet Exposure Hedge Request
TW04TText table for TW04 (Legal form)
TZRR2Treasury: Valuation Areas at Company Code/Product Type Level
TWZ10Event groups (summarization of values (temporary))
TOET_FIL_DEFExposures Filter Definition
TVZ05Inc. Pmnts: Editing per Activity Type (Loans, Real Estate)
TZT15Info. in acc.with §18 German banking act (Texts)
ATRASTreasury Rates Table
TYC_BSPRD_DEFBasis Spread Definition
TOET_HREQ_HEADERHA: Automated Hedge Request Header
TRPAC_POS_CLS_VTTexts for Position Classifier Values
TREAT_MLM_SCENTREA MLM: Assign Scenario to External Account
TZV13Search and replace strings for phonetic partner search
JBDT56PReference interest rate table dependent on exact time
FTR_FP_WHERECONDWhere conditions for Financial Positions
TREAC_MLM_REASONTREA: Margin Limit Reason
TOET_LAYOUT_MAINLayout (Main Attributes)
TZPABFinancial Assets Management product types
FXM_KF_SELKey Figure Selections
INDEXAIndex types
TW54Price notations
TZRR1Treasury: Valuation Areas at Company Code Level
TDO9Heritable Building Right Indicator for Collateral Objects
VDCSPREADCredit Spread per Loan
TRBAC_FLDCHK_ACTActivate Check of Entered Values for Product Types/Fields
TZRPTValuation principle description
ATVO1Volatility Types 1
TW55Price markdowns
FTRC_FS_GEOT005Assignment of geo-coordinates to countries
REGT_DATA_POINTSData Points of Regression Calculation
TOET_HEDGINGAREAHedging Area (including Description)
TOET_TQ_TYPE_USEUsed Target Quota Types
UAP_PREFERENCESUser-Specific Settings
TRCOCC_QUOTNAM_TTexts for Quotation Names
TRPAC_PM_PROCChanges to pm procedure due to position classifier
TRPAC_DFLTGRPASGAssignment of Default Types to Default Type Groups
SPKR1Partner-Vendor relationship
FXM_RP_DEFRequest Parameter Definition
FXM_RP_GRP_DEFRequest Parameter Group Definition
JBD16CURRReplacement of currencies for yield curve types
AT32Control indicators for financial mathematic calculations
TREAC_UPTYP_LIMUTREA: Update Types for MLM Limit Utilization
TREAC_ATTR_S_TTexts For Attribute Values For Short Attributes
FXM_KF_DEFKey Figure Definition
TOET_HA_CLASSHedging Area Organized Exposure Category Relevance
TREAC_UPTYP_PADJTREA: Update Types for MLM Summary Statemnts adjusted PayAmt
TOET_HREQ_DEALHedge Request Deals
TDINTEBTName for Internal Level of Financial Assets Management
TOET_PLAN_EL_ITPlaning Element Item
TOET_EXP_ITEMOrganized Exposure Items
THERKPrice source
TCRC_CSPR_TYPE_TCredit Spread Type - Texts
TREAT_FUT_DIFFTreasury: TREA Differentiation for Deal Position
REGTS_T_DISTRIBT Distribution Table
FTVVT_KWG_MDMaster Data for KWG Relevant Business Partners
FRWRDDATESStart and End of Term of a Forward Transaction
TOET_TEMPTemporary Table
T068BText table for T068A
TRCCT_CURRCHANGECurrency changeover
TD05Target group table
TOEC_SOURCEExposures Source Table
SPBB1Partner-Bank relationship
TDINTEBInternal Level of Financial Assets Management
TOET_SNAPSHOTSnapshot
JBD14Yield Curve Types (Header Information)
TOET_TIME_GRIDTime Pattern for Target Quota Definition
TD05TTexts for table TD05 target groups
TD05_ATIS-IS: ÖNB-Target groups
TREAT_STATEM_HDRClearing Account Statement Header
TOET_DESIG_LEVELLevel of Designation
TREAT_FLOW_PMTreasury: TREA Flow Payment Details
SANS1Address table
TRBAC_INT_REFPossible values for field "Internal Reference"
TRCOCC_QUOTSRCCommodities: quotation sources
TREAT_MLM_RESULTTreasury: Margin Limit Result Entity
TPIT_ACTION_HISTAction History for Trade Requests
TOET_PLAN_ELPlanning Elements
TPIT_TRADE_REQTrade Request
TDZWIS-IS: Payment terms with adjustment days
TOET_TARGETQUOTATarget Quota Definition
TRBAC_CHARAC_TPossible values for field CHARACTERISTICS (text table)
TOEC_HREQ_BASEHedge Request Base/Reason
FXM_SNAP_ITEMSnapshot Item (Balance Sheet FX Risk)
JBDRATEBARDeviation range of ref. int. rates depend. on exact time
TCRT_CTY_PROVIDTMarket Data Provider for Commodity Forward Rates (Texts)
TDBBBAllocation of program-internal flow types
JBD15Yield Curve Types (Values)
TREAC_UPTYP_PAY0obsolete - TREA: UpdTypes for MLM SummStatemts w/PayAmt = 0
BCKTRDT_MULTASSGMultiple Account Assignment of Flows
FTRL_FS_GEOT005Geo-location data for countries
TREAC_ATTR_M_TTexts For Attribute Values For Medium Attributes
TOET_GEN_SELOrganized Exposure General Selections
TCRC_CTY_PROVIDRMarket Data Provider for Commodity Forward Rates
TOET_HDG_AREAHedging Area (Header) - obsolete
TRPAC_CUT_ASSGNUpdate Types for Contract Modification
BCKTRLT_VCL_FLOWFlows Valuation Class Transfer
TOET_HA_VERSIONSHedging Area Versions
THMBUC_PRTYP_ASSAssignment of Product Type to Hedge Risk Category and CoCode
AT56RSupplements to Analysis System for Table T056R
FXM_RP_SEL_OPTNRequest Parameter Selection Option
TMDFACTTYPFactor Types
TRCOCC_QUOTTYPECommodities: quotation types
TRCCC_DFTASSUpdate Types for Account Assignment Reference for CC
TREAC_ATTR_DESCDescription Of Free Position Account Attributes
TOEC_HA_AUTH_G_THedging Area Authorization Groups
SFTR_ALERTS_PARAOBSOLETE
T037RTexts for T037S
TREAT_FHA_DIFFTreasury: TREA Differentiation for Deal Position
JBD1TYield Curve Types (Texts)
TREAT_MLM_AMOUNTTREA: Margin Limit Amounts
TREAC_NET_FTYPESTREA: "Derived" flowtypes for Netting
TRCCT_TRANSCurrency Changeover Transaction
TOET_LAYOUT_FILFilter used within Layout
TOET_FIL_SELOrganized Exposure Filter Selections
TPRZ1Partner-Object Relationship
REGT_REGR_DATAParameters & Output Data of Regression Calculation
TRCOCC_QUOTSRC_TTexttable for commodity quotation sources
TREAT_FLOWTreasury: TREA Flows
TRCCC_FT_ORIAssign Update Tyes for Currency Changeover Transaction
TREAC_ATTR_L_TTexts For Attribute Values For Long Attributes
BCKTRLIT_AD_TRANAccrual/Deferral Business Transactions Backup
TRBAT_DO_REFDependent Object Containing References
TFKY4Serves as check table for depos. bank help-view structure
TOET_LAYOUT_REFLayout (Differentiation Criteria Table)
FTHMB_COMP_MODEAssignment of compare mode
TOET_DESIG_SPLITDesignation Splitting
TOET_HREQHedge Request (Main Table)
TOET_HA_RCURRHedging Area Risk Currencies
TDO9TType of Heritable Building Right (Descriptions)
TREAC_AGR_FTYPESTREA: "Derived" flowtypes for Netting
JBC_CCURVE_TYPECommodity Curve Type
TDB1Flow types for incoming payment rejections
TOEC_HREQ_BASE_TText table for Hedge Request Base/Reason
FXM_SNAPSnapshot (Balance Sheet FX Risk)
TOET_DIFF_CHARDifferentiating Characteristics
TOET_LAYOUT_KEYFLayout (Key Figure Table)
TREAC_EA_POSTDefines in which way flows of an EA should be posted
TREAT_CLEAR_ASGTreasury: Central Clearing Assignement
TOEC_HA_AUTH_GHedging Area Authorization Groups
TRBAC_CHARACPossible values for field CHARACTERISTICS
TREAT_STATEM_ITMClearing Account Statement Detail
TOET_HA_MAINDATAHedging Area Main Data
TRCOCC_QUOTTYP_TCommodities: quotation types
TREAT_EXT_ACC_PMTreasury: External Account Payment Details
JBD11IS-B: Extended interest rate table
TOET_DESIG_CTRLDesignation Control
TZB0GTexts for relationship indicators
VZPARZAPartner addit. data (general part)
TW01TText table for TW01 (Classification of bonds)
VZGPOPartner/role object relationship
TZFBTText table for TZFB Calculation base
TRPAT_CONTR_MODIClassifier Transfer Transaction Table
TW54TPrice notations - Text table
TZV11Relationship category of partner-partner relationship
TZBZCompany code: Additional data
TZK0GTexts for condition type-dependent detailed description
VVZSFELDInternal transfer structure for VZSFELD
VZZKOPOTable condition items
TW21TFund category (text)
TRPAT_POS_CLASSPosition Classifier
TZD37Texts for TZC37
TYC_REF_ENT_DEFReference Unit Definition
TREAC_MLM_RSN_TTREA: Margin Limit Reason Text
TREAC_ATTR_LAttribute Values For Long Attributes
TREAT_SUMMARYTreasury: Summary Statement
TMDFACTTYPETDescription for Dividend Factor Type
THMBUCActivation Bucket in Hedge Management
TOET_FLOWOrganized Exposure Flows
TOEC_CLASS_TText Table for TOEC_CLASS
TREAC_ATTR_SAttribute Values For Short Attributes
T068AExchange rate indicators
TRBAC_INT_REF_TPossible values for field "Internal Reference" (text table)
TD21Reasons for generating incoming payments immediately
TOEC_DESIG_TYP_TDesignation Type
TOET_LAYOUT_DIFLayout (Differentiation Criteria Table)
TDXBLDocuments not updated which are sent to the R/2 system
TOET_HREQ_RELHedge Request Relationships
TW53TListing key - Text table
TRBAC_ASSIGNPossible values for field ASSIGNMENT
TRBAT_VERSIONVersion
TOEC_SOURCE_TText Table for TOEC_SOURCE
TZV0FInternal position/employee group text table
TRPAT_POS_FLOWClassifier Transfer Flow Table
T037SAccount Assignment References acc. to Transaction Type
TZBKFinancial Assets Management valuation areas
TREAT_MLM_UTILIZTreasury: Margin Limit Utilization
VZSTXTSort field names: Texts
TOET_DESIG_ACTIVActivation of Designation
TWZ03Result types text table, texts for summarization types
TOEC_CLASSHedging Classification
TW18Customizing table for SCB indicator
CML_MIG_BUFFERTable DDIC buffering (migration)
TREATS_MLM_ACT_TTREA: Texts for Amount Categories
TZRRTTreasury: Name of Valuation Areas
TREAC_MLM_SCENTTREA: Margin Limit Scenarios
TWL5TTexts for TWL5 (Revenue list output sequence)
VZKNB1Collector for batch input KNB1 from RF-VV
TREAT_NOVATIONTreasury: Novation
TEMP_MDTemporary market rate data table
TCRC_CSPR_TYPECredit Spread Type
TZFBCalculation base value table
TTXBSCorresp.interface: Letter-module relationship
TFKY3Serves as check table (for issuer help-view structure)
TREAT_POSITIONTreasury: TREA Position
TZV07Alloc.of application/role category/dunning parameters
VVWKN2Allocation of values to value groups
TW14TTable for storing offer reasons (text)
TZB0ADefinition of flow types
VZROLLEPartner / role list
TZRCLTreasury: Valuation Classes
TW52TMarket sectors - Text table
TW11TBalance sheet indicator (Text)
TRPAC_PS_CL_ACTActivation of the Position Classifier per Acc Code/Val Area
TWL4Output sequence lists + control parameters
TRPAC_POS_CLS_HDPosition Classifier Header Definition
TXV10Translation table for address category
TW17TText Table for TW17
VVWL7Context
VZSFELDSort field ID's: Version 2.0
TZ02BRelationship table for contracting party classification
TZV02Salutation key
TZRPRTreasury: Valuation Principles
TZV0DTexts for keys of partner share types
TYC_CSPRD_DEFCredit Spread Definition
VZBAVBAV Data
VTVSZYCScenario Database: Yield Curve Types
VZZKOKOTable condition header
VVWKN6Alloc. of charac.group to second.term via the invoice no.
TRTM_CHG_PARTNERTreasury: Change partner
TZM37Transition matrix of internal status
TRPAC_POS_CLS_HTPosition Classifier Header Definition Texts
TZSTReasons for reversal
TZB06Table of relationships between flow types (ref. flow types)
VWPZUSASecurities additional information
TZBBBAllocation of program-internal flow types
TWL5Display sequence (check table)-previously only revenue list
TWL6Display sequence (formerly only revenue list, now all)
TW53Listing key
TZV37Activities and their internal status area
TRPAT_LA_LOGAssignes a LA Calculation Log to a Business Transaction ID
TZPZZPartner and address management installation parameters
VZKNA1Collector for batch input KNA1 from RF-VV
TZ24TRelationship key contracting party classification (Text)
TWL2Sort sequence lists + control parameters
TZ01TTable for the maintenance of ratings (Text)
TW56Security price type
TW07TSCB group (Text)
TZSBWValuation methods
TZB03Flow categories
VZZUSPPayment splitting
VZZPAROPartner / Role / Object relationship
TW02TText table for TW02 (Type of investment)
TZK08Allocation: Calculation type - KOPO fields
TRPAT_DEF_RATESDefault Rates for LGD and PD Values
TZV09Relationship - Reference relationship link
TRPAT_POS_TRANSClassifier Transfer Transaction Table
TZB0HTexts for posting control indicator
TWL1List sort sequence (Position/Trend/Revenue lists)
VZDTXTAttributes for display fields: Country texts
TXV03Translation table for virt. object categories
VZPARUSUser data central partner and address management
TZREExternal role
TRPAC_POS_CONSDefinition of a valid combinition of val. cl., BM and SPPI
TZW01Resubmission periods (Deadline reminder)
TRPAT_CMF_GL_VALContractual Change Gain or Loss
TW07SCB group
TZV15Key for information in acc. with §18 German banking act
VZPARGPOVZPARO - VZGPO allocation
VZZKOPAAlternative condition item - conditions
TW02Type of shareholding
TW21Funds category
TZAFTProduct categories text
TTXADUser data fields per document
TW55TPrice markdowns - Text table
VTB_FACTORVALMarket Data: Factor Values
TZK05Allocation: Calculation type - KOPO fields
TW11Balance sheet indicator