SAP ABAP Table /CWM/ILQUA (LQUA Strurcture for LQ01)

Hierarchy

☛ IS-CWM (Software Component) Industry Solution Catch Weight Management
   ⤷ IS-CWM (Application Component) Industry Solution Catch Weight Management
     ⤷ /CWM/APPL_LES (Package) Logistics Execution

Basic Data

Table Category	INTTAB	Structure
Structure	/CWM/ILQUA	Table Relationship Diagram
Short Description	LQUA Strurcture for LQ01

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	.INCLUDE	☐				0	0	Quants
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
4	LQNUM	☐	LVS_LQNUM	LVS_LQNUM	NUMC	10	0	Quant
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
8	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
9	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
10	SONUM	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
11	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
12	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
13	PLPOS	☐	LVS_PLPOS	LVS_PLPOS	CHAR	2	0	Position in storage bin
14	SKZUE	☐	LQUA_SKZUE	XFELD	CHAR	1	0	Blocking indicator: for putaways (user)
15	SKZUA	☐	LQUA_SKZUA	XFELD	CHAR	1	0	Blocking Indicator: For Stock Removals (User)
16	SKZSE	☐	LQUA_SKZSE	XFELD	CHAR	1	0	Blocking indicator: current placement into stock (system)
17	SKZSA	☐	LQUA_SKZSA	XFELD	CHAR	1	0	Blocking Indicator: Current Stock Removal (System)
18	SKZSI	☐	LQUA_SKZSI	XFELD	CHAR	1	0	Blocking Indicator: Current Inventory (System)
19	SPGRU	☐	LVS_SPGRU	LVS_SPGRU	CHAR	1	0	Blocking reason	T330
20	ZEUGN	☐	LVS_ZEUGN	LVS_ZEUGN	CHAR	10	0	Certificate Number
21	BDATU	☐	LQUA_BDATU	DATUM	DATS	8	0	Date of last movement
22	BZEIT	☐	LQUA_BZEIT	UZEIT	TIMS	6	0	Time of last movement
23	BTANR	☐	LQUA_BTANR	TANUM	NUMC	10	0	Document Number of Last Stock Change in Quant
24	BTAPS	☐	LQUA_BTAPS	TAPOS	NUMC	4	0	Item in transfer order of last stock transfer
25	EDATU	☐	LQUA_EDATU	DATUM	DATS	8	0	Date of last placement into stock
26	EZEIT	☐	LQUA_EZEIT	UZEIT	TIMS	6	0	Time of last placement into stock
27	ADATU	☐	LQUA_ADATU	DATUM	DATS	8	0	Date of last stock removal
28	AZEIT	☐	LQUA_AZEIT	UZEIT	TIMS	6	0	Time of last stock removal
29	ZDATU	☐	LQUA_ZDATU	DATUM	DATS	8	0	Date of last addition to existing stock
30	WDATU	☐	LVS_WDATU	DATUM	DATS	8	0	Date of goods receipt
31	WENUM	☐	LVS_WENUM	BELNR	CHAR	10	0	Goods Receipt Number
32	WEPOS	☐	LVS_WEPOS	MBLPO	NUMC	4	0	Goods receipt item
33	LETYP	☐	LVS_LETYP	LVS_LETYP	CHAR	3	0	Storage Unit Type	T307
34	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
35	GESME	☐	LQUA_GESME	MENSH	QUAN	13	3	Total Quantity
36	VERME	☐	LQUA_VERME	MENSH	QUAN	13	3	Available stock
37	EINME	☐	LQUA_EINME	MENSH	QUAN	13	3	Stock for putaway
38	AUSME	☐	LQUA_AUSME	MENSH	QUAN	13	3	Quantity to remove
39	MGEWI	☐	LQUA_MGEWI	DEC8_3	DEC	11	3	Weight of material
40	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
41	TBNUM	☐	TBNUM	TBNUM	NUMC	10	0	Transfer Requirement Number	*
42	IVNUM	☐	LVS_IVNUM	BELNR	CHAR	10	0	Number of system inventory record
43	IVPOS	☐	LVS_IVPOS	LVS_IVPOS	NUMC	4	0	Item number in inventory document
44	BETYP	☐	LVS_BETYP	LVS_BETYP	CHAR	1	0	Requirement Type	*
45	BENUM	☐	LVS_BENUM	LVS_BENUM	CHAR	10	0	Requirement Number
46	LENUM	☐	LENUM	LENUM	CHAR	20	0	Storage Unit Number	LEIN
47	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
48	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
49	QKAPV	☐	LQUA_QKAPV	DEC8_3	DEC	11	3	Capacity usage of quant
50	KOBER	☐	KOBER	KOBER	CHAR	3	0	Picking Area	*
51	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
52	VIRGO	☐	LQUA_VIRGO	XFELD	CHAR	1	0	Quant does not contain GR data
53	TRAME	☐	LQUA_TRAME	MENSH	QUAN	13	3	Open Transfer Quantity
54	KZHUQ	☐	LQUA_KZHUQ	XFELD	CHAR	1	0	Indicator: Quant is on a handling unit
55	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
56	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
57	IDATU	☐	LQUA_IDATU	DATUM	DATS	8	0	Date of last inventory of quant
58	MSR_INSP_GUID	☐	MSR_INSP_GUID		RAW	16	0	Inspection GUID
59	.INCLUDE	☐				0	0	Structure for LQUA_IM-PME Append
60	/CWM/ERFMG	☐	/CWM/ERFMG	MENG13	QUAN	13	3	Quantity in Parallel Unit of Entry
61	/CWM/ERFME	☐	/CWM/ERFME	MEINS	UNIT	3	0	PUoM Entry Unit of Measure	*
62	/CWM/XCWMAT	☐	/CWM/XCWMAT	XFELD	CHAR	1	0	Material Is Activated for Catch Weight
63	.INCLUDE	☐				0	0	Internal table for messages
64	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
65	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
66	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
67	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
68	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
69	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
70	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
71	MARKI	☐			CHAR	1	0
72	LSONR	☐	LVS_LSONR	LVS_LSONR	CHAR	24	0	Special Stock Number
73	UMBME	☐	LQUA_VERME	MENSH	QUAN	13	3	Available stock
74	/CWM/SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/CWM/ILQUA	LENUM	LEIN	LENUM	REF	C	CN
2	/CWM/ILQUA	LETYP	T307	LETYP	REF	C	CN
3	/CWM/ILQUA	LGNUM	T300	LGNUM
4	/CWM/ILQUA	LGORT	T001L	LGORT
5	/CWM/ILQUA	LGPLA	LAGP	LGPLA	REF	1	CN
6	/CWM/ILQUA	LGTYP	T301	LGTYP
7	/CWM/ILQUA	MATNR	MARA	MATNR	REF	1	CN
8	/CWM/ILQUA	SOBKZ	T148	SOBKZ
9	/CWM/ILQUA	SPGRU	T330	SPGRU
10	/CWM/ILQUA	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	472