/SMERP/STG_MM002

Data staging - Material storage location view complex table | #masterdata | Component: Mobile Application Integration - ERP Core
Column Name Description
MANDT Client
DSF_GUID DSF GUID
Column Name Description
💲 Currency Key (T001.WAERS):
VKLAB Stock value of a value-only material at sales price
VKUML Sales value in stock transfer (SLOc to SLoc)
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
📏 Volume unit (VOLEH):
VOLUM Volume
📏 Base Unit of Measure (MEINS):
WESCH Quantity: Number of GR/GI slips to be printed
LABST Valuated Unrestricted-Use Stock
UMLME Stock in transfer (from one storage location to another)
INSME Stock in Quality Inspection
EINME Total Stock of All Restricted Batches
SPEME Blocked Stock
RETME Blocked Stock Returns
VMLAB Valuated unrestricted-use stock in previous period
VMUML Stock in Transfer in Previous Period
VMINS Stock in Quality Inspection in Previous Period
VMEIN Restricted-Use Stock in Previous Period
VMSPE Blocked stock of previous period
VMRET Blocked Stock Returns in Previous Period
LMINB Reorder point for storage location MRP
LBSTF Replenishment quantity for storage location MRP
KLABS Unrestricted-Use Consignment Stock
KINSM Consignment Stock in Quality Inspection
KEINM Restricted-Use Consignment Stock
KSPEM Blocked Consignment Stock
📏 Unit of Dimension for Length/Width/Height (MEABM):
LAENG Length
BREIT Width
HOEHE Height
/VSO/R_PAL_OVR_D Permissible Overhang (Depth) of Packaging Material (VSO)
/VSO/R_PAL_OVR_W Permissible Overhang (Width) of Shipping Material (VSO)
/VSO/R_PAL_B_HT Maximum Stacking Height of the Packaging Material (VSO)
/VSO/R_PAL_MIN_H Minimum Stacking Height of the Packaging Material (VSO)
/VSO/R_TOL_B_HT Tolerance to Exceed the Max. Stacking Height (VSO)
📏 Unit of weight (allowed packaging weight) (ERGEI):
ERGEW Allowed packaging weight
📏 Volume unit (allowed packaging volume) (ERVOE):
ERVOL Allowed packaging volume
📏 Content unit (INHME):
INHAL Net contents
INHBR Gross contents
📏 Unit of Measure for Maximum Packing Length/Width/Height (MAXDIM_UOM):
MAXL Maximum Packing Length of Packaging Material
MAXB Maximum Packing Width of Packaging Material
MAXH Maximum Packing Height of Packaging Material
📏 Time Unit for Quarantine Period (QQTIMEUOM):
QQTIME Quarantine Period
Column Name Description
DATAB Valid-From Date
LIQDT Deletion date
MSTDE Date from which the cross-plant material status is valid
MSTDV Date from which the X-distr.-chain material status is valid
DLINL Date of Last Posted Count
ERSDA Created On
Column Name Description
AEKLK Stock Transfer Net Change Costing Show values
CADKZ CAD Indicator Show values
QMPUR QM in Procurement Is Active Show values
VABME Variable Purchase Order Unit Active Show values
KZREV Revision Level Has Been Assigned to the Material Show values
KZKFG Configurable Material Show values
MLGUT Empties Bill of Material Show values
ATTYP Material Category Show values
KZNFM Indicator: The material has a follow-up material Show values
CMETH Quantity Conversion Method Show values
KZUMW Environmentally Relevant Show values
SPROF Pricing profile for variants Show values
NRFHG Material qualifies for discount in kind Show values
KZWSM Units of measure usage Show values
IHIVI Indicator: Highly Viscous Show values
ILOOS Indicator: In Bulk/Liquid Show values
SERLV Level of Explicitness for Serial Number Show values
KZGVH Packaging Material is Closed Packaging Show values
XGCHP Approved Batch Record Required Show values
KZEFF Assign effectivity parameter values/ override change numbers Show values
IPRKZ Period Indicator for Shelf Life Expiration Date Show values
RDMHD Rounding rule for calculation of SLED Show values
PRZUS Indicator: Product composition printed on packaging Show values
BFLME Generic Material with Logistical Variants Show values
MATFI Material Is Locked Show values
CMREL Relevant for Configuration Management Show values
SLED_BBD Expiration Date Show values
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant Show values
WEORA Acceptance At Origin Show values
PILFERABLE Pilferable Show values
HAZMAT Relevant for Hazardous Substances Show values
TARE_VAR Variable Tare Weight Show values
CWQREL EWM CW: Material Is a Catch Weight Material Show values
/VSO/R_TILT_IND Material may be Tilted (Vehicle Space Optimization) Show values
/VSO/R_STACK_IND Stacking not Allowed (VSO) Show values
/VSO/R_BOT_IND Bottom Layer (Vehicle Space Optimization) Show values
/VSO/R_TOP_IND Top Layer (VSO) Show values
/VSO/R_PAL_IND Load without Packaging Material (VSO) Show values
/VSO/R_KZGVH_IND Closed Packaging Material Required (VSO) Show values
MCOND Material Condition Management Show values
LVORM Flag Material for Deletion at Storage Location Level Show values
SPERR Physical Inventory Blocking Indicator Show values
DISKZ Storage location MRP indicator Show values
MDRUE MARDH rec. already exists for per. before last of MARD per. Show values
Column Name Description Domain name
DSF_DSTORE_ID Data Store ID /SMFND/DSF_DSTORE_ID
USER_GUID User GUID SYSUUID_C
DSF_RECORD_ID DSF Record ID NUM10
DSF_CHANGED_BY Last Changed By USNAM
DSF_CHANGED_TS Changed time stamp TZNTSTMPS
MATNR Material Number MATNR
VPSTA Maintenance status of complete material PSTAT
BISMT Old material number BISMT
ZEINR Document number (without document management system) CHAR22
ZEIAR Document type (without Document Management system) ZEIAR
ZEIVR Document version (without Document Management system) VERSI
ZEIFO Page format of document (without Document Management system) DINFO
AESZN Document change number (without document management system) AENUM
BLATT Page number of document (without Document Management system) BLATT
BLANZ Number of sheets (without Document Management system) NUM3
FERTH Production/inspection memo FERTH
FORMT Page Format of Production Memo DINFO
GROES Size/dimensions CHAR32
NORMT Industry Standard Description (such as ANSI or ISO) NORMT
DISST Low-Level Code DISST
EANNR European Article Number (EAN) - obsolete!!!!! CHAR13
ENTAR Deactivated CHAR1
EAN11 International Article Number (EAN/UPC) EAN11
GEWTO Excess Weight Tolerance for Handling unit PRZ21
VOLTO Excess Volume Tolerance of the Handling Unit PRZ21
FUELG Maximum level (by volume) DEC3
STFAK Stacking factor INT2
BEGRU Authorization Group BEGRU
SAISJ Season Year CJAHR
MHDRZ Minimum Remaining Shelf Life DEC4
MHDHB Total shelf life DEC4
MHDLP Storage percentage DEC3
VPREH Comparison price unit PACK3
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) ETIAG
CUOBF Internal object number CUOBJ
MFRPN Manufacturer Part Number CHAR40
BBTYP Assortment List Type BBTYP
GTIN_VARIANT Global Trade Item Number Variant GTIN_VARIANT
MAXC Maximum Allowed Capacity of Packaging Material DECV15_3
MAXC_TOL Overcapacity Tolerance of the Handling Unit DEC2_1
/BEV1/LULEINH Loading Units /BEV1/LULEINH
/VSO/R_STACK_NO Stacking Factor (Vehicle Space Optimization) /VSO/M_STACK_NO
/VSO/R_NO_P_GVH Number of Materials for each Closed PKM (VSO) /VSO/M_ANZ_PER_GVH
RETDELC Return Code DFPS_RETDELC
LOGLEV_RETO Return to Logistics Level DFPS_LOGLEV
NSNID NATO Stock Number DFPS_NSNID
IMATN FFF class MATNR
PICNUM Supersession chain number PIC_PICNUM
BSTAT Creation Status - Seasonal Procurement WRFBSTAT
COLOR_ATINN Internal Charactieristic Number for Color Characteristics ATINN
SIZE1_ATINN Internal Char. Number for Characteristics for Main Sizes ATINN
SIZE2_ATINN Internal Char. Number for Characteristics for Second Sizes ATINN
COLOR Characteristic Value for Colors of Variants WRF_ATWRT
SIZE1 Characteristic Value for Main Sizes of Variants WRF_ATWRT
SIZE2 Characteristic Value for Second Size for Variants WRF_ATWRT
FREE_CHAR Characteristic Value for Evaluation Purposes WRF_ATWRT
CARE_CODE Care Codes (such as Washing Code, Ironing Code, etc.) WRF_CARE_CODE
FIBER_PART1 Percentage Share of Fiber (Component 1) WRF_FIBER_PART
FIBER_PART2 Percentage Share of Fiber (Component 2) WRF_FIBER_PART
FIBER_PART3 Percentage Share of Fiber (Component 3) WRF_FIBER_PART
FIBER_PART4 Percentage Share of Fiber (Component 4) WRF_FIBER_PART
FIBER_PART5 Percentage Share of Fiber (Component 5) WRF_FIBER_PART
FASHGRD Fashion Grade FASHGRD
MAKTX Material Description TEXT40
WERKS Plant WERKS
LGORT Storage location LGORT
PSTAT Maintenance status PSTAT
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
KZILL Physical inventory indicator for whse stock in current year INVKZ
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
KZILE Physical inventory indicator for restricted-use stock INVKZ
KZILS Physical inventory indicator for blocked stock INVKZ
KZVLL Physical inventory indicator for stock in previous year INVKZ
KZVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
KZVLE Physical inventory ind. for restricted-use stock, prev.pd INVKZ
KZVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
EXPPG Preference indicator (deactivated) EXPPG
EXVER Export indicator (deactivated) EXVER
LGPBE Storage Bin CHAR10
PRCTL Profit Center PRCTR
LWMKB Picking area for lean WM KOBER
BSKRF Inventory Correction Factor FLTP
MDJIN Fiscal year of current physical inventory indicator GJAHR
DUMMY_STL_INCL_EEW_PS MD PRODUCT Storage location STL_INCL_EEW
Master Data Relations Join Conditions
External Key Check for Loading Unit Groups
DSD Grouping
  • DSD Grouping
  • Client
Container requirements
  • Container requirements
  • Client
  • /SMERP/STG_MM002.BEHVO == T144.BEHVO
  • /SMERP/STG_MM002.MANDT == T144.MANDT
Number of Internal Material Master Record
  • Number of firm's own (internal) inventory-managed material
  • Client
  • /SMERP/STG_MM002.BMATN == MARA.MATNR
  • /SMERP/STG_MM002.MANDT == MARA.MANDT
Brand
Purchase Order Unit of Measure
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.BSTME == T006.MSEHI
Procurement rule
  • Procurement rule
  • Client
  • /SMERP/STG_MM002.BWVOR == T6WP1.BWVOR
  • /SMERP/STG_MM002.MANDT == T6WP1.MANDT
EWM CW: Catch Weight Profile for Entering CW Quantity
  • /SMERP/STG_MM002.MANDT == TCWQPROC.MANDT
  • /SMERP/STG_MM002.CWQPROC == TCWQPROC.CWQPROC
Catch Weight Tolerance Group
  • /SMERP/STG_MM002.MANDT == TCWQTOLGR.MANDT
  • /SMERP/STG_MM002.CWQTOLGR == TCWQTOLGR.CWQTOLGR
Purchasing Value Key
  • /SMERP/STG_MM002.MANDT == T405.MANDT
  • /SMERP/STG_MM002.EKWSL == T405.EKWSL
Unit of weight (allowed packaging weight)
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.ERGEI == T006.MSEHI
Volume unit (allowed packaging volume)
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.ERVOE == T006.MSEHI
Label type
  • Label type
  • Client
  • /SMERP/STG_MM002.ETIAR == T6WP3.ETIAR
  • /SMERP/STG_MM002.MANDT == T6WP3.MANDT
Label form
  • /SMERP/STG_MM002.MANDT == T6WP4.MANDT
  • /SMERP/STG_MM002.ETIFO == T6WP4.ETIFO
External Material Group
  • /SMERP/STG_MM002.MANDT == TWEW.MANDT
  • /SMERP/STG_MM002.EXTWG == TWEW.EXTWG
Fiber Code for Textiles (Component 1)
  • Fiber Code for Textiles (Component 1)
  • Client
Fiber Code for Textiles (Component 2)
  • Fiber Code for Textiles (Component 2)
  • Client
Fiber Code for Textiles (Component 3)
  • Fiber Code for Textiles (Component 3)
  • Client
Fiber Code for Textiles (Component 4)
  • Fiber Code for Textiles (Component 4)
  • Client
Fiber Code for Textiles (Component 5)
  • Fiber Code for Textiles (Component 5)
  • Client
Material Number of the Generic Material in Prepack Materials
  • Material Number of the Generic Material in Prepack Materials
  • Client
  • /SMERP/STG_MM002.GENNR == MARA.MATNR
  • /SMERP/STG_MM002.MANDT == MARA.MANDT
Weight Unit
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.GEWEI == T006.MSEHI
Country of origin
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • /SMERP/STG_MM002.HERKL == T005.LAND1
  • /SMERP/STG_MM002.MANDT == T005.MANDT
Handling Indicator
  • /SMERP/STG_MM002.MANDT == THNDLCD.MANDT
  • /SMERP/STG_MM002.HNDLCODE == THNDLCD.HNDLCODE
Handling Unit Type
  • /SMERP/STG_MM002.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM002.HUTYP == THUTYP.HUTYP
Standard HU Type
  • /SMERP/STG_MM002.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM002.HUTYP_DFLT == THUTYP.HUTYP
Content unit
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.INHME == T006.MSEHI
Product Allocation Determination Procedure
  • /SMERP/STG_MM002.MANDT == T190S.MANDT
  • /SMERP/STG_MM002.KOSCH == T190S.KOSCH
Laboratory/design office
  • /SMERP/STG_MM002.MANDT == T024L.MANDT
  • /SMERP/STG_MM002.LABOR == T024L.LABOR
EWM CW: Logistics Unit of Measure
  • Material Number
  • EWM CW: Logistics Unit of Measure
  • /SMERP/STG_MM002.MANDT == MARM.MANDT
  • /SMERP/STG_MM002.MATNR == MARM.MATNR
  • /SMERP/STG_MM002.LOGUNIT == MARM.MEINH
Special procurement type at storage location level
  • Plant
  • Special procurement type at storage location level
  • /SMERP/STG_MM002.MANDT == T460A.MANDT
  • /SMERP/STG_MM002.WERKS == T460A.WERKS
  • /SMERP/STG_MM002.LSOBS == T460A.SOBSL
Material Group: Packaging Materials
  • /SMERP/STG_MM002.MANDT == TVEGR.MANDT
  • /SMERP/STG_MM002.MAGRV == TVEGR.MAGRV
Material Group
  • /SMERP/STG_MM002.MANDT == T023.MANDT
  • /SMERP/STG_MM002.MATKL == T023.MATKL
Unit of Measure for Maximum Packing Length/Width/Height
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.MAXDIM_UOM == T006.MSEHI
Industry Sector
  • /SMERP/STG_MM002.MANDT == T137.MANDT
  • /SMERP/STG_MM002.MBRSH == T137.MBRSH
Unit of Dimension for Length/Width/Height
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.MEABM == T006.MSEHI
Base Unit of Measure
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.MEINS == T006.MSEHI
Manufacturer Number
  • /SMERP/STG_MM002.MANDT == LFA1.MANDT
  • /SMERP/STG_MM002.MFRNR == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • /SMERP/STG_MM002.MPROF == TMPPF.MPROF
  • /SMERP/STG_MM002.MANDT == TMPPF.MANDT
Cross-Plant Material Status
  • /SMERP/STG_MM002.MANDT == T141.MANDT
  • /SMERP/STG_MM002.MSTAE == T141.MMSTA
Cross-distribution-chain material status
  • /SMERP/STG_MM002.MANDT == TVMS.MANDT
  • /SMERP/STG_MM002.MSTAV == TVMS.VMSTA
Material type
  • /SMERP/STG_MM002.MANDT == T134.MANDT
  • /SMERP/STG_MM002.MTART == T134.MTART
General item category group
  • General item category group
  • Client
  • /SMERP/STG_MM002.MTPOS_MARA == TPTM.MTPOS
  • /SMERP/STG_MM002.MANDT == TPTM.MANDT
Category of International Article Number (EAN)
  • /SMERP/STG_MM002.MANDT == TNTP.MANDT
  • /SMERP/STG_MM002.NUMTP == TNTP.NUMTP
Price Band Category
  • /SMERP/STG_MM002.MANDT == TWPT.MANDT
  • /SMERP/STG_MM002.PLGTP == TWPT.PLGTP
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • /SMERP/STG_MM002.PMATA == MARA.MATNR
  • /SMERP/STG_MM002.MANDT == MARA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • /SMERP/STG_MM002.PRDHA == T179.PRODH
  • /SMERP/STG_MM002.MANDT == T179.MANDT
Dangerous Goods Profile
  • Dangerous Goods Indicator Profile
  • Client
  • /SMERP/STG_MM002.PROFL == TDG41.PROFL
  • /SMERP/STG_MM002.MANDT == TDG41.MANDT
Quality Inspection Group
  • /SMERP/STG_MM002.MANDT == TQGRP.MANDT
  • /SMERP/STG_MM002.QGRP == TQGRP.QGRP
Time Unit for Quarantine Period
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.QQTIMEUOM == T006.MSEHI
Storage conditions
  • /SMERP/STG_MM002.MANDT == T142.MANDT
  • /SMERP/STG_MM002.RAUBE == T142.RAUBE
Catalog Profile
  • /SMERP/STG_MM002.MANDT == T352B.MANDT
  • /SMERP/STG_MM002.RBNRM == T352B.RBNR
Reference Material Check Packing Instruction
  • Reference material for materials packed in same way
  • Client
  • /SMERP/STG_MM002.RMATP == MARA.MATNR
  • /SMERP/STG_MM002.MANDT == MARA.MANDT
Season Category
  • /SMERP/STG_MM002.MANDT == T6WSP.MANDT
  • /SMERP/STG_MM002.SAISO == T6WSP.SAISO
Categories of Seasonal Materials
  • /SMERP/STG_MM002.MANDT == T6WSA.MANDT
  • /SMERP/STG_MM002.SAITY == T6WSA.SAITY
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • /SMERP/STG_MM002.SATNR == MARA.MATNR
  • /SMERP/STG_MM002.MANDT == MARA.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • /SMERP/STG_MM002.SERIAL == TSERIAL.SERIAL
  • /SMERP/STG_MM002.MANDT == TSERIAL.MANDT
Division
  • /SMERP/STG_MM002.MANDT == TSPA.MANDT
  • /SMERP/STG_MM002.SPART == TSPA.SPART
Hazardous material number
  • Hazardous material number
  • ?
  • Client
  • /SMERP/STG_MM002.STOFF == MGEF.STOFF
  • /SMERP/STG_MM002.[column in domain "REGKZ"] == MGEF.REGKZ
  • /SMERP/STG_MM002.MANDT == MGEF.MANDT
Tax classification of the material
  • ?
  • Tax classification of the material
  • Client
  • /SMERP/STG_MM002.[column in domain "TATYP"] == TSKM.TATYP
  • /SMERP/STG_MM002.TAKLV == TSKM.TAXKM
  • /SMERP/STG_MM002.MANDT == TSKM.MANDT
Temperature conditions indicator
  • Temperature conditions indicator
  • Client
  • /SMERP/STG_MM002.TEMPB == T143.TEMPB
  • /SMERP/STG_MM002.MANDT == T143.MANDT
Transportation Group
  • /SMERP/STG_MM002.MANDT == TTGR.MANDT
  • /SMERP/STG_MM002.TRAGR == TTGR.TRAGR
Packaging Material Type
  • /SMERP/STG_MM002.MANDT == TVTY.MANDT
  • /SMERP/STG_MM002.VHART == TVTY.TRATY
Volume unit
  • /SMERP/STG_MM002.MANDT == T006.MANDT
  • /SMERP/STG_MM002.VOLEH == T006.MSEHI
Warehouse Material Group
  • Warehouse Material Group
  • Client
  • /SMERP/STG_MM002.WHMATGR == TWHMATGR.WHMATGR
  • /SMERP/STG_MM002.MANDT == TWHMATGR.MANDT
Warehouse Storage Condition
  • /SMERP/STG_MM002.MANDT == TWHSTC.MANDT
  • /SMERP/STG_MM002.WHSTC == TWHSTC.WHSTC
Basic Material
  • /SMERP/STG_MM002.MANDT == TWSPR.MANDT
  • /SMERP/STG_MM002.WRKST == TWSPR.WRKST