Follow us on LinkedIn for your next SAP project

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 Possible values
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
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
CADKZ
CAD Indicator
CADKZ
CHAR
1 0
QMPUR
QM in Procurement is Active
QMPUR
CHAR
1 0
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
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
KZKFG
Configurable Material
KZKFG
CHAR
1 0
XCHPF
Batch management requirement indicator
XCHPF
CHAR
1 0
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
KZKUP
Indicator: Material can be co-product
KZKUPMAT
CHAR
1 0
KZNFM
Indicator: The material has a follow-up material
KZNFM
CHAR
1 0
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
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
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
NRFHG
Material qualifies for discount in kind
NRFHG
CHAR
1 0
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
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
ILOOS
Indicator: In Bulk/Liquid
ADGE_ILOOS
CHAR
1 0
SERLV
Level of Explicitness for Serial Number
SERLV
CHAR
1 0
KZGVH
Packaging Material is Closed Packaging
KZGVH
CHAR
1 0
XGCHP
Indicator: Approved batch record required
XGCHP
CHAR
1 0
KZEFF
Assign effectivity parameter values/ override change numbers
CC_MTEFF
CHAR
1 0
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
PRZUS
Indicator: Product composition printed on packaging
PRZUS
CHAR
1 0
MTPOS_MARA
General item category group
MTPOS_MARA TPTM
CHAR
4 0
BFLME
Generic Material with Logistical Variants
BFLME
CHAR
1 0
MATFI
Material Is Locked
MATFI
CHAR
1 0
CMREL
Relevant for Configuration Management
DE_CM_RELEVANCE_FLAG
CHAR
1 0
SLED_BBD
Expiration Date
SLED_BBD
CHAR
1 0
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
MCOND
Material Condition Management
DFPS_MCOND
CHAR
1 0
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
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
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 BEHVO T144
Container Requirements for Storing Materials
BEHVO
MARAV BEHVO MARAV MANDT T144
Container Requirements for Storing Materials
MANDT
MARAV BMATN SYST MANDT MARA
General Material Data
MANDT
MARAV BMATN MARAV BMATN MARA
General Material Data
MATNR
MARAV BSTME MARAV MANDT T006
Units of Measurement
MANDT
MARAV BSTME MARAV BSTME T006
Units of Measurement
MSEHI
MARAV BWSCL SY MANDT TMBW1
Source of Supply Keys
MANDT
MARAV BWSCL MARAV BWSCL TMBW1
Source of Supply Keys
BWSCL
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 ERVOE T006
Units of Measurement
MSEHI
MARAV ERVOE MARAV MANDT T006
Units of Measurement
MANDT
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 MANDT T6WP4
Check Table for Label Shape
MANDT
MARAV ETIFO MARAV ETIFO T6WP4
Check Table for Label Shape
ETIFO
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 MANDT T006
Units of Measurement
MANDT
MARAV GEWEI MARAV GEWEI T006
Units of Measurement
MSEHI
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 MANDT T137
Industries for materials
MANDT
MARAV MBRSH MARAV MBRSH T137
Industries for materials
MBRSH
MARAV MEABM MARAV MANDT T006
Units of Measurement
MANDT
MARAV MEABM MARAV MEABM T006
Units of Measurement
MSEHI
MARAV MEDIUM SYST MANDT T372M
Medium
MANDT
MARAV MEDIUM MARAV MEDIUM T372M
Medium
MEDIU
MARAV MEINS MARAV MANDT T006
Units of Measurement
MANDT
MARAV MEINS MARAV MEINS T006
Units of Measurement
MSEHI
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 MARAV MSTAV TVMS
Materials: Status in Sales and Distribution
VMSTA
MARAV MSTAV SY MANDT TVMS
Materials: Status in Sales and Distribution
MANDT
MARAV MTART MARAV MTART T134
Material Types
MTART
MARAV MTART MARAV MANDT T134
Material Types
MANDT
MARAV MTPOS_MARA MARAV MTPOS_MARA TPTM
Materials: Item Category Groups in Material Master
MTPOS
MARAV MTPOS_MARA SYST MANDT TPTM
Materials: Item Category Groups in Material Master
MANDT
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 MANDT TOIGAP
TD Product Group
CLIENT
MARAV OIGROUPNAM MARAV OIGROUPNAM TOIGAP
TD Product Group
GROUPNAME
MARAV PLGTP SY MANDT TWPT
Price band categories
MANDT
MARAV PLGTP MARAV PLGTP TWPT
Price band categories
PLGTP
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 MARAV PROFL TDG41
DG: DG Indicator Profiles for Material Master
PROFL
MARAV PROFL SYST MANDT TDG41
DG: DG Indicator Profiles for Material Master
MANDT
MARAV RAUBE MARAV MANDT T142
Storage Conditions for Materials
MANDT
MARAV RAUBE MARAV RAUBE T142
Storage Conditions for Materials
RAUBE
MARAV RBNRM MARAV RBNRM T352B
Technical report
RBNR
MARAV RBNRM SY MANDT T352B
Technical report
MANDT
MARAV RMATP SYST MANDT MARA
General Material Data
MANDT
MARAV RMATP MARAV RMATP MARA
General Material Data
MATNR
MARAV SAITY MARAV SAITY T6WSA
Categories of seasonal materials
SAITY
MARAV SAITY SYST MANDT T6WSA
Categories of seasonal materials
MANDT
MARAV SATNR MARAV SATNR MARA
General Material Data
MATNR
MARAV SATNR SY MANDT MARA
General Material Data
MANDT
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 SY MANDT MGEF
Hazardous materials
MANDT
MARAV STOFF MARAV STOFF MGEF
Hazardous materials
STOFF
MARAV STOFF * MGEF
Hazardous materials
REGKZ
MARAV TAKLV SY MANDT TSKM
Material Taxes
MANDT
MARAV TAKLV * TSKM
Material Taxes
TATYP
MARAV TAKLV MARAV TAKLV TSKM
Material Taxes
TAXKM
MARAV TEMPB MARAV MANDT T143
Temperature Conditions for Storing Materials
MANDT
MARAV TEMPB MARAV TEMPB T143
Temperature Conditions for Storing Materials
TEMPB
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 VOLEH T006
Units of Measurement
MSEHI
MARAV VOLEH MARAV MANDT T006
Units of Measurement
MANDT
MARAV WRKST SYST MANDT TWSPR
Check Table for Basic Material Field
MANDT
MARAV WRKST MARAV WRKST TWSPR
Check Table for Basic Material Field
WRKST