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're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR 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
Not active
1 Active
2 Active with own price
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
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
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
Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
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
Variants priceable diff.; do not propose GMaterial as ref.
1 Variants priceable differently; propose GMaterial as ref.
2 All variants have the sales price of the generic material
NRFHG Material qualifies for discount in kind CHAR 1 0 NRFHG
Not eligible for discount in kind
1 Eligible for discount in kind for purchasing and sales
2 Eligible for discount in kind only for purchasing
3 Eligible for discount in kind only for sales
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
Alternative unit of measure
A Proportion unit
B Product unit
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
Serialization within the stock material number
1 Keep equipment number and serial number synchronous
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
Day
1 Week
2 Month
3 Year
RDMHD Rounding rule for calculation of SLED CHAR 1 0 RDMHD
No rounding off
+ End of chosen period (week, month or year)
- Start of chosen period (week, month or year)
F Start of the following period (week, month, year)
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
Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
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
B Expiration Date
E Shelf Life Expiration Date
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
No Animal Origin
X Contains Non-Textile Parts of Animal Origin
TEXTILE_COMP_IND Indicator: New Textile Composition Function CHAR 1 0 WRF_TEXTL_COMP_IND
New Textile Comp. Funct. not active
X New Textile Comp. Funct. is active
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
Not Decided
N No
Y Yes
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
No Identification Tag
01 RFID Tag
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
1 Requirement and Stock Segments maintained
2 Only Requirement Segments maintained
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
Do not use Season Year / Season
C Season Year / Season / Collection
S Use Season Year / Season
T Season Year / Season / Collection / Theme
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
Cuboid (Default)
01 Cylinder – Axis along Length
02 Cylinder – Axis along Width
03 Cylinder – Axis along Height
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
No structure
F Full Product
S Structured Empties
/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
No Selection, can be changed
1 Set to Yes, can be changed
2 Not relevant for Auto Renewal
3 Set to Yes, cannot be changed
MCOND Material Condition Management CHAR 1 0 DFPS_MCOND
No Condition Management
1 Condition Management Only
2 Condition Management with Batch Number
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
0 Reference item
1 Expendable spare
2 Repairable spare, having a supporting CMM
6 Repairable spare, not having a supporting CMM
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
Single-Unit Batches not Allowed
A Single-Unit Batches Allowed, but not Proposed
B Single-Unit Batches Allowed and Proposed
C Handled in Single-Unit Batches
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

MARA foreign key relationships

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