MC29V SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from MC29V
Related tables to MC29V
Access table MC29V




Table View field list including key, data, relationships and ABAP select examples

MC29V 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 MC29V 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), LVORM (Flag Material for Deletion at Plant Level), AENAM (Name of Person Who Changed Object).. 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 MC29V 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
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LVORMFlag Material for Deletion at Plant Level LVOWKCHAR1XFELD
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AESZNDocument change number (without document management system) AESZNCHAR6AENUM
BLANZNumber of sheets (without Document Management system) BLANZNUMC3NUM3
BLATTPage number of document (without Document Management system) BLATTCHAR3BLATT
DISSTLow-Level Code DISSTCHAR3DISST
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERSDACreated On ERSDADATS8DATUM
FERTHProduction/inspection memo FERTHCHAR18FERTH
BRGEWGross Weight BRGEWQUAN13(3) MENG13
NTGEWNet Weight NTGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
GROESSize/dimensions GROESCHAR32CHAR32
LABORLaboratory/design office LABORCHAR3T024LLABOR
LAEDADate of Last Change LAEDADATS8DATUM
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MBRSHIndustry sector MBRSHCHAR1T137MBRSHMTP
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
NORMTIndustry Standard Description (such as ANSI or ISO) NORMTCHAR18NORMT
VPSTAMaintenance status of complete material VPSTACHAR15PSTAT
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
VOLUMVolume VOLUMQUAN13(3) MENG13
WRKSTBasic Material WRKSTCHAR48TWSPRWRKST
ZEIARDocument type (without Document Management system) DZEIARCHAR3ZEIAR
ZEIFOPage format of document (without Document Management system) DZEIFOCHAR4DINFO
ZEINRDocument number (without document management system) DZEINRCHAR22CHAR22
ZEIVRDocument version (without Document Management system) DZEIVRCHAR2VERSI
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
ALTSLMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
AUSMEUnit of issue AUSMEUNIT3T006CUNITMEINS
AUSSSAssembly scrap in percent AUSSSDEC5(2) DEC3_2
KZAUSDiscontinuation indicator KZAUSCHAR1KZAUS
AUSDTEffective-Out Date AUSDTDATS8DATUM
NFMATFollow-Up Material NFMATCHAR18MARAMATN1MATNRMAT
SBDKZDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
MMSTAPlant-Specific Material Status MMSTACHAR2T141MMSTA
MMSTDDate from which the plant-specific material status is valid MMSTDDATS8DATUM
BESKZProcurement Type BESKZCHAR1BESKZMBS
DISMMMRP Type DISMMCHAR2T438ADISMM
SOBSLSpecial procurement type SOBSLCHAR2T460ASOBSL
DZEITIn-house production time DZEITDEC3DEC3
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
RGEKZIndicator: Backflush RGEKMCHAR1RGEKM
RUEZTSetup and teardown time RUEZTDEC5(2) DEC3_2
TRANZInteroperation time TRANZDEC5(2) DEC3_2
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
BASMGBase quantity BASMGQUAN13(3) MENG13
BEARZProcessing time BEARZDEC5(2) DEC3_2
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
KAUSFComponent scrap in percent KAUSFDEC5(2) DEC3_2
LGPROIssue Storage Location LGPROCHAR4T001LLGORT
KZREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
KZDKZDocumentation required indicator KZDKZCHAR1XFELD
KZKFGConfigurable Material KZKFGCHAR1XFELD
STDPDConfigurable material STDPDCHAR18MARAMATN1MATNR
CUOBJInternal object number CUOBMNUMC18CUOBJ
SOBSKSpecial Procurement Type for Costing CK_SOBSLCHAR2T460ASOBSL
KZKUPIndicator: Material can be co-product KZKUPMATCHAR1FLAG
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
EPRIOStock determination group BF_GROUPCHAR4T434GBF_GROUP
STAWNCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
PREFEPreference indicator in export/import PREFECHAR1PREFE
PRENEIndicator: Vendor declaration exists PRENECHAR1PRENEPNE
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
KZECHDetermination of batch entry in the production/process order KZECHCHAR1KZECH
SERNPSerial Number Profile SERAILCHAR4T377PSERAIL
MISKZMixed MRP indicator MISKZCHAR1MISKZ
MTVFPChecking Group for Availability Check MTVFPCHAR2TMVFMTVFP
FRTMEProduction unit FRTMEUNIT3T006CUNITMEINS
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
SERLVLevel of Explicitness for Serial Number SERLVCHAR1SERLV
MSTAECross-Plant Material Status MSTAECHAR2T141MMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
VSPVBProposed Supply Area in Material Master Record VSPVBCHAR10PVBEPRVBE
KZBEDIndicator for Requirements Grouping KZBEDCHAR1KZBED
KZEFFAssign effectivity parameter values/ override change numbers CC_MTEFFCHAR1XFELD
FXPRUFixed-Price Co-Product CK_FIXPRKUCHAR1XFELD
APOKZIndicator: Is material relevant for APO APOKZCHAR1APOKZ
AHDISMRP relevancy for dependent requirements AHDISCHAR1AHDIS
USEQUQuota arrangement usage USEQUCHAR1TMQ2USEQU
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME

Key field Non-key field



How do I retrieve data from SAP table MC29V using ABAP code

The following ABAP code Example will allow you to do a basic selection on MC29V to SELECT all data from the table
DATA: WA_MC29V TYPE MC29V.

SELECT SINGLE *
FROM MC29V
INTO CORRESPONDING FIELDS OF WA_MC29V
WHERE...

How to access SAP table MC29V

Within an ECC or HANA version of SAP you can also view further information about MC29V and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!