SAP ABAP Table TRLS_REPORTING_POS_VALUES (Reporting Structure with Position Values)

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_REPORTING_POS_VALUES	Table Relationship Diagram
Short Description	Reporting Structure with Position Values

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	.INCLUDE	☐				0	0	Structure for Differentiation Values
2	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
3	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
4	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
5	ACCOUNTING_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
6	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
8	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
9	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
10	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
11	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
12	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
13	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
14	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
15	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
16	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
17	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
18	.INCLUDE	☐				0	0	Mapping Structure - Reporting for Par. Positions: Pos.Values
19	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
20	UNITS	☐	FTI_UNITS	TPM_UNITS	DEC	22	6	Number of units
21	NOMINAL_AMT_PC	☐	FTI_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Nominal Amount in Position Currency
22	NOMINAL_ORG_AMT_PC	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
23	PURCH_PC	☐	FTI_PURCH_PC	TPM_AMOUNT	CURR	21	2	Purchase Value in Position Currency
24	PURCH_LC	☐	FTI_PURCH_LC	TPM_AMOUNT	CURR	21	2	Purchase Value in Local Currency
25	PURCH_VC	☐	FTI_PURCH_VC	TPM_AMOUNT	CURR	21	2	Purchase Value in Valuation Currency
26	AQU_VAL_PC	☐	FTI_AQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Position Currency
27	AQU_VAL_LC	☐	FTI_AQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Local Currency
28	AQU_VAL_VC	☐	FTI_AQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Valuation Currency
29	BOOK_VAL_PC	☐	FTI_BOOK_VAL_PC	TPM_AMOUNT	CURR	21	2	Book Value in Position Currency
30	BOOK_VAL_LC	☐	FTI_BOOK_VAL_LC	TPM_AMOUNT	CURR	21	2	Book Value in Local Currency
31	BOOK_VAL_VC	☐	FTI_BOOK_VAL_VC	TPM_AMOUNT	CURR	21	2	Book Value in Valuation Currency
32	CHARGE_PC	☐	FTI_CHARGE_PC	TPM_AMOUNT	CURR	21	2	Costs in position currency
33	CHARGE_LC	☐	FTI_CHARGE_LC	TPM_AMOUNT	CURR	21	2	Costs in Local Currency
34	CHARGE_VC	☐	FTI_CHARGE_VC	TPM_AMOUNT	CURR	21	2	Costs in Valuation Currency
35	BOOK_VAL_EX_PC	☐	FTI_BOOK_VAL_EX_PC	TPM_AMOUNT	CURR	21	2	Book Value Excluding Costs in Position Currency
36	BOOK_VAL_EX_LC	☐	FTI_BOOK_VAL_EX_LC	TPM_AMOUNT	CURR	21	2	Book Value Excluding Costs in Local Currency
37	BOOK_VAL_EX_VC	☐	FTI_BOOK_VAL_EX_VC	TPM_AMOUNT	CURR	21	2	Book Value Excluding Costs in Valuation Currency
38	VAL_TI_PC	☐	FTI_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency
39	VAL_TI_LC	☐	FTI_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency
40	VAL_TI_VC	☐	FTI_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency
41	VAL_FX_LC	☐	FTI_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency
42	VAL_FX_VC	☐	FTI_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Currency
43	VAL_CH_TI_PC	☐	FTI_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Position Currency
44	VAL_CH_TI_LC	☐	FTI_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Local Currency
45	VAL_CH_TI_VC	☐	FTI_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Valuation Currency
46	VAL_CH_FX_LC	☐	FTI_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Local Currency
47	VAL_CH_FX_VC	☐	FTI_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Valuation Currency
48	AMORT_PC	☐	FTI_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency
49	AMORT_LC	☐	FTI_AMORT_LC	TPM_AMOUNT	CURR	21	2	Amortization in Local Currency
50	AMORT_VC	☐	FTI_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency
51	IMPMNT_PC	☐	FTI_IMPMNT_PC	TPM_AMOUNT	CURR	21	2	Impairment in Position Currency
52	IMPMNT_LC	☐	FTI_IMPMNT_LC	TPM_AMOUNT	CURR	21	2	Impairment in Local Currency
53	IMPMNT_VC	☐	FTI_IMPMNT_VC	TPM_AMOUNT	CURR	21	2	Impairment in Valuation Currency
54	REPAYMENT_PC	☐	TPM_REPAYMENT_PC	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Position Currency
55	REPAYMENT_LC	☐	TPM_REPAYMENT_LC	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Local Currency
56	REPAYMENT_VC	☐	TPM_REPAYMENT_VC	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Valuation Currency
57	AMAQU_VAL_PC	☐	FTI_AMAQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Amortized Acquisition Value in Position Currency
58	AMAQU_VAL_LC	☐	FTI_AMAQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Amortized Acquisition Value in Local Currency
59	AMAQU_VAL_VC	☐	FTI_AMAQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Amortized Acquisition Value in Valuation Currency
60	DISAGIO_PC	☐	FTI_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Cleared PD Deferral/Tax Compensation in Position Currency
61	DISAGIO_LC	☐	FTI_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Cleared PD Deferral/Tax Compensation in Local Currency
62	DISAGIO_VC	☐	FTI_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Cleared PD Deferral/Tax Compensation in Valuation Currency
63	VAL_TI_NPL_PC	☐	FTI_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in Position Currency
64	VAL_TI_NPL_LC	☐	FTI_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in Local Currency
65	VAL_TI_NPL_VC	☐	FTI_VAL_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Security Valuation, Not Affecting P/L, in Valuation Currency
66	VAL_FX_NPL_LC	☐	FTI_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Affecting P/L, in Local Crcy
67	VAL_FX_NPL_VC	☐	FTI_VAL_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy
68	VAL_CH_TI_NPL_PC	☐	FTI_VAL_CH_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy
69	VAL_CH_TI_NPL_LC	☐	FTI_VAL_CH_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L in Local Crcy
70	VAL_CH_TI_NPL_VC	☐	FTI_VAL_CH_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy
71	VAL_CH_FX_NPL_LC	☐	FTI_VAL_CH_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Aff. P/L in Local Currency
72	VAL_CH_FX_NPL_VC	☐	FTI_VAL_CH_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy
73	VARMAR_PC	☐	FTI_VARMAR_PC	TPM_AMOUNT	CURR	21	2	Variation Margin in Position Currency
74	VARMAR_LC	☐	FTI_VARMAR_LC	TPM_AMOUNT	CURR	21	2	Variation Margin in Local Currency
75	VARMAR_VC	☐	FTI_VARMAR_VC	TPM_AMOUNT	CURR	21	2	Variation Margin in Valuation Currency
76	SPOTVALP_LC	☐	FTI_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Purchase Currency in Local Currency
77	SPOTVALP_VC	☐	FTI_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Purchase Currency in Valuation Currency
78	SPOTVALS_LC	☐	FTI_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Sale Currency in Local Currency
79	SPOTVALS_VC	☐	FTI_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Spot Valuation of Sale Currency in Valuation Currency
80	SWAPACC_PC	☐	FTI_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Swap/Margin Accrual/Deferral in Position Currency
81	SWAPACC_LC	☐	FTI_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Swap or Margin Accrual/Deferral in Local Currency
82	SWAPACC_VC	☐	FTI_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Swap or Margin Accrual/Deferral in Valuation Currency
83	SWAPVAL_LC	☐	FTI_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Local Currency
84	SWAPVAL_VC	☐	FTI_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Swap Valuation in Valuation Currency
85	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
86	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
87	SHWHR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRLS_REPORTING_POS_VALUES	ACCOUNTING_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
2	TRLS_REPORTING_POS_VALUES	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
3	TRLS_REPORTING_POS_VALUES	COMPANY_CODE	T001	BUKRS
4	TRLS_REPORTING_POS_VALUES	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
5	TRLS_REPORTING_POS_VALUES	DEAL_NUMBER	VTBFHA	RFHA	KEY	1	CN
6	TRLS_REPORTING_POS_VALUES	LOANS_CONTRACT	VDARL	RANL
7	TRLS_REPORTING_POS_VALUES	PORTFOLIO	TWPOB	RPORTB
8	TRLS_REPORTING_POS_VALUES	PRODUCT_TYPE	TZPA	GSART
9	TRLS_REPORTING_POS_VALUES	SECURITY_ACCOUNT	TWD01	RLDEPO
10	TRLS_REPORTING_POS_VALUES	SECURITY_ID	VWPANLA	RANL
11	TRLS_REPORTING_POS_VALUES	TRADER	TZDEA	RDEALER
12	TRLS_REPORTING_POS_VALUES	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
13	TRLS_REPORTING_POS_VALUES	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS

History

Last changed by/on	SAP	20080505
SAP Release Created in	600