SAP Tables

Share |

MARA SAP Table - General Material Data


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 also view this information if you enter the Table name MARA into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16

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

Text table = MAKT

Contribute(Add Comments)
Within the comments section below there is also an opportunity for you to ask a question or add useful hints, tips and screen shots specific to this SAP table dictionary object. This means that you and other users will be able to find these details quickly by simply searching on the object name MARA or its description.


Dictionary fields for SAP Table MARA
FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
MATNRMATNRCHAR18Material Number
.INCLUDEEMARAData Division MARA
ERSDAERSDADATS8Created On
ERNAMERNAMCHAR12Name of Person who Created the Object
LAEDALAEDADATS8Date of Last Change
AENAMAENAMCHAR12Name of Person Who Changed Object
VPSTAVPSTACHAR15Maintenance status of complete material
PSTATPSTAT_DCHAR15Maintenance status
LVORMLVOMACHAR1Flag Material for Deletion at Client Level
MTARTMTARTCHAR4T134Material Type
MBRSHMBRSHCHAR1T137Industry sector
MATKLMATKLCHAR9T023Material Group
BISMTBISMTCHAR18Old material number
MEINSMEINSUNIT3T006Base Unit of Measure
BSTMEBSTMEUNIT3T006Purchase Order Unit of Measure
ZEINRDZEINRCHAR22Document number (without document management system)
ZEIARDZEIARCHAR3Document type (without Document Management system)
ZEIVRDZEIVRCHAR2Document version (without Document Management system)
ZEIFODZEIFOCHAR4Page format of document (without Document Management system)
AESZNAESZNCHAR6Document change number (without document management system)
BLATTBLATTCHAR3Page number of document (without Document Management system)
BLANZBLANZNUMC3Number of sheets (without Document Management system)
FERTHFERTHCHAR18Production/inspection memo
FORMTFORMTCHAR4Page Format of Production Memo
GROESGROESCHAR32Size/dimensions
WRKSTWRKSTCHAR48TWSPRBasic Material
NORMTNORMTCHAR18Industry Standard Description (such as ANSI or ISO)
LABORLABORCHAR3T024LLaboratory/design office
EKWSLEKWSLCHAR4T405Purchasing Value Key
BRGEWBRGEWQUAN13(3)Gross Weight
NTGEWNTGEWQUAN13(3)Net Weight
GEWEIGEWEIUNIT3T006Weight Unit
VOLUMVOLUMQUAN13(3)Volume
VOLEHVOLEHUNIT3T006Volume unit
BEHVOBEHVOCHAR2T144Container requirements
RAUBERAUBECHAR2T142Storage conditions
TEMPBTEMPBCHAR2T143Temperature conditions indicator
DISSTDISSTCHAR3Low-Level Code
TRAGRTRAGRCHAR4TTGRTransportation Group
STOFFSTOFFCHAR18MGEFHazardous material number
SPARTSPARTCHAR2TSPADivision
KUNNRWETTBCHAR10V_KNA1WETTCompetitor
EANNREANNRCHAR13European Article Number (EAN) - obsolete!!!!!
WESCHWESCHQUAN13(3)Quantity: Number of GR/GI slips to be printed
BWVORBWVORCHAR1T6WP1Procurement rule
BWSCLBWSCLCHAR1TMBW1Source of Supply
SAISOSAISOCHAR4T6WSPSeason Category
ETIARETIARCHAR2T6WP3Label type
ETIFOETIFOCHAR2T6WP4Label form
ENTARDUMMYENTARCHAR1
*
Deactivated
EAN11EAN11CHAR18International Article Number (EAN/UPC)
NUMTPNUMTPCHAR2TNTPCategory of International Article Number (EAN)
LAENGLAENGQUAN13(3)Length
BREITBREITQUAN13(3)Width
HOEHEHOEHEQUAN13(3)Height
MEABMMEABMUNIT3T006Unit of Dimension for Length/Width/Height
PRDHAPRODH_DCHAR18T179Product hierarchy
AEKLKCK_AEKLKCHAR1Stock Transfer Net Change Costing
CADKZCADKZCHAR1CAD Indicator
QMPURQMPURCHAR1QM in Procurement is Active
ERGEWERGEWQUAN13(3)Allowed packaging weight
ERGEIERGEIUNIT3T006Unit of weight (allowed packaging weight)
ERVOLERVOLQUAN13(3)Allowed packaging volume
ERVOEERVOEUNIT3T006Volume unit (allowed packaging volume)
GEWTOGEWTODEC3(1)Excess Weight Tolerance for Handling unit
VOLTOVOLTODEC3(1)Excess Volume Tolerance of the Handling Unit
VABMEVABMECHAR1Variable Purchase Order Unit Active
KZREVKZREVCHAR1Revision Level Has Been Assigned to the Material
KZKFGKZKFGCHAR1Configurable Material
XCHPFXCHPFCHAR1Batch management requirement indicator
VHARTVHIARTCHAR4TVTYPackaging Material Type
FUELGFUELGDEC3Maximum level (by volume)
STFAKSTFAKINT25Stacking factor
MAGRVMAGRVCHAR4TVEGRMaterial Group: Packaging Materials
BEGRUBEGRUCHAR4Authorization Group
DATABDATABDATS8Valid-From Date
LIQDTLIQDTDATS8Deletion date
SAISJSAISJCHAR4Season Year
PLGTPPLGTPCHAR2TWPTPrice Band Category
MLGUTW_MITLEERGCHAR1Empties Bill of Material
EXTWGEXTWGCHAR18TWEWExternal Material Group
SATNRSATNRCHAR18MARACross-Plant Configurable Material
ATTYPATTYPCHAR2Material Category
KZKUPKZKUPMATCHAR1Indicator: Material can be co-product
KZNFMKZNFMCHAR1Indicator: The material has a follow-up material
PMATAPMATNCHAR18MARAPricing Reference Material
MSTAEMSTAECHAR2T141Cross-Plant Material Status
MSTAVMSTAVCHAR2TVMSCross-distribution-chain material status
MSTDEMSTDEDATS8Date from which the cross-plant material status is valid
MSTDVMSTDVDATS8Date from which the X-distr.-chain material status is valid
TAKLVTAKLVCHAR1TSKMTax classification of the material
RBNRMRBNRCHAR9T352BCatalog Profile
MHDRZMHDRZDEC4Minimum Remaining Shelf Life
MHDHBMHDHBDEC4Total shelf life
MHDLPMHDLPDEC3Storage percentage
INHMEINHMEUNIT3T006Content unit
INHALINHALQUAN13(3)Net contents
VPREHVPREHDEC5Comparison price unit
ETIAGETIAGCHAR18TWEAIS-R Labeling: material grouping (deactivated in 4.0)
INHBRINHBRQUAN13(3)Gross contents
CMETHOIB_CMETHCHAR1Quantity Conversion Method
CUOBFCUOBMNUMC18Internal object number
KZUMWKZUMWCHAR1Environmentally Relevant
KOSCHKOSCHCHAR18T190SProduct allocation determination procedure
SPROFSPROFCHAR1Pricing profile for variants
NRFHGNRFHGCHAR1Material qualifies for discount in kind
MFRPNMFRPNCHAR40Manufacturer Part Number
MFRNRMFRNRCHAR10LFA1Number of a Manufacturer
BMATNMPMATCHAR18MARANumber of firm's own (internal) inventory-managed material
MPROFMPROFCHAR4TMPPFManufacturer Part Profile
KZWSMKZWSOCHAR1Units of measure usage
SAITYSAITYCHAR2T6WSARollout in a Season
PROFLADGE_PROFLCHAR3TDG41Dangerous Goods Indicator Profile
IHIVIADGE_IHIVICHAR1Indicator: Highly Viscous
ILOOSADGE_ILOOSCHAR1Indicator: In Bulk/Liquid
SERLVSERLVCHAR1Level of Explicitness for Serial Number
KZGVHKZGVHCHAR1Packaging Material is Closed Packaging
XGCHPXGCHPCHAR1Indicator: Approved batch record required
KZEFFCC_MTEFFCHAR1Assign effectivity parameter values/ override change numbers
COMPLCSCP_COMP_LVLNUMC2TCSCP_COMP_LVLMaterial completion level
IPRKZDATTPCHAR1Period Indicator for Shelf Life Expiration Date
RDMHDRDMHDCHAR1Rounding rule for calculation of SLED
PRZUSPRZUSCHAR1Indicator: Product composition printed on packaging
MTPOS_MARAMTPOS_MARACHAR4TPTMGeneral item category group
BFLMEBFLMECHAR1Generic Material with Logistical Variants
MATFIMATFICHAR1Material Is Locked
CMRELDE_CM_RELEVANCE_FLAGCHAR1Relevant for Configuration Management
BBTYPBBTYPCHAR1
*
Assortment List Type
SLED_BBDSLED_BBDCHAR1Expiration Date
GTIN_VARIANTGTIN_VARIANTCHAR2Global Trade Item Number Variant
GENNRWSTR_SATNR_PPCHAR18MARAMaterial Number of the Generic Material in Prepack Materials
RMATPPL_RMATPCHAR18MARAReference material for materials packed in same way
GDS_RELEVANTGDS_RELEVANTCHAR1Indicator: Global Data Synchronization-Relevant
WEORAWEORACHAR1Acceptance At Origin
HUTYP_DFLTCIFHUTYPDFCHAR4THUTYPStandard HU Type
PILFERABLECIFPILFRBLCHAR1Pilferable
WHSTCCIFWHSTCCHAR2TWHSTCWarehouse Storage Condition
WHMATGRCIFWHMATGRCHAR4TWHMATGRWarehouse Material Group
HNDLCODECIFHDLCODECHAR4THNDLCDHandling Indicator
HAZMATCIFHAZMATCHAR1Relevant for Hazardous Substances
HUTYPCIFHUTYPCHAR4THUTYPHandling Unit Type
TARE_VARCIFTAREVARCHAR1Variable 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_UOMCIFMAXDUOMUNIT3T006Unit of Measure for Maximum Packing Length/Width/Height
HERKLHERKLCHAR3T005Country of origin of the material
MFRGRMFRGRCHAR8TMFGMaterial freight group
QQTIMECIFQQTIMEQUAN3Quarantine Period
QQTIMEUOMCIFQQTIMEUOMUNIT3T006Time Unit for Quarantine Period
QGRPCIFQGRPCHAR4TQGRPQuality Inspection Group
SERIALCIFSERIALCHAR4TSERIALSerial Number Profile
PS_SMARTFORMCIFPSSFNAMECHAR30STXFADMForm Name
LOGUNITCIFLOGUNITUNIT3MARMEWM CW: Logistics Unit of Measure
CWQRELCIFCWQRELCHAR1EWM CW: Material Is a Catch Weight Material
CWQPROCCIFCWQPROCCHAR2TCWQPROCEWM CW: Catch Weight Profile for Entering CW Quantity
CWQTOLGRCIFCWQTOLGRCHAR9TCWQTOLGREWM-CW: Catch Weight Tolerance Group for EWM
ADPROFCIFADPROFCHAR3TAPROFAdjustment Profile
IPMIPPRODUCTCRM_PRODUCT_ID_IPCHAR40ID for an Intellectual Property (CRM Product)
ALLOW_PMAT_IGNOWPM_ALLOW_PMAT_IGNO_MATCHAR1Variant Price Allowed (for Material Master)
MEDIUMMEDIUCHAR6T372MMedium
COMMODITYTBA_STOEFFCHENCHAR18TBAC_PHYSCOMMPhysical Commodity
ANIMAL_ORIGINWRF_ANIMAL_ORIGIN_FLAGCHAR1Indicator: Contains Non-Textile Parts of Animal Origin
TEXTILE_COMP_INDWRF_TEXTL_COMP_INDCHAR1Indicator: New Textile Composition Function
.INCLUDESGT_MARA_STYMARA Extension with New Fields: Segmentation
SGT_CSGRSGT_CSGRCHAR4SGT_CSGR_TSegmentation Structure
SGT_COVSASGT_COVSACHAR8SGT_COVS_TSegmentation Strategy
SGT_STATSGT_STATDCHAR1Segmentation Material Master Status
SGT_SCOPESGT_SCOPECHAR1Segmentation Strategy Scope
SGT_RELSGT_RELCHAR1Segmentation Relevant
.INCLUDEMARABRAZILMaterial Master Data - Brazil
ANPJ_1BANPNUMC9J_1BTANPANP Code
.INCLUDEFSH_MARA_STYMARA Extension with New Fields: Fashion
FSH_MG_AT1FSH_MG_ATTRIBUTE1CHAR10
*
Fashion Information Field: 1
FSH_MG_AT2FSH_MG_ATTRIBUTE2CHAR10
*
Fashion Information Field: 2
FSH_MG_AT3FSH_MG_ATTRIBUTE3CHAR6
*
Fashion Information Field: 3
FSH_SEALVFSH_SEALVCHAR1Indicator: Use of Season
FSH_SEAIMFSH_SEAIMCHAR1Indicator: Season Active in Inventory Management
FSH_SC_MIDFSH_SC_MIDCHAR2FSH_SC_VCIDSMaterial Conversion ID for Characteristic Value Conversion
.APPEND/BEV1/LUEMARA_AEnhancement for EMARA Loading Units
.INCLUDE/BEV1/LUTRANSPInclude Basic Structure (2Field) for Appends
/BEV1/LULEINH/BEV1/LULEINHNUMC8Loading Units
/BEV1/LULDEGRP/BEV1/LULDEGRPCHAR3/BEV1/LUT906Loading Unit Group: IS Beverage
.APPEND/BEV1/NEEMARA_AEmpties Management: Enhancement of EMARA
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR1Structure Category for Material Relationship
.APPEND/DSD/SL_EMARA_ADSD Append for Tolerance Types
.INCLUDE/DSD/SL_MARA_TG_IDSD Strucure for Tolerance Types
/DSD/SL_TOLTYP/DSD/SL_TOLTYP_IDCHAR4/DSD/SL_TGTYPTolerance Type ID
.APPEND/DSD/SV_EMARA_ADSD append for Counting Group
.INCLUDE/DSD/SV_MARA_IDSD structure for Counting Group
/DSD/SV_CNT_GRP/DSD/SV_COUNT_GROUPCHAR10/DSD/SV_CNTGRCounting Group
.APPEND/DSD/VC_EMARA_AExtension of Material Master for Visit Control (DSD)
.INCLUDE/DSD/VC_MARA_IExtension of Material Master for Visit Control (DSD)
/DSD/VC_GROUP/DSD/VC_GROUPCHAR6/DSD/VC_GRPDSD Grouping
.APPEND/VSO/R_EMARA_AEMARA Append for Vehicle Space Optimization
.INCLUDE/VSO/R_MARA_IInclude for Append to MARA for Vehicle Space Optimization
/VSO/R_TILT_IND/VSO/M_TILT_INDCHAR1Material may be Tilted (Vehicle Space Optimization)
/VSO/R_STACK_IND/VSO/M_STACK_INDCHAR1Stacking not Allowed (VSO)
/VSO/R_BOT_IND/VSO/M_BOTTOM_INDCHAR1Bottom Layer (Vehicle Space Optimization)
/VSO/R_TOP_IND/VSO/M_TOP_INDCHAR1Top Layer (VSO)
/VSO/R_STACK_NO/VSO/M_STACK_NONUMC3Stacking Factor (Vehicle Space Optimization)
/VSO/R_PAL_IND/VSO/M_PALLET_INDCHAR1Load 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_GVHNUMC2Number of Materials for each Closed PKM (VSO)
/VSO/R_QUAN_UNIT/VSO/R_QUAN_UNITUNIT3Unit of Measure Vehicle Space Optimization
/VSO/R_KZGVH_IND/VSO/M_KZGVH_INDCHAR1Closed Packaging Material Required (VSO)
.APPENDCCIFS_EHS_MARA_AAppend for EHS on EMARA
.INCLUDECCIFS_EHS_MARAEHS-INT: Enhancement Fields MARA
PACKCODECBUNE_PACODECHAR10CCUNC121Packaging Code
DG_PACK_STATUSADGE_DG_PACK_STATUSCHAR10TDG101Dangerous Goods Packaging Status
.APPENDDFPS_MARA_APPENDExtension of MARA by New DFPS Fields
.INCLUDEDFPS_MARA_STYExtension of MARA by New DFPS Fields
MCONDDFPS_MCONDCHAR1Material Condition Management
RETDELCDFPS_RETDELCCHAR1
*
Return Code
LOGLEV_RETODFPS_LOGLEV_RETOCHAR1
*
Return to Logistics Level
NSNIDDFPS_NSNIDCHAR9NATO Item Identification Number
.APPENDPIC_MARAPIC: Additional Fields for Parts Interchangeability
.INCLUDEPICST003PIC Additional Fields for Parts Interchangeability
IMATNIMATNCHAR18
*
FFF class
PICNUMPIC_PICNUM_SUSCHAR18Supersession chain number
.APPENDWRFEMARACreation Status - Seasonal Procurement
BSTATWRFBSTATCHAR2WRFMATBSTATCreation Status - Seasonal Procurement
.APPENDWRF_MARA_APPENDMARA Extension with New Fashion Fields: Seasonal Procurement
.INCLUDEWRF_MARA_STYMARA 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_COLORCHAR18Characteristic Value for Colors of Variants
SIZE1WRF_SIZE1CHAR18Characteristic Value for Main Sizes of Variants
SIZE2WRF_SIZE2CHAR18Characteristic Value for Second Size for Variants
FREE_CHARWRF_FREE_CHARCHAR18Characteristic Value for Evaluation Purposes
CARE_CODEWRF_CARE_CODECHAR16Care Codes (such as Washing Code, Ironing Code, etc.)
BRAND_IDWRF_BRAND_IDCHAR4WRF_BRANDSBrand
FIBER_CODE1WRF_FIBER_CODE_1CHAR3WRF_FIBER_CODESFiber Code for Textiles (Component 1)
FIBER_PART1WRF_FIBER_PART_1NUMC3Percentage Share of Fiber (Component 1)
FIBER_CODE2WRF_FIBER_CODE_2CHAR3WRF_FIBER_CODESFiber Code for Textiles (Component 2)
FIBER_PART2WRF_FIBER_PART_2NUMC3Percentage Share of Fiber (Component 2)
FIBER_CODE3WRF_FIBER_CODE_3CHAR3WRF_FIBER_CODESFiber Code for Textiles (Component 3)
FIBER_PART3WRF_FIBER_PART_3NUMC3Percentage Share of Fiber (Component 3)
FIBER_CODE4WRF_FIBER_CODE_4CHAR3WRF_FIBER_CODESFiber Code for Textiles (Component 4)
FIBER_PART4WRF_FIBER_PART_4NUMC3Percentage Share of Fiber (Component 4)
FIBER_CODE5WRF_FIBER_CODE_5CHAR3WRF_FIBER_CODESFiber Code for Textiles (Component 5)
FIBER_PART5WRF_FIBER_PART_5NUMC3Percentage Share of Fiber (Component 5)
.APPENDWSSM_EFASHGRDSlowseller Management: Degree of Fashion
FASHGRDFASHGRDCHAR4T6WFGFashion Grade


Key field
Non-key field




comments powered by Disqus