MGV_MVD_ALV_DATA SAP (Data Transfer Structure: Material Versions Overview Screen) Structure details
Dictionary Type: Structure
Description: Data Transfer Structure: Material Versions Overview Screen
Description: Data Transfer Structure: Material Versions Overview Screen
ABAP Code to SELECT data from MGV_MVD_ALV_DATA
Related tables to MGV_MVD_ALV_DATA
Access table MGV_MVD_ALV_DATA
Related tables to MGV_MVD_ALV_DATA
Access table MGV_MVD_ALV_DATA
Structure field list including key, data, relationships and ABAP select examples
MGV_MVD_ALV_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data Transfer Structure: Material Versions Overview Screen" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MGV_MVD_ALV_DATA TYPE MGV_MVD_ALV_DATA.
The MGV_MVD_ALV_DATA table consists of various fields, each holding specific information or linking keys about Data Transfer Structure: Material Versions Overview Screen data available in SAP. These include ZUORD_ICON (Icon for Document Assignment), MATNR_INT (Material Number), MATNR_EXT (External Long Material Number), MATNR_VERS (Material Version Number).. 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: Can be enhanced (character-type or numeric)
SAP MGV_MVD_ALV_DATA structure 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 |
| ZUORD | Assignment Type for Documents | MGV_MVD_DMS_LINK_TYPE | CHAR | 1 | MGV_MVD_DMS_LINK_TYPE | ||||
| ZUORD_ICON | Icon for Document Assignment | MGV_MVD_DMS_LINK_TYPE_ICON | CHAR | 30 | CHAR30 | ||||
| MATNR_INT | Material Number | MATNR_INT | CHAR | 18 | MATN1 | MATNR_INT | MAT | MAT1 | |
| MATNR_EXT | External Long Material Number | MATNR_EXT | CHAR | 40 | MATNL | MATNR_EXT | |||
| MATNR_VERS | Material Version Number | MATNR_VERS | CHAR | 10 | MATNW | MATNR_VERS | MATVERS | ||
| MATNR_GUID | Material Number (Internal GUID) | MATNR_IGUID | RAW | 16 | SYSUUID | ||||
| MATNR_TYPE | Material Number Type | MATNR_TYPE | CHAR | 1 | MATNR_TYPE | ||||
| MATNR_HEAD | Header Material for Version | MATNR_HEAD | CHAR | 18 | MATN2 | MATNR_INT | |||
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
| MATNR_TYPE_ICON | Icon for Document Assignment | MGV_MVD_MATNR_TYPE_ICON | CHAR | 30 | CHAR30 | ||||
| MATNR_DISPLAY | Header Material for Version | MATNR_HEAD | CHAR | 18 | MATN2 | MATNR_INT | |||
| DOKAR | Document Type | DOKAR | CHAR | 3 | Assigned to domain | DOKAR | CV2 | ||
| DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
| DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
| DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
| DKTXT | Document description | DKTXT | CHAR | 40 | TEXT40 | ||||
| AENNR | Change Number | DAENR | CHAR | 12 | Assigned to domain | AENNR | AENNR | ||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| VPSTA | Maintenance status of complete material | VPSTA | CHAR | 15 | PSTAT | ||||
| PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | PSTAT | ||||
| LVORM | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1 | XFELD | ||||
| MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
| MBRSH | Industry sector | MBRSH | CHAR | 1 | T137 | MBRSH | MTP | ||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| BISMT | Old material number | BISMT | CHAR | 18 | BISMT | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ZEINR | Document number (without document management system) | DZEINR | CHAR | 22 | CHAR22 | ||||
| ZEIAR | Document type (without Document Management system) | DZEIAR | CHAR | 3 | ZEIAR | ||||
| ZEIVR | Document version (without Document Management system) | DZEIVR | CHAR | 2 | VERSI | ||||
| ZEIFO | Page format of document (without Document Management system) | DZEIFO | CHAR | 4 | DINFO | ||||
| AESZN | Document change number (without document management system) | AESZN | CHAR | 6 | AENUM | ||||
| BLATT | Page number of document (without Document Management system) | BLATT | CHAR | 3 | BLATT | ||||
| BLANZ | Number of sheets (without Document Management system) | BLANZ | NUMC | 3 | NUM3 | ||||
| FERTH | Production/inspection memo | FERTH | CHAR | 18 | FERTH | ||||
| FORMT | Page Format of Production Memo | FORMT | CHAR | 4 | DINFO | ||||
| GROES | Size/dimensions | GROES | CHAR | 32 | CHAR32 | ||||
| WRKST | Basic Material | WRKST | CHAR | 48 | TWSPR | WRKST | |||
| NORMT | Industry Standard Description (such as ANSI or ISO) | NORMT | CHAR | 18 | NORMT | ||||
| LABOR | Laboratory/design office | LABOR | CHAR | 3 | T024L | LABOR | |||
| EKWSL | Purchasing Value Key | EKWSL | CHAR | 4 | T405 | EKWSL | |||
| 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 | ||
| BEHVO | Container requirements | BEHVO | CHAR | 2 | T144 | BEHVO | |||
| 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 | ||||
| TRAGR | Transportation Group | TRAGR | CHAR | 4 | TTGR | TRAGR | |||
| STOFF | Hazardous material number | STOFF | CHAR | 18 | MGEF | MATN1 | STOFF | STO | |
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| KUNNR | Competitor | WETTB | CHAR | 10 | V_KNA1WETT | ALPHA | KUNNR | KUN | |
| EANNR | European Article Number (EAN) - obsolete!!!!! | EANNR | CHAR | 13 | CHAR13 | EAN | |||
| WESCH | Quantity: Number of GR/GI slips to be printed | WESCH | QUAN | 13(3) | MENG13 | ||||
| BWVOR | Procurement rule | BWVOR | CHAR | 1 | Assigned to domain | BWVOR | |||
| BWSCL | Source of Supply | BWSCL | CHAR | 1 | TMBW1 | BQSCL | |||
| SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
| ETIAR | Label type | ETIAR | CHAR | 2 | T6WP3 | ETIAR | |||
| ETIFO | Label form | ETIFO | CHAR | 2 | T6WP4 | ETIFO | |||
| ENTAR | Deactivated | DUMMYENTAR | CHAR | 1 | CHAR1 | ||||
| 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 | ||
| AEKLK | Stock Transfer Net Change Costing | CK_AEKLK | CHAR | 1 | XFELD | ||||
| CADKZ | CAD Indicator | CADKZ | CHAR | 1 | XFELD | ||||
| QMPUR | QM in Procurement is Active | QMPUR | CHAR | 1 | XFELD | ||||
| ERGEW | Allowed packaging weight | ERGEW | QUAN | 13(3) | MENG13 | ||||
| ERGEI | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ERVOL | Allowed packaging volume | ERVOL | QUAN | 13(3) | MENG13 | ||||
| ERVOE | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| 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 | ||||
| VABME | Variable Purchase Order Unit Active | VABME | CHAR | 1 | VABME | ||||
| KZREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1 | XFELD | ||||
| KZKFG | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
| XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
| 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 | |||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
| DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
| LIQDT | Deletion date | LIQDT | DATS | 8 | DATUM | ||||
| SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
| PLGTP | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
| MLGUT | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
| EXTWG | External Material Group | EXTWG | CHAR | 18 | TWEW | EXTWG | |||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
| ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
| KZKUP | Indicator: Material can be co-product | KZKUPMAT | CHAR | 1 | FLAG | ||||
| KZNFM | Indicator: The material has a follow-up material | KZNFM | CHAR | 1 | XFELD | ||||
| PMATA | Pricing Reference Material | PMATN | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2 | T141 | MMSTA | |||
| MSTAV | Cross-distribution-chain material status | MSTAV | CHAR | 2 | TVMS | VMSTA | |||
| MSTDE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8 | DATUM | ||||
| MSTDV | Date from which the X-distr.-chain material status is valid | MSTDV | DATS | 8 | DATUM | ||||
| TAKLV | Tax classification of the material | TAKLV | CHAR | 1 | TSKM | TAXKM | |||
| RBNRM | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
| MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
| MHDHB | Total shelf life | MHDHB | DEC | 4 | DEC4 | ||||
| MHDLP | Storage percentage | MHDLP | DEC | 3 | DEC3 | ||||
| INHME | Content unit | INHME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| INHAL | Net contents | INHAL | QUAN | 13(3) | MENG13 | ||||
| VPREH | Comparison price unit | VPREH | DEC | 5 | PACK3 | ||||
| ETIAG | IS-R Labeling: material grouping (deactivated in 4.0) | ETIAG | CHAR | 18 | Assigned to domain | ETIAG | |||
| INHBR | Gross contents | INHBR | QUAN | 13(3) | MENG13 | ||||
| CMETH | Quantity Conversion Method | OIB_CMETH | CHAR | 1 | OIB_CMETH | ||||
| CUOBF | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
| KZUMW | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
| KOSCH | Product allocation determination procedure | KOSCH | CHAR | 18 | T190S | KOSCH | |||
| SPROF | Pricing profile for variants | SPROF | CHAR | 1 | SPROF | ||||
| NRFHG | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
| 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 | ||||
| SAITY | Rollout in a Season | SAITY | CHAR | 2 | T6WSA | SAITY | WMSAITY | ||
| PROFL | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | TDG41 | ADGD_PROFL | |||
| IHIVI | Indicator: Highly Viscous | ADGE_IHIVI | CHAR | 1 | X | ||||
| ILOOS | Indicator: In Bulk/Liquid | ADGE_ILOOS | CHAR | 1 | X | ||||
| SERLV | Level of Explicitness for Serial Number | SERLV | CHAR | 1 | SERLV | ||||
| KZGVH | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | XFELD | ||||
| XGCHP | Indicator: Approved batch record required | XGCHP | CHAR | 1 | XFELD | ||||
| KZEFF | Assign effectivity parameter values/ override change numbers | CC_MTEFF | CHAR | 1 | XFELD | ||||
| COMPL | Material completion level | CSCP_COMP_LVL | NUMC | 2 | TCSCP_COMP_LVL | CSCP_COMP_LVL | |||
| IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
| RDMHD | Rounding rule for calculation of SLED | RDMHD | CHAR | 1 | RDMHD | ||||
| PRZUS | Indicator: Product composition printed on packaging | PRZUS | CHAR | 1 | XFELD | ||||
| MTPOS_MARA | General item category group | MTPOS_MARA | CHAR | 4 | TPTM | MTPOS | |||
| BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1 | BFLME | ||||
| MATFI | Material Is Locked | MATFI | CHAR | 1 | XFELD | ||||
| CMREL | Relevant for Configuration Management | DE_CM_RELEVANCE_FLAG | CHAR | 1 | DO_CM_RELEVANCE_FLAG | ||||
| OVLPN | Overlength Part Number | ADSPC_OPN | CHAR | 32 | ADSPC_OPN | ||||
| RMATP | Reference material for materials packed in same way | PL_RMATP | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| ADSPC_SPC | Spare Part Class Code | ADSPC_SPC | NUMC | 1 | ADSPC_SPC | ||||
| VARID | GUID Variable Object Identification | DI_VARID | RAW | 16 | SYSUUID | ||||
| MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
| VTYPE | Version Category | VERSIONTYPE | CHAR | 10 | MGVTYPE | VERSIONTYPE | |||
| VCHNR | Change number material versions | MGV_VCHNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
| EVVAL | Material is Always Valid | MGV_EVER_VALID | CHAR | 1 | XFELD | ||||
| DVERS | Default Version | MGV_MATNR_VALID_DEFAULT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
| IMATN | FFF class | IMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
| PICNUM | Supersession chain number | PIC_PICNUM_SUS | CHAR | 18 | ALPHA | PIC_PICNUM | PIC_PICNUM | ||
| DWNAM | Name of person responsible | DWNAM | CHAR | 12 | DWNAM | ||||
| DOKST | Document Status | DOKST | CHAR | 2 | Assigned to domain | DOKST | |||
| LABOR_DMS | Laboratory/design office | LABOR | CHAR | 3 | Assigned to domain | LABOR | |||
| WERKA | Plant | WERKA | CHAR | 4 | Assigned to domain | WERKS | |||
| LOEDK | Deletion indicator | LOEDK | CHAR | 1 | XFELD | ||||
| CADKZ_DMS | CAD Indicator | CADKZ | CHAR | 1 | XFELD | ||||
| PRENR | Document number of superior document | PRENR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | ||
| PREVR | Document version of superior document | PREVR | CHAR | 2 | DOKVR | ||||
| PRETL | Document Part of Superior Document | PRETL | CHAR | 3 | DOKTL | ||||
| PREAR | Document type of the superior document | PREAR | CHAR | 3 | Assigned to domain | DOKAR | |||
| BEGRU_DMS | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
| FILEP | Original of document | FILEP | CHAR | 255 | TEXT255 | ||||
| DTTRG | Name of Data Carrier | DTTRG | CHAR | 10 | Assigned to domain | DTTRG | CV5 | ||
| DAPPL | Application | DAPPL | CHAR | 3 | Assigned to domain | DAPPL | |||
| FILEP1 | Original of document | FILEP | CHAR | 255 | TEXT255 | ||||
| DTTRG1 | Name of Data Carrier | DTTRG | CHAR | 10 | Assigned to domain | DTTRG | CV5 | ||
| DAPPL1 | Application | DAPPL | CHAR | 3 | Assigned to domain | DAPPL | |||
| VRLDAT | Due Date | VRLDAT | DATS | 8 | DATUM | ||||
| VPRIOR | Processing priority | VPRIOR | NUMC | 1 | NUMC01 | ||||
| RES1 | Reserve field DRAW | RESDRAW | CHAR | 14 | CHAR14 | ||||
| RES2 | Reserve field DRAW | RESDRAW | CHAR | 14 | CHAR14 | ||||
| RES3 | Reserve field DRAW | RESDRAW | CHAR | 14 | CHAR14 | ||||
| RES4 | Reserve field DRAW | RESDRAW | CHAR | 14 | CHAR14 | ||||
| MRK_FILEP | Original of document | FILEP | CHAR | 255 | TEXT255 | ||||
| MRK_DTTRG | Name of Data Carrier | DTTRG | CHAR | 10 | Assigned to domain | DTTRG | CV5 | ||
| MRK_FILEP1 | Original of document | FILEP | CHAR | 255 | TEXT255 | ||||
| MRK_DTTRG1 | Name of Data Carrier | DTTRG | CHAR | 10 | Assigned to domain | DTTRG | CV5 | ||
| ADATUM | Output date for document | ADATUM | DATS | 8 | DATUM | ||||
| DOKNR_VL | Document Number of Source Document | DOKNR_VL | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | ||
| FILELEN | File length of original | ORLN | NUMC | 12 | NUM12 | ||||
| FILELEN1 | File length of original | ORLN | NUMC | 12 | NUM12 | ||||
| CM_RELEVANCE | Relevant for Configuration Management | DE_CM_RELEVANCE_FLAG | CHAR | 1 | DO_CM_RELEVANCE_FLAG | ||||
| CM_FIXED | Document fixed | DMS_CM_FIXED | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP structure MGV_MVD_ALV_DATA using ABAP code?
As MGV_MVD_ALV_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MGV_MVD_ALV_DATA as there is no data to select.How to access SAP table MGV_MVD_ALV_DATA
Within an ECC or HANA version of SAP you can also view further information about MGV_MVD_ALV_DATA 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