SAP table MARAV (Generated Table for View)

SAP table MARAV has 3 primary key fields being MANDT,MATNR,SPRAS.

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
SPRAS Language Key LANG 1 0 T002 SPRAS
ERSDA Created On DATS 8 0 ERSDA
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
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
KUNNR Competitor CHAR 10 0 V_KNA1WETT WETTB
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
ETIFO Label form CHAR 2 0 T6WP4 ETIFO
ETIAR Label type CHAR 2 0 T6WP3 ETIAR
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
MAKTX Material Description CHAR 40 0 MAKTX
MAKTG Material Description in Uppercase for Matchcodes CHAR 40 0 MAKTG
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
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
KZKUP Indicator: Material can be co-product CHAR 1 0 KZKUPMAT
KZNFM Indicator: The material has a follow-up material CHAR 1 0 KZNFM
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
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
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
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
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
BWSCL Source of Supply CHAR 1 0 TMBW1 BWSCL
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
KOSCH Product allocation determination procedure CHAR 18 0 T190S KOSCH
CUOBF Internal object number NUMC 18 0 CUOBM
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
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
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
WEORA Acceptance At Origin CHAR 1 0 WEORA
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CHAR 40 0 CRM_PRODUCT_ID_IP
MEDIUM Medium CHAR 6 0 T372M MEDIU
COMMODITY Commodity CHAR 18 0 TBAC_PHYSCOMM TBA_STOEFFCHEN
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_REL Segmentation Relevant CHAR 1 0 SGT_REL
/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

MARAV foreign key relationships

Table Field Check Table Check Field
0 MARAV BEHVO T144 Container Requirements for Storing Materials MANDT
0 MARAV BEHVO T144 Container Requirements for Storing Materials BEHVO
1 MARAV BMATN MARA General Material Data MATNR
0 MARAV BSTME T006 Units of Measurement MANDT
1 MARAV BWSCL TMBW1 Source of Supply Keys MANDT
1 MARAV BWSCL TMBW1 Source of Supply Keys BWSCL
0 MARAV COMMODITY TBAC_PHYSCOMM Customizing table for physical commodities COMMODITY
1 MARAV COMPL TCSCP_COMP_LVL Material completion levels (including their sequence) MANDT
0 MARAV EKWSL T405 Purchasing Value Key MANDT
0 MARAV EKWSL T405 Purchasing Value Key EKWSL
1 MARAV ERGEI T006 Units of Measurement MANDT
0 MARAV ERVOE T006 Units of Measurement MANDT
1 MARAV ETIAG TWEA IS-R Labeling: Check Table Material Groups MANDT
0 MARAV ETIAR T6WP3 Check Table for Labelling Type ETIAR
1 MARAV ETIFO T6WP4 Check Table for Label Shape MANDT
1 MARAV ETIFO T6WP4 Check Table for Label Shape ETIFO
0 MARAV EXTWG TWEW External Material Groups MANDT
1 MARAV GENNR MARA General Material Data MATNR
0 MARAV GEWEI T006 Units of Measurement MANDT
0 MARAV GEWEI T006 Units of Measurement MSEHI
1 MARAV INHME T006 Units of Measurement MANDT
0 MARAV KOSCH T190S Product Allocation: Definition Procedure MANDT
0 MARAV KOSCH T190S Product Allocation: Definition Procedure KOSCH
1 MARAV KUNNR V_KNA1WETT Generated Table for View KUNNR
0 MARAV LABOR T024L Laboratory/office for material MANDT
1 MARAV MAGRV TVEGR Material Group: Packaging Materials MANDT
1 MARAV MAGRV TVEGR Material Group: Packaging Materials MAGRV
0 MARAV MANDT T000 Clients MANDT
1 MARAV MATKL T023 Material Groups MATKL
0 MARAV MBRSH T137 Industries for materials MANDT
1 MARAV MEABM T006 Units of Measurement MANDT
0 MARAV MEDIUM T372M Medium MANDT
0 MARAV MEDIUM T372M Medium MEDIU
1 MARAV MEINS T006 Units of Measurement MANDT
1 MARAV MEINS T006 Units of Measurement MSEHI
0 MARAV MFRNR LFA1 Supplier Master (General Section) MANDT
0 MARAV MFRNR LFA1 Supplier Master (General Section) LIFNR
1 MARAV MPROF TMPPF Control Profile for Manufacturer Part Number Management MPROF
0 MARAV MSTAE T141 Material Status from Materials Management/PPC View MANDT
0 MARAV MSTAE T141 Material Status from Materials Management/PPC View MMSTA
1 MARAV MSTAV TVMS Materials: Status in Sales and Distribution MANDT
1 MARAV MSTAV TVMS Materials: Status in Sales and Distribution VMSTA
0 MARAV MTART T134 Material Types MANDT
0 MARAV MTART T134 Material Types MTART
1 MARAV MTPOS_MARA TPTM Materials: Item Category Groups in Material Master MTPOS
0 MARAV NUMTP TNTP International Article Number (EAN) Categories MANDT
0 MARAV NUMTP TNTP International Article Number (EAN) Categories NUMTP
1 MARAV PLGTP TWPT Price band categories MANDT
1 MARAV PLGTP TWPT Price band categories PLGTP
0 MARAV PMATA MARA General Material Data MANDT
0 MARAV PMATA MARA General Material Data MATNR
1 MARAV PRDHA T179 Materials: Product Hierarchies PRODH
0 MARAV PROFL TDG41 DG: DG Indicator Profiles for Material Master MANDT
0 MARAV PROFL TDG41 DG: DG Indicator Profiles for Material Master PROFL
1 MARAV RAUBE T142 Storage Conditions for Materials MANDT
1 MARAV RAUBE T142 Storage Conditions for Materials RAUBE
0 MARAV RBNRM T352B Technical report MANDT
1 MARAV RMATP MARA General Material Data MANDT
1 MARAV RMATP MARA General Material Data MATNR
0 MARAV SAITY T6WSA Categories of seasonal materials MANDT
0 MARAV SAITY T6WSA Categories of seasonal materials SAITY
1 MARAV SATNR MARA General Material Data MATNR
0 MARAV SGT_COVSA SGT_COVS_T Segmentation Strategies MANDT
0 MARAV SGT_COVSA SGT_COVS_T Segmentation Strategies WERKS
1 MARAV SGT_CSGR SGT_CSGR_T Segmentation Structures MANDT
0 MARAV SPART TSPA Organizational Unit: Sales Divisions MANDT
0 MARAV SPART TSPA Organizational Unit: Sales Divisions SPART
1 MARAV STOFF MGEF Hazardous materials MANDT
1 MARAV STOFF MGEF Hazardous materials STOFF
1 MARAV STOFF MGEF Hazardous materials REGKZ
0 MARAV TAKLV TSKM Material Taxes MANDT
0 MARAV TAKLV TSKM Material Taxes TATYP
1 MARAV TEMPB T143 Temperature Conditions for Storing Materials MANDT
1 MARAV TEMPB T143 Temperature Conditions for Storing Materials TEMPB
0 MARAV TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
1 MARAV VHART TVTY Packaging Material Types MANDT
1 MARAV VHART TVTY Packaging Material Types TRATY
0 MARAV VOLEH T006 Units of Measurement MANDT
0 MARAV VOLEH T006 Units of Measurement MSEHI