TRILS_CLASSIFICATION SAP (Classification of Valuation Results per Hedging Relationship) Structure details

Dictionary Type: Structure
Description: Classification of Valuation Results per Hedging Relationship




ABAP Code to SELECT data from TRILS_CLASSIFICATION
Related tables to TRILS_CLASSIFICATION
Access table TRILS_CLASSIFICATION




Structure field list including key, data, relationships and ABAP select examples

TRILS_CLASSIFICATION is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Classification of Valuation Results per Hedging Relationship" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TRILS_CLASSIFICATION TYPE TRILS_CLASSIFICATION.

The TRILS_CLASSIFICATION table consists of various fields, each holding specific information or linking keys about Classification of Valuation Results per Hedging Relationship data available in SAP. These include RFHA (Financial Transaction), HR (), MANDT (Client), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP TRILS_CLASSIFICATION structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
HR 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13ALPHAT_RFHAFANVTBA
HEDGE_IDIdentification Number of Hedge Item THM_HEDGE_IDNUMC10THM_HEDGE_IDHEDGEID
HR_VERSIONVersion of the hedging relationship THM_HR_VERSIONNUMC3THM_HR_VERSION
HR_COMP_KEYKey for hr THM_HR_COMP_KEYNUMC10THM_HR_COMP_KEY
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3TPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
HR_DATEInception date of the current hedge relationship version THM_HR_DATEDATS8DATUM
HR_CR_DATESystem date when hr is written THM_HR_AUDITDATS8DATUM
HR_TIMETime when hedge relationship is written THM_HR_TIMETIMS6TIME
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12
UPUSERLast Changed by TB_UPUSERCHAR12SYCHAR12
VOL_DERIVATIVEDesignated volume of the derivative THM_DES_VOL_DERCURR17(2) WERTV9
CURR_DERIVATIVECurrency of the designated volume of the derivative THM_CURR_DERCUKY5WAERS
VOL_HEDGE_ITEMDesignated volume of the hedge item THM_DES_VOL_HEDGECURR17(2) WERTV9
CURR_HEDGE_ITEMCurrency of the hedge item THM_HEDGE_CURRENCYCUKY5WAERS
MEAS_EXISTSIndicator that HR has an associated measurement THM_HR_VALUEDINT13THM_HR_VALUED
NOT_DELETABLEIs hedging relationship deletable? THM_HR_NOT_DELETABLEINT13THM_HR_NOT_DELETABLE
STATUSHedging relationship status THM_HR_STATUSINT13THM_HR_STATUS
STATUS_CHANGEReason for a status change on the hedging relationship THM_HR_STATUS_CHANGEINT13THM_HR_STATUS_CHANGE
SANLFProduct Category SANLFNUMC3VVSANLF
SFGTYPTransaction Category TB_SFGTYPNUMC3T_SFGTYP
SGSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3T_SFHAARTT02C_AT10
RANTYPContract Type RANTYPCHAR1RANTYP
HR_RATE_CATRates for the hr THM_RATE_CATINT13THM_RATE_CAT
HR_INT_FIXPlanned interest hedge rate for an hedging relationship THM_HEDGE_RATE_INTDEC10(7) DECV3_7
HR_INT_VARPlanned interest reference hedge rate for an hedging rel. THM_HEDGE_RATE_INT_REFCHAR10ZIREFKU
HR_FX_RATEPlanned FX hedge rate for a hedging relationship THM_HEDGE_RATEDEC13(9) TB_KKURS
HR_STARTVALDetermine hedged item's value at inception date THM_STARTVALUE_SETNUMC1THM_STARTVALUE_SET
BENCHMARKBenchmark interest reference for an hedging relationship THM_HR_BENCHMARKCHAR10ZIREFKU
FIX_BENCHMARKFixed benchmark interest rate of an hedging relationship THM_HR_FIX_BENCHMARKDEC10(7) DECV3_7
H_RFHAHypothetical transaction (hedge accounting) GE_HYPTRANSCHAR13ALPHAT_RFHAFANVTBA
HR_SPREADInterest Rate Spread to Risk Free Market Interest Rate THA_SPREADDEC10(7) DECV3_7
PMAXStrike price upper limit TB_PMAXDEC10(7) DECV3_7
PMINStrike Price Lower Limit TB_PMINDEC10(7) DECV3_7
REFTYPReference Category (Unit Category) KL_TYPCHAR3KL_TYPT31
REFNRReference number (unit no.) KL_NRCHAR10ALPHAKL_NRT30
HR_BEGIN_DATEHedging Relationship Start Date THA_HR_BEGIN_DATEDATS8DATUM
KKASSASpot Rate TB_KKASSADEC13(9) TB_KKURS
DVTRABContract Conclusion Date TB_DVTRABDATS8DATUM
DESIG_QUANTITYDesignated quantity THA_DES_QUANTITYQUAN15(3) THA_QUANTITY
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3CUNITMEINS
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
COMMODITY_PRICECommodity Price FTR_COMPRICEDEC13(5) FTR_COMPRICE
HR_REFNRReference number (unit no.) KL_NRCHAR10ALPHAKL_NRT30
EXP_FORW_PRICEForward price of the exposure THA_EXP_FORW_PRICEDEC29(10) THA_PRICE_PER_UNIT
COMM_ID_DERIVCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
HEDGE_DES_QTYDesignated quantity of Hedged Item THA_HEDGE_DES_QTYQUAN15(3) THA_QUANTITY
HEDGE_DES_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3CUNITMEINS
HD_NUMBERHypothetical Derivative Instrument Number FTR_HD_NUMBERCHAR13FTR_HD_NUMBER
HD_VERSIONHypothetical Derivative Instrument Version Number FTR_HD_VERSIONINT13FTR_HD_VERSION
FP_CALC_METHCalculation Method for expected forward price of exposure THM_FP_CALC_METHODCHAR1THM_FP_CALC_METHOD
KEY_DATEDate of a Business Transaction in the Income Ledger TPM_TRIL_DATEDATS8
TO_BE_CLASSIFIEDAmount to be Classified TPM_CLASSIF_AMOUNTCURR13(2) WERTV7
TO_OCIAmount to be Posted to Equity Capital OCI_AMOUNTCURR13(2) WERTV7
TO_PLAmount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7
TO_BE_CLASSIFIED_POS_CURRAmount to be Classified TPM_CLASSIF_AMOUNTCURR13(2) WERTV7
TO_OCI_POS_CURRAmount to be Posted to Equity Capital OCI_AMOUNTCURR13(2) WERTV7
TO_PL_POS_CURRAmount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7
TO_OCI_2Amount to be Posted to Equity Capital OCI_AMOUNTCURR13(2) WERTV7
TO_OCI_POS_CURR_2Amount to be Posted to Equity Capital OCI_AMOUNTCURR13(2) WERTV7
TO_PL_2Amount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7
TO_PL_POS_CURR_2Amount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7
TO_PL_HDG_VCAmount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7
TO_PL_HDG_PCAmount to be Posted to P/L PL_AMOUNTCURR13(2) WERTV7

Key field Non-key field



How do I retrieve data from SAP structure TRILS_CLASSIFICATION using ABAP code?

As TRILS_CLASSIFICATION is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRILS_CLASSIFICATION as there is no data to select.

How to access SAP table TRILS_CLASSIFICATION

Within an ECC or HANA version of SAP you can also view further information about TRILS_CLASSIFICATION and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!