/SMERP/STG_MM004

Data staging - Material warehouse view complex table | #masterdata | Component: Mobile Application Integration - ERP Core
Column Name Description
MANDT Client
DSF_GUID DSF GUID
Column Name Description
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
LHMG1 Loading equipment quantity 1
LHMG2 Loading equipment quantity 2
LHMG3 Loading equipment quantity 3
📏 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
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 Deletion flag for all material data of a warehouse number Show values
KZZUL Indicator: Allow addition to existing stock Show values
KZMBF Indicator: Message to inventory management Show values
VOMEM Default for unit of measure from material master record Show values
L2SKR Material relevance for 2-step picking 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
LGNUM Warehouse Number / Warehouse Complex LGNUM
MKAPV Capacity usage DEC8_3
Master Data Relations Join Conditions
External Key Check for Loading Unit Groups
DSD Grouping
  • DSD Grouping
  • Client
Container requirements
  • Container requirements
  • Client
  • /SMERP/STG_MM004.BEHVO == T144.BEHVO
  • /SMERP/STG_MM004.MANDT == T144.MANDT
Unit of measure for capacity consumption
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.BEZME == T006.MSEHI
Bulk Storage Indicators
  • Bulk Storage Indicators
  • Client
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.BLOCK == T338.BLOCK
  • /SMERP/STG_MM004.MANDT == T338.MANDT
  • /SMERP/STG_MM004.LGNUM == T338.LGNUM
Number of Internal Material Master Record
  • Number of firm's own (internal) inventory-managed material
  • Client
  • /SMERP/STG_MM004.BMATN == MARA.MATNR
  • /SMERP/STG_MM004.MANDT == MARA.MANDT
Brand
Special movement indicator
  • Special movement indicator for warehouse management
  • Client
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.BSSKZ == T306.BSSKZ
  • /SMERP/STG_MM004.MANDT == T306.MANDT
  • /SMERP/STG_MM004.LGNUM == T306.LGNUM
Purchase Order Unit of Measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.BSTME == T006.MSEHI
Procurement rule
  • Procurement rule
  • Client
  • /SMERP/STG_MM004.BWVOR == T6WP1.BWVOR
  • /SMERP/STG_MM004.MANDT == T6WP1.MANDT
EWM CW: Catch Weight Profile for Entering CW Quantity
  • /SMERP/STG_MM004.MANDT == TCWQPROC.MANDT
  • /SMERP/STG_MM004.CWQPROC == TCWQPROC.CWQPROC
Catch Weight Tolerance Group
  • /SMERP/STG_MM004.MANDT == TCWQTOLGR.MANDT
  • /SMERP/STG_MM004.CWQTOLGR == TCWQTOLGR.CWQTOLGR
Purchasing Value Key
  • /SMERP/STG_MM004.MANDT == T405.MANDT
  • /SMERP/STG_MM004.EKWSL == T405.EKWSL
Unit of weight (allowed packaging weight)
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.ERGEI == T006.MSEHI
Volume unit (allowed packaging volume)
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.ERVOE == T006.MSEHI
Label type
  • Label type
  • Client
  • /SMERP/STG_MM004.ETIAR == T6WP3.ETIAR
  • /SMERP/STG_MM004.MANDT == T6WP3.MANDT
Label form
  • /SMERP/STG_MM004.MANDT == T6WP4.MANDT
  • /SMERP/STG_MM004.ETIFO == T6WP4.ETIFO
External Material Group
  • /SMERP/STG_MM004.MANDT == TWEW.MANDT
  • /SMERP/STG_MM004.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_MM004.GENNR == MARA.MATNR
  • /SMERP/STG_MM004.MANDT == MARA.MANDT
Weight Unit
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.GEWEI == T006.MSEHI
Handling Indicator
  • /SMERP/STG_MM004.MANDT == THNDLCD.MANDT
  • /SMERP/STG_MM004.HNDLCODE == THNDLCD.HNDLCODE
Handling Unit Type
  • /SMERP/STG_MM004.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM004.HUTYP == THUTYP.HUTYP
Standard HU Type
  • /SMERP/STG_MM004.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM004.HUTYP_DFLT == THUTYP.HUTYP
Content unit
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.INHME == T006.MSEHI
Product Allocation Determination Procedure
  • /SMERP/STG_MM004.MANDT == T190S.MANDT
  • /SMERP/STG_MM004.KOSCH == T190S.KOSCH
Laboratory/design office
  • /SMERP/STG_MM004.MANDT == T024L.MANDT
  • /SMERP/STG_MM004.LABOR == T024L.LABOR
Storage unit type
  • 1st storage unit type
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.MANDT == T307.MANDT
  • /SMERP/STG_MM004.LETY1 == T307.LETYP
  • /SMERP/STG_MM004.LGNUM == T307.LGNUM
Storage unit type
  • 2nd storage unit type
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.MANDT == T307.MANDT
  • /SMERP/STG_MM004.LETY2 == T307.LETYP
  • /SMERP/STG_MM004.LGNUM == T307.LGNUM
Storage unit type
  • 3rd storage unit type
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.MANDT == T307.MANDT
  • /SMERP/STG_MM004.LETY3 == T307.LETYP
  • /SMERP/STG_MM004.LGNUM == T307.LGNUM
Storage section indicator
  • Storage Section Indicators
  • Client
  • Warehouse Number / Warehouse Complex
  • /SMERP/STG_MM004.LGBKZ == T304.LGBKZ
  • /SMERP/STG_MM004.MANDT == T304.MANDT
  • /SMERP/STG_MM004.LGNUM == T304.LGNUM
Unit of measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.LHME1 == T006.MSEHI
Unit of measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.LHME2 == T006.MSEHI
Unit of measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.LHME3 == T006.MSEHI
EWM CW: Logistics Unit of Measure
  • Material Number
  • EWM CW: Logistics Unit of Measure
  • /SMERP/STG_MM004.MANDT == MARM.MANDT
  • /SMERP/STG_MM004.MATNR == MARM.MATNR
  • /SMERP/STG_MM004.LOGUNIT == MARM.MEINH
Storage type indicator
  • Warehouse Number / Warehouse Complex
  • Storage type indicator for stock removal
  • Client
  • /SMERP/STG_MM004.LGNUM == T305.LGNUM
  • /SMERP/STG_MM004.LTKZA == T305.LGTKZ
  • /SMERP/STG_MM004.MANDT == T305.MANDT
Storage type indicator
  • Warehouse Number / Warehouse Complex
  • Storage type indicator for stock placement
  • Client
  • /SMERP/STG_MM004.LGNUM == T305.LGNUM
  • /SMERP/STG_MM004.LTKZE == T305.LGTKZ
  • /SMERP/STG_MM004.MANDT == T305.MANDT
Unit of measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.LVSME == T006.MSEHI
Material Group: Packaging Materials
  • /SMERP/STG_MM004.MANDT == TVEGR.MANDT
  • /SMERP/STG_MM004.MAGRV == TVEGR.MAGRV
Material Group
  • /SMERP/STG_MM004.MANDT == T023.MANDT
  • /SMERP/STG_MM004.MATKL == T023.MATKL
Unit of Measure for Maximum Packing Length/Width/Height
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.MAXDIM_UOM == T006.MSEHI
Industry Sector
  • /SMERP/STG_MM004.MANDT == T137.MANDT
  • /SMERP/STG_MM004.MBRSH == T137.MBRSH
Unit of Dimension for Length/Width/Height
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.MEABM == T006.MSEHI
Base Unit of Measure
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.MEINS == T006.MSEHI
Manufacturer Number
  • /SMERP/STG_MM004.MANDT == LFA1.MANDT
  • /SMERP/STG_MM004.MFRNR == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • /SMERP/STG_MM004.MPROF == TMPPF.MPROF
  • /SMERP/STG_MM004.MANDT == TMPPF.MANDT
Cross-Plant Material Status
  • /SMERP/STG_MM004.MANDT == T141.MANDT
  • /SMERP/STG_MM004.MSTAE == T141.MMSTA
Cross-distribution-chain material status
  • /SMERP/STG_MM004.MANDT == TVMS.MANDT
  • /SMERP/STG_MM004.MSTAV == TVMS.VMSTA
Material type
  • /SMERP/STG_MM004.MANDT == T134.MANDT
  • /SMERP/STG_MM004.MTART == T134.MTART
General item category group
  • General item category group
  • Client
  • /SMERP/STG_MM004.MTPOS_MARA == TPTM.MTPOS
  • /SMERP/STG_MM004.MANDT == TPTM.MANDT
Category of International Article Number (EAN)
  • /SMERP/STG_MM004.MANDT == TNTP.MANDT
  • /SMERP/STG_MM004.NUMTP == TNTP.NUMTP
Price Band Category
  • /SMERP/STG_MM004.MANDT == TWPT.MANDT
  • /SMERP/STG_MM004.PLGTP == TWPT.PLGTP
Picking storage type for rough-cut and detailed planning
  • Warehouse Number / Warehouse Complex
  • Client
  • Picking storage type for rough-cut and detailed planning
  • /SMERP/STG_MM004.LGNUM == T301.LGNUM
  • /SMERP/STG_MM004.MANDT == T301.MANDT
  • /SMERP/STG_MM004.PLKPT == T301.LGTYP
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • /SMERP/STG_MM004.PMATA == MARA.MATNR
  • /SMERP/STG_MM004.MANDT == MARA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • /SMERP/STG_MM004.PRDHA == T179.PRODH
  • /SMERP/STG_MM004.MANDT == T179.MANDT
Dangerous Goods Profile
  • Dangerous Goods Indicator Profile
  • Client
  • /SMERP/STG_MM004.PROFL == TDG41.PROFL
  • /SMERP/STG_MM004.MANDT == TDG41.MANDT
Quality Inspection Group
  • /SMERP/STG_MM004.MANDT == TQGRP.MANDT
  • /SMERP/STG_MM004.QGRP == TQGRP.QGRP
Time Unit for Quarantine Period
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.QQTIMEUOM == T006.MSEHI
Storage conditions
  • /SMERP/STG_MM004.MANDT == T142.MANDT
  • /SMERP/STG_MM004.RAUBE == T142.RAUBE
Catalog Profile
  • /SMERP/STG_MM004.MANDT == T352B.MANDT
  • /SMERP/STG_MM004.RBNRM == T352B.RBNR
Reference Material Check Packing Instruction
  • Reference material for materials packed in same way
  • Client
  • /SMERP/STG_MM004.RMATP == MARA.MATNR
  • /SMERP/STG_MM004.MANDT == MARA.MANDT
Season Category
  • /SMERP/STG_MM004.MANDT == T6WSP.MANDT
  • /SMERP/STG_MM004.SAISO == T6WSP.SAISO
Categories of Seasonal Materials
  • /SMERP/STG_MM004.MANDT == T6WSA.MANDT
  • /SMERP/STG_MM004.SAITY == T6WSA.SAITY
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • /SMERP/STG_MM004.SATNR == MARA.MATNR
  • /SMERP/STG_MM004.MANDT == MARA.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • /SMERP/STG_MM004.SERIAL == TSERIAL.SERIAL
  • /SMERP/STG_MM004.MANDT == TSERIAL.MANDT
Division
  • /SMERP/STG_MM004.MANDT == TSPA.MANDT
  • /SMERP/STG_MM004.SPART == TSPA.SPART
Hazardous material number
  • Hazardous material number
  • ?
  • Client
  • /SMERP/STG_MM004.STOFF == MGEF.STOFF
  • /SMERP/STG_MM004.[column in domain "REGKZ"] == MGEF.REGKZ
  • /SMERP/STG_MM004.MANDT == MGEF.MANDT
Tax classification of the material
  • ?
  • Tax classification of the material
  • Client
  • /SMERP/STG_MM004.[column in domain "TATYP"] == TSKM.TATYP
  • /SMERP/STG_MM004.TAKLV == TSKM.TAXKM
  • /SMERP/STG_MM004.MANDT == TSKM.MANDT
Temperature conditions indicator
  • Temperature conditions indicator
  • Client
  • /SMERP/STG_MM004.TEMPB == T143.TEMPB
  • /SMERP/STG_MM004.MANDT == T143.MANDT
Transportation Group
  • /SMERP/STG_MM004.MANDT == TTGR.MANDT
  • /SMERP/STG_MM004.TRAGR == TTGR.TRAGR
Packaging Material Type
  • /SMERP/STG_MM004.MANDT == TVTY.MANDT
  • /SMERP/STG_MM004.VHART == TVTY.TRATY
Volume unit
  • /SMERP/STG_MM004.MANDT == T006.MANDT
  • /SMERP/STG_MM004.VOLEH == T006.MSEHI
Warehouse Material Group
  • Warehouse Material Group
  • Client
  • /SMERP/STG_MM004.WHMATGR == TWHMATGR.WHMATGR
  • /SMERP/STG_MM004.MANDT == TWHMATGR.MANDT
Warehouse Storage Condition
  • /SMERP/STG_MM004.MANDT == TWHSTC.MANDT
  • /SMERP/STG_MM004.WHSTC == TWHSTC.WHSTC
Basic Material
  • /SMERP/STG_MM004.MANDT == TWSPR.MANDT
  • /SMERP/STG_MM004.WRKST == TWSPR.WRKST