TRLS_VALUES_PER_DATE SAP (Structure for Reporting on TRL Positions per Key Date) Structure details

Dictionary Type: Structure
Description: Structure for Reporting on TRL Positions per Key Date




ABAP Code to SELECT data from TRLS_VALUES_PER_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_DATEPosition Value Date TPM_POSITION_DATEDATS8TPM_POSITION_DATE
POSITION_VALUES 0
SUBPOS_VALUES 0
SIMULATED_VALUES 0
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5WAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5WAERS
LOCAL_CURRCurrency Key WAERSCUKY5WAERSFWS
S_VAL_TI_PCSecurity Valuation in Position Currency (Simulation) FTI_S_VAL_TI_PCCURR21(2) TPM_AMOUNT
S_VAL_TI_LCSecurity Valuation in Local Currency (Simulation) FTI_S_VAL_TI_LCCURR21(2) TPM_AMOUNT
S_VAL_TI_VCSecurity Valuation in Valuation Currency (Simulation) FTI_S_VAL_TI_VCCURR21(2) TPM_AMOUNT
S_VAL_FX_LCForeign Currency Valuation in Local Currency (Simulation) FTI_S_VAL_FX_LCCURR21(2) TPM_AMOUNT
S_VAL_FX_VCForeign Currency Valuation in Valuation Crcy (Simulation) FTI_S_VAL_FX_VCCURR21(2) TPM_AMOUNT
S_VAL_AMAQU_FX_VCFX Valuation of Amort. Acquisition Value in VC (Simulation) FTI_S_VAL_AMAQU_FX_VCCURR21(2) TPM_AMOUNT
S_VAL_AMAQU_FX_LCFX Valuation of Amort. Acquisition Value in LC (Simulation) FTI_S_VAL_AMAQU_FX_LCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_PCValuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) FTI_S_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_LCValuation of Capitalized Costs, Sec., in Local Crcy (Simul.) FTI_S_VAL_CH_TI_LCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_VCValuation of Capitalized Costs, Sec., in Val. Crcy (Simul.) FTI_S_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
S_VAL_CH_FX_LCValuation of Capitalized Costs, FX, in Local Crcy (Simul.) FTI_S_VAL_CH_FX_LCCURR21(2) TPM_AMOUNT
S_VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Val. Crcy (Simul.) FTI_S_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
S_AMORT_PCAmortization in Position Currency (Simulation) FTI_S_AMORT_PCCURR21(2) TPM_AMOUNT
S_AMORT_LCAmortization in Local Currency (Simulation) FTI_S_AMORT_LCCURR21(2) TPM_AMOUNT
S_AMORT_VCAmortization in Valuation Currency (Simulation) FTI_S_AMORT_VCCURR21(2) TPM_AMOUNT
S_DISAGIO_PCCleared PD Def./Tax Compensation in Pos. Crcy: Simulation FTI_S_DISAGIO_PCCURR21(2) TPM_AMOUNT
S_DISAGIO_LCCleared PD Def./Tax Compensation in Local Crcy: Simulation FTI_S_DISAGIO_LCCURR21(2) TPM_AMOUNT
S_DISAGIO_VCCleared PD Def./Tax Compensation in Val. Crcy: Simulation FTI_S_DISAGIO_VCCURR21(2) TPM_AMOUNT
S_VAL_TI_NPL_PCSecurity Valuation, Not Affecting P/L, in PC (Simulation) FTI_S_VAL_TI_NPL_PCCURR21(2) TPM_AMOUNT
S_VAL_TI_NPL_LCSecurity Valuation, Not Affecting P/L, in LC (Simulation) FTI_S_VAL_TI_NPL_LCCURR21(2) TPM_AMOUNT
S_VAL_TI_NPL_VCSecurity Valuation, Not Affecting P/L, in VC (Simulation) FTI_S_VAL_TI_NPL_VCCURR21(2) TPM_AMOUNT
S_VAL_FX_NPL_LCForeign Currency Valuation, Not Aff. P/L, in LC (Simulation) FTI_S_VAL_FX_NPL_LCCURR21(2) TPM_AMOUNT
S_VAL_FX_NPL_VCForeign Currency Valuation, Not Aff. P/L, in VC (Simulation) FTI_S_VAL_FX_NPL_VCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_NPL_PCValuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) FTI_S_VAL_CH_TI_NPL_PCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_NPL_LCValuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) FTI_S_VAL_CH_TI_NPL_LCCURR21(2) TPM_AMOUNT
S_VAL_CH_TI_NPL_VCValuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.) FTI_S_VAL_CH_TI_NPL_VCCURR21(2) TPM_AMOUNT
S_VAL_CH_FX_NPL_LCValuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) FTI_S_VAL_CH_FX_NPL_LCCURR21(2) TPM_AMOUNT
S_VAL_CH_FX_NPL_VCValuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.) FTI_S_VAL_CH_FX_NPL_VCCURR21(2) TPM_AMOUNT
S_SPOTVALP_LCSpot Valuation, Purchase Currency, in Local Crcy: Simulation FTI_S_SPOTVALP_LCCURR21(2) TPM_AMOUNT
S_SPOTVALP_VCSpot Valuation, Purchase Currency, in Val. Crcy: Simulation FTI_S_SPOTVALP_VCCURR21(2) TPM_AMOUNT
S_SPOTVALS_LCSpot Valuation, Sale Currency, in Local Crcy: Simulation FTI_S_SPOTVALS_LCCURR21(2) TPM_AMOUNT
S_SPOTVALS_VCSpot Valuation, Sale Currency, in Valuation Crcy: Simulation FTI_S_SPOTVALS_VCCURR21(2) TPM_AMOUNT
S_SWAPACC_PCSwap/Margin Accrual/Deferral in Position Crcy (Simulation) FTI_S_SWAPACC_PCCURR21(2) TPM_AMOUNT
S_SWAPACC_LCSwap/Margin Accrual/Deferral in Local Currency: Simulation FTI_S_SWAPACC_LCCURR21(2) TPM_AMOUNT
S_SWAPACC_VCSwap/Margin Accrual/Deferral in Valuation Crcy: Simulation FTI_S_SWAPACC_VCCURR21(2) TPM_AMOUNT
S_SWAPVAL_LCSwap Valuation in Local Currency: Simulation FTI_S_SWAPVAL_LCCURR21(2) TPM_AMOUNT
S_SWAPVAL_VCSwap Valuation in Valuation Currency: Simulation FTI_S_SWAPVAL_VCCURR21(2) TPM_AMOUNT
S_VALID_DATEDate of Found Rate or Present Value TPM_VALID_DATEDATS8DATS
S_VALID_RATE_DATEDate of Exchange Rate Found TPM_VALID_RATE_DATEDATS8DATS
S_MAPMarket Price TPM_MAPDEC15(6) VVPKTKUR
S_MAVMarket Value in Position Currency TPM_MAV_PCCURR21(2) TPM_AMOUNT
S_MAR_FEExchange Rate - Position/Valuation Currency on Market TPM_MAR_FEDEC9(5) EXCRTUKURS
S_SPOT_RATE_PSpot Rate Purchase Currency/Valuation Currency in the Market TPM_SPOT_RATE_PDEC9(5) EXCRTUKURS
S_SPOT_RATE_SSpot Rate Sales Currency/Valuation Currency in the Market TPM_SPOT_RATE_SDEC9(5) EXCRTUKURS
S_SWAP_RATE_PSwap Rate Purchase Currency/Valuation Currency in the Market TPM_SWAP_RATE_PDEC9(5) TB_DEVSWSA
S_SWAP_RATE_SSwap Rate Sales Currency/Valuation Currency in the Market TPM_SWAP_RATE_SDEC9(5) TB_DEVSWSA
S_EFFECTIVE_LCSimulated Effective Amount in Local Currency FTI_S_EFFECTIVE_LCCURR21(2) TPM_AMOUNT
S_EFFECTIVE_PCSimulated Effective Amount in Position Currency FTI_S_EFFECTIVE_PCCURR21(2) TPM_AMOUNT
S_INEFFECTIVE_LCSimulated Ineffective Amount in Local Currency FTI_S_INEFFECTIVE_LCCURR21(2) TPM_AMOUNT
S_INEFFECTIVE_PCSimulated Ineffective Amount in Position Currency FTI_S_INEFFECTIVE_PCCURR21(2) TPM_AMOUNT
S_EFFECTIVE_DORMANT_LCSimulated: Effective Dormant Amount in Local Currency FTI_S_EFFECTIVE_DORMANT_LCCURR21(2) TPM_AMOUNT
S_EFFECTIVE_DORMANT_PCSimulated Effective Dormant Amount in Position Currency FTI_S_EFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
S_INEFFECTIVE_DORMANT_LCSimulated Ineffective Dormant Amount in Local Currency FTI_S_INEFFECTIVE_DORMANT_LCCURR21(2) TPM_AMOUNT
S_INEFFECTIVE_DORMANT_PCSimulated Ineffective Dormant Amount in Position Currency FTI_S_INEFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
S_HADJ_LCSimulated Hedge Adjustment in Local Currency FTI_S_HADJ_LCCURR21(2) TPM_AMOUNT
S_HADJ_PCSimulated Hedge Adjustment in Position Currency FTI_S_HADJ_PCCURR21(2) TPM_AMOUNT
S_ORIG_VAD_LCSimulated Original Value Adjustment in Local Currency FTI_S_ORIG_VAD_LCCURR21(2) TPM_AMOUNT
S_ORIG_VAD_PCSimulated Original Value Adjustment in Position Currency FTI_S_ORIG_VAD_PCCURR21(2) TPM_AMOUNT
S_VAD_GAIN_LCSimulated Value Adjustment of Gains in Local Currency FTI_S_VAD_GAIN_LCCURR21(2) TPM_AMOUNT
S_VAD_GAIN_PC Simulated Value Adjustment of Gains in Position Currency FTI_S_VAD_GAIN_PCCURR21(2) TPM_AMOUNT
S_VAD_LOSS_LCSimulated Value Adjustment of Losses in Local Currency FTI_S_VAD_LOSS_LCCURR21(2) TPM_AMOUNT
S_VAD_LOSS_PCSimulated Value Adjustment of Losses in Position Currency FTI_S_VAD_LOSS_PCCURR21(2) TPM_AMOUNT
FLOWS 0
PL_FLOWS 0
POSITION_VALUES2 0
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5WAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5WAERS
LOCAL_CURRCurrency Key WAERSCUKY5WAERSFWS
DISPLAY_CURRDisplay Currency FTI_ANZGWCUKY5WAERSFFZ
ACC_INTEREST_PCAccrued Interest in Position Currency FTI_ACC_INTEREST_PCCURR21(2) TPM_AMOUNT
ACC_INTEREST_DCAccrued Interest in Display Currency (From PC) FTI_ACC_INTEREST_DCCURR21(2) TPM_AMOUNT
UNITS_LOCKEDNumber of Blocked Units FTI_UNITS_LOCKEDDEC22(6) TPM_UNITS
NOMINAL_AMT_LO_PCLocked Nominal Amount in Position Currency FTI_NOMINAL_AMT_LO_PCCURR21(2) TPM_AMOUNT
NOMINAL_AMT_LO_DCLocked Nominal Amount in Display Currency (From Pos. Crcy) FTI_NOMINAL_AMT_LO_DCCURR21(2) TPM_AMOUNT
ACC_DEF_INT_PCAccrued Interest in Position Currency FTI_ACC_INTEREST_PCCURR21(2) TPM_AMOUNT
ACC_DEF_INT_DCAccrued Interest in Display Currency (From PC) FTI_ACC_INTEREST_DCCURR21(2) TPM_AMOUNT
ACC_DEF_INT_VCAccrued Interest in Valuation Currency FTI_ACC_INTEREST_VCCURR21(2) TPM_AMOUNT
ACC_DEF_INT_LCAccrued Interest in Local Currency FTI_ACC_INTEREST_LCCURR21(2) TPM_AMOUNT
ZERO_POSITIONZero Position on Key Date FTI_ZERO_POSITIONDEC1FTI_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 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!