/SMERP/STG_MM005

Data staging - Material batch view complex table | #transactional | 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
📏 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
ERSDA Created On
LAEDA Date of Last Change
VERAB Availability date
VFDAT Shelf Life Expiration or Best-Before Date
ZAEDT Date of last status change
LWEDT Date of last goods receipt
FVDT1 Date for Free Use
FVDT2 Date for Free Use
FVDT3 Date for Free Use
FVDT4 Date for Free Use
FVDT5 Date for Free Use
FVDT6 Date for Free Use
QNDAT Next Inspection Date
HSDAT Date of Manufacture
ZFDAT Date of Certification
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 Indicator Show values
ZUSTD Batch in Restricted-Use Stock Show values
XPCBT Single-Unit Batch Indicator Show values
DEACT_BM Batch is no longer active Show values
BATCH_TYPE Type of Batch 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
CHARG Batch Number CHARG
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
ZUSCH Batch status key ZUSCH
LICHA Supplier Batch Number LICHN
VLCHA Original batch number (deactivated) CHARG
BATCH_ID Batch ID
CUOBJ_BM Internal object no.: Batch classification CUOBJ
SGT_SCAT Stock Segment SGT_SRCA
ERSDA_TMSTP DEPRECATED - DO NOT USE TZNTSTMPS
ERSDA_TZ_SYS DEPRECATED - DO NOT USE TZNZONE
ERSDA_TZ_USR DEPRECATED - DO NOT USE TZNZONE
CREATION_DATETIME Created On Timestamp TZNTSTMPL
LASTCHANGE_DATETIME Last Change Timestamp TZNTSTMPL
Master Data Relations Join Conditions
External Key Check for Loading Unit Groups
DSD Grouping
  • DSD Grouping
  • Client
Container requirements
  • Container requirements
  • Client
  • /SMERP/STG_MM005.BEHVO == T144.BEHVO
  • /SMERP/STG_MM005.MANDT == T144.MANDT
Number of Internal Material Master Record
  • Number of firm's own (internal) inventory-managed material
  • Client
  • /SMERP/STG_MM005.BMATN == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Brand
Purchase Order Unit of Measure
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.BSTME == T006.MSEHI
Procurement rule
  • Procurement rule
  • Client
  • /SMERP/STG_MM005.BWVOR == T6WP1.BWVOR
  • /SMERP/STG_MM005.MANDT == T6WP1.MANDT
EWM CW: Catch Weight Profile for Entering CW Quantity
  • /SMERP/STG_MM005.MANDT == TCWQPROC.MANDT
  • /SMERP/STG_MM005.CWQPROC == TCWQPROC.CWQPROC
Catch Weight Tolerance Group
  • /SMERP/STG_MM005.MANDT == TCWQTOLGR.MANDT
  • /SMERP/STG_MM005.CWQTOLGR == TCWQTOLGR.CWQTOLGR
Purchasing Value Key
  • /SMERP/STG_MM005.MANDT == T405.MANDT
  • /SMERP/STG_MM005.EKWSL == T405.EKWSL
Unit of weight (allowed packaging weight)
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.ERGEI == T006.MSEHI
Volume unit (allowed packaging volume)
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.ERVOE == T006.MSEHI
Label type
  • Label type
  • Client
  • /SMERP/STG_MM005.ETIAR == T6WP3.ETIAR
  • /SMERP/STG_MM005.MANDT == T6WP3.MANDT
Label form
  • /SMERP/STG_MM005.MANDT == T6WP4.MANDT
  • /SMERP/STG_MM005.ETIFO == T6WP4.ETIFO
External Material Group
  • /SMERP/STG_MM005.MANDT == TWEW.MANDT
  • /SMERP/STG_MM005.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_MM005.GENNR == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Weight Unit
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.GEWEI == T006.MSEHI
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • /SMERP/STG_MM005.HERKL == T005.LAND1
  • /SMERP/STG_MM005.MANDT == T005.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Region of Origin of Material (Non-Preferential Origin)
  • /SMERP/STG_MM005.MANDT == T005S.MANDT
  • /SMERP/STG_MM005.HERKL == T005S.LAND1
  • /SMERP/STG_MM005.HERKR == T005S.BLAND
Handling Indicator
  • /SMERP/STG_MM005.MANDT == THNDLCD.MANDT
  • /SMERP/STG_MM005.HNDLCODE == THNDLCD.HNDLCODE
Handling Unit Type
  • /SMERP/STG_MM005.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM005.HUTYP == THUTYP.HUTYP
Standard HU Type
  • /SMERP/STG_MM005.MANDT == THUTYP.MANDT
  • /SMERP/STG_MM005.HUTYP_DFLT == THUTYP.HUTYP
Content unit
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.INHME == T006.MSEHI
Product Allocation Determination Procedure
  • /SMERP/STG_MM005.MANDT == T190S.MANDT
  • /SMERP/STG_MM005.KOSCH == T190S.KOSCH
Laboratory/design office
  • /SMERP/STG_MM005.MANDT == T024L.MANDT
  • /SMERP/STG_MM005.LABOR == T024L.LABOR
Vendor's account number
  • /SMERP/STG_MM005.MANDT == LFA1.MANDT
  • /SMERP/STG_MM005.LIFNR == LFA1.LIFNR
EWM CW: Logistics Unit of Measure
  • Material Number
  • EWM CW: Logistics Unit of Measure
  • /SMERP/STG_MM005.MANDT == MARM.MANDT
  • /SMERP/STG_MM005.MATNR == MARM.MATNR
  • /SMERP/STG_MM005.LOGUNIT == MARM.MEINH
Material Group: Packaging Materials
  • /SMERP/STG_MM005.MANDT == TVEGR.MANDT
  • /SMERP/STG_MM005.MAGRV == TVEGR.MAGRV
Material Group
  • /SMERP/STG_MM005.MANDT == T023.MANDT
  • /SMERP/STG_MM005.MATKL == T023.MATKL
Unit of Measure for Maximum Packing Length/Width/Height
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.MAXDIM_UOM == T006.MSEHI
Industry Sector
  • /SMERP/STG_MM005.MANDT == T137.MANDT
  • /SMERP/STG_MM005.MBRSH == T137.MBRSH
Unit of Dimension for Length/Width/Height
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.MEABM == T006.MSEHI
Base Unit of Measure
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.MEINS == T006.MSEHI
Manufacturer Number
  • /SMERP/STG_MM005.MANDT == LFA1.MANDT
  • /SMERP/STG_MM005.MFRNR == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • /SMERP/STG_MM005.MPROF == TMPPF.MPROF
  • /SMERP/STG_MM005.MANDT == TMPPF.MANDT
Cross-Plant Material Status
  • /SMERP/STG_MM005.MANDT == T141.MANDT
  • /SMERP/STG_MM005.MSTAE == T141.MMSTA
Cross-distribution-chain material status
  • /SMERP/STG_MM005.MANDT == TVMS.MANDT
  • /SMERP/STG_MM005.MSTAV == TVMS.VMSTA
Material type
  • /SMERP/STG_MM005.MANDT == T134.MANDT
  • /SMERP/STG_MM005.MTART == T134.MTART
General item category group
  • General item category group
  • Client
  • /SMERP/STG_MM005.MTPOS_MARA == TPTM.MTPOS
  • /SMERP/STG_MM005.MANDT == TPTM.MANDT
Material Group for Intrastat
  • /SMERP/STG_MM005.MANDT == TVFM.MANDT
  • /SMERP/STG_MM005.MTVER == TVFM.MTVER
Category of International Article Number (EAN)
  • /SMERP/STG_MM005.MANDT == TNTP.MANDT
  • /SMERP/STG_MM005.NUMTP == TNTP.NUMTP
Price Band Category
  • /SMERP/STG_MM005.MANDT == TWPT.MANDT
  • /SMERP/STG_MM005.PLGTP == TWPT.PLGTP
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • /SMERP/STG_MM005.PMATA == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • /SMERP/STG_MM005.PRDHA == T179.PRODH
  • /SMERP/STG_MM005.MANDT == T179.MANDT
Dangerous Goods Profile
  • Dangerous Goods Indicator Profile
  • Client
  • /SMERP/STG_MM005.PROFL == TDG41.PROFL
  • /SMERP/STG_MM005.MANDT == TDG41.MANDT
Quality Inspection Group
  • /SMERP/STG_MM005.MANDT == TQGRP.MANDT
  • /SMERP/STG_MM005.QGRP == TQGRP.QGRP
Time Unit for Quarantine Period
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.QQTIMEUOM == T006.MSEHI
Storage conditions
  • /SMERP/STG_MM005.MANDT == T142.MANDT
  • /SMERP/STG_MM005.RAUBE == T142.RAUBE
Catalog Profile
  • /SMERP/STG_MM005.MANDT == T352B.MANDT
  • /SMERP/STG_MM005.RBNRM == T352B.RBNR
Reference Material Check Packing Instruction
  • Reference material for materials packed in same way
  • Client
  • /SMERP/STG_MM005.RMATP == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Season Category
  • /SMERP/STG_MM005.MANDT == T6WSP.MANDT
  • /SMERP/STG_MM005.SAISO == T6WSP.SAISO
Categories of Seasonal Materials
  • /SMERP/STG_MM005.MANDT == T6WSA.MANDT
  • /SMERP/STG_MM005.SAITY == T6WSA.SAITY
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • /SMERP/STG_MM005.SATNR == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • /SMERP/STG_MM005.SERIAL == TSERIAL.SERIAL
  • /SMERP/STG_MM005.MANDT == TSERIAL.MANDT
Division
  • /SMERP/STG_MM005.MANDT == TSPA.MANDT
  • /SMERP/STG_MM005.SPART == TSPA.SPART
Hazardous material number
  • Hazardous material number
  • ?
  • Client
  • /SMERP/STG_MM005.STOFF == MGEF.STOFF
  • /SMERP/STG_MM005.[column in domain "REGKZ"] == MGEF.REGKZ
  • /SMERP/STG_MM005.MANDT == MGEF.MANDT
Tax classification of the material
  • ?
  • Tax classification of the material
  • Client
  • /SMERP/STG_MM005.[column in domain "TATYP"] == TSKM.TATYP
  • /SMERP/STG_MM005.TAKLV == TSKM.TAXKM
  • /SMERP/STG_MM005.MANDT == TSKM.MANDT
Temperature conditions indicator
  • Temperature conditions indicator
  • Client
  • /SMERP/STG_MM005.TEMPB == T143.TEMPB
  • /SMERP/STG_MM005.MANDT == T143.MANDT
Transportation Group
  • /SMERP/STG_MM005.MANDT == TTGR.MANDT
  • /SMERP/STG_MM005.TRAGR == TTGR.TRAGR
Packaging Material Type
  • /SMERP/STG_MM005.MANDT == TVTY.MANDT
  • /SMERP/STG_MM005.VHART == TVTY.TRATY
Original material (deactivated)
  • Original material (deactivated)
  • Client
  • /SMERP/STG_MM005.VLMAT == MARA.MATNR
  • /SMERP/STG_MM005.MANDT == MARA.MANDT
Original plant (deactivated)
  • Original material (deactivated)
  • Client
  • Original plant (deactivated)
  • /SMERP/STG_MM005.VLMAT == MARC.MATNR
  • /SMERP/STG_MM005.MANDT == MARC.MANDT
  • /SMERP/STG_MM005.VLWRK == MARC.WERKS
Volume unit
  • /SMERP/STG_MM005.MANDT == T006.MANDT
  • /SMERP/STG_MM005.VOLEH == T006.MSEHI
Warehouse Material Group
  • Warehouse Material Group
  • Client
  • /SMERP/STG_MM005.WHMATGR == TWHMATGR.WHMATGR
  • /SMERP/STG_MM005.MANDT == TWHMATGR.MANDT
Warehouse Storage Condition
  • /SMERP/STG_MM005.MANDT == TWHSTC.MANDT
  • /SMERP/STG_MM005.WHSTC == TWHSTC.WHSTC
Basic Material
  • /SMERP/STG_MM005.MANDT == TWSPR.MANDT
  • /SMERP/STG_MM005.WRKST == TWSPR.WRKST