TRLS_REPORTING_POS_VALUES SAP (Reporting Structure with Position Values) Structure details
Description: Reporting Structure with Position Values
Related tables to TRLS_REPORTING_POS_VALUES
Access table TRLS_REPORTING_POS_VALUES
Structure field list including key, data, relationships and ABAP select examples
TRLS_REPORTING_POS_VALUES 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 "Reporting Structure with Position 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_REPORTING_POS_VALUES TYPE TRLS_REPORTING_POS_VALUES.
The TRLS_REPORTING_POS_VALUES table consists of various fields, each holding specific information or linking keys about Reporting Structure with Position Values data available in SAP. These include VALUATION_AREA (Valuation Area), COM_VAL_CLASS (General Valuation Class), VALUATION_CLASS (Valuation Class), ACCOUNTING_CODE (Accounting 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 (character-type or numeric)
SAP TRLS_REPORTING_POS_VALUES 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 |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
ACCOUNTING_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
PORTFOLIO | Portfolio as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | CHAR | 10 | TWPOB | RPORTB | |||
TRADER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DEAL_NUMBER | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
EXTERNAL_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | TCURC | WAERS | TPM_DIFF_CURR | ||
POS_OSUID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
SUBPOS_OSUID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
UNITS | Number of units | FTI_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT_PC | Nominal Amount in Position Currency | FTI_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT_PC | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_LC | Purchase Value in Local Currency | FTI_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_VC | Purchase Value in Valuation Currency | FTI_PURCH_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_LC | Acquisition Value in Local Currency | FTI_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_VC | Acquisition Value in Valuation Currency | FTI_AQU_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_LC | Book Value in Local Currency | FTI_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_VC | Book Value in Valuation Currency | FTI_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_PC | Costs in position currency | FTI_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_LC | Costs in Local Currency | FTI_CHARGE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_VC | Costs in Valuation Currency | FTI_CHARGE_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_LC | Book Value Excluding Costs in Local Currency | FTI_BOOK_VAL_EX_LC | 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 | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_LC | Security Valuation in Local Currency | FTI_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_VC | Security Valuation in Valuation Currency | FTI_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_LC | Foreign Currency Valuation in Local Currency | FTI_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_VC | Foreign Currency Valuation in Valuation Currency | FTI_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_AMAQU_VAL_LC | FX Valuation of Amort. Acquisition Value in Local Currency | FTI_VAL_FX_AMAQU_VAL_LC | 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_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_LC | Valuation of Cap. Costs, Security, in Local Currency | FTI_VAL_CH_TI_LC | 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_FX_LC | Valuation of Capitalized Costs, FX, in Local Currency | FTI_VAL_CH_FX_LC | 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 | ||||
AMORT_PC | Amortization in Position Currency | FTI_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_LC | Amortization in Local Currency | FTI_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_VC | Amortization in Valuation Currency | FTI_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_LC | Impairment in Local Currency | FTI_IMPMNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_VC | Impairment in Valuation Currency | FTI_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_LC | FX Impairment in Local Currency | FTI_IMPMNT_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_VC | FX Impairment in Valuation Currency | FTI_IMPMNT_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_PC | Cumulative Repayment in Position Currency | TPM_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_LC | Cumulative Repayment in Local Currency | TPM_REPAYMENT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_VC | Cumulative Repayment in Valuation Currency | TPM_REPAYMENT_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_LC | Amortized Acquisition Value in Local Currency | FTI_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_VC | Amortized Acquisition Value in Valuation Currency | FTI_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_PC | Cleared PD Deferral/Tax Compensation in Position Currency | FTI_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_LC | Cleared PD Deferral/Tax Compensation in Local Currency | FTI_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_VC | Cleared PD Deferral/Tax Compensation in Valuation Currency | FTI_DISAGIO_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_LC | Security Valuation, Not Affecting P/L, in Local Currency | FTI_VAL_TI_NPL_LC | 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_LC | Foreign Currency Valuation, Not Affecting P/L, in Local Crcy | FTI_VAL_FX_NPL_LC | 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 | ||||
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_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Local Crcy | FTI_VAL_CH_TI_NPL_LC | 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_LC | Valuation of Cap. Costs, FX, Not Aff. P/L in Local Currency | FTI_VAL_CH_FX_NPL_LC | 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 | ||||
VARMAR_PC | Variation Margin in Position Currency | FTI_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_LC | Variation Margin in Local Currency | FTI_VARMAR_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_VC | Variation Margin in Valuation Currency | FTI_VARMAR_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALP_LC | Spot Valuation of Purchase Currency in Local Currency | FTI_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALP_VC | Spot Valuation of Purchase Currency in Valuation Currency | FTI_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALS_LC | Spot Valuation of Sale Currency in Local Currency | FTI_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALS_VC | Spot Valuation of Sale Currency in Valuation Currency | FTI_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Currency | FTI_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_LC | Swap or Margin Accrual/Deferral in Local Currency | FTI_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_VC | Swap or Margin Accrual/Deferral in Valuation Currency | FTI_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPVAL_LC | Swap Valuation in Local Currency | FTI_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPVAL_VC | Swap Valuation in Valuation Currency | FTI_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
SHWHR | Local Currency | TPM_LOCAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
CONS_GAINS_TI_PC | Consolidated Security Gains in Position Currency | FTI_CONS_GAINS_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_LC | Consolidated Security Gains in Local Currency | FTI_CONS_GAINS_TI_LC | 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_LC | Consolidated Security Losses in Local Currency | FTI_CONS_LOSSES_TI_LC | 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 | ||||
CONS_GAINS_FX_LC | Consolidated FX Gains in Local Currency | FTI_CONS_GAINS_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_FX_LC | Consolidated FX Losses in Local Currency | FTI_CONS_LOSSES_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_LC | Value Adjustment of Gains in Local Currency | FTI_VAD_GAIN_LC | 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_LC | Value Adjustment of Losses in Local Currency | FTI_VAD_LOSS_LC | 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_LC | Original Value Adjustment in Local Currency | FTI_ORIG_VAD_LC | 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 | ||||
HADJ_LC | Hedge Adjustment in Local Currency | FTI_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_VC | Hedge Adjustment in Valuation Currency | FTI_HADJ_VC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_LC | Effective Amount in Local Currency | FTI_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_PC | Effective Amount in Position Currency | FTI_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_VC | Effective Amount in Valuation Currency | FTI_EFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_LC | Effective Dormant Amount in Local Currency | FTI_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_PC | Effective Amount (Dormant) in Position Currency | FTI_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_VC | Effective Amount (Dormant) in Valuation Currency | FTI_EFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_LC | Ineffective Amount in Local Currency | FTI_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_PC | Ineffective Amount in Position Currency | FTI_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_VC | Ineffective Amount in Valuation Currency | FTI_INEFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_LC | Ineffective Dormant Amount in Local Currency | FTI_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_PC | Ineffective Amount (Dormant) in Position Currency | FTI_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_VC | Ineffective Amount (Dormant) in Valuation Currency | FTI_INEFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
ZERO_POSITION | Zero Position on Key Date | FTI_ZERO_POSITION | DEC | 1 | FTI_ZERO_POSITION |
Key field | Non-key field |
How do I retrieve data from SAP structure TRLS_REPORTING_POS_VALUES using ABAP code?
As TRLS_REPORTING_POS_VALUES 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_REPORTING_POS_VALUES as there is no data to select.How to access SAP table TRLS_REPORTING_POS_VALUES
Within an ECC or HANA version of SAP you can also view further information about TRLS_REPORTING_POS_VALUES 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