SAP ABAP Table TRQV_SUBTOTAL (Generated Table for View TRQV_SUBTOTAL)

Basic Data

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

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	VALUATION_AREA	☑	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
4	COM_VAL_CLASS	☑	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
5	COMPANY_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	SECURITY_ACCOUNT	☑	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
7	PRODUCT_TYPE	☑	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
8	SECURITY_ID	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
9	PORTFOLIO	☑	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
10	POSITION_ACCOUNT	☑	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
11	FLAG_LONG_SHORT	☑	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
12	SUBTOTAL_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
13	POSITION_DATE	☐	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
14	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
15	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
16	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
17	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units

Foreign Keys

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

History

Last changed by/on	SAP	20080505
SAP Release Created in