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

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_TREASURY_LEDGER (Package) Treasury Ledger

Basic Data

Table Category	INTTAB	Structure
Structure	TRLS_VALUES_PER_DATE	Table Relationship Diagram
Short Description	Structure for Reporting on TRL Positions per Key Date

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	POSITION_DATE	☐	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
2	POSITION_VALUES	☐	TPMY_VALUE		TTYP	0	0
3	SIMULATED_VALUES	☐	TLVS_FTI_LDB_SIM_POSITION		STRU	0	0
4	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
5	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
6	LOCAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key
7	S_VAL_TI_PC	☐	FTI_S_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency (Simulation)
8	S_VAL_TI_LC	☐	FTI_S_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency (Simulation)
9	S_VAL_TI_VC	☐	FTI_S_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency (Simulation)
10	S_VAL_FX_LC	☐	FTI_S_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency (Simulation)
11	S_VAL_FX_VC	☐	FTI_S_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Crcy (Simulation)
12	S_VAL_CH_TI_PC	☐	FTI_S_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.)
13	S_VAL_CH_TI_LC	☐	FTI_S_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.)
14	S_VAL_CH_TI_VC	☐	FTI_S_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, Sec., in Val. Crcy (Simul.)
15	S_VAL_CH_FX_LC	☐	FTI_S_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Local Crcy (Simul.)
16	S_VAL_CH_FX_VC	☐	FTI_S_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Val. Crcy (Simul.)
17	S_AMORT_PC	☐	FTI_S_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency (Simulation)
18	S_AMORT_LC	☐	FTI_S_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency (Simulation)
19	S_AMORT_VC	☐	FTI_S_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency (Simulation)
20	S_DISAGIO_PC	☐	FTI_S_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation
21	S_DISAGIO_LC	☐	FTI_S_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Local Crcy: Simulation
22	S_DISAGIO_VC	☐	FTI_S_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Cleared PD Def./Tax Compensation in Val. Crcy: Simulation
23	S_VAL_TI_NPL_PC	☐	FTI_S_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in PC (Simulation)
24	S_VAL_TI_NPL_LC	☐	FTI_S_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in LC (Simulation)
25	S_VAL_TI_NPL_VC	☐	FTI_S_VAL_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in VC (Simulation)
26	S_VAL_FX_NPL_LC	☐	FTI_S_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation)
27	S_VAL_FX_NPL_VC	☐	FTI_S_VAL_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Aff. P/L, in VC (Simulation)
28	S_VAL_CH_TI_NPL_PC	☐	FTI_S_VAL_CH_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.)
29	S_VAL_CH_TI_NPL_LC	☐	FTI_S_VAL_CH_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.)
30	S_VAL_CH_TI_NPL_VC	☐	FTI_S_VAL_CH_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.)
31	S_VAL_CH_FX_NPL_LC	☐	FTI_S_VAL_CH_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.)
32	S_VAL_CH_FX_NPL_VC	☐	FTI_S_VAL_CH_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.)
33	S_SPOTVALP_LC	☐	FTI_S_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Local Crcy: Simulation
34	S_SPOTVALP_VC	☐	FTI_S_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Purchase Currency, in Val. Crcy: Simulation
35	S_SPOTVALS_LC	☐	FTI_S_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Local Crcy: Simulation
36	S_SPOTVALS_VC	☐	FTI_S_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation, Sale Currency, in Valuation Crcy: Simulation
37	S_SWAPACC_PC	☐	FTI_S_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Crcy (Simulation)
38	S_SWAPACC_LC	☐	FTI_S_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Local Currency: Simulation
39	S_SWAPACC_VC	☐	FTI_S_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation
40	S_SWAPVAL_LC	☐	FTI_S_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency: Simulation
41	S_SWAPVAL_VC	☐	FTI_S_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency: Simulation
42	S_VALID_DATE	☐	TPM_VALID_DATE	DATS	DATS	8	0	Date of Found Rate or Present Value
43	S_VALID_RATE_DATE	☐	TPM_VALID_RATE_DATE	DATS	DATS	8	0	Date of Exchange Rate Found
44	S_MAP	☐	TPM_MAP	VVPKTKUR	DEC	15	6	Market Price
45	S_MAV	☐	TPM_MAV_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
46	S_MAR_FE	☐	TPM_MAR_FE	UKURS	DEC	9	5	Exchange Rate - Position/Valuation Currency on Market
47	S_SPOT_RATE_P	☐	TPM_SPOT_RATE_P	UKURS	DEC	9	5	Spot Rate Purchase Currency/Valuation Currency in the Market
48	S_SPOT_RATE_S	☐	TPM_SPOT_RATE_S	UKURS	DEC	9	5	Spot Rate Sales Currency/Valuation Currency in the Market
49	S_SWAP_RATE_P	☐	TPM_SWAP_RATE_P	TB_DEVSWSA	DEC	9	5	Swap Rate Purchase Currency/Valuation Currency in the Market
50	S_SWAP_RATE_S	☐	TPM_SWAP_RATE_S	TB_DEVSWSA	DEC	9	5	Swap Rate Sales Currency/Valuation Currency in the Market
51	FLOWS	☐	TRLY_FLOW_AND_TRANS1		TTYP	0	0
52	PL_FLOWS	☐	TRLY_FLOW_AND_TRANS1		TTYP	0	0
53	POSITION_VALUES2	☐	TRLS_REPORTING_VALUES2		STRU	0	0
54	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
55	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
56	LOCAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key
57	ACC_INTEREST_PC	☐	FTI_ACC_INTEREST_PC	TPM_AMOUNT	CURR	21	2	Accrued Interest in Position Currency

History

Last changed by/on	SAP	20110901
SAP Release Created in	110