SAP ABAP Table /SAPNEA/MR3_MAT_STOCK ([Mobile DB] Material stock list)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ /SAPNEA/MR3/HANDHELD_SALES (Package) Mobile Sales for Handhelds

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPNEA/MR3_MAT_STOCK	Table Relationship Diagram
Short Description	[Mobile DB] Material stock list

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	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
4	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
5	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
6	LVORM	☐	LVOLG	XFELD	CHAR	1	0	Flag Material for Deletion at Storage Location Level
7	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
8	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
9	SPERR	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
10	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
11	UMLME	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
12	INSME	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
13	EINME	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
14	SPEME	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
15	RETME	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
16	VMLAB	☐	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
17	VMUML	☐	VMUML	MENG13V	QUAN	13	3	Stock in transfer, previous period
18	VMINS	☐	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
19	VMEIN	☐	VMEIN	MENG13V	QUAN	13	3	Restricted-use stock in previous period
20	VMSPE	☐	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
21	VMRET	☐	VMRET	MENG13V	QUAN	13	3	Blocked stock returns, previous period
22	KZILL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
23	KZILQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
24	KZILE	☐	KZILE	INVKZ	CHAR	3	0	Physical inventory indicator for restricted-use stock
25	KZILS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
26	KZVLL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
27	KZVLQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
28	KZVLE	☐	KZVLE	INVKZ	CHAR	3	0	Physical inventory ind. for restricted-use stock, prev.pd
29	KZVLS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
30	DISKZ	☐	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
31	LSOBS	☐	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	T460A
32	LMINB	☐	LMINB	MENG13	QUAN	13	3	Reorder point for storage location MRP
33	LBSTF	☐	LBSTF	MENG13	QUAN	13	3	Replenishment quantity for storage location MRP
34	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
35	EXPPG	☐	EXPPG	EXPPG	CHAR	1	0	Preference indicator (deactivated)
36	EXVER	☐	EXVER	EXVER	CHAR	2	0	Export indicator (deactivated)
37	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
38	KLABS	☐	KLABS	MENG13V	QUAN	13	3	Unrestricted-use consignment stock
39	KINSM	☐	KINSM	MENG13V	QUAN	13	3	Consignment stock in quality inspection
40	KEINM	☐	KEINM	MENG13V	QUAN	13	3	Restricted-use consignment stock
41	KSPEM	☐	KSPEM	MENG13V	QUAN	13	3	Blocked consignment stock
42	DLINL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
43	PRCTL	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
44	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
45	VKLAB	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
46	VKUML	☐	VKUML	WERT13N	CURR	13	2	Sales value in stock transfer (SLOc to SLoc)
47	LWMKB	☐	MARD_KOBER	KOBER	CHAR	3	0	Picking area for lean WM	*
48	BSKRF	☐	BSKRF	FLTP	FLTP	16	16	Inventory correction factor
49	MDRUE	☐	MDRUE	XFELD	CHAR	1	0	MARDH rec. already exists for per. before last of MARD per.
50	MDJIN	☐	GJINV	GJAHR	NUMC	4	0	Fiscal year of current physical inventory indicator
51	VAN_LOCATION	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
52	VAN_STOCK	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
53	STOCK_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPNEA/MR3_MAT_STOCK	HERKL	T005	LAND1	REF	C	CN
2	/SAPNEA/MR3_MAT_STOCK	LGORT	T001L	LGORT	KEY	1	CN
3	/SAPNEA/MR3_MAT_STOCK	LSOBS	T460A	SOBSL
4	/SAPNEA/MR3_MAT_STOCK	MANDT	T000	MANDT	KEY	1	CN
5	/SAPNEA/MR3_MAT_STOCK	MATNR	MARA	MATNR	KEY	1	CN
6	/SAPNEA/MR3_MAT_STOCK	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in