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 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 Field Data Element Data Type length Checktable Description MANDT MANDT CLNT 000003 T000 Client MATNR MATNR CHAR 000018 Material ERSDA ERSDA DATS 000008 Created On ERNAM ERNAM CHAR 000012 Created by LAEDA LAEDA DATS 000008 Last Change AENAM AENAM CHAR 000012 Changed by VPSTA VPSTA CHAR 000015 Compl. maint. status PSTAT PSTAT_D CHAR 000015 Maintenance status LVORM LVOMA CHAR 000001 DF at client level MTART MTART CHAR 000004 T134 Material Type MBRSH MBRSH CHAR 000001 T137 Industry sector MATKL MATKL CHAR 000009 T023 Material Group BISMT BISMT CHAR 000018 Old material number MEINS MEINS UNIT 000003 T006 Base Unit of Measure BSTME BSTME UNIT 000003 T006 Order Unit ZEINR DZEINR CHAR 000022 ZEIAR DZEIAR CHAR 000003 ZEIVR DZEIVR CHAR 000002 ZEIFO DZEIFO CHAR 000004 AESZN AESZN CHAR 000006 Document change no. BLATT BLATT CHAR 000003 Page number BLANZ BLANZ NUMC 000003 Number of sheets FERTH FERTH CHAR 000018 Prod./insp. memo FORMT FORMT CHAR 000004 Page format GROES GROES CHAR 000032 Size/dimensions WRKST WRKST CHAR 000048 TWSPR Basic material NORMT NORMT CHAR 000018 Industry Std Desc. LABOR LABOR CHAR 000003 T024L Lab/Office EKWSL EKWSL CHAR 000004 T405 Purchasing value key BRGEW BRGEW QUAN 000013 Gross Weight NTGEW NTGEW QUAN 000013 Net Weight GEWEI GEWEI UNIT 000003 T006 Weight unit VOLUM VOLUM QUAN 000013 Volume VOLEH VOLEH UNIT 000003 T006 Volume unit BEHVO BEHVO CHAR 000002 T144 Container reqmts RAUBE RAUBE CHAR 000002 T142 Storage conditions TEMPB TEMPB CHAR 000002 T143 Temp. conditions DISST DISST CHAR 000003 Low-Level Code TRAGR TRAGR CHAR 000004 TTGR Transportation Group STOFF STOFF CHAR 000018 MGEF Haz. material number SPART SPART CHAR 000002 TSPA Division KUNNR WETTB CHAR 000010 V_KNA1WETT Competitor EANNR EANNR CHAR 000013 EAN number WESCH WESCH QUAN 000013 Number of GR slips BWVOR BWVOR CHAR 000001 T6WP1 Procurement rule BWSCL BWSCL CHAR 000001 TMBW1 Source of supply SAISO SAISO CHAR 000004 T6WSP Season ETIAR ETIAR CHAR 000002 T6WP3 Label type ETIFO ETIFO CHAR 000002 T6WP4 Label form ENTAR DUMMYENTAR CHAR 000001 * Field deactivated EAN11 EAN11 CHAR 000018 EAN/UPC NUMTP NUMTP CHAR 000002 TNTP EAN Category LAENG LAENG QUAN 000013 Length BREIT BREIT QUAN 000013 Width HOEHE HOEHE QUAN 000013 Height MEABM MEABM UNIT 000003 T006 Unit of Dimension PRDHA PRODH_D CHAR 000018 T179 Product hierarchy AEKLK CK_AEKLK CHAR 000001 Net Change Costing CADKZ CADKZ CHAR 000001 CAD Indicator QMPUR QMPUR CHAR 000001 QM proc. active ERGEW ERGEW QUAN 000013 Allowed pkg weight ERGEI ERGEI UNIT 000003 T006 Unit of weight ERVOL ERVOL QUAN 000013 Allowed pkg volume ERVOE ERVOE UNIT 000003 T006 Volume unit GEWTO GEWTO DEC 000003 Excess wt tolerance VOLTO VOLTO DEC 000003 Excess volume tol. VABME VABME CHAR 000001 Variable Purchase Order Unit KZREV KZREV CHAR 000001 Revision Level Assgd KZKFG KZKFG CHAR 000001 Material is configurable XCHPF XCHPF CHAR 000001 Batch management VHART VHIART CHAR 000004 TVTY Packaging mat. type FUELG FUELG DEC 000003 Maximum level STFAK STFAK INT2 000005 Stackability factor MAGRV MAGRV CHAR 000004 TVEGR Matl Grp Pack.Matls BEGRU BEGRU CHAR 000004 Authorization Group DATAB DATAB DATS 000008 Valid From LIQDT LIQDT DATS 000008 Valid to SAISJ SAISJ CHAR 000004 Season Year PLGTP PLGTP CHAR 000002 TWPT Price Band Category MLGUT W_MITLEERG CHAR 000001 With empties BOM EXTWG EXTWG CHAR 000018 TWEW Ext. Material Group SATNR SATNR CHAR 000018 MARA Cross-plant CM ATTYP ATTYP CHAR 000002 Material Category KZKUP KZKUPMAT CHAR 000001 Co-product KZNFM KZNFM CHAR 000001 Follow-up material PMATA PMATN CHAR 000018 MARA Pricing Ref. Matl MSTAE MSTAE CHAR 000002 T141 X-plant matl status MSTAV MSTAV CHAR 000002 TVMS X-distr.chain status MSTDE MSTDE DATS 000008 Valid from MSTDV MSTDV DATS 000008 Valid from TAKLV TAKLV CHAR 000001 TSKM Tax classification RBNRM RBNR CHAR 000009 T352B Catalog profile MHDRZ MHDRZ DEC 000004 Min. Rem. Shelf Life MHDHB MHDHB DEC 000004 Total shelf life MHDLP MHDLP DEC 000003 Storage percentage INHME INHME UNIT 000003 T006 Content unit INHAL INHAL QUAN 000013 Net contents VPREH VPREH DEC 000005 ComparisonPriceUnit ETIAG ETIAG CHAR 000018 TWEA Labeling matl grpg INHBR INHBR QUAN 000013 Gross contents CMETH OIB_CMETH CHAR 000001 Conversion Method CUOBF CUOBM NUMC 000018 Internal object no. KZUMW KZUMW CHAR 000001 Environmentally rlvt KOSCH KOSCH CHAR 000018 T190S Product allocation SPROF SPROF CHAR 000001 Pricing profile NRFHG NRFHG CHAR 000001 Qual.f.FreeGoodsDis. MFRPN MFRPN CHAR 000040 Manufacturer Part No. MFRNR MFRNR CHAR 000010 LFA1 Manufacturer BMATN MPMAT CHAR 000018 MARA Int. material number MPROF MPROF CHAR 000004 TMPPF Mfr Part Profile KZWSM KZWSO CHAR 000001 Units of meas. usage SAITY SAITY CHAR 000002 T6WSA Rollout PROFL ADGE_PROFL CHAR 000003 TDG41 DG indicator profile IHIVI ADGE_IHIVI CHAR 000001 Highly viscous ILOOS ADGE_ILOOS CHAR 000001 In bulk/liquid SERLV SERLV CHAR 000001 Serialization level KZGVH KZGVH CHAR 000001 Closed XGCHP XGCHP CHAR 000001 Appr.batch rec. req. KZEFF CC_MTEFF CHAR 000001 Assign effect. vals COMPL CSCP_COMP_LVL NUMC 000002 TCSCP_COMP_LVL Material completion level IPRKZ DATTP CHAR 000001 Period Ind. for SLED RDMHD RDMHD CHAR 000001 Rounding rule SLED PRZUS PRZUS CHAR 000001 Product Composition MTPOS_MARA MTPOS_MARA CHAR 000004 TPTM Gen. item cat. grp BFLME BFLME CHAR 000001 Logistical variants MATFI MATFI CHAR 000001 Material is locked CMREL DE_CM_RELEVANCE_FLAG CHAR 000001 Relevant for CM BBTYP BBTYP CHAR 000001 * Assortment List Type SLED_BBD SLED_BBD CHAR 000001 Expiration Date GTIN_VARIANT GTIN_VARIANT CHAR 000002 EAN Variant GENNR WSTR_SATNR_PP CHAR 000018 MARA Generic Material RMATP PL_RMATP CHAR 000018 MARA Reference matl for packing GDS_RELEVANT GDS_RELEVANT CHAR 000001 GDS-Relevant WEORA WEORA CHAR 000001 Origin Acceptance HUTYP_DFLT CIFHUTYPDF CHAR 000004 THUTYP Standard HU Type HUTYP CIFHUTYP CHAR 000004 THUTYP Handling Unit Type MAXDIM_UOM CIFMAXDUOM UNIT 000003 T006 Unit of Measurement PILFERABLE CIFPILFRBL CHAR 000001 Pilferable HNDLCODE CIFHDLCODE CHAR 000004 THNDLCD Handling Indicator HAZMAT CIFHAZMAT CHAR 000001 Rel. for HS MAXC CIFMAXC DEC 000015 Maximum Capacity MAXC_TOL CIFMAXCTOL DEC 000003 Overcapacity Toler. MAXL CIFMAXL QUAN 000015 Max. Pack. Length MAXB CIFMAXB QUAN 000015 Max. Pack. Width MAXH CIFMAXH QUAN 000015 Max. Pack. Height HERKL HERKL CHAR 000003 T005 Country of origin MFRGR MFRGR CHAR 000008 TMFG Material freight grp QGRP CIFQGRP CHAR 000004 TQGRP Quality Inspec. Grp WHSTC CIFWHSTC CHAR 000002 TWHSTC WH Storage Condition WHMATGR CIFWHMATGR CHAR 000004 TWHMATGR WH Material Group TARE_VAR CIFTAREVAR CHAR 000001 Varb. Tare Weight QQTIME CIFQQTIME QUAN 000003 Quarant. Per. QQTIMEUOM CIFQQTIMEUOM UNIT 000003 T006 Time Unit PS_SMARTFORM CIFPSSFNAME CHAR 000030 STXFADM Form Name LOGUNIT CIFLOGUNIT UNIT 000003 MARM Logistics Unit of Measure ALLOW_PMAT_IGNO WPM_ALLOW_PMAT_IGNO_MAT CHAR 000001 Variant Price Allowed /BEV1/LULEINH /BEV1/LULEINH NUMC 000008 Loading Units /BEV1/LULDEGRP /BEV1/LULDEGRP CHAR 000003 /BEV1/LUT906 Loading Unit Group /BEV1/NESTRUCCAT /BEV1/NESTRUC_CAT CHAR 000001 Structure Category /DSD/VC_GROUP /DSD/VC_GROUP CHAR 000006 /DSD/VC_GRP DSD Grouping /VSO/R_TILT_IND /VSO/M_TILT_IND CHAR 000001 Tilting Allowed /VSO/R_STACK_IND /VSO/M_STACK_IND CHAR 000001 No Stacking /VSO/R_TOP_IND /VSO/M_TOP_IND CHAR 000001 Only Top Layer /VSO/R_STACK_NO /VSO/M_STACK_NO NUMC 000003 Stacking Factor /VSO/R_PAL_IND /VSO/M_PALLET_IND CHAR 000001 Load without PKM /VSO/R_PAL_OVR_D /VSO/R_PAL_OVR_D QUAN 000013 PKM Overhang Depth /VSO/R_PAL_OVR_W /VSO/R_PAL_OVR_W QUAN 000013 PKM Overhang Width /VSO/R_PAL_B_HT /VSO/R_PAL_BIN_HGT QUAN 000013 Max. Stacking Height /VSO/R_PAL_MIN_H /VSO/R_PAL_MIN_HT QUAN 000013 Min. Stacking Height /VSO/R_TOL_B_HT /VSO/R_TOL_BIN_HT QUAN 000013 Max.StackH Tolerance /VSO/R_QUAN_UNIT /VSO/R_QUAN_UNIT UNIT 000003 VSO Unit of Measure /VSO/R_KZGVH_IND /VSO/M_KZGVH_IND CHAR 000001 Closed PKM Required DG_PACK_STATUS ADGE_DG_PACK_STATUS CHAR 000010 TDG101 DG Packaging Status MCOND DFPS_MCOND CHAR 000001 Material Condition Mgmt IMATN IMATN CHAR 000018 * Form-Fit-Function class BSTAT WRFBSTAT CHAR 000002 WRFMATBSTAT Creation Status COLOR_ATINN WRF_COLOR_ATINN NUMC 000010 * Int. Char. Number SIZE1_ATINN WRF_SIZE1_ATINN NUMC 000010 * Int. Char. Number SIZE2_ATINN WRF_SIZE2_ATINN NUMC 000010 * Int. Char. Number COLOR WRF_COLOR CHAR 000018 Color SIZE1 WRF_SIZE1 CHAR 000018 Main Size SIZE2 WRF_SIZE2 CHAR 000018 Second Size FREE_CHAR WRF_FREE_CHAR CHAR 000018 Free Charact. Value CARE_CODE WRF_CARE_CODE CHAR 000016 Care Code BRAND_ID WRF_BRAND_ID CHAR 000004 WRF_BRANDS Brand FIBER_CODE1 WRF_FIBER_CODE_1 CHAR 000003 WRF_FIBER_CODES Component 1 FIBER_PART1 WRF_FIBER_PART_1 NUMC 000003 Percentage Share 1 FIBER_CODE2 WRF_FIBER_CODE_2 CHAR 000003 WRF_FIBER_CODES Component 2 FIBER_PART2 WRF_FIBER_PART_2 NUMC 000003 Percentage Share 2 FIBER_CODE3 WRF_FIBER_CODE_3 CHAR 000003 WRF_FIBER_CODES Component 3 FIBER_PART3 WRF_FIBER_PART_3 NUMC 000003 Percentage Share 3 FIBER_CODE4 WRF_FIBER_CODE_4 CHAR 000003 WRF_FIBER_CODES Component 4 FIBER_PART4 WRF_FIBER_PART_4 NUMC 000003 Percentage Share 4 FIBER_CODE5 WRF_FIBER_CODE_5 CHAR 000003 WRF_FIBER_CODES Component 5 FIBER_PART5 WRF_FIBER_PART_5 NUMC 000003 Percentage Share 5 FASHGRD FASHGRD CHAR 000004 T6WFG Fashion Grade ADPROF CIFADPROF CHAR 000003 TAPROF Adjustment Profile MEDIUM MEDIU CHAR 000006 T372M Medium /DSD/SL_TOLTYP /DSD/SL_TOLTYP_ID CHAR 000004 /DSD/SL_TGTYP Tolerance Type ID PACKCODE CBUNE_PACODE CHAR 000010 CCUNC121 Packaging Code RETDELC DFPS_RETDELC CHAR 000001 * Return Code LOGLEV_RETO DFPS_LOGLEV_RETO CHAR 000001 * Return to Logistics Level NSNID DFPS_NSNID CHAR 000009 NATO Stock Number SERIAL CIFSERIAL CHAR 000004 TSERIAL Serial No. Profile IPMIPPRODUCT CRM_PRODUCT_ID_IP CHAR 000040 Intellectual Property /DSD/SV_CNT_GRP /DSD/SV_COUNT_GROUP CHAR 000010 /DSD/SV_CNTGR Counting Group /VSO/R_NO_P_GVH /VSO/M_ANZ_PER_GVH NUMC 000002 No. Mat / Closed PKM PICNUM PIC_PICNUM_SUS CHAR 000018 Supersession chain number CWQREL CIFCWQREL CHAR 000001 Catch-Weight-Relevant CWQPROC CIFCWQPROC CHAR 000002 TCWQPROC CW Profile for CW Qty CWQTOLGR CIFCWQTOLGR CHAR 000009 TCWQTOLGR CW Tolerance Group /VSO/R_BOT_IND /VSO/M_BOTTOM_IND CHAR 000001 Only Bottom Layer MAR1 MARA1