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

Within the comments section below there is also an opportunity for you to add useful hints, tips and information 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 TypelengthChecktableDescription
MANDTMANDTCLNT000003T000Client
MATNRMATNRCHAR000018Material
ERSDAERSDADATS000008Created On
ERNAMERNAMCHAR000012Created by
LAEDALAEDADATS000008Last Change
AENAMAENAMCHAR000012Changed by
VPSTAVPSTACHAR000015Compl. maint. status
PSTATPSTAT_DCHAR000015Maintenance status
LVORMLVOMACHAR000001DF at client level
MTARTMTARTCHAR000004T134Material Type
MBRSHMBRSHCHAR000001T137Industry sector
MATKLMATKLCHAR000009T023Material Group
BISMTBISMTCHAR000018Old material number
MEINSMEINSUNIT000003T006Base Unit of Measure
BSTMEBSTMEUNIT000003T006Order Unit
ZEINRDZEINRCHAR000022
ZEIARDZEIARCHAR000003
ZEIVRDZEIVRCHAR000002
ZEIFODZEIFOCHAR000004
AESZNAESZNCHAR000006Document change no.
BLATTBLATTCHAR000003Page number
BLANZBLANZNUMC000003Number of sheets
FERTHFERTHCHAR000018Prod./insp. memo
FORMTFORMTCHAR000004Page format
GROESGROESCHAR000032Size/dimensions
WRKSTWRKSTCHAR000048TWSPRBasic material
NORMTNORMTCHAR000018Industry Std Desc.
LABORLABORCHAR000003T024LLab/Office
EKWSLEKWSLCHAR000004T405Purchasing value key
BRGEWBRGEWQUAN000013Gross Weight
NTGEWNTGEWQUAN000013Net Weight
GEWEIGEWEIUNIT000003T006Weight unit
VOLUMVOLUMQUAN000013Volume
VOLEHVOLEHUNIT000003T006Volume unit
BEHVOBEHVOCHAR000002T144Container reqmts
RAUBERAUBECHAR000002T142Storage conditions
TEMPBTEMPBCHAR000002T143Temp. conditions
DISSTDISSTCHAR000003Low-Level Code
TRAGRTRAGRCHAR000004TTGRTransportation Group
STOFFSTOFFCHAR000018MGEFHaz. material number
SPARTSPARTCHAR000002TSPADivision
KUNNRWETTBCHAR000010V_KNA1WETTCompetitor
EANNREANNRCHAR000013EAN number
WESCHWESCHQUAN000013Number of GR slips
BWVORBWVORCHAR000001T6WP1Procurement rule
BWSCLBWSCLCHAR000001TMBW1Source of supply
SAISOSAISOCHAR000004T6WSPSeason
ETIARETIARCHAR000002T6WP3Label type
ETIFOETIFOCHAR000002T6WP4Label form
ENTARDUMMYENTARCHAR000001*Field deactivated
EAN11EAN11CHAR000018EAN/UPC
NUMTPNUMTPCHAR000002TNTPEAN Category
LAENGLAENGQUAN000013Length
BREITBREITQUAN000013Width
HOEHEHOEHEQUAN000013Height
MEABMMEABMUNIT000003T006Unit of Dimension
PRDHAPRODH_DCHAR000018T179Product hierarchy
AEKLKCK_AEKLKCHAR000001Net Change Costing
CADKZCADKZCHAR000001CAD Indicator
QMPURQMPURCHAR000001QM proc. active
ERGEWERGEWQUAN000013Allowed pkg weight
ERGEIERGEIUNIT000003T006Unit of weight
ERVOLERVOLQUAN000013Allowed pkg volume
ERVOEERVOEUNIT000003T006Volume unit
GEWTOGEWTODEC000003Excess wt tolerance
VOLTOVOLTODEC000003Excess volume tol.
VABMEVABMECHAR000001Variable Purchase Order Unit
KZREVKZREVCHAR000001Revision Level Assgd
KZKFGKZKFGCHAR000001Material is configurable
XCHPFXCHPFCHAR000001Batch management
VHARTVHIARTCHAR000004TVTYPackaging mat. type
FUELGFUELGDEC000003Maximum level
STFAKSTFAKINT2000005Stackability factor
MAGRVMAGRVCHAR000004TVEGRMatl Grp Pack.Matls
BEGRUBEGRUCHAR000004Authorization Group
DATABDATABDATS000008Valid From
LIQDTLIQDTDATS000008Valid to
SAISJSAISJCHAR000004Season Year
PLGTPPLGTPCHAR000002TWPTPrice Band Category
MLGUTW_MITLEERGCHAR000001With empties BOM
EXTWGEXTWGCHAR000018TWEWExt. Material Group
SATNRSATNRCHAR000018MARACross-plant CM
ATTYPATTYPCHAR000002Material Category
KZKUPKZKUPMATCHAR000001Co-product
KZNFMKZNFMCHAR000001Follow-up material
PMATAPMATNCHAR000018MARAPricing Ref. Matl
MSTAEMSTAECHAR000002T141X-plant matl status
MSTAVMSTAVCHAR000002TVMSX-distr.chain status
MSTDEMSTDEDATS000008Valid from
MSTDVMSTDVDATS000008Valid from
TAKLVTAKLVCHAR000001TSKMTax classification
RBNRMRBNRCHAR000009T352BCatalog profile
MHDRZMHDRZDEC000004Min. Rem. Shelf Life
MHDHBMHDHBDEC000004Total shelf life
MHDLPMHDLPDEC000003Storage percentage
INHMEINHMEUNIT000003T006Content unit
INHALINHALQUAN000013Net contents
VPREHVPREHDEC000005ComparisonPriceUnit
ETIAGETIAGCHAR000018TWEALabeling matl grpg
INHBRINHBRQUAN000013Gross contents
CMETHOIB_CMETHCHAR000001Conversion Method
CUOBFCUOBMNUMC000018Internal object no.
KZUMWKZUMWCHAR000001Environmentally rlvt
KOSCHKOSCHCHAR000018T190SProduct allocation
SPROFSPROFCHAR000001Pricing profile
NRFHGNRFHGCHAR000001Qual.f.FreeGoodsDis.
MFRPNMFRPNCHAR000040Manufacturer Part No.
MFRNRMFRNRCHAR000010LFA1Manufacturer
BMATNMPMATCHAR000018MARAInt. material number
MPROFMPROFCHAR000004TMPPFMfr Part Profile
KZWSMKZWSOCHAR000001Units of meas. usage
SAITYSAITYCHAR000002T6WSARollout
PROFLADGE_PROFLCHAR000003TDG41DG indicator profile
IHIVIADGE_IHIVICHAR000001Highly viscous
ILOOSADGE_ILOOSCHAR000001In bulk/liquid
SERLVSERLVCHAR000001Serialization level
KZGVHKZGVHCHAR000001Closed
XGCHPXGCHPCHAR000001Appr.batch rec. req.
KZEFFCC_MTEFFCHAR000001Assign effect. vals
COMPLCSCP_COMP_LVLNUMC000002TCSCP_COMP_LVLMaterial completion level
IPRKZDATTPCHAR000001Period Ind. for SLED
RDMHDRDMHDCHAR000001Rounding rule SLED
PRZUSPRZUSCHAR000001Product Composition
MTPOS_MARAMTPOS_MARACHAR000004TPTMGen. item cat. grp
BFLMEBFLMECHAR000001Logistical variants
MATFIMATFICHAR000001Material is locked
CMRELDE_CM_RELEVANCE_FLAGCHAR000001Relevant for CM
BBTYPBBTYPCHAR000001*Assortment List Type
SLED_BBDSLED_BBDCHAR000001Expiration Date
GTIN_VARIANTGTIN_VARIANTCHAR000002EAN Variant
GENNRWSTR_SATNR_PPCHAR000018MARAGeneric Material
RMATPPL_RMATPCHAR000018MARAReference matl for packing
GDS_RELEVANTGDS_RELEVANTCHAR000001GDS-Relevant
WEORAWEORACHAR000001Origin Acceptance
HUTYP_DFLTCIFHUTYPDFCHAR000004THUTYPStandard HU Type
HUTYPCIFHUTYPCHAR000004THUTYPHandling Unit Type
MAXDIM_UOMCIFMAXDUOMUNIT000003T006Unit of Measurement
PILFERABLECIFPILFRBLCHAR000001Pilferable
HNDLCODECIFHDLCODECHAR000004THNDLCDHandling Indicator
HAZMATCIFHAZMATCHAR000001Rel. for HS
MAXCCIFMAXCDEC000015Maximum Capacity
MAXC_TOLCIFMAXCTOLDEC000003Overcapacity Toler.
MAXLCIFMAXLQUAN000015Max. Pack. Length
MAXBCIFMAXBQUAN000015Max. Pack. Width
MAXHCIFMAXHQUAN000015Max. Pack. Height
HERKLHERKLCHAR000003T005Country of origin
MFRGRMFRGRCHAR000008TMFGMaterial freight grp
QGRPCIFQGRPCHAR000004TQGRPQuality Inspec. Grp
WHSTCCIFWHSTCCHAR000002TWHSTCWH Storage Condition
WHMATGRCIFWHMATGRCHAR000004TWHMATGRWH Material Group
TARE_VARCIFTAREVARCHAR000001Varb. Tare Weight
QQTIMECIFQQTIMEQUAN000003Quarant. Per.
QQTIMEUOMCIFQQTIMEUOMUNIT000003T006Time Unit
PS_SMARTFORMCIFPSSFNAMECHAR000030STXFADMForm Name
LOGUNITCIFLOGUNITUNIT000003MARMLogistics Unit of Measure
ALLOW_PMAT_IGNOWPM_ALLOW_PMAT_IGNO_MATCHAR000001Variant Price Allowed
/BEV1/LULEINH/BEV1/LULEINHNUMC000008Loading Units
/BEV1/LULDEGRP/BEV1/LULDEGRPCHAR000003/BEV1/LUT906Loading Unit Group
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR000001Structure Category
/DSD/VC_GROUP/DSD/VC_GROUPCHAR000006/DSD/VC_GRPDSD Grouping
/VSO/R_TILT_IND/VSO/M_TILT_INDCHAR000001Tilting Allowed
/VSO/R_STACK_IND/VSO/M_STACK_INDCHAR000001No Stacking
/VSO/R_TOP_IND/VSO/M_TOP_INDCHAR000001Only Top Layer
/VSO/R_STACK_NO/VSO/M_STACK_NONUMC000003Stacking Factor
/VSO/R_PAL_IND/VSO/M_PALLET_INDCHAR000001Load without PKM
/VSO/R_PAL_OVR_D/VSO/R_PAL_OVR_DQUAN000013PKM Overhang Depth
/VSO/R_PAL_OVR_W/VSO/R_PAL_OVR_WQUAN000013PKM Overhang Width
/VSO/R_PAL_B_HT/VSO/R_PAL_BIN_HGTQUAN000013Max. Stacking Height
/VSO/R_PAL_MIN_H/VSO/R_PAL_MIN_HTQUAN000013Min. Stacking Height
/VSO/R_TOL_B_HT/VSO/R_TOL_BIN_HTQUAN000013Max.StackH Tolerance
/VSO/R_QUAN_UNIT/VSO/R_QUAN_UNITUNIT000003VSO Unit of Measure
/VSO/R_KZGVH_IND/VSO/M_KZGVH_INDCHAR000001Closed PKM Required
DG_PACK_STATUSADGE_DG_PACK_STATUSCHAR000010TDG101DG Packaging Status
MCONDDFPS_MCONDCHAR000001Material Condition Mgmt
IMATNIMATNCHAR000018*Form-Fit-Function class
BSTATWRFBSTATCHAR000002WRFMATBSTATCreation Status
COLOR_ATINNWRF_COLOR_ATINNNUMC000010*Int. Char. Number
SIZE1_ATINNWRF_SIZE1_ATINNNUMC000010*Int. Char. Number
SIZE2_ATINNWRF_SIZE2_ATINNNUMC000010*Int. Char. Number
COLORWRF_COLORCHAR000018Color
SIZE1WRF_SIZE1CHAR000018Main Size
SIZE2WRF_SIZE2CHAR000018Second Size
FREE_CHARWRF_FREE_CHARCHAR000018Free Charact. Value
CARE_CODEWRF_CARE_CODECHAR000016Care Code
BRAND_IDWRF_BRAND_IDCHAR000004WRF_BRANDSBrand
FIBER_CODE1WRF_FIBER_CODE_1CHAR000003WRF_FIBER_CODESComponent 1
FIBER_PART1WRF_FIBER_PART_1NUMC000003Percentage Share 1
FIBER_CODE2WRF_FIBER_CODE_2CHAR000003WRF_FIBER_CODESComponent 2
FIBER_PART2WRF_FIBER_PART_2NUMC000003Percentage Share 2
FIBER_CODE3WRF_FIBER_CODE_3CHAR000003WRF_FIBER_CODESComponent 3
FIBER_PART3WRF_FIBER_PART_3NUMC000003Percentage Share 3
FIBER_CODE4WRF_FIBER_CODE_4CHAR000003WRF_FIBER_CODESComponent 4
FIBER_PART4WRF_FIBER_PART_4NUMC000003Percentage Share 4
FIBER_CODE5WRF_FIBER_CODE_5CHAR000003WRF_FIBER_CODESComponent 5
FIBER_PART5WRF_FIBER_PART_5NUMC000003Percentage Share 5
FASHGRDFASHGRDCHAR000004T6WFGFashion Grade
ADPROFCIFADPROFCHAR000003TAPROFAdjustment Profile
MEDIUMMEDIUCHAR000006T372MMedium
/DSD/SL_TOLTYP/DSD/SL_TOLTYP_IDCHAR000004/DSD/SL_TGTYPTolerance Type ID
PACKCODECBUNE_PACODECHAR000010CCUNC121Packaging Code
RETDELCDFPS_RETDELCCHAR000001*Return Code
LOGLEV_RETODFPS_LOGLEV_RETOCHAR000001*Return to Logistics Level
NSNIDDFPS_NSNIDCHAR000009NATO Stock Number
SERIALCIFSERIALCHAR000004TSERIALSerial No. Profile
IPMIPPRODUCTCRM_PRODUCT_ID_IPCHAR000040Intellectual Property
/DSD/SV_CNT_GRP/DSD/SV_COUNT_GROUPCHAR000010/DSD/SV_CNTGRCounting Group
/VSO/R_NO_P_GVH/VSO/M_ANZ_PER_GVHNUMC000002No. Mat / Closed PKM
PICNUMPIC_PICNUM_SUSCHAR000018Supersession chain number
CWQRELCIFCWQRELCHAR000001Catch-Weight-Relevant
CWQPROCCIFCWQPROCCHAR000002TCWQPROCCW Profile for CW Qty
CWQTOLGRCIFCWQTOLGRCHAR000009TCWQTOLGRCW Tolerance Group
/VSO/R_BOT_IND/VSO/M_BOTTOM_INDCHAR000001Only Bottom Layer






comments powered by Disqus

Terms of Service     Contact Us     Privacy Policy     Useful SAP related sites