TRLS_SUBPOS_DISPLAY SAP (Structure to Display Subposition Values) Structure details
Description: Structure to Display Subposition Values
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_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
SUBPOSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
PA_COMPANY_ID | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
ORIGIN_DATE | Treasury Ledger Date | TPM_TRLDATE | DATS | 8 | DATUM | ||||
HINST_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TPM_DB_OS_GUID | ||||
HITEM_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TPM_DB_OS_GUID | ||||
FLG_FREESTANDING | Indicator: Freestanding Portion of the Position | TPM_FLG_FREESTANDING | CHAR | 1 | XFELD | ||||
DESIG_UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
DESIG_NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
DESIG_NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
INTERN_TO_BE_CLASSIFIED_PC | To Be Classified (Internally) in Position Currency | FTI_INTERN_TO_BE_CLASSIFIED_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INTERN_TO_BE_CLASSIFIED_VC | To Be Classified (Internally) in Valuation Currency | FTI_INTERN_TO_BE_CLASSIFIED_VC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_IDXCL_PC | Hedge Adjustment in Position Currency, Index-Clean | FTI_HADJ_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_VC | Hedge Adjustment in Valuation Currency | FTI_HADJ_VC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_PC | Hedge Amortization in Position Currency | FTI_HAMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_IDXCL_PC | Hedge Amortization in Position Crcy, Index-Clean | FTI_HAMORT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_VC | Hedge Amortization in Valuation Currency | FTI_HAMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
EFF_PC | Effective Amount in Position Currency | FTI_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFF_VC | Effective Amount in Valuation Currency | FTI_EFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
EFF_IDXCL_PC | Effective Amount in Position Currency, Index Clean | FTI_EFFECTIVE_IDXCL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFF_PC | Ineffective Amount in Position Currency | FTI_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFF_VC | Ineffective Amount in Valuation Currency | FTI_INEFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFF_IDXCL_PC | Ineffective Amount in Position Currency, Index Clean | FTI_INEFFECTIVE_IDXCL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFD_PC | Effective Amount (Dormant) in Position Currency | FTI_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFD_VC | Effective Amount (Dormant) in Valuation Currency | FTI_EFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFD_IDXCL_PC | Effective Amount (Dormant) in Position Currency, Index-Clean | FTI_EFFECTIVE_DORMANT_IDXCL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFD_PC | Ineffective Amount (Dormant) in Position Currency | FTI_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFD_VC | Ineffective Amount (Dormant) in Valuation Currency | FTI_INEFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFD_IDXCL_PC | Ineffective Amount (Dormant) in Position Currency, Index-Cln | FTI_INEFF_DORMANT_IDXCL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
FX_RISK | Fx Risk Yes/No | TPM_RISK_FX | CHAR | 1 | TPM_FLAG | ||||
IR_RISK | Interest Rate Risk Yes/No | TPM_RISK_IR | CHAR | 1 | TPM_FLAG | ||||
PRICE_RISK | Price Risk Yes/No | TPM_RISK_PR | CHAR | 1 | TPM_FLAG | ||||
PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_IDXCL_PC | Purchase Value, Index-Clean, in Position Currency | FTI_PURCH_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_VC | Purchase Value in Valuation Currency | FTI_PURCH_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_IDXCL_PC | Security Valuation, Index-Clean, in Position Currency | FTI_VAL_TI_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_VC | Security Valuation in Valuation Currency | FTI_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_VC | Foreign Currency Valuation in Valuation Currency | FTI_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_IDXCL_PC | Security Valuation, Not Affecting P/L, Index-Clean, in PC | FTI_VAL_TI_NPL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_VC | Security Valuation, Not Affecting P/L, in Valuation Currency | FTI_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_NPL_VC | Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy | FTI_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_PC | Costs in position currency | FTI_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_IDXCL_PC | Costs, Index-Clean, in Position Currency | FTI_CHARGE_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_VC | Costs in Valuation Currency | FTI_CHARGE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_IDXCL_PC | Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy | FTI_VAL_CH_TI_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_UP_PC | Write-Up of Capitalized Costs, Security Valn in Pos.Crcy | FTI_VAL_CH_TI_UP_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_DOWN_PC | Write-Down of Capitalized Costs, Security Valn in Pos.Crcy | FTI_VAL_CH_TI_DOWN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_VC | Valuation of Cap. Costs, Security, in Valuation Currency | FTI_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_UP_VC | Write-Up of Capitalized Costs, Security Valn in Val.Crcy | FTI_VAL_CH_TI_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_DOWN_VC | Write-Up of Capitalized Costs, Security Valn in Val.Crcy | FTI_VAL_CH_TI_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Valuation Currency | FTI_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_UP_VC | Write-Up of Capitalized Costs, FX Valuation in Val.Crcy | FTI_VAL_CH_FX_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_DOWN_VC | Write-Down of Capitalized Costs, FX Valuation in Val.Crcy | FTI_VAL_CH_FX_DOWN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_PC | Amortization in Position Currency | FTI_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_IDXCL_PC | Amortization, Index-Clean, in Position Currency | FTI_AMORT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_VC | Amortization in Valuation Currency | FTI_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_PC | Amortized Negotiation Spread in Position Currency | FTI_AMORT_NEG_SPREAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_IDXCL_PC | Amort. Negotiation Spread in Position Currency, Index-Clean | FTI_AMORT_NEG_SPREAD_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_VC | Amortized Negotiation Spread in Valuation Currency | FTI_AMORT_NEG_SPREAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_AMAQU_VAL_VC | FX Valuation of Amort.Acquisition Value in Valuation Crcy | FTI_VAL_FX_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy | FTI_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_IDXCL_PC | Val.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy | FTI_VAL_CH_TI_NPL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_VC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy | FTI_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_NPL_VC | Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy | FTI_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_PC | Consolidated Security Gains in Position Currency | FTI_CONS_GAINS_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_VC | Consolidated Security Gains in Valuation Currency | FTI_CONS_GAINS_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_PC | Consolidated Security Losses in Position Currency | FTI_CONS_LOSSES_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_VC | Consolidated Security Losses in Valuation Currency | FTI_CONS_LOSSES_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_FX_VC | Consolidated FX Gains in Valuation Currency | FTI_CONS_GAINS_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_FX_VC | Consolidated FX Losses in Valuation Currency | FTI_CONS_LOSSES_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_PC | Value Adjustment of Gains in Position Currency | FTI_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_VC | Value Adjustment of Gains in Valuation Currency | FTI_VAD_GAIN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_PC | Value Adjustment of Losses in Position Currency | FTI_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_VC | Value Adjustment of Losses in Valuation Currency | FTI_VAD_LOSS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_PC | Original Value Adjustment in Position Currency | FTI_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_VC | Original Value Adjustment in Valuation Currency | FTI_ORIG_VAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_IDXCL_PC | Impairment in Position Currency, Index Clean | FTI_IMPMNT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_VC | Impairment in Valuation Currency | FTI_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_VC | FX Impairment in Valuation Currency | FTI_IMPMNT_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_IDXCL_PC | Acquisition Value, Index-Clean, in Position Currency | FTI_AQU_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_VC | Acquisition Value in Valuation Currency | FTI_AQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_IDXCL_PC | Amortized Acquisition Value, Index-Clean, in Position Crcy | FTI_AMAQU_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_VC | Amortized Acquisition Value in Valuation Currency | FTI_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_IDXCL_PC | Book Value, Index-Clean, in Position Currency | FTI_BOOK_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_VC | Book Value in Valuation Currency | FTI_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_PC | Book Value Excluding Costs in Position Currency | FTI_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_IDXCL_PC | Book Value Excluding Costs, Index-Clean, in Position Crcy | FTI_BOOK_VAL_EX_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_VC | Book Value Excluding Costs in Valuation Currency | FTI_BOOK_VAL_EX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
HITEM_NUMBER | Hedged Item Number | TPM_HITEM_NUMBER | CHAR | 10 | ALPHA | TPM_HITEM_NUMBER | |||
HITEM_FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HINST_NUMBER | Hedging Instrument Number | TPM_HINST_NUMBER | CHAR | 10 | ALPHA | TPM_HINST_NUMBER | |||
HINST_FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HITEM_DESCR | Hedged Item Description | TPM_HITEM_DESCR | CHAR | 60 | TPM_HITEM_DESCR | ||||
HINST_DESCR | Hedging Instrument Description | TPM_HINST_DESCR | CHAR | 60 | TPM_HINST_DESCR | ||||
HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 10 | ALPHA | TPM_HREL_NUMBER | |||
HREL_FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HREL_PROFILE | Hedging Profile | TPM_HREL_PROFILE | CHAR | 3 | Assigned to domain | ALPHA | TPM_HREL_PROFILE | ||
HREL_DESCR | Hedging Relationship Description | TPM_HREL_DESCR | CHAR | 60 | TPM_HREL_DESCR | ||||
HREL_CATEGORY | Hedging Relationship Category | TPM_HREL_CATEGORY | CHAR | 2 | TPM_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects