TRLS_SUBPOS_DISPLAY SAP (Structure to Display Subposition Values) Structure details

Dictionary Type: Structure
Description: Structure to Display Subposition Values




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




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

TRLS_SUBPOS_DISPLAY 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 "Structure to Display Subposition Values" 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_TRLS_SUBPOS_DISPLAY TYPE TRLS_SUBPOS_DISPLAY.

The TRLS_SUBPOS_DISPLAY table consists of various fields, each holding specific information or linking keys about Structure to Display Subposition Values data available in SAP. These include POSITION_OID (Globally Unique Identifier), SUBPOSITION_OID (Globally Unique Identifier), PA_COMPANY_ID (Company ID of trading partner), ORIGIN_DATE (Treasury Ledger Date).. 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 (character-type or numeric)


SAP TRLS_SUBPOS_DISPLAY 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
POSITION_OIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
SUBPOSITION_OIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
PA_COMPANY_IDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
ORIGIN_DATETreasury Ledger Date TPM_TRLDATEDATS8DATUM
HINST_OIDObject Identity in Database Format TPM_DB_OS_GUIDCHAR32TPM_DB_OS_GUID
HITEM_OIDObject Identity in Database Format TPM_DB_OS_GUIDCHAR32TPM_DB_OS_GUID
FLG_FREESTANDINGIndicator: Freestanding Portion of the Position TPM_FLG_FREESTANDINGCHAR1XFELD
DESIG_UNITSUnits TPM_UNITSDEC22(6) TPM_UNITS
DESIG_NOMINAL_AMTNominal Amount TPM_NOMINAL_AMTCURR21(2) TPM_AMOUNT
DESIG_NOMINAL_ORG_AMTOriginal Nominal Amount in Position Currency TPM_NOMINAL_ORG_AMTCURR21(2) TPM_AMOUNT
NOMINAL_CURRNominal Currency TPM_NOMINAL_CURRCUKY5Assigned to domainWAERS
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
INTERN_TO_BE_CLASSIFIED_PCTo Be Classified (Internally) in Position Currency FTI_INTERN_TO_BE_CLASSIFIED_PCCURR21(2) TPM_AMOUNT
INTERN_TO_BE_CLASSIFIED_VCTo Be Classified (Internally) in Valuation Currency FTI_INTERN_TO_BE_CLASSIFIED_VCCURR21(2) TPM_AMOUNT
HADJ_PCHedge Adjustment in Position Currency FTI_HADJ_PCCURR21(2) TPM_AMOUNT
HADJ_IDXCL_PCHedge Adjustment in Position Currency, Index-Clean FTI_HADJ_INDX_PCCURR21(2) TPM_AMOUNT
HADJ_VCHedge Adjustment in Valuation Currency FTI_HADJ_VCCURR21(2) TPM_AMOUNT
HAMORT_PCHedge Amortization in Position Currency FTI_HAMORT_PCCURR21(2) TPM_AMOUNT
HAMORT_IDXCL_PCHedge Amortization in Position Crcy, Index-Clean FTI_HAMORT_INDX_PCCURR21(2) TPM_AMOUNT
HAMORT_VCHedge Amortization in Valuation Currency FTI_HAMORT_VCCURR21(2) TPM_AMOUNT
EFF_PCEffective Amount in Position Currency FTI_EFFECTIVE_PCCURR21(2) TPM_AMOUNT
EFF_VCEffective Amount in Valuation Currency FTI_EFFECTIVE_VCCURR21(2) TPM_AMOUNT
EFF_IDXCL_PCEffective Amount in Position Currency, Index Clean FTI_EFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFF_PCIneffective Amount in Position Currency FTI_INEFFECTIVE_PCCURR21(2) TPM_AMOUNT
INEFF_VCIneffective Amount in Valuation Currency FTI_INEFFECTIVE_VCCURR21(2) TPM_AMOUNT
INEFF_IDXCL_PCIneffective Amount in Position Currency, Index Clean FTI_INEFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
EFFD_PCEffective Amount (Dormant) in Position Currency FTI_EFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
EFFD_VCEffective Amount (Dormant) in Valuation Currency FTI_EFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
EFFD_IDXCL_PCEffective Amount (Dormant) in Position Currency, Index-Clean FTI_EFFECTIVE_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFFD_PCIneffective Amount (Dormant) in Position Currency FTI_INEFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
INEFFD_VCIneffective Amount (Dormant) in Valuation Currency FTI_INEFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
INEFFD_IDXCL_PCIneffective Amount (Dormant) in Position Currency, Index-Cln FTI_INEFF_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT
FX_RISKFx Risk Yes/No TPM_RISK_FXCHAR1TPM_FLAG
IR_RISKInterest Rate Risk Yes/No TPM_RISK_IRCHAR1TPM_FLAG
PRICE_RISKPrice Risk Yes/No TPM_RISK_PRCHAR1TPM_FLAG
PURCH_PCPurchase Value in Position Currency FTI_PURCH_PCCURR21(2) TPM_AMOUNT
PURCH_IDXCL_PCPurchase Value, Index-Clean, in Position Currency FTI_PURCH_INDX_PCCURR21(2) TPM_AMOUNT
PURCH_VCPurchase Value in Valuation Currency FTI_PURCH_VCCURR21(2) TPM_AMOUNT
VAL_TI_PCSecurity Valuation in Position Currency FTI_VAL_TI_PCCURR21(2) TPM_AMOUNT
VAL_TI_IDXCL_PCSecurity Valuation, Index-Clean, in Position Currency FTI_VAL_TI_INDX_PCCURR21(2) TPM_AMOUNT
VAL_TI_VCSecurity Valuation in Valuation Currency FTI_VAL_TI_VCCURR21(2) TPM_AMOUNT
VAL_FX_VCForeign Currency Valuation in Valuation Currency FTI_VAL_FX_VCCURR21(2) TPM_AMOUNT
VAL_TI_NPL_PCSecurity Valuation, Not Affecting P/L, in Position Currency FTI_VAL_TI_NPL_PCCURR21(2) TPM_AMOUNT
VAL_TI_NPL_IDXCL_PCSecurity Valuation, Not Affecting P/L, Index-Clean, in PC FTI_VAL_TI_NPL_INDX_PCCURR21(2) TPM_AMOUNT
VAL_TI_NPL_VCSecurity Valuation, Not Affecting P/L, in Valuation Currency FTI_VAL_TI_NPL_VCCURR21(2) TPM_AMOUNT
VAL_FX_NPL_VCForeign Currency Valuation, Not Affecting P/L, in Val. Crcy FTI_VAL_FX_NPL_VCCURR21(2) TPM_AMOUNT
CHARGE_PCCosts in position currency FTI_CHARGE_PCCURR21(2) TPM_AMOUNT
CHARGE_IDXCL_PCCosts, Index-Clean, in Position Currency FTI_CHARGE_INDX_PCCURR21(2) TPM_AMOUNT
CHARGE_VCCosts in Valuation Currency FTI_CHARGE_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_PCValuation of Cap. Costs, Security, in Position Currency FTI_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_IDXCL_PCValuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy FTI_VAL_CH_TI_INDX_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_UP_PCWrite-Up of Capitalized Costs, Security Valn in Pos.Crcy FTI_VAL_CH_TI_UP_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_DOWN_PCWrite-Down of Capitalized Costs, Security Valn in Pos.Crcy FTI_VAL_CH_TI_DOWN_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_VCValuation of Cap. Costs, Security, in Valuation Currency FTI_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_UP_VCWrite-Up of Capitalized Costs, Security Valn in Val.Crcy FTI_VAL_CH_TI_UP_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_DOWN_VCWrite-Up of Capitalized Costs, Security Valn in Val.Crcy FTI_VAL_CH_TI_UP_VCCURR21(2) TPM_AMOUNT
VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Valuation Currency FTI_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
VAL_CH_FX_UP_VCWrite-Up of Capitalized Costs, FX Valuation in Val.Crcy FTI_VAL_CH_FX_UP_VCCURR21(2) TPM_AMOUNT
VAL_CH_FX_DOWN_VCWrite-Down of Capitalized Costs, FX Valuation in Val.Crcy FTI_VAL_CH_FX_DOWN_VCCURR21(2) TPM_AMOUNT
AMORT_PCAmortization in Position Currency FTI_AMORT_PCCURR21(2) TPM_AMOUNT
AMORT_IDXCL_PCAmortization, Index-Clean, in Position Currency FTI_AMORT_INDX_PCCURR21(2) TPM_AMOUNT
AMORT_VCAmortization in Valuation Currency FTI_AMORT_VCCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_PCAmortized Negotiation Spread in Position Currency FTI_AMORT_NEG_SPREAD_PCCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_IDXCL_PCAmort. Negotiation Spread in Position Currency, Index-Clean FTI_AMORT_NEG_SPREAD_INDX_PCCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_VCAmortized Negotiation Spread in Valuation Currency FTI_AMORT_NEG_SPREAD_VCCURR21(2) TPM_AMOUNT
VAL_FX_AMAQU_VAL_VCFX Valuation of Amort.Acquisition Value in Valuation Crcy FTI_VAL_FX_AMAQU_VAL_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_NPL_PCValuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy FTI_VAL_CH_TI_NPL_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_NPL_IDXCL_PCVal.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy FTI_VAL_CH_TI_NPL_INDX_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_NPL_VCValuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy FTI_VAL_CH_TI_NPL_VCCURR21(2) TPM_AMOUNT
VAL_CH_FX_NPL_VCValuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy FTI_VAL_CH_FX_NPL_VCCURR21(2) TPM_AMOUNT
CONS_GAINS_TI_PCConsolidated Security Gains in Position Currency FTI_CONS_GAINS_TI_PCCURR21(2) TPM_AMOUNT
CONS_GAINS_TI_VCConsolidated Security Gains in Valuation Currency FTI_CONS_GAINS_TI_VCCURR21(2) TPM_AMOUNT
CONS_LOSSES_TI_PCConsolidated Security Losses in Position Currency FTI_CONS_LOSSES_TI_PCCURR21(2) TPM_AMOUNT
CONS_LOSSES_TI_VCConsolidated Security Losses in Valuation Currency FTI_CONS_LOSSES_TI_VCCURR21(2) TPM_AMOUNT
CONS_GAINS_FX_VCConsolidated FX Gains in Valuation Currency FTI_CONS_GAINS_FX_VCCURR21(2) TPM_AMOUNT
CONS_LOSSES_FX_VCConsolidated FX Losses in Valuation Currency FTI_CONS_LOSSES_FX_VCCURR21(2) TPM_AMOUNT
VAD_GAIN_PCValue Adjustment of Gains in Position Currency FTI_VAD_GAIN_PCCURR21(2) TPM_AMOUNT
VAD_GAIN_VCValue Adjustment of Gains in Valuation Currency FTI_VAD_GAIN_VCCURR21(2) TPM_AMOUNT
VAD_LOSS_PCValue Adjustment of Losses in Position Currency FTI_VAD_LOSS_PCCURR21(2) TPM_AMOUNT
VAD_LOSS_VCValue Adjustment of Losses in Valuation Currency FTI_VAD_LOSS_VCCURR21(2) TPM_AMOUNT
ORIG_VAD_PCOriginal Value Adjustment in Position Currency FTI_ORIG_VAD_PCCURR21(2) TPM_AMOUNT
ORIG_VAD_VCOriginal Value Adjustment in Valuation Currency FTI_ORIG_VAD_VCCURR21(2) TPM_AMOUNT
IMPMNT_PCImpairment in Position Currency FTI_IMPMNT_PCCURR21(2) TPM_AMOUNT
IMPMNT_IDXCL_PCImpairment in Position Currency, Index Clean FTI_IMPMNT_INDX_PCCURR21(2) TPM_AMOUNT
IMPMNT_VCImpairment in Valuation Currency FTI_IMPMNT_VCCURR21(2) TPM_AMOUNT
IMPMNT_FX_VCFX Impairment in Valuation Currency FTI_IMPMNT_FX_VCCURR21(2) TPM_AMOUNT
AQU_VAL_PCAcquisition Value in Position Currency FTI_AQU_VAL_PCCURR21(2) TPM_AMOUNT
AQU_VAL_IDXCL_PCAcquisition Value, Index-Clean, in Position Currency FTI_AQU_VAL_INDX_PCCURR21(2) TPM_AMOUNT
AQU_VAL_VCAcquisition Value in Valuation Currency FTI_AQU_VAL_VCCURR21(2) TPM_AMOUNT
AMAQU_VAL_PCAmortized Acquisition Value in Position Currency FTI_AMAQU_VAL_PCCURR21(2) TPM_AMOUNT
AMAQU_VAL_IDXCL_PCAmortized Acquisition Value, Index-Clean, in Position Crcy FTI_AMAQU_VAL_INDX_PCCURR21(2) TPM_AMOUNT
AMAQU_VAL_VCAmortized Acquisition Value in Valuation Currency FTI_AMAQU_VAL_VCCURR21(2) TPM_AMOUNT
BOOK_VAL_PCBook Value in Position Currency FTI_BOOK_VAL_PCCURR21(2) TPM_AMOUNT
BOOK_VAL_IDXCL_PCBook Value, Index-Clean, in Position Currency FTI_BOOK_VAL_INDX_PCCURR21(2) TPM_AMOUNT
BOOK_VAL_VCBook Value in Valuation Currency FTI_BOOK_VAL_VCCURR21(2) TPM_AMOUNT
BOOK_VAL_EX_PCBook Value Excluding Costs in Position Currency FTI_BOOK_VAL_EX_PCCURR21(2) TPM_AMOUNT
BOOK_VAL_EX_IDXCL_PCBook Value Excluding Costs, Index-Clean, in Position Crcy FTI_BOOK_VAL_EX_INDX_PCCURR21(2) TPM_AMOUNT
BOOK_VAL_EX_VCBook Value Excluding Costs in Valuation Currency FTI_BOOK_VAL_EX_VCCURR21(2) TPM_AMOUNT
HITEM_NUMBERHedged Item Number TPM_HITEM_NUMBERCHAR10ALPHATPM_HITEM_NUMBER
HITEM_FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
HINST_NUMBERHedging Instrument Number TPM_HINST_NUMBERCHAR10ALPHATPM_HINST_NUMBER
HINST_FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
HITEM_DESCRHedged Item Description TPM_HITEM_DESCRCHAR60TPM_HITEM_DESCR
HINST_DESCRHedging Instrument Description TPM_HINST_DESCRCHAR60TPM_HINST_DESCR
HREL_NUMBERHedging Relationship Number (External/Internal) TPM_HREL_NUMBERCHAR10ALPHATPM_HREL_NUMBER
HREL_FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
HREL_PROFILEHedging Profile TPM_HREL_PROFILECHAR3Assigned to domainALPHATPM_HREL_PROFILE
HREL_DESCRHedging Relationship Description TPM_HREL_DESCRCHAR60TPM_HREL_DESCR
HREL_CATEGORYHedging Relationship Category TPM_HREL_CATEGORYCHAR2TPM_HREL_CATEGORY

Key field Non-key field



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

As TRLS_SUBPOS_DISPLAY 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 TRLS_SUBPOS_DISPLAY as there is no data to select.

How to access SAP table TRLS_SUBPOS_DISPLAY

Within an ECC or HANA version of SAP you can also view further information about TRLS_SUBPOS_DISPLAY 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!