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

SAP Table MA07V

Generated Table for View

MA07V (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 MA07V to other SAP tables.

MA07V table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 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
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
BRGEW Gross Weight BRGEW QUAN 13 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
DISST Low-Level Code DISST CHAR 3 0
WESCH Quantity: Number of GR/GI slips to be printed WESCH QUAN 13 3
ETIFO Label form ETIFO T6WP4 CHAR 2 0
ETIAR Label type ETIAR T6WP3 CHAR 2 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
LVORM Flag Material for Deletion at Plant Level LVOWK CHAR 1 0
X Yes
NULL No
BWTTY Valuation Category BWTTY_D T149C CHAR 1 0
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
AUSME Unit of issue AUSME T006 UNIT 3 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
DISMM MRP Type DISMM T438A CHAR 2 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
EISBE Safety Stock EISBE QUAN 13 3
MINBE Reorder Point MINBE QUAN 13 3
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBSL Special procurement type SOBSL T460A CHAR 2 0
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
SSQSS Control Key for Quality Management in Procurement QSSPUR TQ08 CHAR 8 0
UMLMC Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
TRAME Stock in Transit TRAME QUAN 13 3
PERIM Fiscal Year Variant PERIV T009 CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
MMSTA Plant-Specific Material Status MMSTA T141 CHAR 2 0
MMSTD Date from which the plant-specific material status is valid MMSTD DATS 8 0
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 0
DISGR MRP Group DISGR T438M CHAR 4 0
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
ABCIN Physical inventory indicator for cycle counting ABCIN T159C CHAR 1 0
PRCTR Profit Center PRCTR CHAR 10 0
XMCNG Negative stocks allowed in plant XMCNG CHAR 1 0
X Yes
NULL No
SERNP Serial Number Profile SERAIL T377P CHAR 4 0
EKWSL Purchasing Value Key EKWSL T405 CHAR 4 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
CCFIX CC indicator is fixed CCFIX CHAR 1 0
X Yes
NULL No
EPRIO Stock determination group BF_GROUP T434G CHAR 4 0
DZEIT In-house production time DZEIT DEC 3 0
PRDHA Product hierarchy PRODH_D T179 CHAR 18 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
PLGTP Price Band Category PLGTP TWPT CHAR 2 0
SAISO Season Category SAISO T6WSP CHAR 4 0
BWVOR Procurement rule BWVOR T6WP1 CHAR 1 0
BWSCL Source of Supply BWSCL TMBW1 CHAR 1 0
VOLEH Volume unit VOLEH T006 UNIT 3 0
SERVG IS-R service level W_SERVGRD TWSG CHAR 1 0
STRGR Planning strategy group STRGR T461P CHAR 2 0
PRFRQ Interval until next recurring inspection PRFRQ DEC 5 0
STDPD Configurable material STDPD MARA CHAR 18 0
CUOBJ Internal object number CUOBM NUMC 18 0
MLGUT Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
QMATV Inspection Setup Exists for Material/Plant QMATV CHAR 1 0
X Yes
NULL No
SAISJ Season Year SAISJ CHAR 4 0
VKUMC Stock transfer sales value (plant to plant) for VO material VKUMC CURR 13 2
VKTRW Transit value at sales price for value-only material VKTRW CURR 13 2
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
CUOBF Internal object number CUOBM NUMC 18 0
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
GLGMG Tied Empties Stock GLGMG QUAN 13 3
VKGLG Sales value of tied empties stock VKGLG CURR 13 2
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
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)
MCRUE MARDH rec. already exists for per. before last of MARD per. MCRUE CHAR 1 0
X Yes
NULL No
LADGR Loading Group LADGR TLGR 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
DIBER Indicator: MRP area exists DIBER CHAR 1 0
X Yes
NULL No
UCHKZ Indicator for Original Batch Management UCHKZ CHAR 1 0
NULL Not Allowed
1 Allowed
BWESB Valuated Goods Receipt Blocked Stock BWESB QUAN 13 3
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)
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIEDCODE Customs tariff number OIH_EDCODE CHAR 12 0
UOMGR Unit of Mearsure Group (Oil, Natural Gas,...) OIB_UOMGR OIB06 CHAR 3 0
UMRSL Conversion Group (Oil, Natural Gas,..) OIB_UMRSL OIB01 CHAR 4 0
OITAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0

MA07V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MA07V ABCIN MA07V ABCIN T159C Value table for counting cycles in cycle counting ABCIN
MA07V ABCIN MA07V MANDT T159C Value table for counting cycles in cycle counting MANDT
MA07V ABCIN MA07V WERKS T159C Value table for counting cycles in cycle counting WERKS
MA07V AUSME MA07V MANDT T006 Units of Measurement MANDT
MA07V AUSME MA07V AUSME T006 Units of Measurement MSEHI
MA07V BWSCL SY MANDT TMBW1 Source of Supply Keys MANDT
MA07V BWSCL MA07V BWSCL TMBW1 Source of Supply Keys BWSCL
MA07V BWTTY MA07V MANDT T149C Global Valuation Categories MANDT
MA07V BWTTY MA07V BWTTY T149C Global Valuation Categories BWTTY
MA07V BWVOR SYST MANDT T6WP1 Check table, supply source entry MANDT
MA07V BWVOR MA07V BWVOR T6WP1 Check table, supply source entry BWVOR
MA07V DISGR MA07V MANDT T438M Control Parameter for MRP -Material Level- MANDT
MA07V DISGR MA07V WERKS T438M Control Parameter for MRP -Material Level- WERKS
MA07V DISGR MA07V DISGR T438M Control Parameter for MRP -Material Level- MTART
MA07V DISMM MA07V DISMM T438A MRP Type DISMM
MA07V DISMM MA07V MANDT T438A MRP Type MANDT
MA07V DISPO MA07V MANDT T024D MRP controllers MANDT
MA07V DISPO MA07V WERKS T024D MRP controllers WERKS
MA07V DISPO MA07V DISPO T024D MRP controllers DISPO
MA07V EKWSL MA07V EKWSL T405 Purchasing Value Key EKWSL
MA07V EKWSL MA07V MANDT T405 Purchasing Value Key MANDT
MA07V EPRIO SYST MANDT T434G Stock determination group MANDT
MA07V EPRIO MA07V WERKS T434G Stock determination group WERKS
MA07V EPRIO MA07V EPRIO T434G Stock determination group EPRIO
MA07V ETIAR MA07V MANDT T6WP3 Check Table for Labelling Type MANDT
MA07V ETIAR MA07V ETIAR T6WP3 Check Table for Labelling Type ETIAR
MA07V ETIFO MA07V MANDT T6WP4 Check Table for Label Shape MANDT
MA07V ETIFO MA07V ETIFO T6WP4 Check Table for Label Shape ETIFO
MA07V GEWEI MA07V MANDT T006 Units of Measurement MANDT
MA07V GEWEI MA07V GEWEI T006 Units of Measurement MSEHI
MA07V LADGR MA07V MANDT TLGR Routes: Loading Groups MANDT
MA07V LADGR MA07V LADGR TLGR Routes: Loading Groups LADGR
MA07V MANDT MA07V MANDT T000 Clients MANDT
MA07V MATKL MA07V MANDT T023 Material Groups MANDT
MA07V MATKL MA07V MATKL T023 Material Groups MATKL
MA07V MBRSH MA07V MANDT T137 Industries for materials MANDT
MA07V MBRSH MA07V MBRSH T137 Industries for materials MBRSH
MA07V MEINS MA07V MANDT T006 Units of Measurement MANDT
MA07V MEINS MA07V MEINS T006 Units of Measurement MSEHI
MA07V MMSTA MA07V MMSTA T141 Material Status from Materials Management/PPC View MMSTA
MA07V MMSTA MA07V MANDT T141 Material Status from Materials Management/PPC View MANDT
MA07V MTART MA07V MANDT T134 Material Types MANDT
MA07V MTART MA07V MTART T134 Material Types MTART
MA07V MTVFP MA07V MANDT TMVF Availability Check Control MANDT
MA07V MTVFP MA07V MTVFP TMVF Availability Check Control MTVFP
MA07V OITAXGRP MA07V MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
MA07V OITAXGRP MA07V OITAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
MA07V PERIM MA07V PERIM T009 Fiscal Year Variants PERIV
MA07V PERIM MA07V MANDT T009 Fiscal Year Variants MANDT
MA07V PLGTP SY MANDT TWPT Price band categories MANDT
MA07V PLGTP MA07V PLGTP TWPT Price band categories PLGTP
MA07V PRDHA MA07V MANDT T179 Materials: Product Hierarchies MANDT
MA07V PRDHA MA07V PRDHA T179 Materials: Product Hierarchies PRODH
MA07V SAISO MA07V SAISO T6WSP Check Table for Season Indicator SAISO
MA07V SAISO MA07V MANDT T6WSP Check Table for Season Indicator MANDT
MA07V SATNR MA07V SATNR MARA General Material Data MATNR
MA07V SATNR SY MANDT MARA General Material Data MANDT
MA07V SERNP MA07V MANDT T377P Serial Number Management Profiles MANDT
MA07V SERNP MA07V SERNP T377P Serial Number Management Profiles SERAIL
MA07V SERVG SY MANDT TWSG Service level IS-R (Info for assortment list) MANDT
MA07V SERVG MA07V SERVG TWSG Service level IS-R (Info for assortment list) SERVG
MA07V SOBSL MA07V WERKS T460A Special procurement key WERKS
MA07V SOBSL MA07V SOBSL T460A Special procurement key SOBSL
MA07V SOBSL MA07V MANDT T460A Special procurement key MANDT
MA07V SPART MA07V MANDT TSPA Organizational Unit: Sales Divisions MANDT
MA07V SPART MA07V SPART TSPA Organizational Unit: Sales Divisions SPART
MA07V SSQSS MA07V MANDT TQ08 Control of QM in procurement MANDT
MA07V SSQSS MA07V SSQSS TQ08 Control of QM in procurement QM_PUR
MA07V STDPD MA07V MANDT MARA General Material Data MANDT
MA07V STDPD MA07V STDPD MARA General Material Data MATNR
MA07V STRGR SY MANDT T461P Planning strategy group MANDT
MA07V STRGR MA07V STRGR T461P Planning strategy group STRGR
MA07V UMRSL SYST MANDT OIB01 Definition of Conversion Groups MANDT
MA07V UMRSL MA07V UMRSL OIB01 Definition of Conversion Groups UMRSL
MA07V UOMGR SYST MANDT OIB06 HPM Unit of Measurement Group: Definition MANDT
MA07V UOMGR MA07V UOMGR OIB06 HPM Unit of Measurement Group: Definition UOMGR
MA07V VOLEH MA07V MANDT T006 Units of Measurement MANDT
MA07V VOLEH MA07V VOLEH T006 Units of Measurement MSEHI
MA07V WERKS MA07V WERKS T001W Plants/Branches WERKS
MA07V WERKS MA07V MANDT T001W Plants/Branches MANDT