SAP MC29V Table in S/4 HANA - Generated Table for View
MC29V is a standard SAP Table which is used to store Generated Table for View data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MC29V table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: MC29V
MC29V table structure field list
Below is the full MC29V field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
LVORM | Flag Material for Deletion at Plant Level | LVOWK | CHAR | 1(0) | XFELD | |||||
AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
AESZN | Document change number (without document management system) | AESZN | CHAR | 6(0) | AENUM | |||||
BLANZ | Number of sheets (without Document Management system) | BLANZ | NUMC | 3(0) | NUM3 | |||||
BLATT | Page number of document (without Document Management system) | BLATT | CHAR | 3(0) | BLATT | |||||
DISST | Low-Level Code | DISST | CHAR | 3(0) | DISST | |||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
ERSDA | Created On | ERSDA | DATS | 8(0) | DATUM | |||||
FERTH | Production/inspection memo | FERTH | CHAR | 18(0) | FERTH | |||||
BRGEW | Gross weight | BRGEW | QUAN | 13(3) | MENG13 | |||||
NTGEW | Net weight | NTGEW | QUAN | 13(3) | MENG13 | |||||
GEWEI | Weight Unit | GEWEI | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
GROES | Size/dimensions | GROES | CHAR | 32(0) | CHAR32 | |||||
LABOR | Laboratory/design office | LABOR | CHAR | 3(0) | T024L | LABOR | ||||
LAEDA | Date of Last Change | LAEDA | DATS | 8(0) | DATUM | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
MBRSH | Industry Sector | MBRSH | CHAR | 1(0) | T137 | MBRSH | MTP | |||
MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MTART | Material type | MTART | CHAR | 4(0) | T134 | MTART | MTA | |||
NORMT | Industry Standard Description (such as ANSI or ISO) | NORMT | CHAR | 18(0) | NORMT | |||||
VPSTA | Maintenance status of complete material | VPSTA | CHAR | 15(0) | PSTAT | |||||
VOLEH | Volume unit | VOLEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | |||||
WRKST | Basic Material | WRKST | CHAR | 48(0) | TWSPR | WRKST | ||||
ZEIAR | Document type (without Document Management system) | DZEIAR | CHAR | 3(0) | ZEIAR | |||||
ZEIFO | Page format of document (without Document Management system) | DZEIFO | CHAR | 4(0) | DINFO | |||||
ZEINR | Document number (without document management system) | DZEINR | CHAR | 22(0) | CHAR22 | |||||
ZEIVR | Document version (without Document Management system) | DZEIVR | CHAR | 2(0) | VERSI | |||||
ATTYP | Material Category | ATTYP | CHAR | 2(0) | ATTYP | MTY | ||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1(0) | ALTSL | |||||
AUSME | Unit of issue | AUSME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
AUSSS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | |||||
KZAUS | Discontinuation indicator | KZAUS | CHAR | 1(0) | KZAUS | |||||
AUSDT | Effective-Out Date | AUSDT | DATS | 8(0) | DATUM | |||||
NFMAT | Follow-Up Material | NFMAT | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | ||
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1(0) | SBDKZ | |||||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2(0) | T141 | MMSTA | ||||
MMSTD | Date from Which the Plant-Specific Material Status Is Valid | MMSTD | DATS | 8(0) | DATUM | |||||
BESKZ | Procurement Type | BESKZ | CHAR | 1(0) | BESKZ | MBS | ||||
DISMM | MRP Type | DISMM | CHAR | 2(0) | T438A | DISMM | ||||
SOBSL | Special procurement type | SOBSL | CHAR | 2(0) | T460A | SOBSL | ||||
DZEIT | In-house production time | DZEIT | DEC | 3(0) | DEC3 | |||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
RGEKZ | Indicator: Backflush | RGEKM | CHAR | 1(0) | RGEKM | |||||
RUEZT | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | |||||
TRANZ | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | |||||
WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3(0) | DEC3 | |||||
BASMG | Base quantity | BASMG | QUAN | 13(3) | MENG13 | |||||
BEARZ | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | |||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
KAUSF | Component Scrap in Percent | KAUSF | DEC | 5(2) | DEC3_2 | |||||
LGPRO | Issue Storage Location | LGPRO | CHAR | 4(0) | T001L | LGORT | ||||
KZREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1(0) | XFELD | |||||
KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1(0) | XFELD | |||||
KZKFG | Configurable Material | KZKFG | CHAR | 1(0) | XFELD | |||||
STDPD | Configurable material | STDPD | CHAR | 40(0) | MARA | MATN1 | MATNR | |||
CUOBJ | Internal object number | CUOBM | NUMC | 18(0) | CUOBJ | |||||
SOBSK | Special Procurement Type for Costing | CK_SOBSL | CHAR | 2(0) | T460A | SOBSL | ||||
KZKUP | Indicator: Material can be co-product | KZKUPMAT | CHAR | 1(0) | FLAG | |||||
SCHGT | Indicator: bulk material | SCHGT | CHAR | 1(0) | XFELD | |||||
EPRIO | Stock determination group | BF_GROUP | CHAR | 4(0) | T434G | BF_GROUP | ||||
STAWN | Commodity Code | STAWN | CHAR | 17(0) | T604 | STAWN | ||||
PREFE | Customs Preference | PREFE | CHAR | 1(0) | PREFE | |||||
PRENE | Indicator: Vendor declaration exists | PRENE | CHAR | 1(0) | PRENE | PNE | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1(0) | XFELD | |||||
XCHPF | Batch Management Requirement Indicator for Plant | XCHPF_WERKS | CHAR | 1(0) | XFELD | |||||
KZECH | Determination of batch entry in the production/process order | KZECH | CHAR | 1(0) | KZECH | |||||
SERNP | Serial Number Profile | SERAIL | CHAR | 4(0) | T377P | SERAIL | ||||
MISKZ | Mixed MRP indicator | MISKZ | CHAR | 1(0) | MISKZ | |||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2(0) | TMVF | MTVFP | ||||
FRTME | Production unit | FRTME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
KZWSM | Units of measure usage | KZWSO | CHAR | 1(0) | KZWSO | |||||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
SERLV | Level of Explicitness for Serial Number | SERLV | CHAR | 1(0) | SERLV | |||||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2(0) | T141 | MMSTA | H_T141 | MMSTA | ||
MSTDE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8(0) | DATUM | |||||
VSPVB | Proposed Supply Area in Material Master Record | VSPVB | CHAR | 10(0) | PVBE | PRVBE | ||||
KZBED | Indicator for Requirements Grouping | KZBED | CHAR | 1(0) | KZBED | |||||
KZEFF | Assign effectivity parameter values/ override change numbers | CC_MTEFF | CHAR | 1(0) | XFELD | |||||
FXPRU | Fixed-Price Co-Product | CK_FIXPRKU | CHAR | 1(0) | XFELD | |||||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1(0) | APOKZ | |||||
AHDIS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1(0) | AHDIS | |||||
USEQU | Quota arrangement usage | USEQU | CHAR | 1(0) | TMQ2 | USEQU | ||||
BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1(0) | BFLME |
Search for further information about these or an SAP related objects