1. Home
  2. Resources
  3. SAP Tables
  4. MARAV - Generated Table for View

SAP Table MARAV

Generated Table for View

MARAV (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MARAV to other SAP tables.

MARAV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
SPRAS Language Key SPRAS T002 LANG 1 0
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
VPSTA Maintenance status of complete material VPSTA CHAR 15 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
LVORM Flag Material for Deletion at Client Level LVOMA CHAR 1 0
X Yes
NULL No
MTART Material Type MTART T134 CHAR 4 0
MBRSH Industry sector MBRSH T137 CHAR 1 0
MATKL Material Group MATKL T023 CHAR 9 0
BISMT Old material number BISMT CHAR 18 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
BSTME Purchase Order Unit of Measure BSTME T006 UNIT 3 0
ZEINR Document number (without document management system) DZEINR CHAR 22 0
ZEIAR Document type (without Document Management system) DZEIAR CHAR 3 0
ZEIVR Document version (without Document Management system) DZEIVR CHAR 2 0
ZEIFO Page format of document (without Document Management system) DZEIFO CHAR 4 0
AESZN Document change number (without document management system) AESZN CHAR 6 0
BLATT Page number of document (without Document Management system) BLATT CHAR 3 0
BLANZ Number of sheets (without Document Management system) BLANZ NUMC 3 0
FERTH Production/inspection memo FERTH CHAR 18 0
FORMT Page Format of Production Memo FORMT CHAR 4 0
GROES Size/dimensions GROES CHAR 32 0
WRKST Basic Material WRKST TWSPR CHAR 48 0
NORMT Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
LABOR Laboratory/design office LABOR T024L CHAR 3 0
EKWSL Purchasing Value Key EKWSL T405 CHAR 4 0
BRGEW Gross Weight BRGEW QUAN 13 3
NTGEW Net Weight NTGEW QUAN 13 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
BEHVO Container requirements BEHVO T144 CHAR 2 0
RAUBE Storage conditions RAUBE T142 CHAR 2 0
TEMPB Temperature conditions indicator TEMPB T143 CHAR 2 0
DISST Low-Level Code DISST CHAR 3 0
TRAGR Transportation Group TRAGR TTGR CHAR 4 0
STOFF Hazardous material number STOFF MGEF CHAR 18 0
SPART Division SPART TSPA CHAR 2 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
NUMTP Category of International Article Number (EAN) NUMTP TNTP CHAR 2 0
LAENG Length LAENG QUAN 13 3
BREIT Width BREIT QUAN 13 3
HOEHE Height HOEHE QUAN 13 3
MEABM Unit of Dimension for Length/Width/Height MEABM T006 UNIT 3 0
PRDHA Product hierarchy PRODH_D T179 CHAR 18 0
KUNNR Competitor WETTB V_KNA1WETT CHAR 10 0
AEKLK Stock Transfer Net Change Costing CK_AEKLK CHAR 1 0
X Yes
NULL No
CADKZ CAD Indicator CADKZ CHAR 1 0
X Yes
NULL No
QMPUR QM in Procurement is Active QMPUR CHAR 1 0
X Yes
NULL No
ETIFO Label form ETIFO T6WP4 CHAR 2 0
ETIAR Label type ETIAR T6WP3 CHAR 2 0
ERGEW Allowed packaging weight ERGEW QUAN 13 3
ERGEI Unit of weight (allowed packaging weight) ERGEI T006 UNIT 3 0
ERVOL Allowed packaging volume ERVOL QUAN 13 3
ERVOE Volume unit (allowed packaging volume) ERVOE T006 UNIT 3 0
GEWTO Excess Weight Tolerance for Handling unit GEWTO DEC 3 1
VOLTO Excess Volume Tolerance of the Handling Unit VOLTO DEC 3 1
VABME Variable Purchase Order Unit Active VABME CHAR 1 0
NULL Not active
1 Active
2 Active with own price
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
MAKTG Material description in upper case for matchcodes MAKTG CHAR 40 0
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
VHART Packaging Material Type VHIART TVTY CHAR 4 0
FUELG Maximum level (by volume) FUELG DEC 3 0
STFAK Stacking factor STFAK INT2 5 0
MAGRV Material Group: Packaging Materials MAGRV TVEGR CHAR 4 0
BEGRU Authorization Group BEGRU CHAR 4 0
MLGUT Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZKUP Indicator: Material can be co-product KZKUPMAT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZNFM Indicator: The material has a follow-up material KZNFM CHAR 1 0
X Yes
NULL No
TAKLV Tax classification of the material TAKLV TSKM CHAR 1 0
RBNRM Catalog Profile RBNR T352B CHAR 9 0
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4 0
MHDHB Total shelf life MHDHB DEC 4 0
MHDLP Storage percentage MHDLP DEC 3 0
DATAB Valid-From Date DATAB DATS 8 0
LIQDT Deletion date LIQDT DATS 8 0
SAISJ Season Year SAISJ CHAR 4 0
PLGTP Price Band Category PLGTP TWPT CHAR 2 0
EXTWG External Material Group EXTWG TWEW CHAR 18 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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 PMATN MARA CHAR 18 0
MSTAE Cross-Plant Material Status MSTAE T141 CHAR 2 0
MSTAV Cross-distribution-chain material status MSTAV TVMS CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
MSTDV Date from which the X-distr.-chain material status is valid MSTDV DATS 8 0
INHME Content unit INHME T006 UNIT 3 0
INHAL Net contents INHAL QUAN 13 3
VPREH Comparison price unit VPREH DEC 5 0
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) ETIAG TWEA CHAR 18 0
INHBR Gross contents INHBR QUAN 13 3
BWSCL Source of Supply BWSCL TMBW1 CHAR 1 0
KZUMW Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
KOSCH Product allocation determination procedure KOSCH T190S CHAR 18 0
CUOBF Internal object number CUOBM NUMC 18 0
SPROF Pricing profile for variants SPROF CHAR 1 0
NULL 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 NRFHG CHAR 1 0
NULL 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 MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR LFA1 CHAR 10 0
BMATN Number of firm's own (internal) inventory-managed material MPMAT MARA CHAR 18 0
MPROF Manufacturer Part Profile MPROF TMPPF CHAR 4 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
SAITY Rollout in a Season SAITY T6WSA CHAR 2 0
PROFL Dangerous Goods Indicator Profile ADGE_PROFL TDG41 CHAR 3 0
IHIVI Indicator: Highly Viscous ADGE_IHIVI CHAR 1 0
X Yes
NULL No
ILOOS Indicator: In Bulk/Liquid ADGE_ILOOS CHAR 1 0
X Yes
NULL No
SERLV Level of Explicitness for Serial Number SERLV CHAR 1 0
NULL Serialization within the stock material number
1 Keep equipment number and serial number synchronous
KZGVH Packaging Material is Closed Packaging KZGVH CHAR 1 0
X Yes
NULL No
XGCHP Indicator: Approved batch record required XGCHP CHAR 1 0
X Yes
NULL No
KZEFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
COMPL Material completion level CSCP_COMP_LVL TCSCP_COMP_LVL NUMC 2 0
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
RDMHD Rounding rule for calculation of SLED RDMHD CHAR 1 0
NULL No rounding off
- Start of chosen period (week, month or year)
+ End of chosen period (week, month or year)
F Start of the following period (week, month, year)
PRZUS Indicator: Product composition printed on packaging PRZUS CHAR 1 0
X Yes
NULL No
MTPOS_MARA General item category group MTPOS_MARA TPTM CHAR 4 0
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
MATFI Material Is Locked MATFI CHAR 1 0
X Yes
NULL No
CMREL Relevant for Configuration Management DE_CM_RELEVANCE_FLAG CHAR 1 0
NULL Not relevant for Configuration Management
1 Relevant for Configuration Management
SLED_BBD Expiration Date SLED_BBD CHAR 1 0
B Expiration Date
E Shelf Life Expiration Date
GTIN_VARIANT Global Trade Item Number Variant GTIN_VARIANT CHAR 2 0
GENNR Material Number of the Generic Material in Prepack Materials WSTR_SATNR_PP MARA CHAR 18 0
RMATP Reference material for materials packed in same way PL_RMATP MARA CHAR 18 0
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant GDS_RELEVANT CHAR 1 0
X Yes
NULL No
MCOND Material Condition Management DFPS_MCOND CHAR 1 0
NULL No Condition Management
1 Condition Management Only
2 Condition Management with Batch Number
RETDELC Return Code DFPS_RETDELC CHAR 1 0
LOGLEV_RETO Return to Logistics Level DFPS_LOGLEV_RETO CHAR 1 0
NSNID NATO Stock Number DFPS_NSNID CHAR 9 0
WEORA Acceptance At Origin WEORA CHAR 1 0
X Yes
NULL No
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CRM_PRODUCT_ID_IP CHAR 40 0
MEDIUM Medium MEDIU T372M CHAR 6 0
COMMODITY Physical Commodity TBA_STOEFFCHEN TBAC_PHYSCOMM CHAR 18 0
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
OIGROUPNAM TD product group OIG_PCG TOIGAP CHAR 8 0

MARAV foreign key relationships

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