1. Home
  2. Resources
  3. SAP Tables
  4. MC04P_0MAT - Extraction PP-BW: Material View from PP/PP-PI

SAP Table MC04P_0MAT

Extraction PP-BW: Material View from PP/PP-PI

MC04P_0MAT (Extraction PP-BW: Material View from PP/PP-PI) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MC04P_0MAT to other SAP tables.

MC04P_0MAT table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
AUFNR Order Number AUFNR CHAR 12 0
BUKRS Company Code BUKRS CHAR 4 0
ERDAT Created on AUFERFDAT DATS 8 0
FA_GLFT Order has status DELIVERED MC_FA_GLFT CHAR 1 0
X Yes
NULL No
FTRMI Actual release date CO_FTRMI DATS 8 0
FTRMP Planned release date CO_FTRMP DATS 8 0
FTRMS Scheduled release date CO_FTRMS DATS 8 0
GETRI Confirmed Order Finish Date CO_GETRI DATS 8 0
GLTRP Basic finish date CO_GLTRP DATS 8 0
GLTRS Scheduled finish CO_GLTRS DATS 8 0
GSTRI Actual start date CO_GSTRI DATS 8 0
GSTRP Basic start date CO_GSTRP DATS 8 0
GSTRS Scheduled start CO_GSTRS DATS 8 0
LEAD_AUFNR Leading order in current processing CO_LAUFNR CHAR 12 0
MAUFNR Number of superior order MAUFNR CHAR 12 0
WERKS Plant WERKS_D CHAR 4 0
BUDAT Posting date delivery/finish date, actual MC_LTRMI DATS 8 0
DFZEH Unit of measure for execution time DFZEH UNIT 3 0
DFZEXEH Unit for execution time (exact) DFZEXEH UNIT 3 0
ETRMP Opening date of the planned order CO_ETRMP DATS 8 0
IAMNG Actual scrap quantity from an order item MC_IAMNG QUAN 15 3
I_DFZ Actual execution time I_DFZ QUAN 7 1
I_DFZ_EX Actual execution time (exact) I_DFZ_EX QUAN 12 2
I_DLZ Actual lead time I_DLZ QUAN 7 1
I_DLZ_EX Actual lead time (exact) I_DLZ_EX QUAN 12 2
KDAUF Sales order number CO_KDAUF CHAR 10 0
KEINH Unit of of measure for displaying capacity requirements CY_KEINH UNIT 3 0
KSUMS Total target capacity requirements MC_KSUMS QUAN 7 1
LTRMI Actual delivery/finish date CO_LTRMI DATS 8 0
LTRMP Delivery date from planned order CO_LTRMP DATS 8 0
MATNR Material Number MATNR CHAR 18 0
MEINS Base Unit of Measure LAGME UNIT 3 0
PAMNG Fixed quantity of scrap from production MC_AVMNG QUAN 15 3
PGMNG Total planned order quantity MC_GSMNG QUAN 15 3
PI_FREI Planned/actual deviation in scheduled release date PI_FREI QUAN 7 1
PI_LIEF Planned/actual deviation in scheduled delivery date PI_LIEF QUAN 7 1
PI_STAR Planned/actual deviation in scheduled start date PI_STAR QUAN 7 1
PLNUM Planned order number PLNUM CHAR 10 0
POSNR Order Item Number CO_POSNR NUMC 4 0
PSAMG Scrap quantity in item MC_PSAMG QUAN 15 3
PSMNG Order item quantity MC_PSMNG QUAN 15 3
PS_FREI Planned/target deviation in scheduled release date PS_FREI QUAN 7 1
PS_LIEF Planned/target deviation in scheduled delivery date PS_LIEF QUAN 7 1
PS_STAR Planned/target deviation in start date PS_STAR QUAN 7 1
PWERK Planning plant for the order CO_PWERK CHAR 4 0
P_DLZ Planned lead time P_DLZ QUAN 7 1
SI_FREI Target/actual deviation in scheduled release date DSI_FREI QUAN 7 1
SI_LIEF Target/actual deviation in scheduled delivery date DSI_LIEF QUAN 7 1
SI_STAR Target/actual schedule deviation in start date DSI_STAR QUAN 7 1
STRMP Start date of the planned order CO_STRMP DATS 8 0
S_DFZ Target execution time S_DFZ QUAN 7 1
S_DFZ_EX Target execution time (exact) S_DFZ_EX QUAN 12 2
S_DLZ Target lead time S_DLZ QUAN 7 1
S_DLZ_EX Target lead time (exact) S_DLZ_EX QUAN 12 2
WEMNG Quantity of goods received MC_WEMNG QUAN 15 3
ZEITP Event for which updating should take place DZEITP CHAR 2 0
LEAD_MATNR Material Number of Leading Order LEAD_MATNR CHAR 18 0