SAP /MERP/MM_MATBASIC_ENTITY_STR Table in S/4 HANA - Material Basic Entity Type









/MERP/MM_MATBASIC_ENTITY_STR is a standard SAP Table which is used to store Material Basic Entity Type 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 /MERP/MM_MATBASIC_ENTITY_STR 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: /MERP/MM_MATBASIC_ENTITY_STR


/MERP/MM_MATBASIC_ENTITY_STR table structure field list

Below is the full /MERP/MM_MATBASIC_ENTITY_STR 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
VPSTAMaintenance status of complete materialVPSTACHAR15(0) PSTAT
MTARTMaterial typeMTARTCHAR4(0) T134MTARTMTA
MBRSHIndustry SectorMBRSHCHAR1(0) T137MBRSHMTP
MATKLMaterial GroupMATKLCHAR9(0) T023MATKLMKLS_WBWGMATKL
BISMTOld material numberBISMTCHAR40(0) BISMT
MEINSBase Unit of MeasureMEINSUNIT3(0) T006CUNITMEINS
BSTMEPurchase Order Unit of MeasureBSTMEUNIT3(0) T006CUNITMEINS
ZEINRDocument number (without document management system)DZEINRCHAR22(0) CHAR22
ZEIARDocument type (without Document Management system)DZEIARCHAR3(0) ZEIAR
ZEIVRDocument version (without Document Management system)DZEIVRCHAR2(0) VERSI
ZEIFOPage format of document (without Document Management system)DZEIFOCHAR4(0) DINFO
BLATTPage number of document (without Document Management system)BLATTCHAR3(0) BLATT
BLANZNumber of sheets (without Document Management system)BLANZNUMC3(0) NUM3
FERTHProduction/inspection memoFERTHCHAR18(0) FERTH
FORMTPage Format of Production MemoFORMTCHAR4(0) DINFO
GROESSize/dimensionsGROESCHAR32(0) CHAR32
WRKSTBasic MaterialWRKSTCHAR48(0) TWSPRWRKST
NORMTIndustry Standard Description (such as ANSI or ISO)NORMTCHAR18(0) NORMT
LABORLaboratory/design officeLABORCHAR3(0) T024LLABOR
EKWSLPurchasing Value KeyEKWSLCHAR4(0) T405EKWSL
BRGEWGross weightBRGEWQUAN13(3) MENG13
NTGEWNet weightNTGEWQUAN13(3) MENG13
GEWEIWeight UnitGEWEIUNIT3(0) T006CUNITMEINS
VOLUMVolumeVOLUMQUAN13(3) MENG13
VOLEHVolume unitVOLEHUNIT3(0) T006CUNITMEINS
BEHVOContainer requirementsBEHVOCHAR2(0) T144BEHVO
RAUBEStorage conditionsRAUBECHAR2(0) T142RAUBE
TEMPBTemperature conditions indicatorTEMPBCHAR2(0) T143TEMPB
DISSTLow-Level CodeDISSTCHAR3(0) DISST
TRAGRTransportation GroupTRAGRCHAR4(0) TTGRTRAGR
STOFFHazardous material numberSTOFFCHAR40(0) MGEFMATN3STOFFSTO
SPARTDivisionSPARTCHAR2(0) TSPASPARTSPAC_SPARTSPART
KUNNRCompetitorWETTBCHAR10(0) V_KNA1WETTALPHAKUNNRKUN
EANNREuropean Article Number (EAN) - obsolete!!!!!EANNRCHAR13(0) CHAR13EAN
WESCHQuantity: Number of GR/GI slips to be printedWESCHQUAN13(3) MENG13
BWVORProcurement ruleBWVORCHAR1(0) T6WP1BWVOR
SAISOSeason CategorySAISOCHAR4(0) T6WSPSAISOSAISO
ETIARLabel typeETIARCHAR2(0) T6WP3ETIAR
ETIFOLabel formETIFOCHAR2(0) T6WP4ETIFO
ENTARDeactivatedDUMMYENTARCHAR1(0) CHAR1
EAN11International Article Number (EAN/UPC)EAN11CHAR18(0) EAN11EAN11EAN
NUMTPCategory of International Article Number (EAN)NUMTPCHAR2(0) TNTPNUMTP
LAENGLengthLAENGQUAN13(3) MENG13
BREITWidthBREITQUAN13(3) MENG13
HOEHEHeightHOEHEQUAN13(3) MENG13
MEABMUnit of Dimension for Length/Width/HeightMEABMUNIT3(0) T006CUNITMEINS
PRDHAProduct hierarchyPRODH_DCHAR18(0) T179PRODHVPR
AEKLKStock Transfer Net Change CostingCK_AEKLKCHAR1(0) XFELD
CADKZCAD IndicatorCADKZCHAR1(0) XFELD
QMPURQM in Procurement Is ActiveQMPURCHAR1(0) XFELD
ERGEWAllowed packaging weightERGEWQUAN13(3) MENG13
ERGEIUnit of weight (allowed packaging weight)ERGEIUNIT3(0) T006CUNITMEINS
ERVOLAllowed packaging volumeERVOLQUAN13(3) MENG13
ERVOEVolume unit (allowed packaging volume)ERVOEUNIT3(0) T006CUNITMEINS
GEWTOExcess Weight Tolerance for Handling unitGEWTODEC3(1) PRZ21
VOLTOExcess Volume Tolerance of the Handling UnitVOLTODEC3(1) PRZ21
VABMEVariable Purchase Order Unit ActiveVABMECHAR1(0) VABME
KZREVRevision Level Has Been Assigned to the MaterialKZREVCHAR1(0) XFELD
KZKFGConfigurable MaterialKZKFGCHAR1(0) XFELD
VHARTPackaging Material TypeVHIARTCHAR4(0) TVTYTRATY
FUELGMaximum level (by volume)FUELGDEC3(0) DEC3
STFAKStacking factorSTFAKINT25(0) INT2
MAGRVMaterial Group: Packaging MaterialsMAGRVCHAR4(0) TVEGRMAGRV
BEGRUAuthorization GroupBEGRUCHAR4(0) BEGRU
DATABValid-From DateDATABDATS8(0) DATUM
LIQDTDeletion dateLIQDTDATS8(0) DATUM
SAISJSeason YearSAISJCHAR4(0) GJAHRCJAHRWMSAISJ
PLGTPPrice Band CategoryPLGTPCHAR2(0) TWPTPLGTP
MLGUTEmpties Bill of MaterialW_MITLEERGCHAR1(0) FLAG
EXTWGExternal Material GroupEXTWGCHAR18(0) TWEWEXTWG
SATNRCross-Plant Configurable MaterialSATNRCHAR40(0) MARAMATN1MATNR
ATTYPMaterial CategoryATTYPCHAR2(0) ATTYPMTY
KZNFMIndicator: The material has a follow-up materialKZNFMCHAR1(0) XFELD
PMATAPricing Reference MaterialPMATNCHAR40(0) MARAMATN1MATNRMAT
MSTAECross-Plant Material StatusMSTAECHAR2(0) T141MMSTAH_T141MMSTA
MSTAVCross-distribution-chain material statusMSTAVCHAR2(0) TVMSVMSTAH_TVMSVMSTA
MSTDEDate from which the cross-plant material status is validMSTDEDATS8(0) DATUM
MSTDVDate from which the X-distr.-chain material status is validMSTDVDATS8(0) DATUM
TAKLVTax classification of the materialTAKLVCHAR1(0) TSKMTAXKM
RBNRMCatalog ProfileRBNRCHAR9(0) T352BRBNR
MHDRZMinimum Remaining Shelf LifeMHDRZDEC4(0) DEC4
MHDHBTotal shelf lifeMHDHBDEC4(0) DEC4
MHDLPStorage percentageMHDLPDEC3(0) DEC3
INHMEContent unitINHMEUNIT3(0) T006CUNITMEINS
INHALNet contentsINHALQUAN13(3) MENG13
VPREHComparison price unitVPREHDEC5(0) PACK3
ETIAGIS-R Labeling: material grouping (deactivated in 4.0)ETIAGCHAR18(0) Assigned to domainETIAG
INHBRGross contentsINHBRQUAN13(3) MENG13
CMETHQuantity Conversion MethodOIB_CMETHCHAR1(0) OIB_CMETH
CUOBFInternal object numberCUOBMNUMC18(0) CUOBJ
KZUMWEnvironmentally RelevantKZUMWCHAR1(0) XFELD
KOSCHProduct allocation determination procedureKOSCHCHAR18(0) T190SKOSCH
SPROFPricing profile for variantsSPROFCHAR1(0) SPROF
NRFHGMaterial qualifies for discount in kindNRFHGCHAR1(0) NRFHG
MFRPNManufacturer Part NumberMFRPNCHAR40(0) CHAR40
MFRNRManufacturer numberMFRNRCHAR10(0) LFA1ALPHALIFNR
BMATNNumber of firm's own (internal) inventory-managed materialMPMATCHAR40(0) MARAMATN1MATNRMAT
MPROFMfr part profileMPROFCHAR4(0) TMPPFMPROF
KZWSMUnits of measure usageKZWSOCHAR1(0) KZWSO
SAITYRollout in a SeasonSAITYCHAR2(0) T6WSASAITYWMSAITY
SERLVLevel of Explicitness for Serial NumberSERLVCHAR1(0) SERLV
KZGVHPackaging Material is Closed PackagingKZGVHCHAR1(0) XFELD
XGCHPApproved Batch Record RequiredXGCHPCHAR1(0) XFELD
KZEFFAssign effectivity parameter values/ override change numbersCC_MTEFFCHAR1(0) XFELD
IPRKZPeriod Indicator for Shelf Life Expiration DateDATTPCHAR1(0) PERKZDATTPH_PERDKZEPRKZ
RDMHDRounding rule for calculation of SLEDRDMHDCHAR1(0) RDMHD
PRZUSIndicator: Product composition printed on packagingPRZUSCHAR1(0) XFELD
MTPOS_MARAGeneral item category groupMTPOS_MARACHAR4(0) TPTMMTPOS
BFLMEGeneric Material with Logistical VariantsBFLMECHAR1(0) BFLME
MATFIMaterial Is LockedMATFICHAR1(0) XFELD
CMRELRelevant for Configuration ManagementDE_CM_RELEVANCE_FLAGCHAR1(0) DO_CM_RELEVANCE_FLAG
BBTYPAssortment List TypeBBTYPCHAR1(0) Assigned to domainBBTYPWBB
SLED_BBDExpiration DateSLED_BBDCHAR1(0) SLED_BBD
GTIN_VARIANTGlobal Trade Item Number VariantGTIN_VARIANTCHAR2(0) GTIN_VARIANT
GENNRMaterial Number of the Generic Material in Prepack MaterialsWSTR_SATNR_PPCHAR40(0) MARAMATN1MATNR
RMATPReference material for materials packed in same wayPL_RMATPCHAR40(0) MARAMATN1MATNRMAT
GDS_RELEVANTIndicator: Global Data Synchronization-RelevantGDS_RELEVANTCHAR1(0) XFELD
WEORAAcceptance At OriginWEORACHAR1(0) XFELD
HUTYP_DFLTStandard HU TypeCIFHUTYPDFCHAR4(0) THUTYPCHAR4
PILFERABLEPilferableCIFPILFRBLCHAR1(0) XFELD
WHSTCWarehouse Storage ConditionCIFWHSTCCHAR2(0) TWHSTCCHAR2
WHMATGRWarehouse Material GroupCIFWHMATGRCHAR4(0) TWHMATGRCHAR4
HNDLCODEHandling IndicatorCIFHDLCODECHAR4(0) THNDLCDCHAR4
HAZMATRelevant for Hazardous SubstancesCIFHAZMATCHAR1(0) XFELD
HUTYPHandling Unit TypeCIFHUTYPCHAR4(0) THUTYPCHAR4
TARE_VARVariable Tare WeightCIFTAREVARCHAR1(0) XFELD
MAXCMaximum Allowed Capacity of Packaging MaterialCIFMAXCDEC15(3) DECV15_3
MAXC_TOLOvercapacity Tolerance of the Handling UnitCIFMAXCTOLDEC3(1) DEC2_1
MAXLMaximum Packing Length of Packaging MaterialCIFMAXLQUAN15(3) CIFQUAN15
MAXBMaximum Packing Width of Packaging MaterialCIFMAXBQUAN15(3) CIFQUAN15
MAXHMaximum Packing Height of Packaging MaterialCIFMAXHQUAN15(3) CIFQUAN15
MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/HeightCIFMAXDUOMUNIT3(0) T006CUNITMEINS
QQTIMEQuarantine PeriodCIFQQTIMEQUAN3(0)
QQTIMEUOMTime Unit for Quarantine PeriodCIFQQTIMEUOMUNIT3(0) T006CUNITMEINS
QGRPQuality Inspection GroupCIFQGRPCHAR4(0) TQGRPCIFQGRP
SERIALSerial Number ProfileCIFSERIALCHAR4(0) TSERIALCIFSERIAL
PS_SMARTFORMForm NameCIFPSSFNAMECHAR30(0) STXFADMTDSFNAME
LOGUNITEWM CW: Logistics Unit of MeasureCIFLOGUNITUNIT3(0) MARMCUNITMEINS
CWQRELEWM CW: Material Is a Catch Weight MaterialCIFCWQRELCHAR1(0) XFELD
CWQPROCEWM CW: Catch Weight Profile for Entering CW QuantityCIFCWQPROCCHAR2(0) TCWQPROCCIFCWQPROC
CWQTOLGRCatch Weight Tolerance GroupCIFCWQTOLGRCHAR9(0) TCWQTOLGRCIFCWQTOLGR
MCONDMaterial Condition ManagementDFPS_MCONDCHAR1(0) DFPS_MCOND
RETDELCReturn CodeDFPS_RETDELCCHAR1(0) DFPS_RETDELC
LOGLEV_RETOReturn to Logistics LevelDFPS_LOGLEV_RETOCHAR1(0) DFPS_LOGLEV
NSNIDNATO Stock NumberDFPS_NSNIDCHAR9(0) DFPS_NSNID
IMATNFFF classIMATNCHAR40(0) Assigned to domainMATN1MATNR
PICNUMSupersession chain numberPIC_PICNUM_SUSCHAR40(0) ALPHAPIC_PICNUMPIC_PICNUMPICNUM
BSTATCreation Status - Seasonal ProcurementWRFBSTATCHAR2(0) Assigned to domainWRFBSTAT
COLOR_ATINNInternal Charactieristic Number for Color CharacteristicsWRF_COLOR_ATINNNUMC10(0) Assigned to domainATINNATINN
SIZE1_ATINNInternal Char. Number for Characteristics for Main SizesWRF_SIZE1_ATINNNUMC10(0) Assigned to domainATINNATINN
SIZE2_ATINNInternal Char. Number for Characteristics for Second SizesWRF_SIZE2_ATINNNUMC10(0) Assigned to domainATINNATINN
COLORCharacteristic Value for Colors of VariantsWRF_COLORCHAR18(0) WRF_ATWRT
SIZE1Characteristic Value for Main Sizes of VariantsWRF_SIZE1CHAR18(0) WRF_ATWRT
SIZE2Characteristic Value for Second Size for VariantsWRF_SIZE2CHAR18(0) WRF_ATWRT
FREE_CHARCharacteristic Value for Evaluation PurposesWRF_FREE_CHARCHAR18(0) WRF_ATWRT
CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.)WRF_CARE_CODECHAR16(0) WRF_CARE_CODE
BRAND_IDBrandWRF_BRAND_IDCHAR4(0) WRF_BRANDSWRF_BRAND_ID
FIBER_CODE1Fiber Code for Textiles (Component 1)WRF_FIBER_CODE_1CHAR3(0) WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART1Percentage Share of Fiber (Component 1)WRF_FIBER_PART_1NUMC3(0) WRF_FIBER_PART
FIBER_CODE2Fiber Code for Textiles (Component 2)WRF_FIBER_CODE_2CHAR3(0) WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART2Percentage Share of Fiber (Component 2)WRF_FIBER_PART_2NUMC3(0) WRF_FIBER_PART
FIBER_CODE3Fiber Code for Textiles (Component 3)WRF_FIBER_CODE_3CHAR3(0) WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART3Percentage Share of Fiber (Component 3)WRF_FIBER_PART_3NUMC3(0) WRF_FIBER_PART
FIBER_CODE4Fiber Code for Textiles (Component 4)WRF_FIBER_CODE_4CHAR3(0) WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART4Percentage Share of Fiber (Component 4)WRF_FIBER_PART_4NUMC3(0) WRF_FIBER_PART
FIBER_CODE5Fiber Code for Textiles (Component 5)WRF_FIBER_CODE_5CHAR3(0) WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART5Percentage Share of Fiber (Component 5)WRF_FIBER_PART_5NUMC3(0) WRF_FIBER_PART
FASHGRDFashion GradeFASHGRDCHAR4(0) FASHGRDH_FASHGRDFASHGRD
MAKTXMaterial descriptionMAKTXCHAR40(0) TEXT40
IHIVIIndicator: Highly ViscousADGE_IHIVICHAR1(0) X
ILOOSIndicator: In Bulk/LiquidADGE_ILOOSCHAR1(0) X
PROFLDangerous Goods Indicator ProfileADGE_PROFLCHAR3(0) Assigned to domainADGD_PROFL
AESZNDocument change number (without document management system)AESZNCHAR6(0) AENUM
/BEV1/LULEINHLoading Units/BEV1/LULEINHNUMC8(0) /BEV1/LULEINH
/BEV1/LULDEGRPLoading Unit Group: IS Beverage/BEV1/LULDEGRPCHAR3(0) /BEV1/LUT906/BEV1/LULDEGRP
/DSD/VC_GROUPDSD Grouping/DSD/VC_GROUPCHAR6(0) /DSD/VC_GRP/DSD/VC_GROUP
/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization)/VSO/M_TILT_INDCHAR1(0) /VSO/M_XFIELD
/VSO/R_STACK_INDStacking not Allowed (VSO)/VSO/M_STACK_INDCHAR1(0) /VSO/M_XFIELD
/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization)/VSO/M_BOTTOM_INDCHAR1(0) /VSO/M_XFIELD
/VSO/R_TOP_INDTop Layer (VSO)/VSO/M_TOP_INDCHAR1(0) /VSO/M_XFIELD
/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization)/VSO/M_STACK_NONUMC3(0) /VSO/M_STACK_NO
/VSO/R_PAL_INDLoad without Packaging Material (VSO)/VSO/M_PALLET_INDCHAR1(0) /VSO/M_XFIELD
/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO)/VSO/R_PAL_OVR_DQUAN13(3) MENG13
/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO)/VSO/R_PAL_OVR_WQUAN13(3) MENG13
/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO)/VSO/R_PAL_BIN_HGTQUAN13(3) MENG13
/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO)/VSO/R_PAL_MIN_HTQUAN13(3) MENG13
/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO)/VSO/R_TOL_BIN_HTQUAN13(3) MENG13
/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO)/VSO/M_ANZ_PER_GVHNUMC2(0) /VSO/M_ANZ_PER_GVH
/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimization/VSO/R_QUAN_UNITUNIT3(0) CUNIT/VSO/R_QUAN_UNIT/VSO/R_SH_T006_MEMSEHI
/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO)/VSO/M_KZGVH_INDCHAR1(0) /VSO/M_XFIELD




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!