MC04P_0MAT SAP (Extraction PP-BW: Material View from PP/PP-PI) Structure details
Description: Extraction PP-BW: Material View from PP/PP-PI
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 |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1 | BOOLE | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
FA_GLFT | Order has status DELIVERED | MC_FA_GLFT | CHAR | 1 | X | ||||
FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
LEAD_AUFNR | Leading order in current processing | CO_LAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
MAUFNR | Number of superior order | MAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | UAF | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BUDAT | Posting date delivery/finish date, actual | MC_LTRMI | DATS | 8 | DATUM | ||||
DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
DFZEXEH | Unit for execution time (exact) | DFZEXEH | UNIT | 3 | CUNIT | EINHEIT | |||
ETRMP | Opening date of the planned order | CO_ETRMP | DATS | 8 | DATUM | ||||
IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 15(3) | MENGV15_3 | ||||
I_DFZ | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DFZ_EX | Actual execution time (exact) | I_DFZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
I_DLZ | Actual lead time | I_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
I_DLZ_EX | Actual lead time (exact) | I_DLZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
KDAUF | Sales order number | CO_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSUMS | Total target capacity requirements | MC_KSUMS | QUAN | 7(1) | DAUER_6_1V | ||||
LTRMI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
LTRMP | Delivery date from planned order | CO_LTRMP | DATS | 8 | DATUM | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MEINS | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 15(3) | MENGV15_3 | ||||
PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 15(3) | MENGV15_3 | ||||
PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 15(3) | MENGV15_3 | ||||
PSMNG | Order item quantity | MC_PSMNG | QUAN | 15(3) | MENGV15_3 | ||||
PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
PS_STAR | Planned/target deviation in start date | PS_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
PWERK | Planning plant for the order | CO_PWERK | CHAR | 4 | Assigned to domain | WERKS | |||
P_DLZ | Planned lead time | P_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
STRMP | Start date of the planned order | CO_STRMP | DATS | 8 | DATUM | ||||
S_DFZ | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
S_DFZ_EX | Target execution time (exact) | S_DFZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
S_DLZ | Target lead time | S_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
S_DLZ_EX | Target lead time (exact) | S_DLZ_EX | QUAN | 12(2) | DAUER_10_2V | ||||
WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15(3) | MENGV15_3 | ||||
ZEITP | Event for which updating should take place | DZEITP | CHAR | 2 | Assigned to domain | ZEITP | |||
LEAD_MATNR | Material Number of Leading Order | LEAD_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR |
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 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