SAP ABAP View TRQV_SUBTOT_POS (CFM: View via Position with Transacction Figure)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-BO (Application Component) Back Office
     ⤷ FTR_SECURITY_ACCOUNT_MGT (Package) Treasury: Securities Account Management

Basic Data

View Type	D	Database View
Database View	TRQV_SUBTOT_POS
Short Description	CFM: View via Position with Transacction Figure
Root table	TRQT_POSITION	Treasury: Quantity Ledger Position

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRQT_POSITION	MANDT		☐	MANDT	☐	Client
2	POS_GUID	TRQT_POSITION	OS_GUID		☐	TPM_QUANTITIY_POSITION	☐	Quantity Position
3	POSITION_CAT	TRQT_POSITION	POSITION_CAT		☐	TPM_QUAN_POS_CAT	☐	Position Category - Collective/Single Position
4	CONSUMPTION_CAT	TRQT_POSITION	CONSUMPTION_CAT		☐	TPM_CONSUMPTION_CAT	☐	Consumption Sequence Procedure
5	QUANTITY_CAT	TRQT_POSITION	QUANTITY_CAT		☐	TPM_QUANTITY_CAT	☐	Position Quantity Category
6	DIFF_GUID	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
7	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
8	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
9	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
10	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
11	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
12	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
13	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
14	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
15	LOT_ID	DIFT_POS_IDENT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
16	SUBTOTAL_GUID	TRQT_SUBTOTAL	SUBTOTAL_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
17	POSITION_DATE	TRQT_SUBTOTAL	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
18	NOMINAL_AMT	TRQT_SUBTOTAL	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
19	NOMINAL_CURR	TRQT_SUBTOTAL	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
20	UNITS	TRQT_SUBTOTAL	UNITS		☐	TPM_UNITS	☐	Units
21	POSITION_GUID	TRQT_SUBTOTAL	POSITION_GUID		☐	TPM_QUANTITIY_POSITION	☐	Quantity Position

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	462_10