SAP Table IOAFPO
Generated Table for View
IOAFPO (Generated Table for View) 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 IOAFPO to other SAP tables.
IOAFPO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| POSNR | Order Item Number | CO_POSNR | NUMC | 4 | 0 | |||||||||||||||||||||||||||||
| KDAUF | Sales order number | CO_KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| KDPOS | Sales order item | CO_KDPOS | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||||||||||
| MATNR | Material Number for Order | CO_MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| DAUTY | Order category | AUFTYP | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| DAUAT | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | PRPS | NUMC | 8 | 0 | ||||||||||||||||||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| PWERK | Planning plant for the order | CO_PWERK | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| DISPO | MRP controller for the order | CO_DISPO | T024D | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| FEVOR | Production Supervisor | FEVOR | T024F | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| GSTRP | Basic Start Date | PM_ORDGSTRP | 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 | |||||||||||||||||||||||||||||
| GLTRI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| FTRMI | Actual release date | CO_FTRMI | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| CY_SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | 0 | |||||||||||||||||||||||||||||
| APRIO | Order priority | CO_APRIO | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| VERID | Production Version | VERID | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
IOAFPO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| IOAFPO | AUFNR | IOAFPO | MANDT | AUFK | Order master data | MANDT |
| IOAFPO | AUFNR | IOAFPO | AUFNR | AUFK | Order master data | AUFNR |
| IOAFPO | DAUAT | IOAFPO | MANDT | T003O | Order Types | CLIENT |
| IOAFPO | DAUAT | IOAFPO | DAUAT | T003O | Order Types | AUART |
| IOAFPO | DISPO | IOAFPO | MANDT | T024D | MRP controllers | MANDT |
| IOAFPO | DISPO | AUFK | WERKS | T024D | MRP controllers | WERKS |
| IOAFPO | DISPO | IOAFPO | DISPO | T024D | MRP controllers | DISPO |
| IOAFPO | FEVOR | IOAFPO | MANDT | T024F | Production scheduler | MANDT |
| IOAFPO | FEVOR | AUFK | WERKS | T024F | Production scheduler | WERKS |
| IOAFPO | FEVOR | IOAFPO | FEVOR | T024F | Production scheduler | FEVOR |
| IOAFPO | KDAUF | IOAFPO | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| IOAFPO | KDAUF | IOAFPO | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| IOAFPO | KDPOS | IOAFPO | KDAUF | VBUP | Sales Document: Item Status | VBELN |
| IOAFPO | KDPOS | IOAFPO | KDPOS | VBUP | Sales Document: Item Status | POSNR |
| IOAFPO | KDPOS | IOAFPO | MANDT | VBUP | Sales Document: Item Status | MANDT |
| IOAFPO | MANDT | IOAFPO | MANDT | T000 | Clients | MANDT |
| IOAFPO | MATNR | IOAFPO | MANDT | MARA | General Material Data | MANDT |
| IOAFPO | MATNR | IOAFPO | MATNR | MARA | General Material Data | MATNR |
| IOAFPO | PROJN | IOAFPO | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| IOAFPO | PROJN | IOAFPO | PROJN | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| IOAFPO | PWERK | IOAFPO | MANDT | T001W | Plants/Branches | MANDT |
| IOAFPO | PWERK | IOAFPO | PWERK | T001W | Plants/Branches | WERKS |
| IOAFPO | WERKS | IOAFPO | MANDT | T001W | Plants/Branches | MANDT |
| IOAFPO | WERKS | IOAFPO | WERKS | T001W | Plants/Branches | WERKS |
