SAP ABAP Table TRQV_LOT (Generated Table for View TRQV_LOT)

Basic Data

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

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	POSITION_OID	☑	TPM_QUANTITIY_POSITION	TPM_DB_OS_GUID	CHAR	32	0	Quantity Position
3	COM_VAL_CLASS	☑	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
4	COMPANY_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	SECURITY_ACCOUNT	☑	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
6	POSITION_ACCOUNT	☑	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
7	SECURITY_ID	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
8	PORTFOLIO	☑	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
9	TRADER	☑	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
10	POSITION_CAT	☑	TPM_QUAN_POS_CAT	TPM_QUAN_POS_CAT	CHAR	1	0	Position Category - Collective/Single Position
11	CONSUMPTION_CAT	☑	TPM_CONSUMPTION_CAT	TPM_CONSUMPTION_CAT	CHAR	1	0	Consumption Sequence Procedure
12	QUANTITY_CAT	☑	TPM_QUANTITY_CAT	TPM_QUANTITY_CAT	CHAR	1	0	Position Quantity Category
13	NOMINAL_CURR	☑	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
14	SELECTOR_OID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	DIFT_POS_IDENT
15	SELECTOR_CLS	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
16	LOT_GUID	☑	TPM_POSITION_LOT	TPM_DB_OS_GUID	CHAR	32	0	Lot
17	POSITION_DATE	☐	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
18	ORIGIN_DATE	☐	TPM_ORIGIN_DATE	TPM_ORIGIN_DATE	DATS	8	0	Original Position Acquisition Date
19	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
20	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
21	FLAG_INACTIVE	☐	TPM_FLAG_INACTIVE	XFELD	CHAR	1	0	Inactive indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRQV_LOT	COMPANY_CODE	T001	BUKRS
2	TRQV_LOT	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
3	TRQV_LOT	PORTFOLIO	TWPOB	RPORTB
4	TRQV_LOT	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT	KEY	1	CN
5	TRQV_LOT	SECURITY_ACCOUNT	TWD01	RLDEPO
6	TRQV_LOT	SECURITY_ID	VWPANLA	RANL
7	TRQV_LOT	SELECTOR_OID	DIFT_POS_IDENT	OS_GUID		1	1
8	TRQV_LOT	TRADER	TZDEA	RDEALER

History

Last changed by/on	SAP	20080505
SAP Release Created in