Menu

SAP Table MARA

General Material Data

Unsere Literaturempfehlung

SAP-Änderungs- und Transportmanagement: Architektur und Wartung der SAP-Systemlandschaft

Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!

Bei amazon.de ansehen →

The table MARA (General Material Data) is a standard table in SAP ERP. It belongs to the package MG.

Technical Information

Table MARA
Short Text General Material Data
Package MG
Table Type Transparent Table

Fields for Table MARA

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
MATNR Material Number MATNR CHAR 18
ERSDA Created On ERSDA DATS 8
ERNAM Name of Person who Created the Object ERNAM CHAR 12
LAEDA Date of Last Change LAEDA DATS 8
AENAM Name of Person Who Changed Object AENAM CHAR 12
VPSTA Maintenance status of complete material VPSTA CHAR 15
PSTAT Maintenance status PSTAT_D CHAR 15
LVORM Flag Material for Deletion at Client Level LVOMA CHAR 1
MTART Material Type MTART CHAR 4 T134
MBRSH Industry sector MBRSH CHAR 1 T137
MATKL Material Group MATKL CHAR 9 T023
BISMT Old material number BISMT CHAR 18
MEINS Base Unit of Measure MEINS UNIT 3 T006
BSTME Purchase Order Unit of Measure BSTME UNIT 3 T006
ZEINR Document number (without document management system) DZEINR CHAR 22
ZEIAR Document type (without Document Management system) DZEIAR CHAR 3
ZEIVR Document version (without Document Management system) DZEIVR CHAR 2
ZEIFO Page format of document (without Document Management system) DZEIFO CHAR 4
AESZN Document change number (without document management system) AESZN CHAR 6
BLATT Page number of document (without Document Management system) BLATT CHAR 3
BLANZ Number of sheets (without Document Management system) BLANZ NUMC 3
FERTH Production/inspection memo FERTH CHAR 18
FORMT Page Format of Production Memo FORMT CHAR 4
GROES Size/dimensions GROES CHAR 32
WRKST Basic Material WRKST CHAR 48 TWSPR
NORMT Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18
LABOR Laboratory/design office LABOR CHAR 3 T024L
EKWSL Purchasing Value Key EKWSL CHAR 4 T405
BRGEW Gross Weight BRGEW QUAN 13
NTGEW Net Weight NTGEW QUAN 13
GEWEI Weight Unit GEWEI UNIT 3 T006
VOLUM Volume VOLUM QUAN 13
VOLEH Volume unit VOLEH UNIT 3 T006
BEHVO Container requirements BEHVO CHAR 2 T144
RAUBE Storage conditions RAUBE CHAR 2 T142
TEMPB Temperature conditions indicator TEMPB CHAR 2 T143
DISST Low-Level Code DISST CHAR 3
TRAGR Transportation Group TRAGR CHAR 4 TTGR
STOFF Hazardous material number STOFF CHAR 18 MGEF
SPART Division SPART CHAR 2 TSPA
KUNNR Competitor WETTB CHAR 10 V_KNA1WETT
EANNR European Article Number (EAN) - obsolete!!!!! EANNR CHAR 13
WESCH Quantity: Number of GR/GI slips to be printed WESCH QUAN 13
BWVOR Procurement rule BWVOR CHAR 1 T6WP1
BWSCL Source of Supply BWSCL CHAR 1 TMBW1
SAISO Season Category SAISO CHAR 4 T6WSP
ETIAR Label type ETIAR CHAR 2 T6WP3
ETIFO Label form ETIFO CHAR 2 T6WP4
ENTAR Deactivated DUMMYENTAR CHAR 1 *
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18
NUMTP Category of International Article Number (EAN) NUMTP CHAR 2 TNTP
LAENG Length LAENG QUAN 13
BREIT Width BREIT QUAN 13
HOEHE Height HOEHE QUAN 13
MEABM Unit of Dimension for Length/Width/Height MEABM UNIT 3 T006
PRDHA Product hierarchy PRODH_D CHAR 18 T179
AEKLK Stock Transfer Net Change Costing CK_AEKLK CHAR 1
CADKZ CAD Indicator CADKZ CHAR 1
QMPUR QM in Procurement is Active QMPUR CHAR 1
ERGEW Allowed packaging weight ERGEW QUAN 13
ERGEI Unit of weight (allowed packaging weight) ERGEI UNIT 3 T006
ERVOL Allowed packaging volume ERVOL QUAN 13
ERVOE Volume unit (allowed packaging volume) ERVOE UNIT 3 T006
GEWTO Excess Weight Tolerance for Handling unit GEWTO DEC 3
VOLTO Excess Volume Tolerance of the Handling Unit VOLTO DEC 3
VABME Variable Purchase Order Unit Active VABME CHAR 1
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1
KZKFG Configurable Material KZKFG CHAR 1
XCHPF Batch management requirement indicator XCHPF CHAR 1
VHART Packaging Material Type VHIART CHAR 4 TVTY
FUELG Maximum level (by volume) FUELG DEC 3
STFAK Stacking factor STFAK INT2 5
MAGRV Material Group: Packaging Materials MAGRV CHAR 4 TVEGR
BEGRU Authorization Group BEGRU CHAR 4
DATAB Valid-From Date DATAB DATS 8
LIQDT Deletion date LIQDT DATS 8
SAISJ Season Year SAISJ CHAR 4
PLGTP Price Band Category PLGTP CHAR 2 TWPT
MLGUT Empties Bill of Material W_MITLEERG CHAR 1
EXTWG External Material Group EXTWG CHAR 18 TWEW
SATNR Cross-Plant Configurable Material SATNR CHAR 18 MARA
ATTYP Material Category ATTYP CHAR 2
KZKUP Indicator: Material can be co-product KZKUPMAT CHAR 1
KZNFM Indicator: The material has a follow-up material KZNFM CHAR 1
PMATA Pricing Reference Material PMATN CHAR 18 MARA
MSTAE Cross-Plant Material Status MSTAE CHAR 2 T141
MSTAV Cross-distribution-chain material status MSTAV CHAR 2 TVMS
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8
MSTDV Date from which the X-distr.-chain material status is valid MSTDV DATS 8
TAKLV Tax classification of the material TAKLV CHAR 1 TSKM
RBNRM Catalog Profile RBNR CHAR 9 T352B
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4
MHDHB Total shelf life MHDHB DEC 4
MHDLP Storage percentage MHDLP DEC 3
INHME Content unit INHME UNIT 3 T006
INHAL Net contents INHAL QUAN 13
VPREH Comparison price unit VPREH DEC 5
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) ETIAG CHAR 18 TWEA
INHBR Gross contents INHBR QUAN 13
CMETH Quantity Conversion Method OIB_CMETH CHAR 1
CUOBF Internal object number CUOBM NUMC 18
KZUMW Environmentally Relevant KZUMW CHAR 1
KOSCH Product allocation determination procedure KOSCH CHAR 18 T190S
SPROF Pricing profile for variants SPROF CHAR 1
NRFHG Material qualifies for discount in kind NRFHG CHAR 1
MFRPN Manufacturer Part Number MFRPN CHAR 40
MFRNR Number of a Manufacturer MFRNR CHAR 10 LFA1
BMATN Number of firm's own (internal) inventory-managed material MPMAT CHAR 18 MARA
MPROF Manufacturer Part Profile MPROF CHAR 4 TMPPF
KZWSM Units of measure usage KZWSO CHAR 1
SAITY Rollout in a Season SAITY CHAR 2 T6WSA
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 TDG41
IHIVI Indicator: Highly Viscous ADGE_IHIVI CHAR 1
ILOOS Indicator: In Bulk/Liquid ADGE_ILOOS CHAR 1
SERLV Level of Explicitness for Serial Number SERLV CHAR 1
KZGVH Packaging Material is Closed Packaging KZGVH CHAR 1
XGCHP Indicator: Approved batch record required XGCHP CHAR 1
KZEFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1
COMPL Material completion level CSCP_COMP_LVL NUMC 2 TCSCP_COMP_LVL
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1
RDMHD Rounding rule for calculation of SLED RDMHD CHAR 1
PRZUS Indicator: Product composition printed on packaging PRZUS CHAR 1
MTPOS_MARA General item category group MTPOS_MARA CHAR 4 TPTM
BFLME Generic Material with Logistical Variants BFLME CHAR 1
MATFI Material Is Locked MATFI CHAR 1
CMREL Relevant for Configuration Management DE_CM_RELEVANCE_FLAG CHAR 1
BBTYP Assortment List Type BBTYP CHAR 1 *
SLED_BBD Expiration Date SLED_BBD CHAR 1
GTIN_VARIANT Global Trade Item Number Variant GTIN_VARIANT CHAR 2
GENNR Material Number of the Generic Material in Prepack Materials WSTR_SATNR_PP CHAR 18 MARA
RMATP Reference material for materials packed in same way PL_RMATP CHAR 18 MARA
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant GDS_RELEVANT CHAR 1
WEORA Acceptance At Origin WEORA CHAR 1
HUTYP_DFLT Standard HU Type CIFHUTYPDF CHAR 4 THUTYP
PILFERABLE Pilferable CIFPILFRBL CHAR 1
WHSTC Warehouse Storage Condition CIFWHSTC CHAR 2 TWHSTC
WHMATGR Warehouse Material Group CIFWHMATGR CHAR 4 TWHMATGR
HNDLCODE Handling Indicator CIFHDLCODE CHAR 4 THNDLCD
HAZMAT Relevant for Hazardous Substances CIFHAZMAT CHAR 1
HUTYP Handling Unit Type CIFHUTYP CHAR 4 THUTYP
TARE_VAR Variable Tare Weight CIFTAREVAR CHAR 1
MAXC Maximum Allowed Capacity of Packaging Material CIFMAXC DEC 15
MAXC_TOL Overcapacity Tolerance of the Handling Unit CIFMAXCTOL DEC 3
MAXL Maximum Packing Length of Packaging Material CIFMAXL QUAN 15
MAXB Maximum Packing Width of Packaging Material CIFMAXB QUAN 15
MAXH Maximum Packing Height of Packaging Material CIFMAXH QUAN 15
MAXDIM_UOM Unit of Measure for Maximum Packing Length/Width/Height CIFMAXDUOM UNIT 3 T006
HERKL Country of origin of the material HERKL CHAR 3 T005
MFRGR Material freight group MFRGR CHAR 8 TMFG
QQTIME Quarantine Period CIFQQTIME QUAN 3
QQTIMEUOM Time Unit for Quarantine Period CIFQQTIMEUOM UNIT 3 T006
QGRP Quality Inspection Group CIFQGRP CHAR 4 TQGRP
SERIAL Serial Number Profile CIFSERIAL CHAR 4 TSERIAL
PS_SMARTFORM Form Name CIFPSSFNAME CHAR 30 STXFADM
LOGUNIT EWM CW: Logistics Unit of Measure CIFLOGUNIT UNIT 3 MARM
CWQREL EWM CW: Material Is a Catch Weight Material CIFCWQREL CHAR 1
CWQPROC EWM CW: Catch Weight Profile for Entering CW Quantity CIFCWQPROC CHAR 2 TCWQPROC
CWQTOLGR EWM-CW: Catch Weight Tolerance Group for EWM CIFCWQTOLGR CHAR 9 TCWQTOLGR
ADPROF Adjustment Profile CIFADPROF CHAR 3 TAPROF
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CRM_PRODUCT_ID_IP CHAR 40
ALLOW_PMAT_IGNO Variant Price Allowed (for Material Master) WPM_ALLOW_PMAT_IGNO_MAT CHAR 1
MEDIUM Medium MEDIU CHAR 6 T372M
COMMODITY Physical Commodity TBA_STOEFFCHEN CHAR 18 TBAC_PHYSCOMM
ANIMAL_ORIGIN Indicator: Contains Non-Textile Parts of Animal Origin WRF_ANIMAL_ORIGIN_FLAG CHAR 1
TEXTILE_COMP_IND Indicator: New Textile Composition Function WRF_TEXTL_COMP_IND CHAR 1
ANP ANP Code J_1BANP NUMC 9 J_1BTANP
/BEV1/LULEINH Loading Units /BEV1/LULEINH NUMC 8
/BEV1/LULDEGRP Loading Unit Group: IS Beverage /BEV1/LULDEGRP CHAR 3 /BEV1/LUT906
/BEV1/NESTRUCCAT Structure Category for Material Relationship /BEV1/NESTRUC_CAT CHAR 1
/DSD/SL_TOLTYP Tolerance Type ID /DSD/SL_TOLTYP_ID CHAR 4 /DSD/SL_TGTYP
/DSD/SV_CNT_GRP Counting Group /DSD/SV_COUNT_GROUP CHAR 10 /DSD/SV_CNTGR
/DSD/VC_GROUP DSD Grouping /DSD/VC_GROUP CHAR 6 /DSD/VC_GRP
/SAPMP/KADU Cable Diameter /SAPMP/KADU DEC 7
/SAPMP/ABMEIN Unit for Dimensions /SAPMP/ABMEIN UNIT 3 *
/SAPMP/KADP Cable Diameter Allowance in Percent /SAPMP/KADP DEC 5
/SAPMP/BRAD Bending Factor /SAPMP/BRAD DEC 4
/SAPMP/SPBI Inner Width /SAPMP/SPBI DEC 7
/SAPMP/TRAD Outer Diameter /SAPMP/TRAD DEC 7
/SAPMP/KEDU Core Diameter /SAPMP/KEDU DEC 7
/SAPMP/SPTR Load Capacity /SAPMP/SPTR QUAN 13
/SAPMP/FBDK Run-Out Flange Thickness /SAPMP/FBDK DEC 7
/SAPMP/FBHK R-O Flange Height /SAPMP/FBHK DEC 7
/SAPMP/RILI Coil Delivery /SAPMP/RILI CHAR 1
/SAPMP/FBAK Run-Out Flange /SAPMP/FBAK CHAR 1
/SAPMP/AHO Maximum Number of Vertical Layers /SAPMP/AHO NUMC 3
/SAPMP/MIFRR Smallest Permissible Reel Clearance for a Cable /SAPMP/MIFRR DEC 7
/VSO/R_TILT_IND Material may be Tilted (Vehicle Space Optimization) /VSO/M_TILT_IND CHAR 1
/VSO/R_STACK_IND Stacking not Allowed (VSO) /VSO/M_STACK_IND CHAR 1
/VSO/R_BOT_IND Bottom Layer (Vehicle Space Optimization) /VSO/M_BOTTOM_IND CHAR 1
/VSO/R_TOP_IND Top Layer (VSO) /VSO/M_TOP_IND CHAR 1
/VSO/R_STACK_NO Stacking Factor (Vehicle Space Optimization) /VSO/M_STACK_NO NUMC 3
/VSO/R_PAL_IND Load without Packaging Material (VSO) /VSO/M_PALLET_IND CHAR 1
/VSO/R_PAL_OVR_D Permissible Overhang (Depth) of Packaging Material (VSO) /VSO/R_PAL_OVR_D QUAN 13
/VSO/R_PAL_OVR_W Permissible Overhang (Width) of Shipping Material (VSO) /VSO/R_PAL_OVR_W QUAN 13
/VSO/R_PAL_B_HT Maximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGT QUAN 13
/VSO/R_PAL_MIN_H Minimum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_MIN_HT QUAN 13
/VSO/R_TOL_B_HT Tolerance to Exceed the Max. Stacking Height (VSO) /VSO/R_TOL_BIN_HT QUAN 13
/VSO/R_NO_P_GVH Number of Materials for each Closed PKM (VSO) /VSO/M_ANZ_PER_GVH NUMC 2
/VSO/R_QUAN_UNIT Unit of Measure Vehicle Space Optimization /VSO/R_QUAN_UNIT UNIT 3
/VSO/R_KZGVH_IND Closed Packaging Material Required (VSO) /VSO/M_KZGVH_IND CHAR 1
PACKCODE Packaging Code CBUNE_PACODE CHAR 10 CCUNC121
DG_PACK_STATUS Dangerous Goods Packaging Status ADGE_DG_PACK_STATUS CHAR 10 TDG101
MCOND Material Condition Management DFPS_MCOND CHAR 1
RETDELC Return Code DFPS_RETDELC CHAR 1 *
LOGLEV_RETO Return to Logistics Level DFPS_LOGLEV_RETO CHAR 1 *
NSNID NATO Stock Number DFPS_NSNID CHAR 9
OVLPN Overlength Part Number ADSPC_OPN CHAR 32
ADSPC_SPC Spare Part Class Code ADSPC_SPC NUMC 1
VARID GUID Variable Object Identification DI_VARID RAW 16
MSBOOKPARTNO Manufacturer Book Part Number /SAPHT/DRM_MSBOOKPART CHAR 18 *
VTYPE Version Category VERSIONTYPE CHAR 10 MGVTYPE
VCHNR Change number material versions MGV_VCHNR CHAR 12 AENR
EVVAL Material is Always Valid MGV_EVER_VALID CHAR 1
DVERS Default Version MGV_MATNR_VALID_DEFAULT CHAR 18 *
DPCBT Single-Unit Batch Def. Value MILL_DPCBT CHAR 1
XGRDT Goods Receipt to Posted Single-Unit Batch Allowed MILL_XGRDT CHAR 1
IMATN FFF class IMATN CHAR 18 *
PICNUM Supersession chain number PIC_PICNUM_SUS CHAR 18
BSTAT Creation Status - Seasonal Procurement WRFBSTAT CHAR 2 WRFMATBSTAT
COLOR_ATINN Internal Charactieristic Number for Color Characteristics WRF_COLOR_ATINN NUMC 10 *
SIZE1_ATINN Internal Char. Number for Characteristics for Main Sizes WRF_SIZE1_ATINN NUMC 10 *
SIZE2_ATINN Internal Char. Number for Characteristics for Second Sizes WRF_SIZE2_ATINN NUMC 10 *
COLOR Characteristic Value for Colors of Variants WRF_COLOR CHAR 18
SIZE1 Characteristic Value for Main Sizes of Variants WRF_SIZE1 CHAR 18
SIZE2 Characteristic Value for Second Size for Variants WRF_SIZE2 CHAR 18
FREE_CHAR Characteristic Value for Evaluation Purposes WRF_FREE_CHAR CHAR 18
CARE_CODE Care Codes (such as Washing Code, Ironing Code, etc.) WRF_CARE_CODE CHAR 16
BRAND_ID Brand WRF_BRAND_ID CHAR 4 WRF_BRANDS
FIBER_CODE1 Fiber Code for Textiles (Component 1) WRF_FIBER_CODE_1 CHAR 3 WRF_FIBER_CODES
FIBER_PART1 Percentage Share of Fiber (Component 1) WRF_FIBER_PART_1 NUMC 3
FIBER_CODE2 Fiber Code for Textiles (Component 2) WRF_FIBER_CODE_2 CHAR 3 WRF_FIBER_CODES
FIBER_PART2 Percentage Share of Fiber (Component 2) WRF_FIBER_PART_2 NUMC 3
FIBER_CODE3 Fiber Code for Textiles (Component 3) WRF_FIBER_CODE_3 CHAR 3 WRF_FIBER_CODES
FIBER_PART3 Percentage Share of Fiber (Component 3) WRF_FIBER_PART_3 NUMC 3
FIBER_CODE4 Fiber Code for Textiles (Component 4) WRF_FIBER_CODE_4 CHAR 3 WRF_FIBER_CODES
FIBER_PART4 Percentage Share of Fiber (Component 4) WRF_FIBER_PART_4 NUMC 3
FIBER_CODE5 Fiber Code for Textiles (Component 5) WRF_FIBER_CODE_5 CHAR 3 WRF_FIBER_CODES
FIBER_PART5 Percentage Share of Fiber (Component 5) WRF_FIBER_PART_5 NUMC 3
FASHGRD Fashion Grade FASHGRD CHAR 4 T6WFG
COBJID Object ID HROBJID NUMC 8 *
COTYPE Object Type OTYPE CHAR 2 *
OIGROUPNAM TD product group OIG_PCG CHAR 8 TOIGAP
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1
OIHMTXGR Material tax group OIH_J1B_MTXGR CHAR 4 OIH2M_J1B