MAPOV 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
MAPOV 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 MAPOV 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), SPRAS (Language Key), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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 MAPOV 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 | |
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
ZIEME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
RAUBE | Storage conditions | RAUBE | CHAR | 2 | T142 | RAUBE | |||
TEMPB | Temperature conditions indicator | TEMPB | CHAR | 2 | T143 | TEMPB | |||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
NUMTP | Category of International Article Number (EAN) | NUMTP | CHAR | 2 | TNTP | NUMTP | |||
LAENG | Length | LAENG | QUAN | 13(3) | MENG13 | ||||
BREIT | Width | BREIT | QUAN | 13(3) | MENG13 | ||||
HOEHE | Height | HOEHE | QUAN | 13(3) | MENG13 | ||||
MEABM | Unit of Dimension for Length/Width/Height | MEABM | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
KUNNR | Competitor | WETTB | CHAR | 10 | V_KNA1WETT | ALPHA | KUNNR | KUN | |
VERSG | Material statistics group | STGMA | CHAR | 1 | TVSM | STGMA | |||
BONUS | Volume rebate group | BONUS | CHAR | 2 | TVBO | BONUS | |||
PROVG | Commission group | PROVG | CHAR | 2 | TVPR | PROVG | |||
SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | XFELD | ||||
VMSTA | Distribution-chain-specific material status | VMSTA | CHAR | 2 | TVMS | VMSTA | |||
VMSTD | Date from which distr.-chain-spec. material status is valid | VMSTD | DATS | 8 | DATUM | ||||
AUMNG | Minimum order quantity in base unit of measure | MINAU | QUAN | 13(3) | MENG13 | ||||
LFMNG | Minimum delivery quantity in delivery note processing | MINLF | QUAN | 13(3) | MENG13 | ||||
EFMNG | Minimum make-to-order quantity | MINEF | QUAN | 13(3) | MENG13 | ||||
SCHME | Unit of measure of delivery unit | SCHME | UNIT | 3 | T006 | CUNIT | MEINS | ||
SCMNG | Delivery unit | SCHRT | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
ARKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
PMATN | Pricing Reference Material | PMATN | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
MTPOS | Item category group from material master | MTPOS | CHAR | 4 | TPTM | MTPOS | |||
DWERK | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 4 | TVKWZ | WERKS | SH_DWERK_EXTS | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | TTGR | TRAGR | |||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
KTGRM | Account assignment group for this material | KTGRM | CHAR | 2 | TVKM | KTGRM | |||
KONDM | Material Pricing Group | KONDM | CHAR | 2 | T178 | KONDM | VKM | ||
LVORM | Ind.: Flag material for deletion at distribution chain level | LVOVK | CHAR | 1 | XFELD | ||||
MVGR1 | Material group 1 | MVGR1 | CHAR | 3 | TVM1 | MVGR1 | |||
MVGR2 | Material group 2 | MVGR2 | CHAR | 3 | TVM2 | MVGR2 | |||
MVGR3 | Material group 3 | MVGR3 | CHAR | 3 | TVM3 | MVGR3 | |||
MVGR4 | Material group 4 | MVGR4 | CHAR | 3 | TVM4 | MVGR4 | |||
MVGR5 | Material group 5 | MVGR5 | CHAR | 3 | TVM5 | MVGR5 | |||
VHART | Packaging Material Type | VHIART | CHAR | 4 | TVTY | TRATY | |||
FUELG | Maximum level (by volume) | FUELG | DEC | 3 | DEC3 | ||||
STFAK | Stacking factor | STFAK | INT2 | 5 | INT2 | ||||
MAGRV | Material Group: Packaging Materials | MAGRV | CHAR | 4 | TVEGR | MAGRV | |||
ERGEI | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ERGEW | Allowed packaging weight | ERGEW | QUAN | 13(3) | MENG13 | ||||
ERVOE | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3 | T006 | CUNIT | MEINS | ||
ERVOL | Allowed packaging volume | ERVOL | QUAN | 13(3) | MENG13 | ||||
GEWTO | Excess Weight Tolerance for Handling unit | GEWTO | DEC | 3(1) | PRZ21 | ||||
VOLTO | Excess Volume Tolerance of the Handling Unit | VOLTO | DEC | 3(1) | PRZ21 | ||||
PRAT1 | ID for product attribute 1 | PRAT1 | CHAR | 1 | PRATA | ||||
PRAT2 | ID for product attribute 2 | PRAT2 | CHAR | 1 | PRATA | ||||
PRAT3 | ID for product attribute 3 | PRAT3 | CHAR | 1 | PRATA | ||||
PRAT4 | ID for product attribute 4 | PRAT4 | CHAR | 1 | PRATA | ||||
PRAT5 | ID for product attribute 5 | PRAT5 | CHAR | 1 | PRATA | ||||
PRAT6 | ID for product attribute 6 | PRAT6 | CHAR | 1 | PRATA | ||||
PRAT7 | ID for product attribute 7 | PRAT7 | CHAR | 1 | PRATA | ||||
PRAT8 | ID for product attribute 8 | PRAT8 | CHAR | 1 | PRATA | ||||
PRAT9 | ID for product attribute 9 | PRAT9 | CHAR | 1 | PRATA | ||||
PRATA | ID for product attribute 10 | PRATA | CHAR | 1 | PRATA | ||||
MLGUT | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
KZUMW | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
KOSCH | Product allocation determination procedure | KOSCH | CHAR | 18 | T190S | KOSCH | |||
MBRSH | Industry sector | MBRSH | CHAR | 1 | T137 | MBRSH | MTP | ||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
KZGVH | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | XFELD | ||||
MSTAV | Cross-distribution-chain material status | MSTAV | CHAR | 2 | TVMS | VMSTA | |||
MSTDV | Date from which the X-distr.-chain material status is valid | MSTDV | DATS | 8 | DATUM | ||||
KZWSM | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
PROFL | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | TDG41 | ADGD_PROFL | |||
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | TMPPF | MPROF | |||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
KZKFG | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
MTPOS_MARA | General item category group | MTPOS_MARA | CHAR | 4 | TPTM | MTPOS | |||
VAVME | Variable Sales Unit Not Allowed | VAVME | CHAR | 1 | XFELD | ||||
BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1 | BFLME | ||||
PVMSO | Material sorting in product proposal | PVMSO | NUMC | 8 | PVMSO |
Key field | Non-key field |
How do I retrieve data from SAP table MAPOV using ABAP code
The following ABAP code Example will allow you to do a basic selection on MAPOV to SELECT all data from the tableDATA: WA_MAPOV TYPE MAPOV.
SELECT SINGLE *
FROM MAPOV
INTO CORRESPONDING FIELDS OF WA_MAPOV
WHERE...
How to access SAP table MAPOV
Within an ECC or HANA version of SAP you can also view further information about MAPOV 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