/SMERP/STG_MM006 - Data staging - Material master accounting view complex table

Data staging - Material master accounting view complex table information is stored in SAP table /SMERP/STG_MM006.
It is part of development package /SMERP/MDO_MM in software component MOB-APP-MAO-ERP. This development package consists of objects that can be grouped under "MDO Framework - Materials Management".

Fields for table /SMERP/STG_MM006

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DSF_GUIDDSF GUIDX/SMFND/DSF_GUID_DTECHAR64
.INCLUDE/SMFND/DSF_REQ_FLDS_STR0
DSF_DSTORE_IDData Store ID/SMFND/DSF_DSTORE_ID_DTECHAR80*
USER_GUIDUser GUID/SYCLO/CORE_USER_GUID_DTECHAR64
DSF_RECORD_IDDSF Record ID/SMFND/DSF_RECORD_ID_DTENUMC20
DSF_CHANGED_BYLast Changed By/SYCLO/CORE_CHANGEDBY_DTECHAR24
DSF_CHANGED_TSChanged time stamp/SYCLO/CORE_CHANGEDTS_DTEDEC8
MATNRMaterial NumberMATNRCHAR80
.INCLUDE/SYCLO/MM_MARA_COMMON_STR0
VPSTAMaintenance status of complete materialVPSTACHAR30
MTARTMaterial typeMTARTCHAR8T134
MBRSHIndustry SectorMBRSHCHAR2T137
MATKLMaterial GroupMATKLCHAR18T023
BISMTOld material numberBISMTCHAR80
MEINSBase Unit of MeasureMEINSUNIT6T006
BSTMEPurchase Order Unit of MeasureBSTMEUNIT6T006
AESZNDocument change number (without document management system)AESZNCHAR12
BLATTPage number of document (without Document Management system)BLATTCHAR6
BLANZNumber of sheets (without Document Management system)BLANZNUMC6
FERTHProduction/inspection memoFERTHCHAR36
FORMTPage Format of Production MemoFORMTCHAR8
GROESSize/dimensionsGROESCHAR64
WRKSTBasic MaterialWRKSTCHAR96TWSPR
NORMTIndustry Standard Description (such as ANSI or ISO)NORMTCHAR36
LABORLaboratory/design officeLABORCHAR6T024L
EKWSLPurchasing Value KeyEKWSLCHAR8T405
BRGEWGross weightBRGEWQUAN7
NTGEWNet weightNTGEWQUAN7
GEWEIWeight UnitGEWEIUNIT6T006
VOLUMVolumeVOLUMQUAN7
VOLEHVolume unitVOLEHUNIT6T006
BEHVOContainer requirementsBEHVOCHAR4T144
RAUBEStorage conditionsRAUBECHAR4T142
TEMPBTemperature conditions indicatorTEMPBCHAR4T143
DISSTLow-Level CodeDISSTCHAR6
TRAGRTransportation GroupTRAGRCHAR8TTGR
STOFFHazardous material numberSTOFFCHAR80MGEF
SPARTDivisionSPARTCHAR4TSPA
KUNNRCompetitorWETTBCHAR20V_KNA1WETT
EANNREuropean Article Number (EAN) - obsolete!!!!!EANNRCHAR26
WESCHQuantity: Number of GR/GI slips to be printedWESCHQUAN7
BWVORProcurement ruleBWVORCHAR2T6WP1
SAISOSeason CategorySAISOCHAR8T6WSP
ETIARLabel typeETIARCHAR4T6WP3
ETIFOLabel formETIFOCHAR4T6WP4
ENTARDeactivatedDUMMYENTARCHAR2
EAN11International Article Number (EAN/UPC)EAN11CHAR36
NUMTPCategory of International Article Number (EAN)NUMTPCHAR4TNTP
LAENGLengthLAENGQUAN7
BREITWidthBREITQUAN7
HOEHEHeightHOEHEQUAN7
MEABMUnit of Dimension for Length/Width/HeightMEABMUNIT6T006
PRDHAProduct hierarchyPRODH_DCHAR36T179
AEKLKStock Transfer Net Change CostingCK_AEKLKCHAR2
CADKZCAD IndicatorCADKZCHAR2
QMPURQM in Procurement Is ActiveQMPURCHAR2
ERGEWAllowed packaging weightERGEWQUAN7
ERGEIUnit of weight (allowed packaging weight)ERGEIUNIT6T006
ERVOLAllowed packaging volumeERVOLQUAN7
ERVOEVolume unit (allowed packaging volume)ERVOEUNIT6T006
GEWTOExcess Weight Tolerance for Handling unitGEWTODEC2
VOLTOExcess Volume Tolerance of the Handling UnitVOLTODEC2
VABMEVariable Purchase Order Unit ActiveVABMECHAR2
KZREVRevision Level Has Been Assigned to the MaterialKZREVCHAR2
KZKFGConfigurable MaterialKZKFGCHAR2
VHARTPackaging Material TypeVHIARTCHAR8TVTY
FUELGMaximum level (by volume)FUELGDEC2
STFAKStacking factorSTFAKINT22
MAGRVMaterial Group: Packaging MaterialsMAGRVCHAR8TVEGR
BEGRUAuthorization GroupBEGRUCHAR8
DATABValid-From DateDATABDATS16
LIQDTDeletion dateLIQDTDATS16
SAISJSeason YearSAISJCHAR8
PLGTPPrice Band CategoryPLGTPCHAR4TWPT
MLGUTEmpties Bill of MaterialW_MITLEERGCHAR2
EXTWGExternal Material GroupEXTWGCHAR36TWEW
SATNRCross-Plant Configurable MaterialSATNRCHAR80MARA
ATTYPMaterial CategoryATTYPCHAR4
KZNFMIndicator: The material has a follow-up materialKZNFMCHAR2
PMATAPricing Reference MaterialPMATNCHAR80MARA
MSTAECross-Plant Material StatusMSTAECHAR4T141
MSTAVCross-distribution-chain material statusMSTAVCHAR4TVMS
MSTDEDate from which the cross-plant material status is validMSTDEDATS16
MSTDVDate from which the X-distr.-chain material status is validMSTDVDATS16
TAKLVTax classification of the materialTAKLVCHAR2TSKM
RBNRMCatalog ProfileRBNRCHAR18T352B
MHDRZMinimum Remaining Shelf LifeMHDRZDEC3
MHDHBTotal shelf lifeMHDHBDEC3
MHDLPStorage percentageMHDLPDEC2
INHMEContent unitINHMEUNIT6T006
INHALNet contentsINHALQUAN7
VPREHComparison price unitVPREHDEC3
ETIAGIS-R Labeling: material grouping (deactivated in 4.0)ETIAGCHAR36*
INHBRGross contentsINHBRQUAN7
CMETHQuantity Conversion MethodOIB_CMETHCHAR2
CUOBFInternal object numberCUOBMNUMC36
KZUMWEnvironmentally RelevantKZUMWCHAR2
KOSCHProduct allocation determination procedureKOSCHCHAR36T190S
SPROFPricing profile for variantsSPROFCHAR2
NRFHGMaterial qualifies for discount in kindNRFHGCHAR2
MFRPNManufacturer Part NumberMFRPNCHAR80
MFRNRManufacturer numberMFRNRCHAR20LFA1
BMATNNumber of firm's own (internal) inventory-managed materialMPMATCHAR80MARA
MPROFMfr part profileMPROFCHAR8TMPPF
KZWSMUnits of measure usageKZWSOCHAR2
SAITYRollout in a SeasonSAITYCHAR4T6WSA
PROFLDangerous Goods Indicator ProfileADGE_PROFLCHAR6TDG41
IHIVIIndicator: Highly ViscousADGE_IHIVICHAR2
ILOOSIndicator: In Bulk/LiquidADGE_ILOOSCHAR2
SERLVLevel of Explicitness for Serial NumberSERLVCHAR2
KZGVHPackaging Material is Closed PackagingKZGVHCHAR2
XGCHPApproved Batch Record RequiredXGCHPCHAR2
KZEFFAssign effectivity parameter values/ override change numbersCC_MTEFFCHAR2
IPRKZPeriod Indicator for Shelf Life Expiration DateDATTPCHAR2
RDMHDRounding rule for calculation of SLEDRDMHDCHAR2
PRZUSIndicator: Product composition printed on packagingPRZUSCHAR2
MTPOS_MARAGeneral item category groupMTPOS_MARACHAR8TPTM
BFLMEGeneric Material with Logistical VariantsBFLMECHAR2
MATFIMaterial Is LockedMATFICHAR2
CMRELRelevant for Configuration ManagementDE_CM_RELEVANCE_FLAGCHAR2
BBTYPAssortment List TypeBBTYPCHAR2*
SLED_BBDExpiration DateSLED_BBDCHAR2
GTIN_VARIANTGlobal Trade Item Number VariantGTIN_VARIANTCHAR4
GENNRMaterial Number of the Generic Material in Prepack MaterialsWSTR_SATNR_PPCHAR80MARA
RMATPReference material for materials packed in same wayPL_RMATPCHAR80MARA
GDS_RELEVANTIndicator: Global Data Synchronization-RelevantGDS_RELEVANTCHAR2
WEORAAcceptance At OriginWEORACHAR2
HUTYP_DFLTStandard HU TypeCIFHUTYPDFCHAR8THUTYP
PILFERABLEPilferableCIFPILFRBLCHAR2
WHSTCWarehouse Storage ConditionCIFWHSTCCHAR4TWHSTC
WHMATGRWarehouse Material GroupCIFWHMATGRCHAR8TWHMATGR
HNDLCODEHandling IndicatorCIFHDLCODECHAR8THNDLCD
HAZMATRelevant for Hazardous SubstancesCIFHAZMATCHAR2
HUTYPHandling Unit TypeCIFHUTYPCHAR8THUTYP
TARE_VARVariable Tare WeightCIFTAREVARCHAR2
MAXCMaximum Allowed Capacity of Packaging MaterialCIFMAXCDEC8
MAXC_TOLOvercapacity Tolerance of the Handling UnitCIFMAXCTOLDEC2
MAXLMaximum Packing Length of Packaging MaterialCIFMAXLQUAN8
MAXBMaximum Packing Width of Packaging MaterialCIFMAXBQUAN8
MAXHMaximum Packing Height of Packaging MaterialCIFMAXHQUAN8
MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/HeightCIFMAXDUOMUNIT6T006
QQTIMEQuarantine PeriodCIFQQTIMEQUAN2
QQTIMEUOMTime Unit for Quarantine PeriodCIFQQTIMEUOMUNIT6T006
QGRPQuality Inspection GroupCIFQGRPCHAR8TQGRP
SERIALSerial Number ProfileCIFSERIALCHAR8TSERIAL
PS_SMARTFORMForm NameCIFPSSFNAMECHAR60STXFADM
LOGUNITEWM CW: Logistics Unit of MeasureCIFLOGUNITUNIT6MARM
CWQRELEWM CW: Material Is a Catch Weight MaterialCIFCWQRELCHAR2
CWQPROCEWM CW: Catch Weight Profile for Entering CW QuantityCIFCWQPROCCHAR4TCWQPROC
CWQTOLGRCatch Weight Tolerance GroupCIFCWQTOLGRCHAR18TCWQTOLGR
.INCLUDE/BEV1/LUTRANSP0
/BEV1/LULEINHLoading Units/BEV1/LULEINHNUMC16
/BEV1/LULDEGRPLoading Unit Group: IS Beverage/BEV1/LULDEGRPCHAR6/BEV1/LUT906
.INCLUDE/DSD/VC_MARA_I0
/DSD/VC_GROUPDSD Grouping/DSD/VC_GROUPCHAR12/DSD/VC_GRP
.INCLUDE/VSO/R_MARA_I0
/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization)/VSO/M_TILT_INDCHAR2
/VSO/R_STACK_INDStacking not Allowed (VSO)/VSO/M_STACK_INDCHAR2
/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization)/VSO/M_BOTTOM_INDCHAR2
/VSO/R_TOP_INDTop Layer (VSO)/VSO/M_TOP_INDCHAR2
/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization)/VSO/M_STACK_NONUMC6
/VSO/R_PAL_INDLoad without Packaging Material (VSO)/VSO/M_PALLET_INDCHAR2
/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO)/VSO/R_PAL_OVR_DQUAN7
/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO)/VSO/R_PAL_OVR_WQUAN7
/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO)/VSO/R_PAL_BIN_HGTQUAN7
/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO)/VSO/R_PAL_MIN_HTQUAN7
/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO)/VSO/R_TOL_BIN_HTQUAN7
/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO)/VSO/M_ANZ_PER_GVHNUMC4
/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimization/VSO/R_QUAN_UNITUNIT6
/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO)/VSO/M_KZGVH_INDCHAR2
.INCLUDEDFPS_MARA_STY0
MCONDMaterial Condition ManagementDFPS_MCONDCHAR2
RETDELCReturn CodeDFPS_RETDELCCHAR2
LOGLEV_RETOReturn to Logistics LevelDFPS_LOGLEV_RETOCHAR2
NSNIDNATO Stock NumberDFPS_NSNIDCHAR18
.INCLUDEPICST0030
IMATNFFF classIMATNCHAR80*
PICNUMSupersession chain numberPIC_PICNUM_SUSCHAR80
BSTATCreation Status - Seasonal ProcurementWRFBSTATCHAR4*
.INCLUDEWRF_MARA_STY0
COLOR_ATINNInternal Charactieristic Number for Color CharacteristicsWRF_COLOR_ATINNNUMC20*
SIZE1_ATINNInternal Char. Number for Characteristics for Main SizesWRF_SIZE1_ATINNNUMC20*
SIZE2_ATINNInternal Char. Number for Characteristics for Second SizesWRF_SIZE2_ATINNNUMC20*
COLORCharacteristic Value for Colors of VariantsWRF_COLORCHAR36
SIZE1Characteristic Value for Main Sizes of VariantsWRF_SIZE1CHAR36
SIZE2Characteristic Value for Second Size for VariantsWRF_SIZE2CHAR36
FREE_CHARCharacteristic Value for Evaluation PurposesWRF_FREE_CHARCHAR36
CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.)WRF_CARE_CODECHAR32
BRAND_IDBrandWRF_BRAND_IDCHAR8WRF_BRANDS
FIBER_CODE1Fiber Code for Textiles (Component 1)WRF_FIBER_CODE_1CHAR6WRF_FIBER_CODES
FIBER_PART1Percentage Share of Fiber (Component 1)WRF_FIBER_PART_1NUMC6
FIBER_CODE2Fiber Code for Textiles (Component 2)WRF_FIBER_CODE_2CHAR6WRF_FIBER_CODES
FIBER_PART2Percentage Share of Fiber (Component 2)WRF_FIBER_PART_2NUMC6
FIBER_CODE3Fiber Code for Textiles (Component 3)WRF_FIBER_CODE_3CHAR6WRF_FIBER_CODES
FIBER_PART3Percentage Share of Fiber (Component 3)WRF_FIBER_PART_3NUMC6
FIBER_CODE4Fiber Code for Textiles (Component 4)WRF_FIBER_CODE_4CHAR6WRF_FIBER_CODES
FIBER_PART4Percentage Share of Fiber (Component 4)WRF_FIBER_PART_4NUMC6
FIBER_CODE5Fiber Code for Textiles (Component 5)WRF_FIBER_CODE_5CHAR6WRF_FIBER_CODES
FIBER_PART5Percentage Share of Fiber (Component 5)WRF_FIBER_PART_5NUMC6
FASHGRDFashion GradeFASHGRDCHAR8
MAKTXMaterial DescriptionMAKTXCHAR80
BWKEYValuation areaBWKEYCHAR8
BWTARValuation TypeBWTAR_DCHAR20
.INCLUDEEMBEW0
LVORMDeletion flag for all material data of a valuation typeLVOBACHAR2
.INCLUDEEMBEW10
LBKUMTotal Valuated StockLBKUMQUAN7
SALK3Value of Total Valuated StockSALK3CURR7
VPRSVPrice control indicatorVPRSVCHAR2
VERPRMoving Average Price/Periodic Unit PriceVERPRCURR6
STPRSStandard priceSTPRSCURR6
PEINHPrice unitPEINHDEC3
BKLASValuation ClassBKLASCHAR8T025
SALKVValue based on moving average price (only with price ctrl S)SALKVCURR7
VMKUMTotal valuated stock in previous periodVMKUMQUAN7
VMSALValue of total valuated stock in previous periodVMSALCURR7
VMVPRPrice Control Indicator in Previous PeriodVMVPRCHAR2
VMVERMoving Average Price/Periodic Unit Price in Previous PeriodVMVERCURR6
VMSTPStandard price in the previous periodVMSTPCURR6
VMPEIPrice unit of previous periodVMPEIDEC3
VMBKLValuation Class in Previous PeriodVMBKLCHAR8T025
VMSAVValue based on moving average price (previous period)VMSAVCURR7
VJKUMTotal Valuated Stock in Previous YearVJKUMQUAN7
VJSALValue of total valuated stock in previous yearVJSALCURR7
VJVPRPrice Control Indicator in Previous YearVJVPRCHAR2
VJVERMoving Average Price/Periodic Unit Price in Previous YearVJVERCURR6
VJSTPStandard price in previous yearVJSTPCURR6
VJPEIPrice unit of previous yearVJPEIDEC3
VJBKLValuation Class in Previous YearVJBKLCHAR8T025
VJSAVValue based on moving average price (previous year)VJSAVCURR7
LFGJAFiscal Year of Current PeriodLFGJANUMC8
LFMONCurrent period (posting period)LFMONNUMC4
BWTTYValuation CategoryBWTTY_DCHAR2T149C
STPRVPrevious PriceSTPRVCURR6
LAEPRDate of Last Price ChangeLAEPRDATS16
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
BWPRSValuation price based on tax law: level 1BWPRSCURR6
BWPRHValuation price based on commercial law: level 1BWPRHCURR6
VJBWSValuation price based on tax law: level 3VJBWSCURR6
VJBWHValuation price based on commercial law: level 3VJBWHCURR6
VVJSLValue of total valuated stock in year before lastVVJSLCURR7
VVJLBTotal valuated stock in year before lastVVJLBQUAN7
VVMLBTotal valuated stock in period before lastVVMLBQUAN7
VVSALValue of total valuated stock in period before lastVVSALCURR7
.INCLUDEEMBEW20
PPERZPeriod for future standard cost estimate (deactivated)PPERZACCP12
PPERLPeriod for current standard cost estimate (deactivated)PPERLACCP12
PPERVPeriod for previous standard cost estimate (deactivated)PPERVACCP12
.INCLUDEEMBEW30
KALKZIndicator: standard cost estimate for future periodKAXKZCHAR2
KALKLStandard Cost Estimate for Current PeriodKALKLCHAR2
KALKVIndicator: Standard Cost Estimate for Previous PeriodKALKVCHAR2
KALSCOverhead key (deactivated)KALSCCHAR12
XLIFOLIFO/FIFO-RelevantXLIFOCHAR2
MYPOLPool number for LIFO valuationMYPOOLCHAR8TPOOL
BWPH1Valuation price based on commercial law: level 2BWPH1CURR6
BWPS1Valuation price based on tax law: level 2BWPS1CURR6
ABWKZLowest value: devaluation indicatorABWKZNUMC4
PSTATMaintenance statusPSTAT_DCHAR30
.INCLUDEEMBEW40
KALN1Cost Estimate Number - Product CostingCK_KALNR1NUMC24*
KALNRCost Estimate Number for Cost Est. w/o Qty StructureCK_KALNRNUMC24*
.INCLUDEEMBEW50
BWVA1Valuation Variant for Future Standard Cost EstimateCK_BWVA1CHAR6TCK05
BWVA2Valuation Variant for Current Standard Cost EstimateCK_BWVA2CHAR6TCK05
BWVA3Valuation Variant for Previous Standard Cost EstimateCK_BWVA3CHAR6TCK05
VERS1Costing Version of Future Standard Cost EstimateCK_TVERS1NUMC4
VERS2Costing Version of Current Standard Cost EstimateCK_TVERS2NUMC4
VERS3Costing Version of Previous Standard Cost EstimateCK_TVERS3NUMC4
HRKFTOrigin Group as Subdivision of Cost ElementHRKFTCHAR8TKKH1
KOSGRCosting Overhead GroupCK_KOSGRCHAR20TCK14
PPRDZPeriod of Future Standard Cost EstimateCK_PPRDZNUMC6
PPRDLPeriod of Current Standard Cost EstimateCK_PPRDLNUMC6
PPRDVPeriod of Previous Standard Cost EstimateCK_PPRDVNUMC6
PDATZFiscal Year of Future Standard Cost EstimateCK_PDATZNUMC8
PDATLFiscal Year of Current Standard Cost EstimateCK_PDATLNUMC8
PDATVFiscal Year of Previous Standard Cost EstimateCK_PDATVNUMC8
EKALRMaterial Is Costed with Quantity StructureCK_EKALRELCHAR2
VPLPRPrevious Planned PriceVPLPRCURR6
MLMAAMaterial Ledger Activated at Material LevelCK_ML_MAACCHAR2
MLASTMaterial Price Determination: ControlCK_ML_ABSTCHAR2
LPLPRCurrent Planned PriceCK_LPLPRCURR6
VKSALValue of Total Valuated Stock at Sales PriceVKSALCURR7
HKMATMaterial-related originHKMATCHAR2
SPERWPhysical Inventory Blocking IndicatorSPERRCHAR2
KZIWLPhys. inventory indicator for value-only materialKZIWLCHAR6
WLINLDate of Last Posted CountDLINLDATS16
ABCIWPhysical Inventory Indicator for Cycle CountingABCINCHAR2*
.INCLUDEEMBEW60
BWSPAValuation marginBWSPADEC4
LPLPXFixed Portion of Current Planned PriceCK_LPLPXCURR6
VPLPXFixed Portion of Previous Planned PriceCK_VPLPXCURR6
FPLPXFixed Portion of Future Planned PriceCK_ZPLPXCURR6
LBWSTVal. Strat. for Current Plan Price, Sales Order/Proj. StockCK_LBWSTCHAR2
VBWSTValuation Strategy for Previous Planned Price, Special StockCK_VBWSTCHAR2
FBWSTValuation Strategy for Future Planned Price, Special StockCK_ZBWSTCHAR2
EKLASValuation Class for Sales Order StockEKLASCHAR8T025
QKLASValuation Class for Project StockQKLASCHAR8T025
MTUSEUsage of the materialJ_1BMATUSECHAR2
MTORGOrigin of the materialJ_1BMATORGCHAR2
OWNPRProduced in-houseJ_1BOWNPROCHAR2
XBEWMValuation based on the batch-specific unit of measureXBEWWCHAR2
BWPEIPrice unit for valuation prices based on tax/commercial lawBWPEIDEC3
.INCLUDEEMBEW70
MBRUEMBEWH rec. already exists for per. before last of MBEW per.MBRUECHAR2
OKLASValuation Class for Special Stock at the VendorOKLASCHAR8T025
.INCLUDEVAL_INCL_EEW_PS0
DUMMY_VAL_INCL_EEW_PSMD Product valuation extension field elementVAL_INCL_EEWCHAR2
.INCLU--APJVEMBEW0
OIPPINVPrepaid Inventory Flag for Material Valuation Type SegmentJV_PPINVCHAR2
Privacy Policy