MGVMARA_ALL 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
MGVMARA_ALL 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 MGVMARA_ALL 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), ERSDA (Created On), ERNAM (Name of Person who Created the Object), LAEDA (Date of Last Change).. 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 MGVMARA_ALL 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 | |
ERSDA | Created On | ERSDA | DATS | 8 | DATUM | ||||
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 | T6WP1 | 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 | TWEA | 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 | ||||
BBTYP | Assortment List Type | BBTYP | CHAR | 1 | BBTYP | WBB | |||
SLED_BBD | Expiration Date | SLED_BBD | CHAR | 1 | SLED_BBD | ||||
GTIN_VARIANT | Global Trade Item Number Variant | GTIN_VARIANT | CHAR | 2 | GTIN_VARIANT | ||||
GENNR | Material Number of the Generic Material in Prepack Materials | WSTR_SATNR_PP | CHAR | 18 | MARA | MATN1 | MATNR | ||
RMATP | Reference material for materials packed in same way | PL_RMATP | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
GDS_RELEVANT | Indicator: Global Data Synchronization-Relevant | GDS_RELEVANT | CHAR | 1 | XFELD | ||||
WEORA | Acceptance At Origin | WEORA | CHAR | 1 | XFELD | ||||
HUTYP_DFLT | Standard HU Type | CIFHUTYPDF | CHAR | 4 | THUTYP | CHAR4 | |||
PILFERABLE | Pilferable | CIFPILFRBL | CHAR | 1 | XFELD | ||||
WHSTC | Warehouse Storage Condition | CIFWHSTC | CHAR | 2 | TWHSTC | CHAR2 | |||
WHMATGR | Warehouse Material Group | CIFWHMATGR | CHAR | 4 | TWHMATGR | CHAR4 | |||
HNDLCODE | Handling Indicator | CIFHDLCODE | CHAR | 4 | THNDLCD | CHAR4 | |||
HAZMAT | Relevant for Hazardous Substances | CIFHAZMAT | CHAR | 1 | XFELD | ||||
HUTYP | Handling Unit Type | CIFHUTYP | CHAR | 4 | THUTYP | CHAR4 | |||
TARE_VAR | Variable Tare Weight | CIFTAREVAR | CHAR | 1 | XFELD | ||||
MAXC | Maximum Allowed Capacity of Packaging Material | CIFMAXC | DEC | 15(3) | DECV15_3 | ||||
MAXC_TOL | Overcapacity Tolerance of the Handling Unit | CIFMAXCTOL | DEC | 3(1) | DEC2_1 | ||||
MAXL | Maximum Packing Length of Packaging Material | CIFMAXL | QUAN | 15(3) | CIFQUAN15 | ||||
MAXB | Maximum Packing Width of Packaging Material | CIFMAXB | QUAN | 15(3) | CIFQUAN15 | ||||
MAXH | Maximum Packing Height of Packaging Material | CIFMAXH | QUAN | 15(3) | CIFQUAN15 | ||||
MAXDIM_UOM | Unit of Measure for Maximum Packing Length/Width/Height | CIFMAXDUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
MFRGR | Material freight group | MFRGR | CHAR | 8 | TMFG | MFRGR | |||
QQTIME | Quarantine Period | CIFQQTIME | QUAN | 3 | |||||
QQTIMEUOM | Time Unit for Quarantine Period | CIFQQTIMEUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
QGRP | Quality Inspection Group | CIFQGRP | CHAR | 4 | TQGRP | CIFQGRP | |||
SERIAL | Serial Number Profile | CIFSERIAL | CHAR | 4 | TSERIAL | CIFSERIAL | |||
PS_SMARTFORM | Form Name | CIFPSSFNAME | CHAR | 30 | STXFADM | TDSFNAME | |||
LOGUNIT | EWM CW: Logistics Unit of Measure | CIFLOGUNIT | UNIT | 3 | MARM | CUNIT | MEINS | ||
CWQREL | EWM CW: Material Is a Catch Weight Material | CIFCWQREL | CHAR | 1 | XFELD | ||||
CWQPROC | EWM CW: Catch Weight Profile for Entering CW Quantity | CIFCWQPROC | CHAR | 2 | TCWQPROC | CIFCWQPROC | |||
CWQTOLGR | EWM-CW: Catch Weight Tolerance Group for EWM | CIFCWQTOLGR | CHAR | 9 | TCWQTOLGR | CIFCWQTOLGR | |||
ADPROF | Adjustment Profile | CIFADPROF | CHAR | 3 | TAPROF | CIFADPROF | |||
IPMIPPRODUCT | ID for an Intellectual Property (CRM Product) | CRM_PRODUCT_ID_IP | CHAR | 40 | CRM_PRODUCT_ID | ||||
ALLOW_PMAT_IGNO | Variant Price Allowed (for Material Master) | WPM_ALLOW_PMAT_IGNO_MAT | CHAR | 1 | XFELD | ||||
MEDIUM | Medium | MEDIU | CHAR | 6 | T372M | MEDIU | |||
COMMODITY | Physical Commodity | TBA_STOEFFCHEN | CHAR | 18 | TBAC_PHYSCOMM | TBA_STOEFFCHEN | |||
ANIMAL_ORIGIN | Indicator: Contains Non-Textile Parts of Animal Origin | WRF_ANIMAL_ORIGIN_FLAG | CHAR | 1 | WRF_ANIMAL_ORIGIN_FLAG | ||||
TEXTILE_COMP_IND | Indicator: New Textile Composition Function | WRF_TEXTL_COMP_IND | CHAR | 1 | WRF_TEXTL_COMP_IND | ||||
ANP | ANP Code | J_1BANP | NUMC | 9 | J_1BTANP | J_1BANP | |||
/BEV1/LULEINH | Loading Units | /BEV1/LULEINH | NUMC | 8 | /BEV1/LULEINH | ||||
/BEV1/LULDEGRP | Loading Unit Group: IS Beverage | /BEV1/LULDEGRP | CHAR | 3 | /BEV1/LUT906 | /BEV1/LULDEGRP | |||
/BEV1/NESTRUCCAT | Structure Category for Material Relationship | /BEV1/NESTRUC_CAT | CHAR | 1 | /BEV1/NESTRUC_CAT | ||||
/DSD/SL_TOLTYP | Tolerance Type ID | /DSD/SL_TOLTYP_ID | CHAR | 4 | /DSD/SL_TGTYP | /DSD/SL_TOLTYP_ID | |||
/DSD/SV_CNT_GRP | Counting Group | /DSD/SV_COUNT_GROUP | CHAR | 10 | /DSD/SV_CNTGR | /DSD/SV_COUNT_GROUP | |||
/DSD/VC_GROUP | DSD Grouping | /DSD/VC_GROUP | CHAR | 6 | /DSD/VC_GRP | /DSD/VC_GROUP | |||
/SAPMP/KADU | Cable Diameter | /SAPMP/KADU | DEC | 7(2) | /SAPMP/DURCHME | ||||
/SAPMP/ABMEIN | Unit for Dimensions | /SAPMP/ABMEIN | UNIT | 3 | CUNIT | MEINS | |||
/SAPMP/KADP | Cable Diameter Allowance in Percent | /SAPMP/KADP | DEC | 5(2) | /SAPMP/PROZENT | ||||
/SAPMP/BRAD | Bending Factor | /SAPMP/BRAD | DEC | 4 | /SAPMP/BRAD | ||||
/SAPMP/SPBI | Inner Width | /SAPMP/SPBI | DEC | 7(2) | /SAPMP/DIMENS | ||||
/SAPMP/TRAD | Outer Diameter | /SAPMP/TRAD | DEC | 7(2) | /SAPMP/DURCHME | ||||
/SAPMP/KEDU | Core Diameter | /SAPMP/KEDU | DEC | 7(2) | /SAPMP/DURCHME | ||||
/SAPMP/SPTR | Load Capacity | /SAPMP/SPTR | QUAN | 13(3) | /SAPMP/GEWICHT | ||||
/SAPMP/FBDK | Run-Out Flange Thickness | /SAPMP/FBDK | DEC | 7(2) | /SAPMP/DIMENS | ||||
/SAPMP/FBHK | R-O Flange Height | /SAPMP/FBHK | DEC | 7(2) | /SAPMP/DIMENS | ||||
/SAPMP/RILI | Coil Delivery | /SAPMP/RILI | CHAR | 1 | XFELD | ||||
/SAPMP/FBAK | Run-Out Flange | /SAPMP/FBAK | CHAR | 1 | XFELD | ||||
/SAPMP/AHO | Maximum Number of Vertical Layers | /SAPMP/AHO | NUMC | 3 | NUMC3 | ||||
/SAPMP/MIFRR | Smallest Permissible Reel Clearance for a Cable | /SAPMP/MIFRR | DEC | 7(2) | /SAPMP/DIMENS | ||||
/VSO/R_TILT_IND | Material may be Tilted (Vehicle Space Optimization) | /VSO/M_TILT_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_STACK_IND | Stacking not Allowed (VSO) | /VSO/M_STACK_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_BOT_IND | Bottom Layer (Vehicle Space Optimization) | /VSO/M_BOTTOM_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_TOP_IND | Top Layer (VSO) | /VSO/M_TOP_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_STACK_NO | Stacking Factor (Vehicle Space Optimization) | /VSO/M_STACK_NO | NUMC | 3 | /VSO/M_STACK_NO | ||||
/VSO/R_PAL_IND | Load without Packaging Material (VSO) | /VSO/M_PALLET_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_PAL_OVR_D | Permissible Overhang (Depth) of Packaging Material (VSO) | /VSO/R_PAL_OVR_D | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_OVR_W | Permissible Overhang (Width) of Shipping Material (VSO) | /VSO/R_PAL_OVR_W | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_B_HT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_MIN_H | Minimum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_MIN_HT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_TOL_B_HT | Tolerance to Exceed the Max. Stacking Height (VSO) | /VSO/R_TOL_BIN_HT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_NO_P_GVH | Number of Materials for each Closed PKM (VSO) | /VSO/M_ANZ_PER_GVH | NUMC | 2 | /VSO/M_ANZ_PER_GVH | ||||
/VSO/R_QUAN_UNIT | Unit of Measure Vehicle Space Optimization | /VSO/R_QUAN_UNIT | UNIT | 3 | CUNIT | /VSO/R_QUAN_UNIT | /VSO/R_SH_T006_ME | ||
/VSO/R_KZGVH_IND | Closed Packaging Material Required (VSO) | /VSO/M_KZGVH_IND | CHAR | 1 | /VSO/M_XFIELD | ||||
PACKCODE | Packaging Code | CBUNE_PACODE | CHAR | 10 | CCUNC121 | CBUND_PACOD | |||
DG_PACK_STATUS | Dangerous Goods Packaging Status | ADGE_DG_PACK_STATUS | CHAR | 10 | TDG101 | CHAR10 | |||
MCOND | Material Condition Management | DFPS_MCOND | CHAR | 1 | DFPS_MCOND | ||||
RETDELC | Return Code | DFPS_RETDELC | CHAR | 1 | DFPS_RETDELC | ||||
LOGLEV_RETO | Return to Logistics Level | DFPS_LOGLEV_RETO | CHAR | 1 | DFPS_LOGLEV | ||||
NSNID | NATO Stock Number | DFPS_NSNID | CHAR | 9 | DFPS_NSNID | ||||
OVLPN | Overlength Part Number | ADSPC_OPN | CHAR | 32 | ADSPC_OPN | ||||
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_MSBOOKPART | CHAR | 18 | MATN1 | MATNR | 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 | MATN1 | MATNR | |||
DPCBT | Single-Unit Batch Def. Value | MILL_DPCBT | CHAR | 1 | MILL_DPCBT | ||||
XGRDT | Goods Receipt to Posted Single-Unit Batch Allowed | MILL_XGRDT | CHAR | 1 | XFELD | ||||
IMATN | FFF class | IMATN | CHAR | 18 | MATN1 | MATNR | |||
PICNUM | Supersession chain number | PIC_PICNUM_SUS | CHAR | 18 | ALPHA | PIC_PICNUM | PIC_PICNUM | ||
BSTAT | Creation Status - Seasonal Procurement | WRFBSTAT | CHAR | 2 | WRFMATBSTAT | WRFBSTAT | |||
COLOR_ATINN | Internal Charactieristic Number for Color Characteristics | WRF_COLOR_ATINN | NUMC | 10 | ATINN | ATINN | |||
SIZE1_ATINN | Internal Char. Number for Characteristics for Main Sizes | WRF_SIZE1_ATINN | NUMC | 10 | ATINN | ATINN | |||
SIZE2_ATINN | Internal Char. Number for Characteristics for Second Sizes | WRF_SIZE2_ATINN | NUMC | 10 | ATINN | ATINN | |||
COLOR | Characteristic Value for Colors of Variants | WRF_COLOR | CHAR | 18 | WRF_ATWRT | ||||
SIZE1 | Characteristic Value for Main Sizes of Variants | WRF_SIZE1 | CHAR | 18 | WRF_ATWRT | ||||
SIZE2 | Characteristic Value for Second Size for Variants | WRF_SIZE2 | CHAR | 18 | WRF_ATWRT | ||||
FREE_CHAR | Characteristic Value for Evaluation Purposes | WRF_FREE_CHAR | CHAR | 18 | WRF_ATWRT | ||||
CARE_CODE | Care Codes (such as Washing Code, Ironing Code, etc.) | WRF_CARE_CODE | CHAR | 16 | WRF_CARE_CODE | ||||
BRAND_ID | Brand | WRF_BRAND_ID | CHAR | 4 | WRF_BRANDS | WRF_BRAND_ID | |||
FIBER_CODE1 | Fiber Code for Textiles (Component 1) | WRF_FIBER_CODE_1 | CHAR | 3 | WRF_FIBER_CODES | FIBER | WRF_FIBER_CODE | ||
FIBER_PART1 | Percentage Share of Fiber (Component 1) | WRF_FIBER_PART_1 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE2 | Fiber Code for Textiles (Component 2) | WRF_FIBER_CODE_2 | CHAR | 3 | WRF_FIBER_CODES | FIBER | WRF_FIBER_CODE | ||
FIBER_PART2 | Percentage Share of Fiber (Component 2) | WRF_FIBER_PART_2 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE3 | Fiber Code for Textiles (Component 3) | WRF_FIBER_CODE_3 | CHAR | 3 | WRF_FIBER_CODES | FIBER | WRF_FIBER_CODE | ||
FIBER_PART3 | Percentage Share of Fiber (Component 3) | WRF_FIBER_PART_3 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE4 | Fiber Code for Textiles (Component 4) | WRF_FIBER_CODE_4 | CHAR | 3 | WRF_FIBER_CODES | FIBER | WRF_FIBER_CODE | ||
FIBER_PART4 | Percentage Share of Fiber (Component 4) | WRF_FIBER_PART_4 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE5 | Fiber Code for Textiles (Component 5) | WRF_FIBER_CODE_5 | CHAR | 3 | WRF_FIBER_CODES | FIBER | WRF_FIBER_CODE | ||
FIBER_PART5 | Percentage Share of Fiber (Component 5) | WRF_FIBER_PART_5 | NUMC | 3 | WRF_FIBER_PART | ||||
FASHGRD | Fashion Grade | FASHGRD | CHAR | 4 | T6WFG | FASHGRD | H_FASHGRD | ||
COBJID | Object ID | HROBJID | NUMC | 8 | HROBJID | PON | |||
COTYPE | Object Type | OTYPE | CHAR | 2 | OTYPE | POT | |||
OIGROUPNAM | TD product group | OIG_PCG | CHAR | 8 | TOIGAP | ALPHA | OIG_PCG | OI7 | |
OITRIND | Transfer sign for plant-to-plant transfers | OIH_TRIND | CHAR | 1 | OIH_TRIND | ||||
OIHMTXGR | Material tax group | OIH_J1B_MTXGR | CHAR | 4 | OIH2M_J1B | OIH_J1B_MTXGR | H_OIHMTXGR | ||
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 | |||
SPTYP | Specialization Category | MGV_SPEC_TYPE | CHAR | 10 | MGV_SPEC_TYPE | ||||
MATNR_SEL | External Material Number Plus Version for Selection | MATNR_SEL | CHAR | 51 |
Key field | Non-key field |
How do I retrieve data from SAP table MGVMARA_ALL using ABAP code
The following ABAP code Example will allow you to do a basic selection on MGVMARA_ALL to SELECT all data from the tableDATA: WA_MGVMARA_ALL TYPE MGVMARA_ALL.
SELECT SINGLE *
FROM MGVMARA_ALL
INTO CORRESPONDING FIELDS OF WA_MGVMARA_ALL
WHERE...
How to access SAP table MGVMARA_ALL
Within an ECC or HANA version of SAP you can also view further information about MGVMARA_ALL 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