MC04P_0MAT SAP (Extraction PP-BW: Material View from PP/PP-PI) Structure details

Dictionary Type: Structure
Description: Extraction PP-BW: Material View from PP/PP-PI




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




Structure field list including key, data, relationships and ABAP select examples

MC04P_0MAT 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 "Extraction PP-BW: Material View from PP/PP-PI" 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_MC04P_0MAT TYPE MC04P_0MAT.

The MC04P_0MAT table consists of various fields, each holding specific information or linking keys about Extraction PP-BW: Material View from PP/PP-PI data available in SAP. These include AUFNR (Order Number), BUKRS (Company Code), ERDAT (Created on), FA_GLFT (Order has status DELIVERED).. 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 MC04P_0MAT 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
ROCANCELIndicator: Cancel Data Record ROCANCELCHAR1BOOLE
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ERDATCreated on AUFERFDATDATS8DATUM
FA_GLFTOrder has status DELIVERED MC_FA_GLFTCHAR1X
FTRMIActual release date CO_FTRMIDATS8DATUM
FTRMPPlanned release date CO_FTRMPDATS8DATUM
FTRMSScheduled release date CO_FTRMSDATS8DATUM
GETRIConfirmed Order Finish Date CO_GETRIDATS8DATUM
GLTRPBasic finish date CO_GLTRPDATS8DATUM
GLTRSScheduled finish CO_GLTRSDATS8DATUM
GSTRIActual start date CO_GSTRIDATS8DATUM
GSTRPBasic start date CO_GSTRPDATS8DATUM
GSTRSScheduled start CO_GSTRSDATS8DATUM
LEAD_AUFNRLeading order in current processing CO_LAUFNRCHAR12Assigned to domainALPHAAUFNR
MAUFNRNumber of superior order MAUFNRCHAR12Assigned to domainALPHAAUFNRUAF
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
BUDATPosting date delivery/finish date, actual MC_LTRMIDATS8DATUM
DFZEHUnit of measure for execution time DFZEHUNIT3CUNITEINHEIT
DFZEXEHUnit for execution time (exact) DFZEXEHUNIT3CUNITEINHEIT
ETRMPOpening date of the planned order CO_ETRMPDATS8DATUM
IAMNGActual scrap quantity from an order item MC_IAMNGQUAN15(3) MENGV15_3
I_DFZActual execution time I_DFZQUAN7(1) DAUER_6_1V
I_DFZ_EXActual execution time (exact) I_DFZ_EXQUAN12(2) DAUER_10_2V
I_DLZActual lead time I_DLZQUAN7(1) DAUER_6_1V
I_DLZ_EXActual lead time (exact) I_DLZ_EXQUAN12(2) DAUER_10_2V
KDAUFSales order number CO_KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KEINHUnit of of measure for displaying capacity requirements CY_KEINHUNIT3Assigned to domainCUNITMEINS
KSUMSTotal target capacity requirements MC_KSUMSQUAN7(1) DAUER_6_1V
LTRMIActual delivery/finish date CO_LTRMIDATS8DATUM
LTRMPDelivery date from planned order CO_LTRMPDATS8DATUM
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MEINSBase Unit of Measure LAGMEUNIT3Assigned to domainCUNITMEINS
PAMNGFixed quantity of scrap from production MC_AVMNGQUAN15(3) MENGV15_3
PGMNGTotal planned order quantity MC_GSMNGQUAN15(3) MENGV15_3
PI_FREIPlanned/actual deviation in scheduled release date PI_FREIQUAN7(1) DAUER_6_1V
PI_LIEFPlanned/actual deviation in scheduled delivery date PI_LIEFQUAN7(1) DAUER_6_1V
PI_STARPlanned/actual deviation in scheduled start date PI_STARQUAN7(1) DAUER_6_1V
PLNUMPlanned order number PLNUMCHAR10Assigned to domainALPHAPLNUMPAF
POSNROrder Item Number CO_POSNRNUMC4CO_POSNR
PSAMGScrap quantity in item MC_PSAMGQUAN15(3) MENGV15_3
PSMNGOrder item quantity MC_PSMNGQUAN15(3) MENGV15_3
PS_FREIPlanned/target deviation in scheduled release date PS_FREIQUAN7(1) DAUER_6_1V
PS_LIEFPlanned/target deviation in scheduled delivery date PS_LIEFQUAN7(1) DAUER_6_1V
PS_STARPlanned/target deviation in start date PS_STARQUAN7(1) DAUER_6_1V
PWERKPlanning plant for the order CO_PWERKCHAR4Assigned to domainWERKS
P_DLZPlanned lead time P_DLZQUAN7(1) DAUER_6_1V
SI_FREITarget/actual deviation in scheduled release date DSI_FREIQUAN7(1) DAUER_6_1V
SI_LIEFTarget/actual deviation in scheduled delivery date DSI_LIEFQUAN7(1) DAUER_6_1V
SI_STARTarget/actual schedule deviation in start date DSI_STARQUAN7(1) DAUER_6_1V
STRMPStart date of the planned order CO_STRMPDATS8DATUM
S_DFZTarget execution time S_DFZQUAN7(1) DAUER_6_1V
S_DFZ_EXTarget execution time (exact) S_DFZ_EXQUAN12(2) DAUER_10_2V
S_DLZTarget lead time S_DLZQUAN7(1) DAUER_6_1V
S_DLZ_EXTarget lead time (exact) S_DLZ_EXQUAN12(2) DAUER_10_2V
WEMNGQuantity of goods received MC_WEMNGQUAN15(3) MENGV15_3
ZEITPEvent for which updating should take place DZEITPCHAR2Assigned to domainZEITP
LEAD_MATNRMaterial Number of Leading Order LEAD_MATNRCHAR18Assigned to domainMATN1MATNR

Key field Non-key field



How do I retrieve data from SAP structure MC04P_0MAT using ABAP code?

As MC04P_0MAT 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 MC04P_0MAT as there is no data to select.

How to access SAP table MC04P_0MAT

Within an ECC or HANA version of SAP you can also view further information about MC04P_0MAT 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!