SAP ABAP View TRQV_SUBTOTAL (View Transaction Figure with Differentiations)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_QUANTITY_LEDGER (Package) Treasury: Quantity Ledger

Basic Data

View Type	D	Database View
Database View	TRQV_SUBTOTAL
Short Description	View Transaction Figure with Differentiations
Root table	TRQT_SUBTOTAL	Treasury: Table with Quantity Ledger Position Trans. Figures

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRQT_SUBTOTAL	TRQT_SUBTOTAL
2	TRQT_POSITION
3	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_POSITION	MANDT	JL	EQ				0	0
2	TRQT_SUBTOTAL	MANDT	JR	EQ			AND	0	0
3	TRQT_POSITION	OS_GUID	JL	EQ				0	0
4	TRQT_SUBTOTAL	POSITION_GUID	JR	EQ			AND	0	0
5	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
6	TRQT_POSITION	MANDT	JR	EQ			AND	0	0
7	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
8	TRQT_POSITION	SELECTOR_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	DIFT_POS_IDENT	MANDT		☐	MANDT	☐	Client
2	OS_GUID	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
4	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
5	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
6	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
7	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
8	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
9	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
10	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
11	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
12	SUBTOTAL_GUID	TRQT_SUBTOTAL	SUBTOTAL_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
13	POSITION_DATE	TRQT_SUBTOTAL	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
14	NOMINAL_AMT	TRQT_SUBTOTAL	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
15	NOMINAL_ORG_AMT	TRQT_SUBTOTAL	NOMINAL_ORG_AMT		☐	TPM_NOMINAL_ORG_AMT	☐	Original Nominal Amount in Position Currency
16	NOMINAL_CURR	TRQT_SUBTOTAL	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
17	UNITS	TRQT_SUBTOTAL	UNITS		☐	TPM_UNITS	☐	Units

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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