SAP ABAP View TRQV_LOTFLOW (Treasury: Lot Flow with Related Position Flow)

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_LOTFLOW
Short Description	Treasury: Lot Flow with Related Position Flow
Root table	TRQT_LOTFLOW	Treasury: Table with Lot Flows

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRQT_LOTFLOW	TRQT_LOTFLOW
2	TRQT_FLOW
3	TRQT_LOT
4	TRQT_POSITION
5	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_LOTFLOW	MANDT	JL	EQ				0	0
2	TRQT_FLOW	MANDT	JR	EQ			AND	0	0
3	TRQT_LOTFLOW	FLOW_GUID	JL	EQ				0	0
4	TRQT_FLOW	FLOW_GUID	JR	EQ			AND	0	0
5	TRQT_LOT	MANDT	JL	EQ				0	0
6	TRQT_LOTFLOW	MANDT	JR	EQ			AND	0	0
7	TRQT_LOT	OS_GUID	JL	EQ				0	0
8	TRQT_LOTFLOW	LOT_GUID	JR	EQ			AND	0	0
9	TRQT_POSITION	MANDT	JL	EQ				0	0
10	TRQT_LOT	MANDT	JR	EQ			AND	0	0
11	TRQT_POSITION	OS_GUID	JL	EQ				0	0
12	TRQT_LOT	POSITION_OID	JR	EQ			AND	0	0
13	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
14	TRQT_POSITION	MANDT	JR	EQ			AND	0	0
15	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
16	TRQT_POSITION	SELECTOR_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRQT_LOTFLOW	MANDT		☐	MANDT	☐	Client
2	LOTFLOW_GUID	TRQT_LOTFLOW	LOTFLOW_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	FLOW_GUID	TRQT_LOTFLOW	FLOW_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	LOT_GUID	TRQT_LOTFLOW	LOT_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	TRD_TRANSACTION	TRQT_FLOW	TRD_TRANSACTION		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
6	TRD_FLOWNR	TRQT_FLOW	TRD_FLOWNR		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
7	DIS_FLOWTYPE	TRQT_FLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
8	QUANT_CAT	TRQT_FLOW	QUANT_CAT		☐	TPM_QTY_PM_CAT	☐	Position Change Category: Quantity
9	SOURCETARGET_FLG	TRQT_FLOW	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
10	TRANSFER_GROUP	TRQT_FLOW	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
11	POSITION_CURR	TRQT_LOTFLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
12	POSITION_AMT	TRQT_LOTFLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
13	POSAMT_IDX_CLEAN	TRQT_LOTFLOW	POSAMT_IDX_CLEAN		☐	TPM_POSITION_AMT_IDX_CLEAN	☐	Amount in Position Currency Index-Clean
14	POSITION_DATE	TRQT_LOTFLOW	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
15	UNITS	TRQT_LOTFLOW	UNITS		☐	TPM_UNITS	☐	Units
16	NOMINAL_CURR	TRQT_LOTFLOW	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
17	NOMINAL_AMT	TRQT_LOTFLOW	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
18	NOMINAL_ORG_AMT	TRQT_LOTFLOW	NOMINAL_ORG_AMT		☐	TPM_NOMINAL_ORG_AMT	☐	Original Nominal Amount in Position Currency
19	LOCAL_CURR	TRQT_LOTFLOW	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
20	LOCAL_AMT	TRQT_LOTFLOW	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
21	PAYMENT_CURR	TRQT_LOTFLOW	PAYMENT_CURR		☐	TPM_PAYMENT_CURR	☐	Payment Currency
22	PAYMENT_AMT	TRQT_LOTFLOW	PAYMENT_AMT		☐	TPM_PAYMENT_AMT	☐	Amount in Payment Currency
23	LOT_ID	TRQT_LOT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
24	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
25	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
26	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
27	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
28	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
29	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
30	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short 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	20130529
SAP Release Created in