SAP Tables | Logistics - General | Logistics Basic Data | Material Master(LO-MD-MM) SAP LO

MARA SAP General Material Data Table







MARA is a standard SAP Table which is used to store General Material Data information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table MARA and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can Be Enhanced (Deep)

Text table = MAKT

==>View Table relationships


Dictionary fields for SAP Table MARA

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
MATNRMATNRCHAR18 Material Number
.INCLUDEEMARA Data Division MARA
ERSDAERSDADATS8 Created On
ERNAMERNAMCHAR12 Name of Person who Created the Object
LAEDALAEDADATS8 Date of Last Change
AENAMAENAMCHAR12 Name of Person Who Changed Object
VPSTAVPSTACHAR15 Maintenance status of complete material
PSTATPSTAT_DCHAR15 Maintenance status
LVORMLVOMACHAR1 Flag Material for Deletion at Client Level
MTARTMTARTCHAR4 T134Material Type
MBRSHMBRSHCHAR1 T137Industry sector
BISMTBISMTCHAR18 Old material number
MEINSMEINSUNIT3 T006Base Unit of Measure
BSTMEBSTMEUNIT3 T006Purchase Order Unit of Measure
ZEINRDZEINRCHAR22 Document number (without document management system)
ZEIARDZEIARCHAR3 Document type (without Document Management system)
ZEIVRDZEIVRCHAR2 Document version (without Document Management system)
ZEIFODZEIFOCHAR4 Page format of document (without Document Management system)
AESZNAESZNCHAR6 Document change number (without document management system)
BLATTBLATTCHAR3 Page number of document (without Document Management system)
BLANZBLANZNUMC3 Number of sheets (without Document Management system)
FERTHFERTHCHAR18 Production/inspection memo
FORMTFORMTCHAR4 Page Format of Production Memo
GROESGROESCHAR32 Size/dimensions
WRKSTWRKSTCHAR48 TWSPRBasic Material
NORMTNORMTCHAR18 Industry Standard Description (such as ANSI or ISO)
LABORLABORCHAR3 T024LLaboratory/design office
EKWSLEKWSLCHAR4 T405Purchasing Value Key
BRGEWBRGEWQUAN13(3) Gross Weight
NTGEWNTGEWQUAN13(3) Net Weight
GEWEIGEWEIUNIT3 T006Weight Unit
VOLUMVOLUMQUAN13(3) Volume
VOLEHVOLEHUNIT3 T006Volume unit
BEHVOBEHVOCHAR2 T144Container requirements
RAUBERAUBECHAR2 T142Storage conditions
TEMPBTEMPBCHAR2 T143Temperature conditions indicator
DISSTDISSTCHAR3 Low-Level Code
TRAGRTRAGRCHAR4 TTGRTransportation Group
STOFFSTOFFCHAR18 MGEFHazardous material number
KUNNRWETTBCHAR10 V_KNA1WETTCompetitor
EANNREANNRCHAR13 European Article Number (EAN) - obsolete!!!!!
WESCHWESCHQUAN13(3) Quantity: Number of GR/GI slips to be printed
BWVORBWVORCHAR1 T6WP1Procurement rule
BWSCLBWSCLCHAR1 TMBW1Source of Supply
SAISOSAISOCHAR4 T6WSPSeason Category
ETIARETIARCHAR2 T6WP3Label type
ETIFOETIFOCHAR2 T6WP4Label form
ENTARDUMMYENTARCHAR1
*
Deactivated
EAN11EAN11CHAR18 International Article Number (EAN/UPC)
NUMTPNUMTPCHAR2 TNTPCategory of International Article Number (EAN)
LAENGLAENGQUAN13(3) Length
BREITBREITQUAN13(3) Width
HOEHEHOEHEQUAN13(3) Height
MEABMMEABMUNIT3 T006Unit of Dimension for Length/Width/Height
PRDHAPRODH_DCHAR18 T179Product hierarchy
AEKLKCK_AEKLKCHAR1 Stock Transfer Net Change Costing
CADKZCADKZCHAR1 CAD Indicator
QMPURQMPURCHAR1 QM in Procurement is Active
ERGEWERGEWQUAN13(3) Allowed packaging weight
ERGEIERGEIUNIT3 T006Unit of weight (allowed packaging weight)
ERVOLERVOLQUAN13(3) Allowed packaging volume
ERVOEERVOEUNIT3 T006Volume unit (allowed packaging volume)
GEWTOGEWTODEC3(1) Excess Weight Tolerance for Handling unit
VOLTOVOLTODEC3(1) Excess Volume Tolerance of the Handling Unit
VABMEVABMECHAR1 Variable Purchase Order Unit Active
KZREVKZREVCHAR1 Revision Level Has Been Assigned to the Material
KZKFGKZKFGCHAR1 Configurable Material
XCHPFXCHPFCHAR1 Batch management requirement indicator
VHARTVHIARTCHAR4 TVTYPackaging Material Type
FUELGFUELGDEC3 Maximum level (by volume)
STFAKSTFAKINT25 Stacking factor
MAGRVMAGRVCHAR4 TVEGRMaterial Group: Packaging Materials
BEGRUBEGRUCHAR4 Authorization Group
DATABDATABDATS8 Valid-From Date
LIQDTLIQDTDATS8 Deletion date
SAISJSAISJCHAR4 Season Year
PLGTPPLGTPCHAR2 TWPTPrice Band Category
MLGUTW_MITLEERGCHAR1 Empties Bill of Material
EXTWGEXTWGCHAR18 TWEWExternal Material Group
SATNRSATNRCHAR18 MARACross-Plant Configurable Material
ATTYPATTYPCHAR2 Material Category
KZKUPKZKUPMATCHAR1 Indicator: Material can be co-product
KZNFMKZNFMCHAR1 Indicator: The material has a follow-up material
PMATAPMATNCHAR18 MARAPricing Reference Material
MSTAEMSTAECHAR2 T141Cross-Plant Material Status
MSTAVMSTAVCHAR2 TVMSCross-distribution-chain material status
MSTDEMSTDEDATS8 Date from which the cross-plant material status is valid
MSTDVMSTDVDATS8 Date from which the X-distr.-chain material status is valid
TAKLVTAKLVCHAR1 TSKMTax classification of the material
RBNRMRBNRCHAR9 T352BCatalog Profile
MHDRZMHDRZDEC4 Minimum Remaining Shelf Life
MHDHBMHDHBDEC4 Total shelf life
MHDLPMHDLPDEC3 Storage percentage
INHMEINHMEUNIT3 T006Content unit
INHALINHALQUAN13(3) Net contents
VPREHVPREHDEC5 Comparison price unit
ETIAGETIAGCHAR18 TWEAIS-R Labeling: material grouping (deactivated in 4.0)
INHBRINHBRQUAN13(3) Gross contents
CMETHOIB_CMETHCHAR1 Quantity Conversion Method
CUOBFCUOBMNUMC18 Internal object number
KZUMWKZUMWCHAR1 Environmentally Relevant
KOSCHKOSCHCHAR18 T190SProduct allocation determination procedure
SPROFSPROFCHAR1 Pricing profile for variants
NRFHGNRFHGCHAR1 Material qualifies for discount in kind
MFRPNMFRPNCHAR40 Manufacturer Part Number
MFRNRMFRNRCHAR10 LFA1Number of a Manufacturer
BMATNMPMATCHAR18 MARANumber of firm's own (internal) inventory-managed material
MPROFMPROFCHAR4 TMPPFManufacturer Part Profile
KZWSMKZWSOCHAR1 Units of measure usage
SAITYSAITYCHAR2 T6WSARollout in a Season
PROFLADGE_PROFLCHAR3 TDG41Dangerous Goods Indicator Profile
IHIVIADGE_IHIVICHAR1 Indicator: Highly Viscous
ILOOSADGE_ILOOSCHAR1 Indicator: In Bulk/Liquid
SERLVSERLVCHAR1 Level of Explicitness for Serial Number
KZGVHKZGVHCHAR1 Packaging Material is Closed Packaging
XGCHPXGCHPCHAR1 Indicator: Approved batch record required
KZEFFCC_MTEFFCHAR1 Assign effectivity parameter values/ override change numbers
COMPLCSCP_COMP_LVLNUMC2 TCSCP_COMP_LVLMaterial completion level
IPRKZDATTPCHAR1 Period Indicator for Shelf Life Expiration Date
RDMHDRDMHDCHAR1 Rounding rule for calculation of SLED
PRZUSPRZUSCHAR1 Indicator: Product composition printed on packaging
MTPOS_MARAMTPOS_MARACHAR4 TPTMGeneral item category group
BFLMEBFLMECHAR1 Generic Material with Logistical Variants
MATFIMATFICHAR1 Material Is Locked
CMRELDE_CM_RELEVANCE_FLAGCHAR1 Relevant for Configuration Management
BBTYPBBTYPCHAR1
*
Assortment List Type
SLED_BBDSLED_BBDCHAR1 Expiration Date
GTIN_VARIANTGTIN_VARIANTCHAR2 Global Trade Item Number Variant
GENNRWSTR_SATNR_PPCHAR18 MARAMaterial Number of the Generic Material in Prepack Materials
RMATPPL_RMATPCHAR18 MARAReference material for materials packed in same way
GDS_RELEVANTGDS_RELEVANTCHAR1 Indicator: Global Data Synchronization-Relevant
WEORAWEORACHAR1 Acceptance At Origin
HUTYP_DFLTCIFHUTYPDFCHAR4 THUTYPStandard HU Type
PILFERABLECIFPILFRBLCHAR1 Pilferable
WHSTCCIFWHSTCCHAR2 TWHSTCWarehouse Storage Condition
WHMATGRCIFWHMATGRCHAR4 TWHMATGRWarehouse Material Group
HNDLCODECIFHDLCODECHAR4 THNDLCDHandling Indicator
HAZMATCIFHAZMATCHAR1 Relevant for Hazardous Substances
HUTYPCIFHUTYPCHAR4 THUTYPHandling Unit Type
TARE_VARCIFTAREVARCHAR1 Variable Tare Weight
MAXCCIFMAXCDEC15(3) Maximum Allowed Capacity of Packaging Material
MAXC_TOLCIFMAXCTOLDEC3(1) Overcapacity Tolerance of the Handling Unit
MAXLCIFMAXLQUAN15(3) Maximum Packing Length of Packaging Material
MAXBCIFMAXBQUAN15(3) Maximum Packing Width of Packaging Material
MAXHCIFMAXHQUAN15(3) Maximum Packing Height of Packaging Material
MAXDIM_UOMCIFMAXDUOMUNIT3 T006Unit of Measure for Maximum Packing Length/Width/Height
HERKLHERKLCHAR3 T005Country of origin of the material
MFRGRMFRGRCHAR8 TMFGMaterial freight group
QQTIMECIFQQTIMEQUAN3 Quarantine Period
QQTIMEUOMCIFQQTIMEUOMUNIT3 T006Time Unit for Quarantine Period
QGRPCIFQGRPCHAR4 TQGRPQuality Inspection Group
SERIALCIFSERIALCHAR4 TSERIALSerial Number Profile
PS_SMARTFORMCIFPSSFNAMECHAR30 STXFADMForm Name
LOGUNITCIFLOGUNITUNIT3 MARMEWM CW: Logistics Unit of Measure
CWQRELCIFCWQRELCHAR1 EWM CW: Material Is a Catch Weight Material
CWQPROCCIFCWQPROCCHAR2 TCWQPROCEWM CW: Catch Weight Profile for Entering CW Quantity
CWQTOLGRCIFCWQTOLGRCHAR9 TCWQTOLGREWM-CW: Catch Weight Tolerance Group for EWM
ADPROFCIFADPROFCHAR3 TAPROFAdjustment Profile
IPMIPPRODUCTCRM_PRODUCT_ID_IPCHAR40 ID for an Intellectual Property (CRM Product)
ALLOW_PMAT_IGNOWPM_ALLOW_PMAT_IGNO_MATCHAR1 Variant Price Allowed (for Material Master)
MEDIUMMEDIUCHAR6 T372MMedium
COMMODITYTBA_STOEFFCHENCHAR18 TBAC_PHYSCOMMPhysical Commodity
ANIMAL_ORIGINWRF_ANIMAL_ORIGIN_FLAGCHAR1 Indicator: Contains Non-Textile Parts of Animal Origin
TEXTILE_COMP_INDWRF_TEXTL_COMP_INDCHAR1 Indicator: New Textile Composition Function
.INCLUDEMARABRAZIL Material Master Data - Brazil
ANPJ_1BANPNUMC9 J_1BTANPANP Code
/BEV1/LULEINH/BEV1/LULEINHNUMC8 Loading Units
/BEV1/LULDEGRP/BEV1/LULDEGRPCHAR3 /BEV1/LUT906Loading Unit Group: IS Beverage
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR1 Structure Category for Material Relationship
/DSD/SL_TOLTYP/DSD/SL_TOLTYP_IDCHAR4 /DSD/SL_TGTYPTolerance Type ID
/DSD/SV_CNT_GRP/DSD/SV_COUNT_GROUPCHAR10 /DSD/SV_CNTGRCounting Group
/DSD/VC_GROUP/DSD/VC_GROUPCHAR6 /DSD/VC_GRPDSD Grouping
/SAPMP/KADU/SAPMP/KADUDEC7(2) Cable Diameter
/SAPMP/ABMEIN/SAPMP/ABMEINUNIT3
*
Unit for Dimensions
/SAPMP/KADP/SAPMP/KADPDEC5(2) Cable Diameter Allowance in Percent
/SAPMP/BRAD/SAPMP/BRADDEC4 Bending Factor
/SAPMP/SPBI/SAPMP/SPBIDEC7(2) Inner Width
/SAPMP/TRAD/SAPMP/TRADDEC7(2) Outer Diameter
/SAPMP/KEDU/SAPMP/KEDUDEC7(2) Core Diameter
/SAPMP/SPTR/SAPMP/SPTRQUAN13(3) Load Capacity
/SAPMP/FBDK/SAPMP/FBDKDEC7(2) Run-Out Flange Thickness
/SAPMP/FBHK/SAPMP/FBHKDEC7(2) R-O Flange Height
/SAPMP/RILI/SAPMP/RILICHAR1 Coil Delivery
/SAPMP/FBAK/SAPMP/FBAKCHAR1 Run-Out Flange
/SAPMP/AHO/SAPMP/AHONUMC3 Maximum Number of Vertical Layers
/SAPMP/MIFRR/SAPMP/MIFRRDEC7(2) Smallest Permissible Reel Clearance for a Cable
/VSO/R_TILT_IND/VSO/M_TILT_INDCHAR1 Material may be Tilted (Vehicle Space Optimization)
/VSO/R_STACK_IND/VSO/M_STACK_INDCHAR1 Stacking not Allowed (VSO)
/VSO/R_BOT_IND/VSO/M_BOTTOM_INDCHAR1 Bottom Layer (Vehicle Space Optimization)
/VSO/R_TOP_IND/VSO/M_TOP_INDCHAR1 Top Layer (VSO)
/VSO/R_STACK_NO/VSO/M_STACK_NONUMC3 Stacking Factor (Vehicle Space Optimization)
/VSO/R_PAL_IND/VSO/M_PALLET_INDCHAR1 Load without Packaging Material (VSO)
/VSO/R_PAL_OVR_D/VSO/R_PAL_OVR_DQUAN13(3) Permissible Overhang (Depth) of Packaging Material (VSO)
/VSO/R_PAL_OVR_W/VSO/R_PAL_OVR_WQUAN13(3) Permissible Overhang (Width) of Shipping Material (VSO)
/VSO/R_PAL_B_HT/VSO/R_PAL_BIN_HGTQUAN13(3) Maximum Stacking Height of the Packaging Material (VSO)
/VSO/R_PAL_MIN_H/VSO/R_PAL_MIN_HTQUAN13(3) Minimum Stacking Height of the Packaging Material (VSO)
/VSO/R_TOL_B_HT/VSO/R_TOL_BIN_HTQUAN13(3) Tolerance to Exceed the Max. Stacking Height (VSO)
/VSO/R_NO_P_GVH/VSO/M_ANZ_PER_GVHNUMC2 Number of Materials for each Closed PKM (VSO)
/VSO/R_QUAN_UNIT/VSO/R_QUAN_UNITUNIT3 Unit of Measure Vehicle Space Optimization
/VSO/R_KZGVH_IND/VSO/M_KZGVH_INDCHAR1 Closed Packaging Material Required (VSO)
.APPENDCCIFS_EHS_MARA_A Append for EHS on EMARA
.INCLUDECCIFS_EHS_MARA EHS-INT: Enhancement Fields MARA
PACKCODECBUNE_PACODECHAR10 CCUNC121Packaging Code
DG_PACK_STATUSADGE_DG_PACK_STATUSCHAR10 TDG101Dangerous Goods Packaging Status
.APPENDDFPS_MARA_APPEND Extension of MARA by New DFPS Fields
.INCLUDEDFPS_MARA_STY Extension of MARA by New DFPS Fields
MCONDDFPS_MCONDCHAR1 Material Condition Management
RETDELCDFPS_RETDELCCHAR1
*
Return Code
LOGLEV_RETODFPS_LOGLEV_RETOCHAR1
*
Return to Logistics Level
NSNIDDFPS_NSNIDCHAR9 NATO Stock Number
.APPENDDIS_IND_1 Discrete Industries 1
OVLPNADSPC_OPNCHAR32 Overlength Part Number
.APPENDDIS_IND_3 Discrete Industries 3
ADSPC_SPCADSPC_SPCNUMC1 Spare Part Class Code
.APPENDDIS_VARID Variable Object Identification
VARIDDI_VARIDRAW16 GUID Variable Object Identification
.APPENDDRMSMATN DRM relevant append to EMARA
MSBOOKPARTNO/SAPHT/DRM_MSBOOKPARTCHAR18
*
Manufacturer Book Part Number
.APPENDMGV_MARA Version Fields in MARA
VTYPEVERSIONTYPECHAR10 MGVTYPEVersion Category
.INCLUDEMGVVALIDITY Effectivity information for versions
VCHNRMGV_VCHNRCHAR12 AENRChange number material versions
EVVALMGV_EVER_VALIDCHAR1 Material is Always Valid
DVERSMGV_MATNR_VALID_DEFAULTCHAR18
*
Default Version
.APPENDMILL_MARA Mill-Specific Fields MARA
DPCBTMILL_DPCBTCHAR1 Single-Unit Batch Def. Value
XGRDTMILL_XGRDTCHAR1 Goods Receipt to Posted Single-Unit Batch Allowed
.APPENDPIC_MARA PIC: Additional Fields for Parts Interchangeability
.INCLUDEPICST003 PIC Additional Fields for Parts Interchangeability
IMATNIMATNCHAR18
*
FFF class
PICNUMPIC_PICNUM_SUSCHAR18 Supersession chain number
.APPENDWRFEMARA Creation Status - Seasonal Procurement
BSTATWRFBSTATCHAR2 WRFMATBSTATCreation Status - Seasonal Procurement
.APPENDWRF_MARA_APPEND MARA Extension with New Fashion Fields: Seasonal Procurement
.INCLUDEWRF_MARA_STY MARA Extension with New Fields: Seasonal Procurement
COLOR_ATINNWRF_COLOR_ATINNNUMC10
*
Internal Charactieristic Number for Color Characteristics
SIZE1_ATINNWRF_SIZE1_ATINNNUMC10
*
Internal Char. Number for Characteristics for Main Sizes
SIZE2_ATINNWRF_SIZE2_ATINNNUMC10
*
Internal Char. Number for Characteristics for Second Sizes
COLORWRF_COLORCHAR18 Characteristic Value for Colors of Variants
SIZE1WRF_SIZE1CHAR18 Characteristic Value for Main Sizes of Variants
SIZE2WRF_SIZE2CHAR18 Characteristic Value for Second Size for Variants
FREE_CHARWRF_FREE_CHARCHAR18 Characteristic Value for Evaluation Purposes
CARE_CODEWRF_CARE_CODECHAR16 Care Codes (such as Washing Code, Ironing Code, etc.)
BRAND_IDWRF_BRAND_IDCHAR4 WRF_BRANDSBrand
FIBER_CODE1WRF_FIBER_CODE_1CHAR3 WRF_FIBER_CODESFiber Code for Textiles (Component 1)
FIBER_PART1WRF_FIBER_PART_1NUMC3 Percentage Share of Fiber (Component 1)
FIBER_CODE2WRF_FIBER_CODE_2CHAR3 WRF_FIBER_CODESFiber Code for Textiles (Component 2)
FIBER_PART2WRF_FIBER_PART_2NUMC3 Percentage Share of Fiber (Component 2)
FIBER_CODE3WRF_FIBER_CODE_3CHAR3 WRF_FIBER_CODESFiber Code for Textiles (Component 3)
FIBER_PART3WRF_FIBER_PART_3NUMC3 Percentage Share of Fiber (Component 3)
FIBER_CODE4WRF_FIBER_CODE_4CHAR3 WRF_FIBER_CODESFiber Code for Textiles (Component 4)
FIBER_PART4WRF_FIBER_PART_4NUMC3 Percentage Share of Fiber (Component 4)
FIBER_CODE5WRF_FIBER_CODE_5CHAR3 WRF_FIBER_CODESFiber Code for Textiles (Component 5)
FIBER_PART5WRF_FIBER_PART_5NUMC3 Percentage Share of Fiber (Component 5)
.APPENDWSSM_EFASHGRD Slowseller Management: Degree of Fashion
FASHGRDFASHGRDCHAR4 T6WFGFashion Grade
COBJIDHROBJIDNUMC8
*
Object ID
COTYPEOTYPECHAR2
*
Object Type
.APPENDOILMARA Is-Oil Append
OIGROUPNAMOIG_PCGCHAR8 TOIGAPTD product group
OITRINDOIH_TRINDCHAR1 Transfer sign for plant-to-plant transfers
OIHMTXGROIH_J1B_MTXGRCHAR4 OIH2M_J1BMaterial tax group


Key field
Non-key field


Relations between MARA and other tables


MARA-General Material Data
      MBEW-Material Valuation
      MARC-Plant Data for Material
            MARD-Material Master: Storage Location/Batch Segment
                  MCHB-Batch Stocks


EBAN-Purchase Requisition
      MARA-General Material Data
      EBKN-Purchase Requisition Account Assignment


MARA-Material Master: General Data
      MBEW-Material Valuation
            MKPF-Header: Material Document
                  MSEG-Document Segment: Material
            BKPF-Accounting Document Header
                  BSEG-Accounting Document Segment


MARA-Material master: General data
      MACKW-Generated Table for View MACKW


EKDY-Dummy Table for Database EBM
      EKKO-Purchasing Document Header
            EKPO-Purchasing Document Item
                  EKET-Scheduling Agreement Schedule Lines
                  MARA-General Material Data
                  EKKN-Account Assignment in Purchasing Document
                  EKBE-History per Purchasing Document
      EBAN-Purchase Requisition
            EBKN-Purchase Requisition Account Assignment


EINA-Purchasing Info Record: General Data
      MARA-General Material Data
      EINE-Purchasing Info Record: Purchasing Org. Data
      EIPA-Order Price History: Info Record


LAGP-Storage bins
      LQUA-Quants
            MARA-Material master: General data
                  MAKT-Material descriptions
                        MARC-Material Master: C Segment
                        MLGN-Material data for each warehouse number


WTY_PNWTYH_DIA-Warranty Claim Header
      WTY_VELO-Vehicle
      QMEL_H-Quality Notification (Header)
      IBIB_H-Installation (Header)
      ILOA_H-Functional Location (Header)
      EQUI_H-Equipment (Header)
      LFA1_H-Vendor (Header)
      KNA1_H-Customer (Header)
      WTY_PNWTYV_DIA-Warranty Claim Version
            LFA1_V-Vendor (Version)
            KNA1_V-Customer (Version)
            WTY_PVWTY_DIA-Warranty Claim Item
                  LFA1_I-Vendor (Item)
                  MARA-Material Data