SAP ABAP View TRQV_LOT (CFM: View of TRQ Lots with Selectors)

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_LOT
Short Description	CFM: View of TRQ Lots with Selectors
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_LOT

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_LOT	MANDT	JR	EQ			AND	0	0
7	TRQT_POSITION	OS_GUID	JL	EQ				0	0
8	TRQT_LOT	POSITION_OID	JR	EQ			AND	0	0
9	DIFT_POS_IDENT	CONTEXT		EQ	'TRQ'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRQT_POSITION	MANDT		☐	MANDT	☐	Client
2	POSITION_OID	TRQT_POSITION	OS_GUID		☐	TPM_QUANTITIY_POSITION	☐	Quantity Position
3	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
4	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
5	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
6	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
7	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
8	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
9	TRADER	DIFT_POS_IDENT	TRADER		☐	RDEALER	☐	Trader
10	POSITION_CAT	TRQT_POSITION	POSITION_CAT		☐	TPM_QUAN_POS_CAT	☐	Position Category - Collective/Single Position
11	CONSUMPTION_CAT	TRQT_POSITION	CONSUMPTION_CAT		☐	TPM_CONSUMPTION_CAT	☐	Consumption Sequence Procedure
12	QUANTITY_CAT	TRQT_POSITION	QUANTITY_CAT		☐	TPM_QUANTITY_CAT	☐	Position Quantity Category
13	NOMINAL_CURR	TRQT_POSITION	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
14	SELECTOR_OID	TRQT_POSITION	SELECTOR_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	SELECTOR_CLS	TRQT_POSITION	SELECTOR_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
16	LOT_GUID	TRQT_LOT	OS_GUID		☐	TPM_POSITION_LOT	☐	Lot
17	POSITION_DATE	TRQT_LOT	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
18	ORIGIN_DATE	TRQT_LOT	ORIGIN_DATE		☐	TPM_ORIGIN_DATE	☐	Original Position Acquisition Date
19	BUSTRANSID	TRQT_LOT	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
20	LOT_ID	TRQT_LOT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
21	FLAG_INACTIVE	TRQT_LOT	FLAG_INACTIVE		☐	TPM_FLAG_INACTIVE	☐	Inactive indicator

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