SAP ABAP View TRQV_FLOW_LOTID (CFM: Quantity Ledger Flow with Lot ID)

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_FLOW_LOTID
Short Description	CFM: Quantity Ledger Flow with Lot ID
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_LOT
3	TRQT_FLOW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRQT_LOT	MANDT	JL	EQ				0	0
2	TRQT_LOTFLOW	MANDT	JR	EQ			AND	0	0
3	TRQT_LOT	OS_GUID	JL	EQ				0	0
4	TRQT_LOTFLOW	LOT_GUID	JR	EQ			AND	0	0
5	TRQT_FLOW	MANDT	JL	EQ				0	0
6	TRQT_LOTFLOW	MANDT	JR	EQ			AND	0	0
7	TRQT_FLOW	FLOW_GUID	JL	EQ				0	0
8	TRQT_LOTFLOW	FLOW_GUID	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	LOT_GUID	TRQT_LOTFLOW	LOT_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	FLOW_GUID	TRQT_LOTFLOW	FLOW_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	UNITS	TRQT_LOTFLOW	UNITS		☐	TPM_UNITS	☐	Units
6	NOMINAL_CURR	TRQT_LOTFLOW	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
7	NOMINAL_AMT	TRQT_LOTFLOW	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
8	NOMINAL_ORG_AMT	TRQT_LOTFLOW	NOMINAL_ORG_AMT		☐	TPM_NOMINAL_ORG_AMT	☐	Original Nominal Amount in Position Currency
9	POSITION_CURR	TRQT_LOTFLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
10	POSITION_AMT	TRQT_LOTFLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
11	POSAMT_IDX_CLEAN	TRQT_LOTFLOW	POSAMT_IDX_CLEAN		☐	TPM_POSITION_AMT_IDX_CLEAN	☐	Amount in Position Currency Index-Clean
12	LOCAL_CURR	TRQT_LOTFLOW	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
13	LOCAL_AMT	TRQT_LOTFLOW	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
14	PAYMENT_CURR	TRQT_LOTFLOW	PAYMENT_CURR		☐	TPM_PAYMENT_CURR	☐	Payment Currency
15	PAYMENT_AMT	TRQT_LOTFLOW	PAYMENT_AMT		☐	TPM_PAYMENT_AMT	☐	Amount in Payment Currency
16	LOT_OS_GUID	TRQT_LOT	OS_GUID		☐	TPM_POSITION_LOT	☐	Lot
17	LOT_ID	TRQT_LOT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
18	FLOW_OS_GUID	TRQT_FLOW	FLOW_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
19	TRD_TRANSACTION	TRQT_FLOW	TRD_TRANSACTION		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
20	TRD_FLOWNR	TRQT_FLOW	TRD_FLOWNR		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
21	DIS_FLOWTYPE	TRQT_FLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
22	POSITION_DATE	TRQT_FLOW	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
23	QUANT_CAT	TRQT_FLOW	QUANT_CAT		☐	TPM_QTY_PM_CAT	☐	Position Change Category: Quantity
24	SOURCETARGET_FLG	TRQT_FLOW	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
25	TRANSFER_GROUP	TRQT_FLOW	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
26	LOT_CREATION	TRQT_FLOW	LOT_CREATION		☐	TPM_LOT_CREATION	☐	Lot Creation Category

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	110