TRLS_VALUES_PER_DATE SAP (Structure for Reporting on TRL Positions per Key Date) Structure details
Description: Structure for Reporting on TRL Positions per Key Date
Related tables to TRLS_VALUES_PER_DATE
Access table TRLS_VALUES_PER_DATE
Structure field list including key, data, relationships and ABAP select examples
TRLS_VALUES_PER_DATE 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 for Reporting on TRL Positions per Key Date" 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_VALUES_PER_DATE TYPE TRLS_VALUES_PER_DATE.
The TRLS_VALUES_PER_DATE table consists of various fields, each holding specific information or linking keys about Structure for Reporting on TRL Positions per Key Date data available in SAP. These include POSITION_VALUES (), SUBPOS_VALUES (), SIMULATED_VALUES (), POSITION_CURR (Position Currency).. 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 TRLS_VALUES_PER_DATE 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_DATE | Position Value Date | TPM_POSITION_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
POSITION_VALUES | 0 | ||||||||
SUBPOS_VALUES | 0 | ||||||||
SIMULATED_VALUES | 0 | ||||||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | WAERS | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | WAERS | ||||
LOCAL_CURR | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
S_VAL_TI_PC | Security Valuation in Position Currency (Simulation) | FTI_S_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_LC | Security Valuation in Local Currency (Simulation) | FTI_S_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_VC | Security Valuation in Valuation Currency (Simulation) | FTI_S_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_LC | Foreign Currency Valuation in Local Currency (Simulation) | FTI_S_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_VC | Foreign Currency Valuation in Valuation Crcy (Simulation) | FTI_S_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_AMAQU_FX_VC | FX Valuation of Amort. Acquisition Value in VC (Simulation) | FTI_S_VAL_AMAQU_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_AMAQU_FX_LC | FX Valuation of Amort. Acquisition Value in LC (Simulation) | FTI_S_VAL_AMAQU_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_PC | Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) | FTI_S_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_LC | Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.) | FTI_S_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_VC | Valuation of Capitalized Costs, Sec., in Val. Crcy (Simul.) | FTI_S_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Crcy (Simul.) | FTI_S_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Val. Crcy (Simul.) | FTI_S_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_PC | Amortization in Position Currency (Simulation) | FTI_S_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_LC | Amortization in Local Currency (Simulation) | FTI_S_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_VC | Amortization in Valuation Currency (Simulation) | FTI_S_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_PC | Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation | FTI_S_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_LC | Cleared PD Def./Tax Compensation in Local Crcy: Simulation | FTI_S_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_VC | Cleared PD Def./Tax Compensation in Val. Crcy: Simulation | FTI_S_DISAGIO_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in PC (Simulation) | FTI_S_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in LC (Simulation) | FTI_S_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_VC | Security Valuation, Not Affecting P/L, in VC (Simulation) | FTI_S_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_NPL_LC | Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation) | FTI_S_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_NPL_VC | Foreign Currency Valuation, Not Aff. P/L, in VC (Simulation) | FTI_S_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) | FTI_S_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_NPL_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) | FTI_S_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_NPL_VC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.) | FTI_S_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_NPL_LC | Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) | FTI_S_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_NPL_VC | Valuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.) | FTI_S_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALP_LC | Spot Valuation, Purchase Currency, in Local Crcy: Simulation | FTI_S_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALP_VC | Spot Valuation, Purchase Currency, in Val. Crcy: Simulation | FTI_S_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALS_LC | Spot Valuation, Sale Currency, in Local Crcy: Simulation | FTI_S_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALS_VC | Spot Valuation, Sale Currency, in Valuation Crcy: Simulation | FTI_S_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Crcy (Simulation) | FTI_S_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_LC | Swap/Margin Accrual/Deferral in Local Currency: Simulation | FTI_S_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_VC | Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation | FTI_S_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPVAL_LC | Swap Valuation in Local Currency: Simulation | FTI_S_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPVAL_VC | Swap Valuation in Valuation Currency: Simulation | FTI_S_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VALID_DATE | Date of Found Rate or Present Value | TPM_VALID_DATE | DATS | 8 | DATS | ||||
S_VALID_RATE_DATE | Date of Exchange Rate Found | TPM_VALID_RATE_DATE | DATS | 8 | DATS | ||||
S_MAP | Market Price | TPM_MAP | DEC | 15(6) | VVPKTKUR | ||||
S_MAV | Market Value in Position Currency | TPM_MAV_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_MAR_FE | Exchange Rate - Position/Valuation Currency on Market | TPM_MAR_FE | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_P | Spot Rate Purchase Currency/Valuation Currency in the Market | TPM_SPOT_RATE_P | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_S | Spot Rate Sales Currency/Valuation Currency in the Market | TPM_SPOT_RATE_S | DEC | 9(5) | EXCRT | UKURS | |||
S_SWAP_RATE_P | Swap Rate Purchase Currency/Valuation Currency in the Market | TPM_SWAP_RATE_P | DEC | 9(5) | TB_DEVSWSA | ||||
S_SWAP_RATE_S | Swap Rate Sales Currency/Valuation Currency in the Market | TPM_SWAP_RATE_S | DEC | 9(5) | TB_DEVSWSA | ||||
S_EFFECTIVE_LC | Simulated Effective Amount in Local Currency | FTI_S_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_PC | Simulated Effective Amount in Position Currency | FTI_S_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_LC | Simulated Ineffective Amount in Local Currency | FTI_S_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_PC | Simulated Ineffective Amount in Position Currency | FTI_S_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_DORMANT_LC | Simulated: Effective Dormant Amount in Local Currency | FTI_S_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_DORMANT_PC | Simulated Effective Dormant Amount in Position Currency | FTI_S_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_DORMANT_LC | Simulated Ineffective Dormant Amount in Local Currency | FTI_S_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_DORMANT_PC | Simulated Ineffective Dormant Amount in Position Currency | FTI_S_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_HADJ_LC | Simulated Hedge Adjustment in Local Currency | FTI_S_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_HADJ_PC | Simulated Hedge Adjustment in Position Currency | FTI_S_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_ORIG_VAD_LC | Simulated Original Value Adjustment in Local Currency | FTI_S_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_ORIG_VAD_PC | Simulated Original Value Adjustment in Position Currency | FTI_S_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_GAIN_LC | Simulated Value Adjustment of Gains in Local Currency | FTI_S_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_GAIN_PC | Simulated Value Adjustment of Gains in Position Currency | FTI_S_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_LOSS_LC | Simulated Value Adjustment of Losses in Local Currency | FTI_S_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_LOSS_PC | Simulated Value Adjustment of Losses in Position Currency | FTI_S_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
FLOWS | 0 | ||||||||
PL_FLOWS | 0 | ||||||||
POSITION_VALUES2 | 0 | ||||||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | WAERS | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | WAERS | ||||
LOCAL_CURR | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
DISPLAY_CURR | Display Currency | FTI_ANZGW | CUKY | 5 | WAERS | FFZ | |||
ACC_INTEREST_PC | Accrued Interest in Position Currency | FTI_ACC_INTEREST_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_INTEREST_DC | Accrued Interest in Display Currency (From PC) | FTI_ACC_INTEREST_DC | CURR | 21(2) | TPM_AMOUNT | ||||
UNITS_LOCKED | Number of Blocked Units | FTI_UNITS_LOCKED | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT_LO_PC | Locked Nominal Amount in Position Currency | FTI_NOMINAL_AMT_LO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_AMT_LO_DC | Locked Nominal Amount in Display Currency (From Pos. Crcy) | FTI_NOMINAL_AMT_LO_DC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_PC | Accrued Interest in Position Currency | FTI_ACC_INTEREST_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_DC | Accrued Interest in Display Currency (From PC) | FTI_ACC_INTEREST_DC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_VC | Accrued Interest in Valuation Currency | FTI_ACC_INTEREST_VC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_LC | Accrued Interest in Local Currency | FTI_ACC_INTEREST_LC | 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_VALUES_PER_DATE using ABAP code?
As TRLS_VALUES_PER_DATE 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_VALUES_PER_DATE as there is no data to select.How to access SAP table TRLS_VALUES_PER_DATE
Within an ECC or HANA version of SAP you can also view further information about TRLS_VALUES_PER_DATE 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