SAP ABAP Table RL030 (Join LAGP and LQUA (RLS10030 and RLS10034))

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	INTTAB	Structure
Structure	RL030	Table Relationship Diagram
Short Description	Join LAGP and LQUA (RLS10030 and RLS10034)

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	Storage bins
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
4	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
5	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
6	LGBER	☐	LGBER	LGBER	CHAR	3	0	Storage Section	T302
7	LPTYP	☐	LVS_LPTYP	LVS_LPTYP	CHAR	2	0	Storage bin type	T303
8	PLAUF	☐	LVS_PLAUF	LVS_PLAUF	CHAR	1	0	Section of a storage bin	*
9	SKZUA	☐	LAGP_SKZUA	XFELD	CHAR	1	0	Blocking Indicator: For Stock Removals (User)
10	SKZUE	☐	LAGP_SKZUE	XFELD	CHAR	1	0	Blocking indicator: for putaways (user)
11	SKZSA	☐	LAGP_SKZSA	XFELD	CHAR	1	0	Blocking Indicator: Current Stock Removal (System)
12	SKZSE	☐	LAGP_SKZSE	XFELD	CHAR	1	0	Blocking indicator: current stock placement (system)
13	SKZSI	☐	LAGP_SKZSI	XFELD	CHAR	1	0	Blocking indicator: current inventory (system)
14	SPGRU	☐	LVS_SPGRU	LVS_SPGRU	CHAR	1	0	Blocking reason	T330
15	ANZQU	☐	LAGP_ANZQU	LVS_ANZQU	DEC	7	0	Number of quants in storage bin
16	MAXQU	☐	LAGP_MAXQU	LVS_ANZQU	DEC	7	0	Maximum number of quants in storage bin
17	ANZLE	☐	LAGP_ANZLE	LAGP_ANZLE	DEC	9	3	Number of storage units in storage bin
18	MAXLE	☐	LAGP_MAXLE	LAGP_MAXLE	DEC	5	0	Maximum number of storage units in storage bin
19	KZDYN	☐	LVS_KZDYN	XFELD	CHAR	1	0	Indicator: dynamic storage bin
20	LGEWI	☐	LAGP_LGEWI	DEC8_3	DEC	11	3	Load Capacity of Storage Bin
21	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
22	MGEWI	☐	LAGP_MGEWI	DEC8_3	DEC	11	3	Weight of materials in storage bin
23	BDATU	☐	LAGP_BDATU	DATUM	DATS	8	0	Date of last movement
24	BZEIT	☐	LAGP_BZEIT	UZEIT	TIMS	6	0	Time of last movement
25	BTANR	☐	LAGP_BTANR	TANUM	NUMC	10	0	Transfer order number of last stock transfer
26	BTAPS	☐	LAGP_BTAPS	TAPOS	NUMC	4	0	Item in transfer order of last stock transfer
27	RDATU	☐	LAGP_RDATU	DATUM	DATS	8	0	Date of last bin clearing
28	RZEIT	☐	LAGP_RZEIT	UZEIT	TIMS	6	0	Time of last clearing
29	KZINV	☐	LVS_KZINV	LVS_KZINV	CHAR	2	0	Inventory method
30	IDATU	☐	LAGP_IDATU	DATUM	DATS	8	0	Date of last inventory for this storage bin
31	IVNUM	☐	LVS_IVNUM	BELNR	CHAR	10	0	Number of system inventory record
32	IVPOS	☐	LVS_IVPOS	LVS_IVPOS	NUMC	4	0	Item number in inventory document
33	IVIVO	☐	LVS_IVIVO	XFELD	CHAR	1	0	Inventory in preparation
34	KZLER	☐	LAGP_KZLER	XFELD	CHAR	1	0	Indicator whether storage bin is empty
35	KZVOL	☐	LAGP_KZVOL	XFELD	CHAR	1	0	Indicator whether storage bin is full
36	SORLP	☐	LAGP_SORLP	LAGP_SORLP	CHAR	6	0	Sort field for storage bin (cross-line storage)
37	BRAND	☐	LVS_BRAND	LVS_BRAND	CHAR	2	0	Fire-containment section	T309
38	UNAME	☐	LAGP_UNAME	USERNAME	CHAR	12	0	Last changed by
39	LAEDT	☐	LAGP_LAEDT	DATUM	DATS	8	0	Date of last change
40	LKAPV	☐	LAGP_LKAPV	DEC8_3	DEC	11	3	Total capacity of storage bin
41	RKAPV	☐	LAGP_RKAPV	LAGP_RKAPV	DEC	11	3	Available capacity in storage bin
42	KOBER	☐	KOBER	KOBER	CHAR	3	0	Picking Area	T30A
43	REIHF	☐	LAGP_REIHF	LAGP_SORLP	CHAR	6	0	Sort field for storage bin (TO items, picking)
44	VERIF	☐	LAGP_VERIF	LGPLA	CHAR	10	0	Verification Field for Mobile Data Entry	*
45	.INCLU--AP	☐				0	0	TRM append structure for LAGP
46	.INCLUDE	☐				0	0	TRM coordinates
47	LZONE	☐	LAGP_LZONE	LTRM_ZONE	CHAR	10	0	Zone
48	XCORD	☐	LAGP_XCORD	LTRM_COORD	QUAN	10	3	X Coordinate
49	YCORD	☐	LAGP_YCORD	LTRM_COORD	QUAN	10	3	Y Coordinate
50	ZCORD	☐	LAGP_ZCORD	LTRM_COORD	QUAN	10	3	Z Coordinate
51	LQUA_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
52	LQUA_LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
53	LQNUM	☐	LVS_LQNUM	LVS_LQNUM	NUMC	10	0	Quant
54	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
55	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
56	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
57	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
58	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
59	SONUM	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
60	LQUA_LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
61	LQUA_LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
62	PLPOS	☐	LVS_PLPOS	LVS_PLPOS	CHAR	2	0	Position in storage bin
63	LQUA_SKZUE	☐	LQUA_SKZUE	XFELD	CHAR	1	0	Blocking indicator: for putaways (user)
64	LQUA_SKZUA	☐	LQUA_SKZUA	XFELD	CHAR	1	0	Blocking Indicator: For Stock Removals (User)
65	LQUA_SKZSE	☐	LQUA_SKZSE	XFELD	CHAR	1	0	Blocking indicator: current placement into stock (system)
66	LQUA_SKZSA	☐	LQUA_SKZSA	XFELD	CHAR	1	0	Blocking Indicator: Current Stock Removal (System)
67	LQUA_SKZSI	☐	LQUA_SKZSI	XFELD	CHAR	1	0	Blocking Indicator: Current Inventory (System)
68	LQUA_SPGRU	☐	LVS_SPGRU	LVS_SPGRU	CHAR	1	0	Blocking reason	*
69	ZEUGN	☐	LVS_ZEUGN	LVS_ZEUGN	CHAR	10	0	Certificate Number
70	LQUA_BDATU	☐	LQUA_BDATU	DATUM	DATS	8	0	Date of last movement
71	LQUA_BZEIT	☐	LQUA_BZEIT	UZEIT	TIMS	6	0	Time of last movement
72	LQUA_BTANR	☐	LQUA_BTANR	TANUM	NUMC	10	0	Document Number of Last Stock Change in Quant
73	LQUA_BTAPS	☐	LQUA_BTAPS	TAPOS	NUMC	4	0	Item in transfer order of last stock transfer
74	EDATU	☐	LQUA_EDATU	DATUM	DATS	8	0	Date of last placement into stock
75	EZEIT	☐	LQUA_EZEIT	UZEIT	TIMS	6	0	Time of last placement into stock
76	ADATU	☐	LQUA_ADATU	DATUM	DATS	8	0	Date of last stock removal
77	AZEIT	☐	LQUA_AZEIT	UZEIT	TIMS	6	0	Time of last stock removal
78	ZDATU	☐	LQUA_ZDATU	DATUM	DATS	8	0	Date of last addition to existing stock
79	WDATU	☐	LVS_WDATU	DATUM	DATS	8	0	Date of goods receipt
80	WENUM	☐	LVS_WENUM	BELNR	CHAR	10	0	Goods Receipt Number
81	WEPOS	☐	LVS_WEPOS	MBLPO	NUMC	4	0	Goods receipt item
82	LETYP	☐	LVS_LETYP	LVS_LETYP	CHAR	3	0	Storage Unit Type	*
83	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
84	GESME	☐	LQUA_GESME	MENSH	QUAN	13	3	Total Quantity
85	VERME	☐	LQUA_VERME	MENSH	QUAN	13	3	Available stock
86	EINME	☐	LQUA_EINME	MENSH	QUAN	13	3	Stock for putaway
87	AUSME	☐	LQUA_AUSME	MENSH	QUAN	13	3	Quantity to remove
88	LQUA_MGEWI	☐	LQUA_MGEWI	DEC8_3	DEC	11	3	Weight of material
89	LQUA_GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
90	TBNUM	☐	TBNUM	TBNUM	NUMC	10	0	Transfer Requirement Number	*
91	LQUA_IVNUM	☐	LVS_IVNUM	BELNR	CHAR	10	0	Number of system inventory record
92	LQUA_IVPOS	☐	LVS_IVPOS	LVS_IVPOS	NUMC	4	0	Item number in inventory document
93	BETYP	☐	LVS_BETYP	LVS_BETYP	CHAR	1	0	Requirement Type	*
94	BENUM	☐	LVS_BENUM	LVS_BENUM	CHAR	10	0	Requirement Number
95	LENUM	☐	LENUM	LENUM	CHAR	20	0	Storage Unit Number	*
96	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
97	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
98	QKAPV	☐	LQUA_QKAPV	DEC8_3	DEC	11	3	Capacity usage of quant
99	LQUA_KOBER	☐	KOBER	KOBER	CHAR	3	0	Picking Area	*
100	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
101	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
102	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
103	LQUA_IDATU	☐	LQUA_IDATU	DATUM	DATS	8	0	Date of last inventory of quant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RL030	BRAND	T309	BRAND	REF	C	CN
2	RL030	GEWEI	T006	MSEHI	REF	C	CN
3	RL030	KOBER	T30A	KOBER		1	CN
4	RL030	LGBER	T302	LGBER	REF	1	CN
5	RL030	LGNUM	T300	LGNUM
6	RL030	LGTYP	T301	LGTYP	KEY	1	CN
7	RL030	LPTYP	T303	LPTYP	REF	1	CN
8	RL030	SPGRU	T330	SPGRU	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in