SAP MBEFM Table in S/4 HANA - Obsolete.. Do not use.









MBEFM is a standard SAP Table which is used to store Obsolete.. Do not use. data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP MBEFM table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MBEFM


MBEFM table structure field list

Below is the full MBEFM field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
KMBEWIndicator MBEW from configurable materialKMBEWCHAR1(0) XFELD
SPRASLanguage KeySPRASLANG1(0) ISOLASPRASSPRH_T002SPRAS
MAKTXMaterial descriptionMAKTXCHAR40(0) TEXT40
MTARTMaterial typeMTARTCHAR4(0) MTARTMTA
MBRSHIndustry SectorMBRSHCHAR1(0) MBRSHMTP
MATKLMaterial GroupMATKLCHAR9(0) MATKLMKLS_WBWGMATKL
MEINSBase Unit of MeasureMEINSUNIT3(0) CUNITMEINS
AUSMEUnit of issueAUSMEUNIT3(0) CUNITMEINS
VOLUMVolumeVOLUMQUAN13(3) MENG13
BRGEWGross weightBRGEWQUAN13(3) MENG13
GEWEIWeight UnitGEWEIUNIT3(0) CUNITMEINS
WERKSPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
LGORTStorage locationLGORT_DCHAR4(0) LGORTLAG
CHARGBatch NumberCHARG_DCHAR10(0) CHARGCHA
PSTATMaintenance statusPSTAT_DCHAR15(0) PSTAT
LVORMDeletion IndicatorLVORMCHAR1(0) XFELD
XCHPFBatch management requirement indicatorXCHPFCHAR1(0) XFELD
XCHARBatch management indicator (internal)XCHARCHAR1(0) XFELD
XSONDMaterial managed in special stocksXSONDCHAR1(0) XFELD
DISMMMRP TypeDISMMCHAR2(0) DISMM
DISSTLow-Level CodeDISSTCHAR3(0) DISST
DISPOMRP ControllerDISPOCHAR3(0) DISPODGRHS_T024DDISPO
DISKZStorage location MRP indicatorDISKZCHAR1(0) DISKZ
DIBERIndicator: MRP area existsDIBERCHAR1(0) XFELD
APOKZIndicator: Is material relevant for APOAPOKZCHAR1(0) APOKZ
MTVFPChecking Group for Availability CheckMTVFPCHAR2(0) MTVFP
PLIFZPlanned Delivery Time in DaysPLIFZDEC3(0) DEC3
WEBAZGoods receipt processing time in daysWEBAZDEC3(0) DEC3
EISBESafety stockEISBEQUAN13(3) MENG13
MINBEReorder PointMINBEQUAN13(3) MENG13
BESKZProcurement TypeBESKZCHAR1(0) BESKZMBS
SOBESSpecial procurement typeSOBESCHAR1(0) SOBES
MISKZMixed MRP indicatorMISKZCHAR1(0) MISKZ
VRMODConsumption modeVRMODCHAR1(0) VRMOD
VINT1Consumption period: backwardVINT1NUMC3(0) VRINT
VINT2Consumption period: forwardVINT2NUMC3(0) VRINT
PERIMFiscal Year VariantPERIVCHAR2(0) PERIV
PERKZPeriod IndicatorPERKZCHAR1(0) PERKZPKZ
SSQSSQA Control KeySSQSSCHAR8(0) SSQSS
VMBWEValuated Goods Receipt Blocked StockBWESBQUAN13(3) MENG13V
SPERRPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
KZILLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KZVLLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KZILQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KZVLQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KZILEPhysical inventory indicator for restricted-use stockKZILECHAR3(0) INVKZ
KZVLEPhysical inventory ind. for restricted-use stock, prev.pdKZVLECHAR3(0) INVKZ
KZILSPhysical inventory indicator for blocked stockKZILSCHAR3(0) INVKZ
KZVLSPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR3(0) INVKZ
BWKEYValuation areaBWKEYCHAR4(0) BWKEYBWK
BWTTYValuation CategoryBWTTY_DCHAR1(0) BWTTY
BWTARValuation TypeBWTAR_DCHAR10(0) BWTARBWT
KZBAAIndicator: valuation type is set automaticallyKZBAACHAR1(0) XFELD
XLIFOLIFO/FIFO-RelevantXLIFOCHAR1(0) LIFO_FIFO
VPRSVPrice control indicatorVPRSVCHAR1(0) VPRSV
VERPRMoving Average Price/Periodic Unit PriceVERPRCURR11(2) WERT11V
STPRSStandard priceSTPRSCURR11(2) WERT11V
PEINHPrice unitPEINHDEC5(0) PACK3
BKLASValuation ClassBKLASCHAR4(0) BKLAS
EKLASValuation Class for Sales Order StockEKLASCHAR4(0) BKLAS
QKLASValuation Class for Project StockQKLASCHAR4(0) BKLAS
OKLASValuation Class for Special Stock at the VendorOKLASCHAR4(0) BKLAS
SPARTDivisionSPARTCHAR2(0) SPARTSPAC_SPARTSPART
HRKFTOrigin Group as Subdivision of Cost ElementHRKFTCHAR4(0) HRKFT
MENGUQuantity Updating in Material Master RecordMENGUCHAR1(0) XFELD
WERTUValue Updating in Material Master RecordWERTUCHAR1(0) XFELD
VMVPRPrice Control Indicator in Previous PeriodVMVPRCHAR1(0) VPRSV
VMSTPStandard price in the previous periodVMSTPCURR11(2) WERT11V
VMVERMoving Average Price/Periodic Unit Price in Previous PeriodVMVERCURR11(2) WERT11V
VMPEIPrice unit of previous periodVMPEIDEC5(0) PACK3
VMBKLValuation Class in Previous PeriodVMBKLCHAR4(0) BKLAS
ZUSCHBatch status keyDZUSCHCHAR1(0) ZUSCH
ZUSTDBatch in Restricted-Use StockDZUSTDCHAR1(0) XFELD
CHAMEUnit of issue for batch (deactivated)CHAMEUNIT3(0) CUNITMEINS
SPERCPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
KZICLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KZICQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KZICEPhysical inventory indicator for restricted-use stockKZILECHAR3(0) INVKZ
KZICSPhysical inventory indicator for blocked stockKZILSCHAR3(0) INVKZ
VFDATShelf Life Expiration or Best-Before DateVFDATDATS8(0) DATUM
HSDATDate of ManufactureHSDATDATS8(0) DATUM
LWEDTDate of last goods receiptLWEDTDATS8(0) DATUM
KONPRConsignment priceKONPRCURR11(2) WERT11
KOPEIPrice unit for consignment priceKOPEIDEC5(0) DEC5
SPERSPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
KZISLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KZISQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KZISEPhysical inventory indicator for restricted-use stockKZILECHAR3(0) INVKZ
KZISSPhysical inventory indicator for blocked stockKZILSCHAR3(0) INVKZ
KZVSLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
KZVSQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
KZVSEPhysical inventory ind. for restricted-use stock, prev.pdKZVLECHAR3(0) INVKZ
KZVSSPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR3(0) INVKZ
DBESTMessage if material is used in Inventory ManagementDBESTCHAR1(0) FEDIA
MTSTBDescription of material status from MM/PP viewMTSTBCHAR25(0) TEXT25
GSBERBusiness AreaGSBERCHAR4(0) GSBERGSB
PRCTRProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
WESCHQuantity: Number of GR/GI slips to be printedWESCHQUAN13(3) MENG13
KUSPRPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
KUVUMStock in Transfer in Previous PeriodVMUMLQUAN13(3) MENG13V
KUILLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KUILQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KUVLLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
KUVLQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
KUFLLPhysical inventory indicator for stock in following yearKZFLLCHAR3(0) INVKZ
KUFLQPhysical inventory indicator, quality insp.stck, follow.yr.KZFLQCHAR3(0) INVKZ
LBSPRPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
LBVUMStock in Transfer in Previous PeriodVMUMLQUAN13(3) MENG13V
LBILLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
LBILQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
LBVLLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
LBVLQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
LBFLLPhysical inventory indicator for stock in following yearKZFLLCHAR3(0) INVKZ
LBFLQPhysical inventory indicator, quality insp.stck, follow.yr.KZFLQCHAR3(0) INVKZ
KASPRPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
KAILLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
KAILQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
KAVLLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
KAVLQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
KAFLLPhysical inventory indicator for stock in following yearKZFLLCHAR3(0) INVKZ
KAFLQPhysical inventory indicator, quality insp.stck, follow.yr.KZFLQCHAR3(0) INVKZ
ETIARLabel typeETIARCHAR2(0) ETIAR
ETIFOLabel formETIFOCHAR2(0) ETIFO
KAILSPhysical inventory indicator for blocked stockKZILSCHAR3(0) INVKZ
KAVLSPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR3(0) INVKZ
KAFLSPhys. inventory ind. for blocked stock in following periodKZFLSCHAR3(0) INVKZ
DISGRMRP GroupDISGRCHAR4(0) DISGR
VERABAvailability dateVERABDATS8(0) DATUM
LIFCHVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
LICHASupplier Batch NumberLICHNCHAR15(0) LICHN
DLINLDate of Last Posted CountDLINLDATS8(0) DATS
CHDLLDate of Last Posted CountDLINLDATS8(0) DATS
ABCINPhysical Inventory Indicator for Cycle CountingABCINCHAR1(0) ABCIN
XMCNGNegative stocks allowed in plantXMCNGCHAR1(0) XFELD
KADLLDate of Last Posted CountDLINLDATS8(0) DATS
KUDLLDate of Last Posted CountDLINLDATS8(0) DATS
KODLLDate of Last Posted CountDLINLDATS8(0) DATS
LBDLLDate of Last Posted CountDLINLDATS8(0) DATS
PRSPRPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
PRILLPhysical inventory indicator for whse stock in current yearKZILLCHAR3(0) INVKZ
PRILQPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR3(0) INVKZ
PRILSPhysical inventory indicator for blocked stockKZILSCHAR3(0) INVKZ
PRVLLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
PRVLQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
PRVLSPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR3(0) INVKZ
PRFLLPhysical inventory indicator for stock in following yearKZFLLCHAR3(0) INVKZ
PRFLQPhysical inventory indicator, quality insp.stck, follow.yr.KZFLQCHAR3(0) INVKZ
PRFLSPhys. inventory ind. for blocked stock in following periodKZFLSCHAR3(0) INVKZ
PRDLLDate of Last Posted CountDLINLDATS8(0) DATS
MLMAAMaterial Ledger Activated at Material LevelCK_ML_MAACCHAR1(0) XFELD
MLASTMaterial Price Determination: ControlCK_ML_ABSTCHAR1(0) CK_ML_ABST
KALN1Cost Estimate Number - Product CostingCK_KALNR1NUMC12(0) CK_KALNRKNE
SERNPSerial Number ProfileSERAILCHAR4(0) SERAIL
EKWSLPurchasing Value KeyEKWSLCHAR4(0) EKWSL
MHDRZMinimum Remaining Shelf LifeMHDRZDEC4(0) DEC4
MHDHBTotal shelf lifeMHDHBDEC4(0) DEC4
MHDLPStorage percentageMHDLPDEC3(0) DEC3
HKMATMaterial-related originHKMATCHAR1(0) HKMAT
CCFIXCC indicator is fixedCCFIXCHAR1(0) XFELD
EPRIOWithdrawal Sequence Group for StocksEPRIOCHAR4(0) EPRIO
KZPIPPipeline Handling MandatoryKZPIPCHAR1(0) XFELD
XPIZUPipeline handling allowedXPIZUCHAR1(0) XFELD
DZEITIn-house production timeDZEITDEC3(0) DEC3
PRDHAProduct hierarchyPRODH_DCHAR18(0) PRODHVPR
SATNRCross-Plant Configurable MaterialSATNRCHAR40(0) MATN1MATNR
BWVORProcurement ruleBWVORCHAR1(0) BWVOR
BWSCLSource of SupplyBWSCLCHAR1(0) BQSCL
SAISOSeason CategorySAISOCHAR4(0) SAISOSAISO
VOLEHVolume unitVOLEHUNIT3(0) CUNITMEINS
PLGTPPrice Band CategoryPLGTPCHAR2(0) PLGTP
SERVGIS-R service levelW_SERVGRDCHAR1(0) W_SERVGRD
STRGRPlanning Strategy GroupSTRGRCHAR2(0) STRGR
QNDATNext Inspection DateQNPDATDATS8(0) DATUM
PRFRQInterval Until Next Recurring InspectionPRFRQDEC5(0) DEC5
CUOBJInternal object numberCUOBMNUMC18(0) CUOBJ
STDPDConfigurable materialSTDPDCHAR40(0) MATN1MATNR
KZIWLPhys. inventory indicator for value-only materialKZIWLCHAR3(0) INVKZ
MLGUTEmpties Bill of MaterialW_MITLEERGCHAR1(0) FLAG
SPERWPhysical Inventory Blocking IndicatorSPERRCHAR1(0) SPERR
WLINLDate of Last Posted CountDLINLDATS8(0) DATS
ABCIWPhysical Inventory Indicator for Cycle CountingABCINCHAR1(0) ABCIN
SAISJSeason YearSAISJCHAR4(0) GJAHRCJAHRWMSAISJ
BWSPAValuation marginBWSPADEC6(2) PRZ32V
ATTYPMaterial CategoryATTYPCHAR2(0) ATTYPMTY
CUOBFInternal object numberCUOBMNUMC18(0) CUOBJ
KZWSMUnits of measure usageKZWSOCHAR1(0) KZWSO
KALNRCost Estimate Number for Cost Est. w/o Qty StructureCK_KALNRNUMC12(0) CK_KALNRKNR
EKALRMaterial Is Costed with Quantity StructureCK_EKALRELCHAR1(0) XFELD
SERLVLevel of Explicitness for Serial NumberSERLVCHAR1(0) SERLV
XBEWMValuation based on the batch-specific unit of measureXBEWWCHAR1(0) XFELD
MDRUEMARDH rec. already exists for per. before last of MARD per.MDRUECHAR1(0) XFELD
VVKLAStock value of a value-only material at sales priceVKLABCURR13(2) WERT13N
VVKUMSales value in stock transfer (SLOc to SLoc)VKUMLCURR13(2) WERT13N
VVKTRTransit value at sales price for value-only materialVKTRWCURR13(2) WERT13N
VVKUCStock transfer sales value (plant to plant) for VO materialVKUMCCURR13(2) WERT13N
VVKSAValue of Total Valuated Stock at Sales PriceVKSALCURR13(2) WERT13N
IPRKZPeriod Indicator for Shelf Life Expiration DateDATTPCHAR1(0) PERKZDATTPH_PERDKZEPRKZ
RDMHDRounding rule for calculation of SLEDRDMHDCHAR1(0) RDMHD
MBRUEMBEWH rec. already exists for per. before last of MBEW per.MBRUECHAR1(0) XFELD
VMUMCStock in transfer (plant to plant)UMLMEQUAN13(3) MENG13V
VMTRAStock in TransitTRAMEQUAN13(3) MENG13V
VMVKUStock transfer sales value (plant to plant) for VO materialVKUMCCURR13(2) WERT13N
VMVKTTransit value at sales price for value-only materialVKTRWCURR13(2) WERT13N
VMGLGTied Empties StockGLGMGQUAN13(3) MENG13V
VMVKGSales value of tied empties stockVKGLGCURR13(2) WERT13N
SAVTRStock in transitSATRAQUAN13(3) MENG13V
SQVTRStock in transitSQTRAQUAN13(3) MENG13V
VMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per.VMVKSCURR13(2) WERT13N
LADGRLoading GroupLADGRCHAR4(0) LADGR
BFLMEGeneric Material with Logistical VariantsBFLMECHAR1(0) BFLME
LGPBEStorage BinLGPBECHAR10(0) CHAR10
KZVCLPhysical inventory indicator for stock in previous yearKZVLLCHAR3(0) INVKZ
KZVCQPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR3(0) INVKZ
KZVCEPhysical inventory ind. for restricted-use stock, prev.pdKZVLECHAR3(0) INVKZ
KZVCSPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR3(0) INVKZ
SAVBWValuated Goods Receipt Blocked Stock, Sales OrderSABWEQUAN13(3) MENG13V
SQVBWValuated Goods Receipt Blocked Stock, ProjectSQBWEQUAN13(3) MENG13V
VMCSBValuated Goods Receipt Blocked StockBWESBQUAN13(3) MENG13V
VMESBValuated Goods Receipt Blocked Stock, Sales OrderSABWEQUAN13(3) MENG13V
VMQSBValuated Goods Receipt Blocked Stock, ProjectSQBWEQUAN13(3) MENG13V
SGT_STATCSegmentation StatusSGT_STATCCHAR1(0) SGT_STAT
SGT_SCOPESegmentation Strategy ScopeSGT_SCOPECHAR1(0) SGT_SCOPE
SGT_COVSSegmentation StrategySGT_COVSCHAR8(0) SGT_COVSSGT_ESGT_COVS_SHLPSGT_COVS
SGT_SCATStock SegmentSGT_SCATCHAR40(0) SGT_SRCASGT_SSGT_CAT_FIELD_POPUPVALUE




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!