SAP ABAP Table TRQV_FLOW_LOTID (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRQV_FLOW_LOTID	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	LOTFLOW_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	LOT_GUID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRQT_LOT
4	FLOW_GUID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRQT_FLOW
5	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
6	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	TCURC
7	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
8	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
9	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	TCURC
10	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
11	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
12	LOCAL_CURR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency	TCURC
13	LOCAL_AMT	☐	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
14	PAYMENT_CURR	☐	TPM_PAYMENT_CURR	WAERS	CUKY	5	0	Payment Currency
15	PAYMENT_AMT	☐	TPM_PAYMENT_AMT	TPM_AMOUNT	CURR	21	2	Amount in Payment Currency
16	LOT_OS_GUID	☐	TPM_POSITION_LOT	TPM_DB_OS_GUID	CHAR	32	0	Lot
17	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
18	FLOW_OS_GUID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
19	TRD_TRANSACTION	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
20	TRD_FLOWNR	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
21	DIS_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type
22	POSITION_DATE	☐	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
23	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
24	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
25	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
26	LOT_CREATION	☐	TPM_LOT_CREATION	TPM_LOT_CREATION	NUMC	1	0	Lot Creation Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRQV_FLOW_LOTID	FLOW_GUID	TRQT_FLOW	FLOW_GUID
2	TRQV_FLOW_LOTID	LOCAL_CURR	TCURC	WAERS	KEY	1	CN
3	TRQV_FLOW_LOTID	LOT_GUID	TRQT_LOT	OS_GUID
4	TRQV_FLOW_LOTID	NOMINAL_CURR	TCURC	WAERS	KEY	1	CN
5	TRQV_FLOW_LOTID	POSITION_CURR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in