SAP ABAP Table RL070 (All LQUA and LINV Fields)

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	RL070	Table Relationship Diagram
Short Description	All LQUA and LINV Fields

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	NANUM	☐	LINV_NANUM	LVS_NANUM	NUMC	2	0	Inventory recount number
60	ISTAT	☐	LINV_ISTAT	LVS_ISTAT	CHAR	1	0	Item status of inventory at quant level
61	NVERS	☐	LINV_NVERS	LVS_NANUM	NUMC	2	0	Inventory recount version
62	ISEIT	☐	LVS_ISEIT	LVS_ISEIT	NUMC	4	0	Inventory page
63	ANZLE	☐	LINV_ANZLE	LAGP_ANZLE	DEC	9	3	Number of storage units corresponding to counted quantity
64	MENGE	☐	LINV_MENGE	MENG13	QUAN	13	3	Counted quantity in stockkeeping unit
65	ALTME	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	*
66	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
67	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
68	MENGA	☐	LINV_MENGA	MENG13	QUAN	13	3	Counted quantity in alternative unit of measure
69	LINV_IDATU	☐	LVS_IDATU	DATUM	DATS	8	0	Date of inventory
70	KZINV	☐	LVS_KZINV	LVS_KZINV	CHAR	2	0	Inventory method
71	IRNUM	☐	LVS_IRNUM	LVS_IRNUM	CHAR	10	0	Inventory reference number
72	TANUM	☐	LINV_TANUM	TANUM	NUMC	10	0	Transfer order number of continuous inventory procedure
73	TAPOS	☐	LINV_TAPOS	TAPOS	NUMC	4	0	Transfer order item of continuous inventory procedure
74	UNAME	☐	LINV_UNAME	CHAR25	CHAR	25	0	Name of counter for system inventory record
75	ICON	☐	ICON_RLINV070	WM_ICON132	CHAR	132	0	Status
76	QUINV	☐	LINK_QUINV	XFELD	CHAR	1	0	Indicator for quant inventory
77	LSONR	☐	LVS_LSONR	LVS_LSONR	CHAR	24	0	Special Stock Number
78	LINV_GESME	☐	LQUA_GESME	MENSH	QUAN	13	3	Total Quantity

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in