SAP Table MCAFKO
Order header data PP orders
MCAFKO (Order header data PP orders) 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 MCAFKO to other SAP tables.
MCAFKO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | 0 | |||||||||||||||||||||||||||||
| AUART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| AUTYP | Order category | AUFTYP | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| ERDAT | Created on | AUFERFDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| PLGRP | Responsible planner group/department | VAGRP | T024A | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| DISPO | MRP controller for the order | CO_DISPO | T024D | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| FEVOR | Production Supervisor | FEVOR | T024F | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GSTRP | Basic start date | CO_GSTRP | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GSTRI | Actual start date | CO_GSTRI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| FTRMI | Actual release date | CO_FTRMI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| FTRMP | Planned release date | CO_FTRMP | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GASMG | Total Scrap Quantity in the Order | MC_GASMG | QUAN | 15 | 3 | |||||||||||||||||||||||||||||
| GAMNG | Total order quantity | MC_GAMNG | QUAN | 15 | 3 | |||||||||||||||||||||||||||||
| GMEIN | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||
| VERID | Production Version | VERID | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
| MDV01 | Production line | MDV01 | T437P | CHAR | 8 | 0 | ||||||||||||||||||||||||||||
| MDV02 | Planning identification 2 | MDV02 | T437P | CHAR | 8 | 0 | ||||||||||||||||||||||||||||
| KUNUM | Customer Number | KUNUM | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| AMEIN | Unit of measure for in-house production | CO_AUFME | UNIT | 3 | 0 | |||||||||||||||||||||||||||||
| VDATU | Date of update for statistics updating | MC_VDATUM | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| TERKZ | Scheduling type | TERMKZ | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| FA_FREI | Order has status RELEASED | MC_FA_FREI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| FA_GLFT | Order has status DELIVERED | MC_FA_GLFT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| FA_RUECK | Order has status CONFIRMED | MC_FA_RUECK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| FA_TGLI | Order has Status PDLV | MC_FA_TGLI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| FA_TRUEC | Order has status PARTIALLY CONFIRMED | MC_FA_TRUEC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| GLUZS | Scheduled finish time | CO_GLUZS | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| GSUZS | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| GSUZI | Actual start time | CO_GSUZI | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| GEUZI | Confirmed order finish (time) | CO_GEUZI | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| PLNME | Task list unit of measure | PLNME | UNIT | 3 | 0 | |||||||||||||||||||||||||||||
| LEAD_AUFNR | Leading order in current processing | CO_LAUFNR | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| MAUFNR | Number of superior order | MAUFNR | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| A | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
MCAFKO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCAFKO | AUART | SYST | MANDT | T003O | Order Types | CLIENT |
| MCAFKO | AUART | MCAFKO | AUART | T003O | Order Types | AUART |
| MCAFKO | AUFNR | SYST | MANDT | AUFK | Order master data | MANDT |
| MCAFKO | AUFNR | MCAFKO | AUFNR | AUFK | Order master data | AUFNR |
| MCAFKO | BUKRS | SYST | MANDT | T001 | Company Codes | MANDT |
| MCAFKO | BUKRS | MCAFKO | BUKRS | T001 | Company Codes | BUKRS |
| MCAFKO | DISPO | SYST | MANDT | T024D | MRP controllers | MANDT |
| MCAFKO | DISPO | MCAFKO | WERKS | T024D | MRP controllers | WERKS |
| MCAFKO | DISPO | MCAFKO | DISPO | T024D | MRP controllers | DISPO |
| MCAFKO | FEVOR | SYST | MANDT | T024F | Production scheduler | MANDT |
| MCAFKO | FEVOR | MCAFKO | WERKS | T024F | Production scheduler | WERKS |
| MCAFKO | FEVOR | MCAFKO | FEVOR | T024F | Production scheduler | FEVOR |
| MCAFKO | GMEIN | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MCAFKO | GMEIN | MCAFKO | GMEIN | T006 | Units of Measurement | MSEHI |
| MCAFKO | KUNUM | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
| MCAFKO | KUNUM | MCAFKO | KUNUM | KNA1 | General Data in Customer Master | KUNNR |
| MCAFKO | MDV01 | MCAFKO | MDV01 | T437P | Planning IDs for Repetitive Manufacturing | PLAN_ID |
| MCAFKO | MDV01 | SYST | MANDT | T437P | Planning IDs for Repetitive Manufacturing | MANDT |
| MCAFKO | MDV01 | MCAFKO | WERKS | T437P | Planning IDs for Repetitive Manufacturing | WERKS |
| MCAFKO | MDV02 | SYST | MANDT | T437P | Planning IDs for Repetitive Manufacturing | MANDT |
| MCAFKO | MDV02 | MCAFKO | WERKS | T437P | Planning IDs for Repetitive Manufacturing | WERKS |
| MCAFKO | MDV02 | MCAFKO | MDV02 | T437P | Planning IDs for Repetitive Manufacturing | PLAN_ID |
| MCAFKO | OBJNR | SYST | MANDT | ONR00 | General Object Number | MANDT |
| MCAFKO | OBJNR | MCAFKO | OBJNR | ONR00 | General Object Number | OBJNR |
| MCAFKO | PLGRP | SYST | MANDT | T024A | Planner group | MANDT |
| MCAFKO | PLGRP | MCAFKO | WERKS | T024A | Planner group | WERKS |
| MCAFKO | PLGRP | MCAFKO | PLGRP | T024A | Planner group | FEVOR |
| MCAFKO | WERKS | MCAFKO | WERKS | T001W | Plants/Branches | WERKS |
| MCAFKO | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
