SAP Tables

Share |

MARA SAP Table - General Material Data

MARA is a standard SAP Table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more 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 add useful hints, tips and screen shots specific to this SAP 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
.INCLUDEEMARA
ERSDAERSDADATS8Created On
ERNAMERNAMCHAR12Created by
LAEDALAEDADATS8Last Change
AENAMAENAMCHAR12Changed by
VPSTAVPSTACHAR15Compl. maint. status
PSTATPSTAT_DCHAR15Maintenance status
LVORMLVOMACHAR1DF at client level
MTARTMTARTCHAR4T134Material Type
MBRSHMBRSHCHAR1T137Industry sector
MATKLMATKLCHAR9T023Material Group
BISMTBISMTCHAR18Old material number
MEINSMEINSUNIT3T006Base Unit of Measure
BSTMEBSTMEUNIT3T006Order Unit
ZEINRDZEINRCHAR22 
ZEIARDZEIARCHAR3 
ZEIVRDZEIVRCHAR2 
ZEIFODZEIFOCHAR4 
AESZNAESZNCHAR6Document change no.
BLATTBLATTCHAR3Page number
BLANZBLANZNUMC3Number of sheets
FERTHFERTHCHAR18Prod./insp. memo
FORMTFORMTCHAR4Page format
GROESGROESCHAR32Size/dimensions
WRKSTWRKSTCHAR48TWSPRBasic material
NORMTNORMTCHAR18Industry Std Desc.
LABORLABORCHAR3T024LLab/Office
EKWSLEKWSLCHAR4T405Purchasing value key
BRGEWBRGEWQUAN13(3)Gross Weight
NTGEWNTGEWQUAN13(3)Net Weight
GEWEIGEWEIUNIT3T006Weight unit
VOLUMVOLUMQUAN13(3)Volume
VOLEHVOLEHUNIT3T006Volume unit
BEHVOBEHVOCHAR2T144Container reqmts
RAUBERAUBECHAR2T142Storage conditions
TEMPBTEMPBCHAR2T143Temp. conditions
DISSTDISSTCHAR3Low-Level Code
TRAGRTRAGRCHAR4TTGRTransportation Group
STOFFSTOFFCHAR18MGEFHaz. material number
SPARTSPARTCHAR2TSPADivision
KUNNRWETTBCHAR10V_KNA1WETTCompetitor
EANNREANNRCHAR13EAN number
WESCHWESCHQUAN13(3)Number of GR slips
BWVORBWVORCHAR1T6WP1Procurement rule
BWSCLBWSCLCHAR1TMBW1Source of supply
SAISOSAISOCHAR4T6WSPSeason
ETIARETIARCHAR2T6WP3Label type
ETIFOETIFOCHAR2T6WP4Label form
ENTARDUMMYENTARCHAR1
*
Field deactivated
EAN11EAN11CHAR18EAN/UPC
NUMTPNUMTPCHAR2TNTPEAN Category
LAENGLAENGQUAN13(3)Length
BREITBREITQUAN13(3)Width
HOEHEHOEHEQUAN13(3)Height
MEABMMEABMUNIT3T006Unit of Dimension
PRDHAPRODH_DCHAR18T179Product hierarchy
AEKLKCK_AEKLKCHAR1Net Change Costing
CADKZCADKZCHAR1CAD Indicator
QMPURQMPURCHAR1QM proc. active
ERGEWERGEWQUAN13(3)Allowed pkg weight
ERGEIERGEIUNIT3T006Unit of weight
ERVOLERVOLQUAN13(3)Allowed pkg volume
ERVOEERVOEUNIT3T006Volume unit
GEWTOGEWTODEC3(1)Excess wt tolerance
VOLTOVOLTODEC3(1)Excess volume tol.
VABMEVABMECHAR1Variable Purchase Order Unit
KZREVKZREVCHAR1Revision Level Assgd
KZKFGKZKFGCHAR1Material is configurable
XCHPFXCHPFCHAR1Batch management
VHARTVHIARTCHAR4TVTYPackaging mat. type
FUELGFUELGDEC3Maximum level
STFAKSTFAKINT25Stackability factor
MAGRVMAGRVCHAR4TVEGRMatl Grp Pack.Matls
BEGRUBEGRUCHAR4Authorization Group
DATABDATABDATS8Valid From
LIQDTLIQDTDATS8Valid to
SAISJSAISJCHAR4Season Year
PLGTPPLGTPCHAR2TWPTPrice Band Category
MLGUTW_MITLEERGCHAR1With empties BOM
EXTWGEXTWGCHAR18TWEWExt. Material Group
SATNRSATNRCHAR18MARACross-plant CM
ATTYPATTYPCHAR2Material Category
KZKUPKZKUPMATCHAR1Co-product
KZNFMKZNFMCHAR1Follow-up material
PMATAPMATNCHAR18MARAPricing Ref. Matl
MSTAEMSTAECHAR2T141X-plant matl status
MSTAVMSTAVCHAR2TVMSX-distr.chain status
MSTDEMSTDEDATS8Valid from
MSTDVMSTDVDATS8Valid from
TAKLVTAKLVCHAR1TSKMTax classification
RBNRMRBNRCHAR9T352BCatalog profile
MHDRZMHDRZDEC4Min. Rem. Shelf Life
MHDHBMHDHBDEC4Total shelf life
MHDLPMHDLPDEC3Storage percentage
INHMEINHMEUNIT3T006Content unit
INHALINHALQUAN13(3)Net contents
VPREHVPREHDEC5ComparisonPriceUnit
ETIAGETIAGCHAR18TWEALabeling matl grpg
INHBRINHBRQUAN13(3)Gross contents
CMETHOIB_CMETHCHAR1Conversion Method
CUOBFCUOBMNUMC18Internal object no.
KZUMWKZUMWCHAR1Environmentally rlvt
KOSCHKOSCHCHAR18T190SProduct allocation
SPROFSPROFCHAR1Pricing profile
NRFHGNRFHGCHAR1Qual.f.FreeGoodsDis.
MFRPNMFRPNCHAR40Manufacturer Part No.
MFRNRMFRNRCHAR10LFA1Manufacturer
BMATNMPMATCHAR18MARAInt. material number
MPROFMPROFCHAR4TMPPFMfr Part Profile
KZWSMKZWSOCHAR1Units of meas. usage
SAITYSAITYCHAR2T6WSARollout
PROFLADGE_PROFLCHAR3TDG41DG indicator profile
IHIVIADGE_IHIVICHAR1Highly viscous
ILOOSADGE_ILOOSCHAR1In bulk/liquid
SERLVSERLVCHAR1Serialization level
KZGVHKZGVHCHAR1Closed
XGCHPXGCHPCHAR1Appr.batch rec. req.
KZEFFCC_MTEFFCHAR1Assign effect. vals
COMPLCSCP_COMP_LVLNUMC2TCSCP_COMP_LVLMaterial completion level
IPRKZDATTPCHAR1Period Ind. for SLED
RDMHDRDMHDCHAR1Rounding rule SLED
PRZUSPRZUSCHAR1Product Composition
MTPOS_MARAMTPOS_MARACHAR4TPTMGen. item cat. grp
BFLMEBFLMECHAR1Logistical variants
MATFIMATFICHAR1Material is locked
CMRELDE_CM_RELEVANCE_FLAGCHAR1Relevant for CM
BBTYPBBTYPCHAR1
*
Assortment List Type
SLED_BBDSLED_BBDCHAR1Expiration Date
GTIN_VARIANTGTIN_VARIANTCHAR2EAN Variant
GENNRWSTR_SATNR_PPCHAR18MARAGeneric Material
RMATPPL_RMATPCHAR18MARAReference matl for packing
GDS_RELEVANTGDS_RELEVANTCHAR1GDS-Relevant
WEORAWEORACHAR1Origin Acceptance
HUTYP_DFLTCIFHUTYPDFCHAR4THUTYPStandard HU Type
PILFERABLECIFPILFRBLCHAR1Pilferable
WHSTCCIFWHSTCCHAR2TWHSTCWH Storage Condition
WHMATGRCIFWHMATGRCHAR4TWHMATGRWH Material Group
HNDLCODECIFHDLCODECHAR4THNDLCDHandling Indicator
HAZMATCIFHAZMATCHAR1Rel. for HS
HUTYPCIFHUTYPCHAR4THUTYPHandling Unit Type
TARE_VARCIFTAREVARCHAR1Varb. Tare Weight
MAXCCIFMAXCDEC15(3)Maximum Capacity
MAXC_TOLCIFMAXCTOLDEC3(1)Overcapacity Toler.
MAXLCIFMAXLQUAN15(3)Max. Pack. Length
MAXBCIFMAXBQUAN15(3)Max. Pack. Width
MAXHCIFMAXHQUAN15(3)Max. Pack. Height
MAXDIM_UOMCIFMAXDUOMUNIT3T006Unit of Measurement
HERKLHERKLCHAR3T005Country of origin
MFRGRMFRGRCHAR8TMFGMaterial freight grp
QQTIMECIFQQTIMEQUAN3Quarant. Per.
QQTIMEUOMCIFQQTIMEUOMUNIT3T006Time Unit
QGRPCIFQGRPCHAR4TQGRPQuality Inspec. Grp
SERIALCIFSERIALCHAR4TSERIALSerial No. Profile
PS_SMARTFORMCIFPSSFNAMECHAR30STXFADMForm Name
LOGUNITCIFLOGUNITUNIT3MARMLogistics Unit of Measure
CWQRELCIFCWQRELCHAR1Catch-Weight-Relevant
CWQPROCCIFCWQPROCCHAR2TCWQPROCCW Profile for CW Qty
CWQTOLGRCIFCWQTOLGRCHAR9TCWQTOLGRCW Tolerance Group
ADPROFCIFADPROFCHAR3TAPROFAdjustment Profile
IPMIPPRODUCTCRM_PRODUCT_ID_IPCHAR40Intellectual Property
ALLOW_PMAT_IGNOWPM_ALLOW_PMAT_IGNO_MATCHAR1Variant Price Allowed
MEDIUMMEDIUCHAR6T372MMedium
COMMODITYTBA_STOEFFCHENCHAR18TBAC_PHYSCOMMPhysical Commodity
ANIMAL_ORIGINWRF_ANIMAL_ORIGIN_FLAGCHAR1Cont. Non-Textile Parts of Animal Origin
TEXTILE_COMP_INDWRF_TEXTL_COMP_INDCHAR1Textile Composition Maintenance Active
.INCLUDESGT_MARA_STY
SGT_CSGRSGT_CSGRCHAR4SGT_CSGR_TSegmentation Structure
SGT_COVSASGT_COVSACHAR8SGT_COVS_TSegmentation Strategy
SGT_STATSGT_STATDCHAR1Segmentation Status
SGT_SCOPESGT_SCOPECHAR1Segmentation Strategy Scope
SGT_RELSGT_RELCHAR1Segmentation Relevant
.INCLUDEMARABRAZIL
ANPJ_1BANPNUMC9J_1BTANPANP Code
.INCLUDEFSH_MARA_STY
FSH_MG_AT1FSH_MG_ATTRIBUTE1CHAR10
*
Fashion Attribute 1
FSH_MG_AT2FSH_MG_ATTRIBUTE2CHAR10
*
Fashion Attribute 2
FSH_MG_AT3FSH_MG_ATTRIBUTE3CHAR6
*
Fashion Attribute 3
FSH_SEALVFSH_SEALVCHAR1Season Usage
FSH_SEAIMFSH_SEAIMCHAR1Season Active in Inventory Management
FSH_SC_MIDFSH_SC_MIDCHAR2FSH_SC_VCIDSMaterial Conv. ID
/BEV1/LULEINH/BEV1/LULEINHNUMC8Loading Units
/BEV1/LULDEGRP/BEV1/LULDEGRPCHAR3/BEV1/LUT906Loading Unit Group
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR1Structure Category
/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
/VSO/R_TILT_IND/VSO/M_TILT_INDCHAR1Tilting Allowed
/VSO/R_STACK_IND/VSO/M_STACK_INDCHAR1No Stacking
/VSO/R_BOT_IND/VSO/M_BOTTOM_INDCHAR1Only Bottom Layer
/VSO/R_TOP_IND/VSO/M_TOP_INDCHAR1Only Top Layer
/VSO/R_STACK_NO/VSO/M_STACK_NONUMC3Stacking Factor
/VSO/R_PAL_IND/VSO/M_PALLET_INDCHAR1Load without PKM
/VSO/R_PAL_OVR_D/VSO/R_PAL_OVR_DQUAN13(3)PKM Overhang Depth
/VSO/R_PAL_OVR_W/VSO/R_PAL_OVR_WQUAN13(3)PKM Overhang Width
/VSO/R_PAL_B_HT/VSO/R_PAL_BIN_HGTQUAN13(3)Max. Stacking Height
/VSO/R_PAL_MIN_H/VSO/R_PAL_MIN_HTQUAN13(3)Min. Stacking Height
/VSO/R_TOL_B_HT/VSO/R_TOL_BIN_HTQUAN13(3)Max.StackH Tolerance
/VSO/R_NO_P_GVH/VSO/M_ANZ_PER_GVHNUMC2No. Mat / Closed PKM
/VSO/R_QUAN_UNIT/VSO/R_QUAN_UNITUNIT3VSO Unit of Measure
/VSO/R_KZGVH_IND/VSO/M_KZGVH_INDCHAR1Closed PKM Required
.APPENDCCIFS_EHS_MARA_A
.INCLUDECCIFS_EHS_MARA
PACKCODECBUNE_PACODECHAR10CCUNC121Packaging Code
DG_PACK_STATUSADGE_DG_PACK_STATUSCHAR10TDG101DG Packaging Status
.APPENDDFPS_MARA_APPEND
.INCLUDEDFPS_MARA_STY
MCONDDFPS_MCONDCHAR1Material Condition Mgmt
RETDELCDFPS_RETDELCCHAR1
*
Return Code
LOGLEV_RETODFPS_LOGLEV_RETOCHAR1
*
Return to Logistics Level
NSNIDDFPS_NSNIDCHAR9NATO Item ID Number
.APPENDPIC_MARA
.INCLUDEPICST003
IMATNIMATNCHAR18
*
Form-Fit-Function class
PICNUMPIC_PICNUM_SUSCHAR18Supersession chain number
.APPENDWRFEMARA
BSTATWRFBSTATCHAR2WRFMATBSTATCreation Status
.APPENDWRF_MARA_APPEND
.INCLUDEWRF_MARA_STY
COLOR_ATINNWRF_COLOR_ATINNNUMC10
*
Int. Char. Number
SIZE1_ATINNWRF_SIZE1_ATINNNUMC10
*
Int. Char. Number
SIZE2_ATINNWRF_SIZE2_ATINNNUMC10
*
Int. Char. Number
COLORWRF_COLORCHAR18Color
SIZE1WRF_SIZE1CHAR18Main Size
SIZE2WRF_SIZE2CHAR18Second Size
FREE_CHARWRF_FREE_CHARCHAR18Free Charact. Value
CARE_CODEWRF_CARE_CODECHAR16Care Code
BRAND_IDWRF_BRAND_IDCHAR4WRF_BRANDSBrand
FIBER_CODE1WRF_FIBER_CODE_1CHAR3WRF_FIBER_CODESComponent 1
FIBER_PART1WRF_FIBER_PART_1NUMC3Percentage Share 1
FIBER_CODE2WRF_FIBER_CODE_2CHAR3WRF_FIBER_CODESComponent 2
FIBER_PART2WRF_FIBER_PART_2NUMC3Percentage Share 2
FIBER_CODE3WRF_FIBER_CODE_3CHAR3WRF_FIBER_CODESComponent 3
FIBER_PART3WRF_FIBER_PART_3NUMC3Percentage Share 3
FIBER_CODE4WRF_FIBER_CODE_4CHAR3WRF_FIBER_CODESComponent 4
FIBER_PART4WRF_FIBER_PART_4NUMC3Percentage Share 4
FIBER_CODE5WRF_FIBER_CODE_5CHAR3WRF_FIBER_CODESComponent 5
FIBER_PART5WRF_FIBER_PART_5NUMC3Percentage Share 5
.APPENDWSSM_EFASHGRD
FASHGRDFASHGRDCHAR4T6WFGFashion Grade







comments powered by Disqus