MA06V SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
MA06V is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The MA06V table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MATNR (Material Number), WERKS (Plant), MATKL (Material Group), MEINS (Base Unit of Measure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP MA06V table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MLGUT | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
CUOBJ | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
VABME | Variable Purchase Order Unit Active | VABME | CHAR | 1 | VABME | ||||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | PSTAT | ||||
LVORM | Flag Material for Deletion at Plant Level | LVOWK | CHAR | 1 | XFELD | ||||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
AUSME | Unit of issue | AUSME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2 | T141 | MMSTA | |||
MMSTD | Date from which the plant-specific material status is valid | MMSTD | DATS | 8 | DATUM | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
INSMK | Post to Inspection Stock | INSMK_MAT | CHAR | 1 | QKZ | ||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
DISMM | MRP Type | DISMM | CHAR | 2 | T438A | DISMM | |||
USEQU | Quota arrangement usage | USEQU | CHAR | 1 | TMQ2 | USEQU | |||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
EKWSL | Purchasing Value Key | EKWSL | CHAR | 4 | T405 | EKWSL | |||
BWSCL | Source of Supply | BWSCL | CHAR | 1 | TMBW1 | BQSCL | |||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
KORDB | Indicator: Source list requirement | KORDB | CHAR | 1 | XFELD | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
KAUTB | Indicator: 'automatic purchase order allowed' | KAUTB | CHAR | 1 | FLAG | ||||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | T005S | REGIO | |||
QMPUR | QM in Procurement is Active | QMPUR | CHAR | 1 | XFELD | ||||
SSQSS | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8 | TQ08 | QSSPUR | |||
QZGTP | Certificate Type | QZGTYP | CHAR | 4 | TQ05 | QZGTYP | QCT | ||
QMATV | Inspection Setup Exists for Material/Plant | QMATV | CHAR | 1 | XFELD | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
KZREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1 | XFELD | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
QSSYS | Required QM System for Vendor | QSSYS_SOLL | CHAR | 4 | TQ02 | QSSYS | |||
KZKFG | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBSL | Special procurement type | SOBSL | CHAR | 2 | T460A | SOBSL | |||
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
PLGTP | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
ETIAR | Label type | ETIAR | CHAR | 2 | T6WP3 | ETIAR | |||
ETIFO | Label form | ETIFO | CHAR | 2 | T6WP4 | ETIFO | |||
BWVOR | Procurement rule | BWVOR | CHAR | 1 | T6WP1 | BWVOR | |||
MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
MHDHB | Total shelf life | MHDHB | DEC | 4 | DEC4 | ||||
SERVG | IS-R service level | W_SERVGRD | CHAR | 1 | TWSG | W_SERVGRD | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
STDPD | Configurable material | STDPD | CHAR | 18 | MARA | MATN1 | MATNR | ||
CUOBF | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
LGFSB | Default storage location for external procurement | LGFSB | CHAR | 4 | T001L | LGORT | |||
DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
LIQDT | Deletion date | LIQDT | DATS | 8 | DATUM | ||||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2 | T141 | MMSTA | |||
MSTDE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8 | DATUM | ||||
MRPPP | PPC planning calendar | MRPPP | CHAR | 3 | T439G | MRPPP | |||
NRFHG | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
MFRGR | Material freight group | MFRGR | CHAR | 8 | TMFG | MFRGR | |||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | T604F | STEUC | |||
INDUS | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
BMATN | Number of firm's own (internal) inventory-managed material | MPMAT | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | TMPPF | MPROF | |||
KZWSM | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
FABKZ | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | TTGR | TRAGR | |||
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | T377P | SERAIL | |||
BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1 | BFLME | ||||
LADGR | Loading Group | LADGR | CHAR | 4 | TLGR | LADGR | |||
LFRHY | Planning cycle | LFRHY | CHAR | 3 | MRPPP | ||||
PERKZ | Period Indicator | PERKZ | CHAR | 1 | PERKZ | PKZ | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
RDPRF | Rounding Profile | RDPRF | CHAR | 4 | RDPR | RDPRF | |||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | ||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | ||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | ||||
MEGRU | Unit of Measure Group | MEGRU | CHAR | 4 | TWMEG | MEGRU | |||
PRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
IMATN | FFF class | IMATN | CHAR | 18 | MATN1 | MATNR | |||
PICNUM | Supersession chain number | PIC_PICNUM_SUS | CHAR | 18 | ALPHA | PIC_PICNUM | PIC_PICNUM | ||
CONS_PROCG | Consignment Control | WRF_CONS_PROCG | CHAR | 1 | WRFT_CONS_PROCG | WRF_CONS_PROCG | |||
GI_PR_TIME | Goods Issue Processing Time in Days | WRF_PSCD_WABAZ | DEC | 3 | DEC3 | ||||
MULTIPLE_EKGRP | Purchasing Across Purchasing Group | WRF_POHF_OTHER_EKGRP_ALLOW | CHAR | 1 | CHAR1_X |
Key field | Non-key field |
How do I retrieve data from SAP table MA06V using ABAP code
The following ABAP code Example will allow you to do a basic selection on MA06V to SELECT all data from the tableDATA: WA_MA06V TYPE MA06V.
SELECT SINGLE *
FROM MA06V
INTO CORRESPONDING FIELDS OF WA_MA06V
WHERE...
How to access SAP table MA06V
Within an ECC or HANA version of SAP you can also view further information about MA06V and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects