SAP ABAP Table LQUA (Quants)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ LVS (Package) Application development Warehouse Management (WM)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LQUA	Table Relationship Diagram
Short Description	Quants

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in