SAP ABAP Table TRLV_POSITION (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRLV_POSITION	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	OS_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
4	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
5	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
6	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
7	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
8	ACCOUNTING_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
9	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
12	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
13	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
14	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
15	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
16	POS_MAN_PROC	☐	TPM_POS_MAN_PROC	TPM_POS_MAN_PROC	CHAR	4	0	Position Management Procedure
17	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
18	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
19	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
20	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
21	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
22	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
23	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
24	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator
25	SKWG14NEU	☐	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
26	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
27	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
28	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
29	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
30	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
31	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
32	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
33	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in