SAP ABAP Table TRQV_SUBTOT_POS (Generated Table for View TRQV_SUBTOT_POS)

Basic Data

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

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	POS_GUID	☑	TPM_QUANTITIY_POSITION	TPM_DB_OS_GUID	CHAR	32	0	Quantity Position
3	POSITION_CAT	☑	TPM_QUAN_POS_CAT	TPM_QUAN_POS_CAT	CHAR	1	0	Position Category - Collective/Single Position
4	CONSUMPTION_CAT	☑	TPM_CONSUMPTION_CAT	TPM_CONSUMPTION_CAT	CHAR	1	0	Consumption Sequence Procedure
5	QUANTITY_CAT	☑	TPM_QUANTITY_CAT	TPM_QUANTITY_CAT	CHAR	1	0	Position Quantity Category
6	DIFF_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
7	COM_VAL_CLASS	☑	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
8	COMPANY_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	PRODUCT_TYPE	☑	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	SECURITY_ACCOUNT	☑	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
11	SECURITY_ID	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
12	PORTFOLIO	☑	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
13	POSITION_ACCOUNT	☑	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
14	FLAG_LONG_SHORT	☑	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
15	LOT_ID	☑	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
16	SUBTOTAL_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
17	POSITION_DATE	☐	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
18	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
19	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
20	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
21	POSITION_GUID	☐	TPM_QUANTITIY_POSITION	TPM_DB_OS_GUID	CHAR	32	0	Quantity Position	TRQT_POSITION

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRQV_SUBTOT_POS	COMPANY_CODE	T001	BUKRS
2	TRQV_SUBTOT_POS	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
3	TRQV_SUBTOT_POS	PORTFOLIO	TWPOB	RPORTB
4	TRQV_SUBTOT_POS	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT	KEY	1	CN
5	TRQV_SUBTOT_POS	POSITION_GUID	TRQT_POSITION	OS_GUID	KEY	1	CN
6	TRQV_SUBTOT_POS	PRODUCT_TYPE	TZPA	GSART
7	TRQV_SUBTOT_POS	SECURITY_ACCOUNT	TWD01	RLDEPO
8	TRQV_SUBTOT_POS	SECURITY_ID	VWPANLA	RANL

History

Last changed by/on	SAP	20080505
SAP Release Created in