MC04P_2MAT SAP (Extraction PP-BW: Material View from MCAFPO) Structure details
Description: Extraction PP-BW: Material View from MCAFPO
Structure field list including key, data, relationships and ABAP select examples
MC04P_2MAT 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 MCAFPO" 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_2MAT TYPE MC04P_2MAT.
The MC04P_2MAT table consists of various fields, each holding specific information or linking keys about Extraction PP-BW: Material View from MCAFPO data available in SAP. These include DFZEH (Unit of measure for execution time), DFZEXEH (Unit for execution time (exact)), ETRMP (Opening date of the planned order), IAMNG (Actual scrap quantity from an order item).. 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_2MAT 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 |
| 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 |
| Key field | Non-key field |
How do I retrieve data from SAP structure MC04P_2MAT using ABAP code?
As MC04P_2MAT 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_2MAT as there is no data to select.How to access SAP table MC04P_2MAT
Within an ECC or HANA version of SAP you can also view further information about MC04P_2MAT 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