SAP Table

MARA General Material Data

The SAP table MARA, also known as the General Material Data table, is a crucial component within the SAP ERP system that stores master data related to materials. This table serves as a centralized repository for essential material-related information used across various business processes such as procurement, production, inventory management, and sales. Key data fields in MARA include the material number (MATNR), material type (MTART), industry sector (MBRSH), and base unit of measure (MEINS), among others. By maintaining comprehensive material records, MARA ensures data consistency and facilitates efficient material management and operations within an organization.

SAP table MARA has 2 primary key fields being MANDT,MATNR.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

MARA columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyMATNR Material Number CHAR 40 0 MATNR
ERSDA Created On DATS 8 0 ERSDA
CREATED_AT_TIME Time of Creation TIMS 6 0 CREATED_AT_TIME
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
LAEDA Date of Last Change DATS 8 0 LAEDA
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
VPSTA Maintenance status of complete material CHAR 15 0 VPSTA
PSTAT Maintenance status CHAR 15 0 PSTAT_D
LVORM Flag Material for Deletion at Client Level CHAR 1 0 LVOMA
MTART Material type CHAR 4 0 T134 MTART
MBRSH Industry Sector CHAR 1 0 T137 MBRSH
MATKL Material Group CHAR 9 0 T023 MATKL
BISMT Old material number CHAR 40 0 BISMT
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BSTME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
ZEINR Document number (without document management system) CHAR 22 0 DZEINR
ZEIAR Document type (without Document Management system) CHAR 3 0 DZEIAR
ZEIVR Document version (without Document Management system) CHAR 2 0 DZEIVR
ZEIFO Page format of document (without Document Management system) CHAR 4 0 DZEIFO
AESZN Document change number (without document management system) CHAR 6 0 AESZN
BLATT Page number of document (without Document Management system) CHAR 3 0 BLATT
BLANZ Number of sheets (without Document Management system) NUMC 3 0 BLANZ
FERTH Production/inspection memo CHAR 18 0 FERTH
FORMT Page Format of Production Memo CHAR 4 0 FORMT
GROES Size/dimensions CHAR 32 0 GROES
WRKST Basic Material CHAR 48 0 TWSPR WRKST
NORMT Industry Standard Description (such as ANSI or ISO) CHAR 18 0 NORMT
LABOR Laboratory/design office CHAR 3 0 T024L LABOR
EKWSL Purchasing Value Key CHAR 4 0 T405 EKWSL
BRGEW Gross weight QUAN 13 3 BRGEW
NTGEW Net weight QUAN 13 3 NTGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 T006 VOLEH
BEHVO Container requirements CHAR 2 0 T144 BEHVO
RAUBE Storage conditions CHAR 2 0 T142 RAUBE
TEMPB Temperature conditions indicator CHAR 2 0 T143 TEMPB
DISST Low-Level Code CHAR 3 0 DISST
TRAGR Transportation Group CHAR 4 0 TTGR TRAGR
STOFF Hazardous material number CHAR 40 0 MGEF STOFF
SPART Division CHAR 2 0 TSPA SPART
KUNNR Competitor CHAR 10 0 V_KNA1WETT WETTB
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
WESCH Quantity: Number of GR/GI slips to be printed QUAN 13 3 WESCH
BWVOR Procurement rule CHAR 1 0 T6WP1 BWVOR
BWSCL Source of Supply CHAR 1 0 TMBW1 BWSCL
SAISO Season Category CHAR 4 0 T6WSP SAISO
ETIAR Label type CHAR 2 0 T6WP3 ETIAR
ETIFO Label form CHAR 2 0 T6WP4 ETIFO
ENTAR Deactivated CHAR 1 0 * DUMMYENTAR
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
NUMTP Category of International Article Number (EAN) CHAR 2 0 TNTP NUMTP
LAENG Length QUAN 13 3 LAENG
BREIT Width QUAN 13 3 BREIT
HOEHE Height QUAN 13 3 HOEHE
MEABM Unit of Dimension for Length/Width/Height UNIT 3 0 T006 MEABM
PRDHA Product hierarchy CHAR 18 0 T179 PRODH_D
AEKLK Stock Transfer Net Change Costing CHAR 1 0 CK_AEKLK
CADKZ CAD Indicator CHAR 1 0 CADKZ
QMPUR QM in Procurement Is Active CHAR 1 0 QMPUR
ERGEW Allowed packaging weight QUAN 13 3 ERGEW
ERGEI Unit of weight (allowed packaging weight) UNIT 3 0 T006 ERGEI
ERVOL Allowed packaging volume QUAN 13 3 ERVOL
ERVOE Volume unit (allowed packaging volume) UNIT 3 0 T006 ERVOE
GEWTO Excess Weight Tolerance for Handling unit DEC 3 1 GEWTO
VOLTO Excess Volume Tolerance of the Handling Unit DEC 3 1 VOLTO
VABME Variable Purchase Order Unit Active CHAR 1 0 VABME
KZREV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
KZKFG Configurable Material CHAR 1 0 KZKFG
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
VHART Packaging Material Type CHAR 4 0 TVTY VHIART
FUELG Maximum level (by volume) DEC 3 0 FUELG
STFAK Stacking factor INT2 5 0 STFAK
MAGRV Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
BEGRU Authorization Group CHAR 4 0 BEGRU
DATAB Valid-From Date DATS 8 0 DATAB
LIQDT Deletion date DATS 8 0 LIQDT
SAISJ Season Year CHAR 4 0 SAISJ
PLGTP Price Band Category CHAR 2 0 TWPT PLGTP
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
EXTWG External Material Group CHAR 18 0 TWEW EXTWG
SATNR Cross-Plant Configurable Material CHAR 40 0 MARA SATNR
ATTYP Material Category CHAR 2 0 ATTYP
KZKUP Indicator: Material can be co-product CHAR 1 0 KZKUPMAT
KZNFM Indicator: The material has a follow-up material CHAR 1 0 KZNFM
PMATA Pricing Reference Material CHAR 40 0 MARA PMATN
MSTAE Cross-Plant Material Status CHAR 2 0 T141 MSTAE
MSTAV Cross-distribution-chain material status CHAR 2 0 TVMS MSTAV
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE
MSTDV Date from which the X-distr.-chain material status is valid DATS 8 0 MSTDV
TAKLV Tax classification of the material CHAR 1 0 TSKM TAKLV
RBNRM Catalog Profile CHAR 9 0 T352B RBNR
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
MHDHB Total shelf life DEC 4 0 MHDHB
MHDLP Storage percentage DEC 3 0 MHDLP
INHME Content unit UNIT 3 0 T006 INHME
INHAL Net contents QUAN 13 3 INHAL
VPREH Comparison price unit DEC 5 0 VPREH
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) CHAR 18 0 TWEA ETIAG
INHBR Gross contents QUAN 13 3 INHBR
CMETH Quantity Conversion Method CHAR 1 0 OIB_CMETH
CUOBF Internal object number NUMC 18 0 CUOBM
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
KOSCH Product allocation determination procedure CHAR 18 0 T190S KOSCH
SPROF Pricing profile for variants CHAR 1 0 SPROF
NRFHG Material qualifies for discount in kind CHAR 1 0 NRFHG
MFRPN Manufacturer Part Number CHAR 40 0 MFRPN
MFRNR Manufacturer number CHAR 10 0 LFA1 MFRNR
BMATN Number of firm's own (internal) inventory-managed material CHAR 40 0 MARA MPMAT
MPROF Mfr part profile CHAR 4 0 TMPPF MPROF
KZWSM Units of measure usage CHAR 1 0 KZWSO
SAITY Rollout in a Season CHAR 2 0 T6WSA SAITY
PROFL Dangerous Goods Indicator Profile CHAR 3 0 TDG41 ADGE_PROFL
IHIVI Indicator: Highly Viscous CHAR 1 0 ADGE_IHIVI
ILOOS Indicator: In Bulk/Liquid CHAR 1 0 ADGE_ILOOS
SERLV Level of Explicitness for Serial Number CHAR 1 0 SERLV
KZGVH Packaging Material is Closed Packaging CHAR 1 0 KZGVH
XGCHP Approved Batch Record Required CHAR 1 0 XGCHP
KZEFF Assign effectivity parameter values/ override change numbers CHAR 1 0 CC_MTEFF
COMPL Material completion level NUMC 2 0 TCSCP_COMP_LVL CSCP_COMP_LVL
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
RDMHD Rounding rule for calculation of SLED CHAR 1 0 RDMHD
PRZUS Indicator: Product composition printed on packaging CHAR 1 0 PRZUS
MTPOS_MARA General item category group CHAR 4 0 TPTM MTPOS_MARA
BFLME Generic Material with Logistical Variants CHAR 1 0 BFLME
MATFI Material Is Locked CHAR 1 0 MATFI
CMREL Relevant for Configuration Management CHAR 1 0 DE_CM_RELEVANCE_FLAG
BBTYP Assortment List Type CHAR 1 0 * BBTYP
SLED_BBD Expiration Date CHAR 1 0 SLED_BBD
GTIN_VARIANT Global Trade Item Number Variant CHAR 2 0 GTIN_VARIANT
GENNR Material Number of the Generic Material in Prepack Materials CHAR 40 0 MARA WSTR_SATNR_PP
RMATP Reference material for materials packed in same way CHAR 40 0 MARA PL_RMATP
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant CHAR 1 0 GDS_RELEVANT
WEORA Acceptance At Origin CHAR 1 0 WEORA
HUTYP_DFLT Standard HU Type CHAR 4 0 THUTYP CIFHUTYPDF
PILFERABLE Pilferable CHAR 1 0 CIFPILFRBL
WHSTC Warehouse Storage Condition CHAR 2 0 TWHSTC CIFWHSTC
WHMATGR Warehouse Material Group CHAR 4 0 TWHMATGR CIFWHMATGR
HNDLCODE Handling Indicator CHAR 4 0 THNDLCD CIFHDLCODE
HAZMAT Relevant for Hazardous Substances CHAR 1 0 CIFHAZMAT
HUTYP Handling Unit Type CHAR 4 0 THUTYP CIFHUTYP
TARE_VAR Variable Tare Weight CHAR 1 0 CIFTAREVAR
MAXC Maximum Allowed Capacity of Packaging Material DEC 15 3 CIFMAXC
MAXC_TOL Overcapacity Tolerance of the Handling Unit DEC 3 1 CIFMAXCTOL
MAXL Maximum Packing Length of Packaging Material QUAN 15 3 CIFMAXL
MAXB Maximum Packing Width of Packaging Material QUAN 15 3 CIFMAXB
MAXH Maximum Packing Height of Packaging Material QUAN 15 3 CIFMAXH
MAXDIM_UOM Unit of Measure for Maximum Packing Length/Width/Height UNIT 3 0 T006 CIFMAXDUOM
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
MFRGR Material freight group CHAR 8 0 TMFG MFRGR
QQTIME Quarantine Period QUAN 3 0 CIFQQTIME
QQTIMEUOM Time Unit for Quarantine Period UNIT 3 0 T006 CIFQQTIMEUOM
QGRP Quality Inspection Group CHAR 4 0 TQGRP CIFQGRP
SERIAL Serial Number Profile CHAR 4 0 TSERIAL CIFSERIAL
PS_SMARTFORM Form Name CHAR 30 0 STXFADM CIFPSSFNAME
LOGUNIT EWM CW: Logistics Unit of Measure UNIT 3 0 MARM CIFLOGUNIT
CWQREL EWM CW: Material Is a Catch Weight Material CHAR 1 0 CIFCWQREL
CWQPROC EWM CW: Catch Weight Profile for Entering CW Quantity CHAR 2 0 TCWQPROC CIFCWQPROC
CWQTOLGR Catch Weight Tolerance Group CHAR 9 0 TCWQTOLGR CIFCWQTOLGR
ADPROF Adjustment Profile CHAR 3 0 /SCWM/TMEDI_AP CIFADPROF
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CHAR 40 0 CRM_PRODUCT_ID_IP
ALLOW_PMAT_IGNO Variant Price Allowed (for Material Master) CHAR 1 0 WPM_ALLOW_PMAT_IGNO_MAT
MEDIUM Medium CHAR 6 0 T372M MEDIU
COMMODITY Commodity CHAR 18 0 TBAC_PHYSCOMM TBA_STOEFFCHEN
ANIMAL_ORIGIN Indicator: Contains Non-Textile Parts of Animal Origin CHAR 1 0 WRF_ANIMAL_ORIGIN_FLAG
TEXTILE_COMP_IND Indicator: New Textile Composition Function CHAR 1 0 WRF_TEXTL_COMP_IND
LAST_CHANGED_TIME Time of Last Change TIMS 6 0 LAST_CHANGED_TIME
MATNR_EXTERNAL External Representation of Material Number CHAR 40 0 MATNR_EXTERNAL
CHML_CMPLNC_RLVNCE_IND Chemical Compliance Relevance Indicator CHAR 1 0 CHML_CMPLNC_RLVNCE_IND
LOGISTICAL_MAT_CATEGORY Category of a Logistical Material CHAR 1 0 DE_LOGISTICAL_MAT_CATEGORY
SALES_MATERIAL Material Number of a Sales Material CHAR 40 0 MARA DE_SALES_MATERIAL
IDENTIFICATION_TAG_TYPE Identification Tag Type CHAR 2 0 IDENTIFICATIONTAGTYPE
SGT_CSGR Segmentation Structure CHAR 4 0 SGT_CSGR_T SGT_CSGR
SGT_COVSA Segmentation Strategy CHAR 8 0 SGT_COVS_T SGT_COVSA
SGT_STAT Segmentation Material Master Status CHAR 1 0 SGT_STATD
SGT_SCOPE Segmentation Strategy Scope CHAR 1 0 SGT_SCOPE
SGT_REL Segmentation Relevant CHAR 1 0 SGT_REL
ANP ANP Code NUMC 9 0 J_1BTANP J_1BANP
PSM_CODE Code of Protected Species Management CHAR 2 0 * WRF_PSM_CODE
FSH_MG_AT1 Fashion Information Field: 1 CHAR 10 0 FSH_MG_ATTRIBUTE1
FSH_MG_AT2 Fashion Information Field: 2 CHAR 10 0 FSH_MG_ATTRIBUTE2
FSH_MG_AT3 Fashion Information Field: 3 CHAR 6 0 FSH_MG_ATTRIBUTE3
FSH_SEALV Indicator: Use of Season CHAR 1 0 FSH_SEALV
FSH_SEAIM Indicator: Season Active in Inventory Management CHAR 1 0 FSH_SEAIM
FSH_SC_MID Material Conversion ID for Characteristic Value Conversion CHAR 2 0 FSH_SC_VCIDS FSH_SC_MID
DUMMY_PRD_INCL_EEW_PS Dummy Field CHAR 1 0 PRD_INCL_EEW
ZZ1_CUSTOMFIELDHIGHRIS_PRD Custom Field: High Risk ? CHAR 1 0 ZZ1_CUSTOMFIELDHIGHRIS
ZZ1_CUSTOMFIELDRISKMIT_PRD Custom Field: Risk Mitigation CHAR 80 0 ZZ1_CUSTOMFIELDRISKMIT
ZZ1_CUSTOMFIELDRISKREA_PRD Custom Field: Risk Reason CHAR 80 0 ZZ1_CUSTOMFIELDRISKREA
SCM_MATID_GUID16 Internal Key for Product RAW 16 0 /SCMB/MDL_MATID
SCM_MATID_GUID22 Internal Number (UID) for Product CHAR 22 0 /SAPAPO/MATID
SCM_MATURITY_DUR Maturation Time DEC 11 0 /SAPAPO/MATURITY_DUR
SCM_SHLF_LFE_REQ_MIN Obsolete. Use /SAPAPO/MATKEY-/SAPAPO/SHELF_LIFE_REQ_MIN. DEC 11 0 PRD_SCM_SHELF_LIFE_REQ_MIN
SCM_SHLF_LFE_REQ_MAX Required Maximum Shelf Life DEC 11 0 /SAPAPO/SHELF_LIFE_REQ_MAX
SCM_PUOM Preferred Alternative UoM for Warehouse Operations UNIT 3 0 T006 /SCWM/DE_PUOM
RMATP_PB Reference Product for Package Building CHAR 40 0 /SAPAPO/MATNR_RMATP_PB
PROD_SHAPE Product Shape CHAR 2 0 /SAPAPO/PROD_SHAPE
MO_PROFILE_ID Product Orientation Profile CHAR 20 0 /SCMB/MO_PROFILE_ID
OVERHANG_TRESH Overhang Threshold [%] DEC 5 2 /SAPAPO/OVERHANG_TRESH
BRIDGE_TRESH Bridge Threshold [%] DEC 5 2 /SAPAPO/BRIDGE_TRESH
BRIDGE_MAX_SLOPE Maximum Slope for Bridges [°] DEC 5 2 /SAPAPO/BRIDGE_MAX_SLOPE
HEIGHT_NONFLAT Absolute Height Threshold for Stacking on Non-Flat Surface QUAN 13 3 /SAPAPO/HEIGHT_NONFLAT
HEIGHT_NONFLAT_UOM UoM of Abs. Height Threshold (Stacking on Non-Flat Surface) UNIT 3 0 * /SAPAPO/HEIGHT_NONFLAT_UOM
SCM_KITCOMP Product for Kit-to-Order CHAR 1 0 /SAPAPO/CMPKIT
SCM_PROD_PAOOPT Product can be used for Procure-to-Order CHAR 1 0 /SAPAPO/PAOOPT
SCM_BOD_DEPLVL Carry Out Push Deployment from Supplier CHAR 1 0 /SAPAPO/BODDEPLVL
SCM_RESTRICT_INVBAL Inventory Balancing Not Allowed CHAR 1 0 /SAPAPO/RESTRICT_INVBAL
SCM_DRP_GL_STOCK Global Stock on Entry Location DRP CHAR 1 0 /SAPAPO/DRP_GL_STOCK
SCM_EXCL_EXPEDITE Exclude from Express Shipment CHAR 1 0 /SAPAPO/EXCLEXP
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/VALUM Valuation Unit of Measure UNIT 3 0 * /CWM/VALUM
/CWM/TOLGR Tolerance Group for CWM CHAR 9 0 * /CWM/TOLGR
/CWM/TARA Consider Complete Tare for each Reference Unit of Measure CHAR 1 0 /CWM/TARA
/CWM/TARUM Reference Unit of Measure for the TARE Calculation UNIT 3 0 T006 /CWM/TARUM
/BEV1/LULEINH Loading Units NUMC 8 0 /BEV1/LULEINH
/BEV1/LULDEGRP Loading Unit Group: IS Beverage CHAR 3 0 /BEV1/LUT906 /BEV1/LULDEGRP
/BEV1/NESTRUCCAT Structure Category for Material Relationship CHAR 1 0 /BEV1/NESTRUC_CAT
/DSD/SL_TOLTYP Tolerance Type ID CHAR 4 0 /DSD/SL_TGTYP /DSD/SL_TOLTYP_ID
/DSD/SV_CNT_GRP Counting Group CHAR 10 0 /DSD/SV_CNTGR /DSD/SV_COUNT_GROUP
/DSD/VC_GROUP DSD Grouping CHAR 6 0 /DSD/VC_GRP /DSD/VC_GROUP
/SAPMP/KADU Cable Diameter DEC 7 2 /SAPMP/KADU
/SAPMP/ABMEIN Unit for Dimensions UNIT 3 0 * /SAPMP/ABMEIN
/SAPMP/KADP Cable Diameter Allowance in Percent DEC 5 2 /SAPMP/KADP
/SAPMP/BRAD Bending Factor DEC 4 0 /SAPMP/BRAD
/SAPMP/SPBI Inner Width DEC 7 2 /SAPMP/SPBI
/SAPMP/TRAD Outer Diameter DEC 7 2 /SAPMP/TRAD
/SAPMP/KEDU Core Diameter DEC 7 2 /SAPMP/KEDU
/SAPMP/SPTR Load Capacity QUAN 13 3 /SAPMP/SPTR
/SAPMP/FBDK Run-Out Flange Thickness DEC 7 2 /SAPMP/FBDK
/SAPMP/FBHK R-O Flange Height DEC 7 2 /SAPMP/FBHK
/SAPMP/RILI Coil Delivery CHAR 1 0 /SAPMP/RILI
/SAPMP/FBAK Run-Out Flange CHAR 1 0 /SAPMP/FBAK
/SAPMP/AHO Maximum Number of Vertical Layers NUMC 3 0 /SAPMP/AHO
/SAPMP/MIFRR Smallest Permissible Reel Clearance for a Cable DEC 7 2 /SAPMP/MIFRR
/STTPEC/SERTYPE Serialization Type INT1 3 0 /STTPEC/E_SERTYPE
/STTPEC/SYNCACT Synchronization Active CHAR 1 0 /STTPEC/E_SYNCACTIVE
/STTPEC/SYNCTIME Synchronization Time Stamp DEC 15 0 /STTPEC/E_SYNCTIME
/STTPEC/SYNCCHG Indicator Changed Since Integration CHAR 1 0 /STTPEC/E_SERCHG
/STTPEC/COUNTRY_REF Profile Relevant Country/Region CHAR 3 0 * /STTPEC/E_PR_REL_COUNTRY
/STTPEC/PRDCAT Product Category CHAR 10 0 * /STTPEC/E_PRDCAT
/VSO/R_TILT_IND Material may be Tilted (Vehicle Space Optimization) CHAR 1 0 /VSO/M_TILT_IND
/VSO/R_STACK_IND Stacking not Allowed (VSO) CHAR 1 0 /VSO/M_STACK_IND
/VSO/R_BOT_IND Bottom Layer (Vehicle Space Optimization) CHAR 1 0 /VSO/M_BOTTOM_IND
/VSO/R_TOP_IND Top Layer (VSO) CHAR 1 0 /VSO/M_TOP_IND
/VSO/R_STACK_NO Stacking Factor (Vehicle Space Optimization) NUMC 3 0 /VSO/M_STACK_NO
/VSO/R_PAL_IND Load without Packaging Material (VSO) CHAR 1 0 /VSO/M_PALLET_IND
/VSO/R_PAL_OVR_D Permissible Overhang (Depth) of Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_OVR_D
/VSO/R_PAL_OVR_W Permissible Overhang (Width) of Shipping Material (VSO) QUAN 13 3 /VSO/R_PAL_OVR_W
/VSO/R_PAL_B_HT Maximum Stacking Height of the Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_BIN_HGT
/VSO/R_PAL_MIN_H Minimum Stacking Height of the Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_MIN_HT
/VSO/R_TOL_B_HT Tolerance to Exceed the Max. Stacking Height (VSO) QUAN 13 3 /VSO/R_TOL_BIN_HT
/VSO/R_NO_P_GVH Number of Materials for each Closed PKM (VSO) NUMC 2 0 /VSO/M_ANZ_PER_GVH
/VSO/R_QUAN_UNIT Unit of Measure Vehicle Space Optimization UNIT 3 0 /VSO/R_QUAN_UNIT
/VSO/R_KZGVH_IND Closed Packaging Material Required (VSO) CHAR 1 0 /VSO/M_KZGVH_IND
PACKCODE Packaging Code CHAR 10 0 CCUNC121 CBUNE_PACODE
DG_PACK_STATUS Dangerous Goods Packaging Status CHAR 10 0 TDG101 ADGE_DG_PACK_STATUS
SRV_DURA Duration of Work QUAN 13 3 CRMT_PR_DURATION
SRV_DURA_UOM Unit for Duration of Work UNIT 3 0 T006 CRMT_PR_DURATION_UOM
SRV_SERWI Service Profile CHAR 10 0 CRMD_SERWI SRV_SERWI
SRV_ESCAL Response Profile CHAR 10 0 CRMD_ESCAL SRV_ESCAL
SOM_CYCLE Billing Cycle CHAR 4 0 TFK2607 CYCLE_KK
SOM_CYCLE_RULE Billing Cycle Determination Rule ID CHAR 4 0 CRMC_ISX_BCDETR CRM_ISX_CYCLE_RULE
SOM_TC_SCHEMA Assignment Schema CHAR 2 0 CRMS4C_SOM_TRAS CRMT_TC_SCHEMA
SOM_CTR_AUTORENEWAL Contract Auto Renewal Indicator CHAR 1 0 CRMS4_SOM_CTR_AUTORENEWAL
MCOND Material Condition Management CHAR 1 0 DFPS_MCOND
RETDELC Return Code CHAR 1 0 * DFPS_RETDELC
LOGLEV_RETO Return to Logistics Level CHAR 1 0 * DFPS_LOGLEV_RETO
NSNID NATO Stock Number CHAR 9 0 DFPS_NSNID
ICFA Interchangeability Code for Ammunition CHAR 8 0 DFS_ICFA
RIC_ID Reportable Item Code - Numerical ID INT8 19 0 /ISDFPS/RIC_ID
DFS_SENSITIVITY_KEY Sensitivity for Characteristics CHAR 4 0 * DFS_SENSITIVITY_KEY
DFS_MFRP2 Long Manufacturer Part Number CHAR 60 0 DFS_MFRP2
OVLPN Overlength Part Number CHAR 32 0 ADSPC_OPN
ADSPC_SPC Spare Part Class Code NUMC 1 0 ADSPC_SPC
VARID GUID Variable Object Identification RAW 16 0 DI_VARID
MSBOOKPARTNO Manufacturer Book Part Number CHAR 40 0 DIMP_DRM_MSBOOKPART
TOLERANCE_TYPE Tolerance Type CHAR 4 0 * LMD_MDE_TOLERANCE_TYPE
DPCBT Single-Unit Batch Def. Value CHAR 1 0 MILL_DPCBT
XGRDT Goods Receipt to Posted Single-Unit Batch Allowed CHAR 1 0 MILL_XGRDT
IMATN FFF class CHAR 40 0 IMATN
PICNUM Supersession chain number CHAR 40 0 PIC_PICNUM_SUS
BSTAT Creation Status - Seasonal Procurement CHAR 2 0 WRFMATBSTAT WRFBSTAT
COLOR_ATINN Internal Charactieristic Number for Color Characteristics NUMC 10 0 * WRF_COLOR_ATINN
SIZE1_ATINN Internal Char. Number for Characteristics for Main Sizes NUMC 10 0 * WRF_SIZE1_ATINN
SIZE2_ATINN Internal Char. Number for Characteristics for Second Sizes NUMC 10 0 * WRF_SIZE2_ATINN
COLOR Characteristic Value for Colors of Variants CHAR 18 0 WRF_COLOR
SIZE1 Characteristic Value for Main Sizes of Variants CHAR 18 0 WRF_SIZE1
SIZE2 Characteristic Value for Second Size for Variants CHAR 18 0 WRF_SIZE2
FREE_CHAR Characteristic Value for Evaluation Purposes CHAR 18 0 WRF_FREE_CHAR
CARE_CODE Care Codes (such as Washing Code, Ironing Code, etc.) CHAR 16 0 WRF_CARE_CODE
BRAND_ID Brand CHAR 4 0 WRF_BRANDS WRF_BRAND_ID
FIBER_CODE1 Fiber Code for Textiles (Component 1) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_1
FIBER_PART1 Percentage Share of Fiber (Component 1) NUMC 3 0 WRF_FIBER_PART_1
FIBER_CODE2 Fiber Code for Textiles (Component 2) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_2
FIBER_PART2 Percentage Share of Fiber (Component 2) NUMC 3 0 WRF_FIBER_PART_2
FIBER_CODE3 Fiber Code for Textiles (Component 3) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_3
FIBER_PART3 Percentage Share of Fiber (Component 3) NUMC 3 0 WRF_FIBER_PART_3
FIBER_CODE4 Fiber Code for Textiles (Component 4) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_4
FIBER_PART4 Percentage Share of Fiber (Component 4) NUMC 3 0 WRF_FIBER_PART_4
FIBER_CODE5 Fiber Code for Textiles (Component 5) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_5
FIBER_PART5 Percentage Share of Fiber (Component 5) NUMC 3 0 WRF_FIBER_PART_5
FASHGRD Fashion Grade CHAR 4 0 T6WFG FASHGRD
/ Relationships

MARA foreign keys.

Table Field Check Table Description Check Field
MARA /CWM/TARUM T006 Units of Measurement MANDT
MARA BEHVO T144 Container Requirements for Storing Materials MANDT
MARA BEHVO T144 Container Requirements for Storing Materials BEHVO
MARA BMATN MARA General Material Data MANDT
MARA BMATN MARA General Material Data MATNR
MARA BRAND_ID WRF_BRANDS Markers MANDT
MARA BRAND_ID WRF_BRANDS Markers BRAND_ID
MARA BSTAT WRFMATBSTAT Creation Status - Seasonal Procurement MANDT
MARA BSTAT WRFMATBSTAT Creation Status - Seasonal Procurement BSTAT
MARA BSTME T006 Units of Measurement MANDT
MARA BWSCL TMBW1 Source of Supply Keys MANDT
MARA BWSCL TMBW1 Source of Supply Keys BWSCL
MARA BWVOR T6WP1 Check table, supply source entry MANDT
MARA COMMODITY TBAC_PHYSCOMM Customizing table for physical commodities COMMODITY
MARA COMPL TCSCP_COMP_LVL Material completion levels (including their sequence) MANDT
MARA CWQPROC TCWQPROC EWM-CW: EWM-CW: Catch Weight Quantity Input Control MANDT
MARA CWQPROC TCWQPROC EWM-CW: EWM-CW: Catch Weight Quantity Input Control CWQPROC
MARA CWQTOLGR TCWQTOLGR EWM-CW: Tolerance Groups MANDT
MARA DG_PACK_STATUS TDG101 Dangerous Goods Packaging Status MANDT
MARA DG_PACK_STATUS TDG101 Dangerous Goods Packaging Status DG_PACK_STATUS
MARA EKWSL T405 Purchasing Value Key MANDT
MARA EKWSL T405 Purchasing Value Key EKWSL
MARA ERGEI T006 Units of Measurement MANDT
MARA ERVOE T006 Units of Measurement MANDT
MARA ETIAG TWEA IS-R Labeling: Check Table Material Groups MANDT
MARA ETIAR T6WP3 Check Table for Labelling Type ETIAR
MARA ETIFO T6WP4 Check Table for Label Shape MANDT
MARA ETIFO T6WP4 Check Table for Label Shape ETIFO
MARA EXTWG TWEW External Material Groups MANDT
MARA FASHGRD T6WFG Degree of Fashion MANDT
MARA FIBER_CODE1 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
MARA FIBER_CODE2 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
MARA FIBER_CODE3 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
MARA FIBER_CODE4 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
MARA FIBER_CODE5 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
MARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs MANDT
MARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_IDT
MARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_ID
MARA GENNR MARA General Material Data MANDT
MARA GENNR MARA General Material Data MATNR
MARA GEWEI T006 Units of Measurement MANDT
MARA GEWEI T006 Units of Measurement MSEHI
MARA HERKL T005 Countries MANDT
MARA HERKL T005 Countries LAND1
MARA HNDLCODE THNDLCD Handling Indicator MANDT
MARA HNDLCODE THNDLCD Handling Indicator HNDLCODE
MARA HUTYP THUTYP Handling Unit Types MANDT
MARA HUTYP THUTYP Handling Unit Types HUTYP
MARA HUTYP_DFLT THUTYP Handling Unit Types MANDT
MARA HUTYP_DFLT THUTYP Handling Unit Types HUTYP
MARA INHME T006 Units of Measurement MANDT
MARA KOSCH T190S Product Allocation: Definition Procedure MANDT
MARA KOSCH T190S Product Allocation: Definition Procedure KOSCH
MARA KUNNR V_KNA1WETT Generated Table for View KUNNR
MARA LABOR T024L Laboratory/office for material MANDT
MARA LOGUNIT MARM Units of Measure for Material MANDT
MARA LOGUNIT MARM Units of Measure for Material MEINH
MARA MAGRV TVEGR Material Group: Packaging Materials MANDT
MARA MAGRV TVEGR Material Group: Packaging Materials MAGRV
MARA MANDT T000 Clients MANDT
MARA MATKL T023 Material Groups MATKL
MARA MAXDIM_UOM T006 Units of Measurement MANDT
MARA MBRSH T137 Industries for materials MANDT
MARA MEABM T006 Units of Measurement MANDT
MARA MEDIUM T372M Medium MANDT
MARA MEDIUM T372M Medium MEDIU
MARA MEINS T006 Units of Measurement MANDT
MARA MEINS T006 Units of Measurement MSEHI
MARA MFRGR TMFG Material freight groups MANDT
MARA MFRGR TMFG Material freight groups MFRGR
MARA MFRNR LFA1 Supplier Master (General Section) MANDT
MARA MFRNR LFA1 Supplier Master (General Section) LIFNR
MARA MPROF TMPPF Control Profile for Manufacturer Part Number Management MPROF
MARA MSTAE T141 Material Status from Materials Management/PPC View MANDT
MARA MSTAE T141 Material Status from Materials Management/PPC View MMSTA
MARA MSTAV TVMS Materials: Status in Sales and Distribution MANDT
MARA MSTAV TVMS Materials: Status in Sales and Distribution VMSTA
MARA MTART T134 Material Types MANDT
MARA MTART T134 Material Types MTART
MARA MTPOS_MARA TPTM Materials: Item Category Groups in Material Master MTPOS
MARA NUMTP TNTP International Article Number (EAN) Categories MANDT
MARA NUMTP TNTP International Article Number (EAN) Categories NUMTP
MARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) MANDT
MARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) LWDG
MARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) PACKCODE
MARA PLGTP TWPT Price band categories MANDT
MARA PLGTP TWPT Price band categories PLGTP
MARA PMATA MARA General Material Data MANDT
MARA PMATA MARA General Material Data MATNR
MARA PRDHA T179 Materials: Product Hierarchies PRODH
MARA PROFL TDG41 DG: DG Indicator Profiles for Material Master MANDT
MARA PROFL TDG41 DG: DG Indicator Profiles for Material Master PROFL
MARA PS_SMARTFORM STXFADM Smart Forms: Administration FORMNAME
MARA QGRP TQGRP Quality Inspection Group MANDT
MARA QGRP TQGRP Quality Inspection Group QGRP
MARA QQTIMEUOM T006 Units of Measurement MANDT
MARA RAUBE T142 Storage Conditions for Materials MANDT
MARA RAUBE T142 Storage Conditions for Materials RAUBE
MARA RBNRM T352B Technical report MANDT
MARA RMATP MARA General Material Data MANDT
MARA RMATP MARA General Material Data MATNR
MARA SAISO T6WSP Check Table for Season Indicator MANDT
MARA SAISO T6WSP Check Table for Season Indicator SAISO
MARA SAITY T6WSA Categories of seasonal materials MANDT
MARA SAITY T6WSA Categories of seasonal materials SAITY
MARA SALES_MATERIAL MARA General Material Data MANDT
MARA SALES_MATERIAL MARA General Material Data MATNR
MARA SATNR MARA General Material Data MATNR
MARA SCM_PUOM T006 Units of Measurement MANDT
MARA SERIAL TSERIAL Serial Number Profile MANDT
MARA SERIAL TSERIAL Serial Number Profile SERIAL
MARA SGT_COVSA SGT_COVS_T Segmentation Strategies MANDT
MARA SGT_COVSA SGT_COVS_T Segmentation Strategies WERKS
MARA SGT_CSGR SGT_CSGR_T Segmentation Structures MANDT
MARA SOM_CYCLE TFK2607 Billing Cycles CYCLE
MARA SOM_CYCLE_RULE CRMC_ISX_BCDETR Billing Cycle Determination Rules CLIENT
MARA SOM_CYCLE_RULE CRMC_ISX_BCDETR Billing Cycle Determination Rules RULE_ID
MARA SOM_TC_SCHEMA CRMS4C_SOM_TRAS Assignment Schema for Technical Resources ASSIGN_SCHEMA
MARA SPART TSPA Organizational Unit: Sales Divisions MANDT
MARA SPART TSPA Organizational Unit: Sales Divisions SPART
MARA SRV_DURA_UOM T006 Units of Measurement MANDT
MARA SRV_ESCAL CRMD_ESCAL Service Response Time Schema SRV_ESCAL
MARA SRV_SERWI CRMD_SERWI Service Availability Profile SRV_SERWI
MARA STOFF MGEF Hazardous materials MANDT
MARA STOFF MGEF Hazardous materials STOFF
MARA STOFF MGEF Hazardous materials REGKZ
MARA TAKLV TSKM Material Taxes MANDT
MARA TAKLV TSKM Material Taxes TATYP
MARA TEMPB T143 Temperature Conditions for Storing Materials MANDT
MARA TEMPB T143 Temperature Conditions for Storing Materials TEMPB
MARA TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
MARA VHART TVTY Packaging Material Types MANDT
MARA VHART TVTY Packaging Material Types TRATY
MARA VOLEH T006 Units of Measurement MANDT
MARA VOLEH T006 Units of Measurement MSEHI
MARA WHMATGR TWHMATGR Warehouse Material Group MANDT
MARA WHMATGR TWHMATGR Warehouse Material Group WHMATGR
MARA WHSTC TWHSTC Warehouse Storage Condition WHSTC
Back to SAP tables