AFKO SAP (Order Header Data PP Orders) Table details
Dictionary Type: Table
Description: Order Header Data PP Orders
Description: Order Header Data PP Orders
Table field list including key, data, relationships and ABAP select examples
AFKO is a standard SAP Table which is used to store Order Header Data PP Orders data and is available within R/3 SAP systems depending on the version and release level.
The AFKO table consists of various fields, each holding specific information or linking keys about Order Header Data PP Orders data available in SAP. These include AUFNR (Order Number), GLTRP (Basic finish date), GSTRP (Basic Start Date), FTRMS (Scheduled release date).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AFKO table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
GSTRP | Basic Start Date | PM_ORDGSTRP | DATS | 8 | DATUM | ||||
FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
GASMG | Total scrap quantity in the order | GASMG | QUAN | 13(3) | MENG13 | ||||
GAMNG | Total order quantity | GAMNG | QUAN | 13(3) | MENG13 | ||||
GMEIN | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLNBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
PLNTY | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAW | Application of the task list | PLNAW | CHAR | 1 | TCA09 | PLNAW | |||
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
PLAUF | Date for routing transfer | CO_PLAUF | DATS | 8 | DATUM | ||||
PLSVB | To lot size | LOSGRBIS | QUAN | 13(3) | MENG13 | ||||
PLNME | Task list unit of measure | PLNME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLSVN | From Lot Size | LOSGRVON | QUAN | 13(3) | MENG13 | ||||
PDATV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
PAENR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
LODIV | Lot size divisor | LOSDIV | QUAN | 13(3) | MENG13 | ||||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
STLST | BOM status | STLST | NUMC | 2 | T415S | STLST | |||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
SDATV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
SBMNG | Base quantity | BASMN | QUAN | 13(3) | MENG13 | ||||
SBMEH | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
SAENR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
STLAL | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
STLAN | BOM Usage | STLAN | CHAR | 1 | T416 | STLAN | CSV | ||
SLSVN | From Lot Size | LOSVN | QUAN | 13(3) | MENG13 | ||||
SLSBS | To Lot Size | LOSBS | QUAN | 13(3) | MENG13 | ||||
AUFLD | Date of BOM Explosion/Routing Transfer | CO_AUFLD | DATS | 8 | DATUM | ||||
DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | T024D | DISPO | DGR | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
FEVOR | Production Supervisor | FEVOR | CHAR | 3 | T024F | FEVOR | CFV | ||
FHORI | Scheduling Margin Key for Floats | FHORI | CHAR | 3 | T436A | FHORI | |||
TERKZ | Scheduling type | TERMKZ | CHAR | 1 | T482 | TERART | |||
REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | REDKZ | ||||
APRIO | Order priority | CO_APRIO | CHAR | 1 | CHAR1 | ||||
NTZUE | Superior network number | NETZ_UEBER | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
VORUE | Superior activity | VORG_UEBER | CHAR | 4 | NUMCV | VORNR | |||
PROFID | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
VORGZ | Float before production (in days) | VORGZ | NUMC | 3 | NUM3 | ||||
SICHZ | Float after production (in days) | SICHZ | NUMC | 3 | NUM3 | ||||
FREIZ | Release period (in days) | FREIZ | NUMC | 3 | NUM3 | ||||
UPTER | Indicator: Change to Scheduled Dates | CO_UPTER | CHAR | 1 | CHAR1 | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
PRONR | Project definition | PS_PSP_PRO | NUMC | 8 | PROJ | KONPD | PS_PSPNR | ||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
MZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
ZKRIZ | Counter for additional criteria | DZKRIZ | NUMC | 7 | ZKRIZ | ||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
KLVARP | Costing variant for planned costs | KALKVARPLN | CHAR | 4 | Assigned to domain | KLVAR | |||
KLVARI | Costing variant for actual costs | KALKVARIST | CHAR | 4 | Assigned to domain | KLVAR | |||
RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | CO_RGEKZ | ||||
PLART | Basis for scheduling | PS_PLART | CHAR | 1 | PS_PLART | ||||
FLG_AOB | Indicator: relationships | FLG_AOB | CHAR | 1 | FLAG | ||||
FLG_ARBEI | Indicator: Default value work is relevant | FLG_ARBEI | CHAR | 1 | FLAG | ||||
GLTPP | Finish date (forecast) | CO_GLTPP | DATS | 8 | DATUM | ||||
GSTPP | Forecast start date | CO_GSTPP | DATS | 8 | DATUM | ||||
GLTPS | Scheduled forecast finish | CO_GLTPS | DATS | 8 | DATUM | ||||
GSTPS | Scheduled forecast start | CO_GSTPS | DATS | 8 | DATUM | ||||
FTRPS | Scheduled release date (forecast) | CO_FTRPS | DATS | 8 | DATUM | ||||
RDKZP | Reduction indicator for scheduling (forecast) | REDKZP | CHAR | 1 | REDKZ | ||||
TRKZP | Scheduling type (forecast) | TERMKZP | CHAR | 1 | Assigned to domain | TERART | |||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
IGMNG | Yield confirmed from order confirmation | CO_IGMNG | QUAN | 13(3) | MENG13 | ||||
RATID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
GROID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
GLUZS | Scheduled finish time | CO_GLUZS | TIMS | 6 | UHRZT | ||||
GSUZS | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | ATIME | ||||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
RSHTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
RSHID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
RSNTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
RSNID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
NAUTERM | Indicator: Do not schedule automatically | CO_NAUTERM | CHAR | 1 | KREUZ | ||||
NAUCOST | Indicator: Do not cost automatically | CO_NAUCOST | CHAR | 1 | KREUZ | ||||
STUFE | Level (in multi-level BOM explosions) | HISTU | DEC | 2 | DEC2 | ||||
WEGXX | Path (for multi-level BOM explosions) | WEGXX | DEC | 4 | DEC4 | ||||
VWEGX | Path (for multi-level BOM explosions) | WEGXX | DEC | 4 | DEC4 | ||||
ARSNR | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
ARSPS | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
MAUFNR | Number of superior order | MAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | UAF | |
LKNOT | Left node in collective order | CO_LKNOT | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RKNOT | Right node of a collective order | CO_RKNOT | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
PRODNET | Indicator: Order is part of collective order | CO_PRODNET | CHAR | 1 | KREUZ | ||||
IASMG | Scrap confirmed for order | CO_IASMG | QUAN | 13(3) | MENG13 | ||||
ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
AUFNT | Number of superior network | CO_TEILNET | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
AUFPT | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZT | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | NO_DISP_PLUS | ||||
CSPLIT | Apportionment Structure | CSPLIT | CHAR | 4 | MAKV | CSPLIT | |||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
CY_SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | CY_SEQNR | ||||
BREAKS | Indicator: Scheduling allowing for breaks | BREAKS | CHAR | 1 | XFELD | ||||
VORGZ_TRM | Scheduled float before production in days | VORGZ_TRM | DEC | 6(3) | PUFFER_TRM | ||||
SICHZ_TRM | Scheduled float after production in days | SICHZ_TRM | DEC | 6(3) | PUFFER_TRM | ||||
TRMDT | Date of the last scheduling | TRMDT | DATS | 8 | DATUM | ||||
GLUZP | Basic finish (time) | CO_GLUZP | TIMS | 6 | UHRZT | ||||
GSUZP | Basic start time | CO_GSUZP | TIMS | 6 | UHRZT | ||||
GSUZI | Actual start time | CO_GSUZI | TIMS | 6 | UHRZT | ||||
GEUZI | Confirmed order finish (time) | CO_GEUZI | TIMS | 6 | UHRZT | ||||
GLUPP | Forecast finish (time) | CO_GLUPP | TIMS | 6 | UHRZT | ||||
GSUPP | Forecast start (time) | CO_GSUPP | TIMS | 6 | UHRZT | ||||
GLUPS | Scheduled forecast finish time | CO_GLUPS | TIMS | 6 | UHRZT | ||||
GSUPS | Scheduled start time (Forecast) | CO_GSUPS | TIMS | 6 | UHRZT | ||||
CHSCH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | T683 | KALSM | |||
KAPT_VORGZ | Float (bef. production) remaining after finite scheduling | KAPT_VORGZ | NUMC | 3 | NUM3 | ||||
KAPT_SICHZ | Remaining float after finite scheduling | KAPT_SICHZ | NUMC | 3 | NUM3 | ||||
LEAD_AUFNR | Leading order in current processing | CO_LAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
PNETSTARTD | Outline start of collective network (date) | CO_PSTARTD | DATS | 8 | DATUM | ||||
PNETSTARTT | Start time of a collective order | CO_PSTARTT | TIMS | 6 | ATIME | ||||
PNETENDD | Outline finish of collective order (date) | CO_PENDD | DATS | 8 | DATUM | ||||
PNETENDT | Outline finish time | CO_PENDT | TIMS | 6 | ATIME | ||||
KBED | Ind: do not create capacity requirements | KBED_D | CHAR | 1 | XFELD | ||||
KKALKR | Indicator: Components will not be costed | COMP_CALC | CHAR | 1 | XFELD | ||||
SFCPF | Production Scheduling Profile | CO_PRODPRF | CHAR | 6 | TCO43 | CO_PRODPRF | |||
RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
GSBTR | Overall commitment date | CO_GSBTR | DATS | 8 | DATUM | ||||
VFMNG | Committed quantity for order acc. to ATP check components | CO_VFMNG | QUAN | 13(3) | MENG13 | ||||
NOPCOST | Do not calculate planned costs for order | CO_NOPCOST | CHAR | 1 | XFELD | ||||
NETZKONT | Indicator for the account assignment of a network(hdr/act.) | NETZKONT | CHAR | 1 | NETZKONT | ||||
ATRKZ | Request ID | ATRKZ | CHAR | 1 | ATRKZ | ||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | OCM_OBJ_TYPE | ||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | OCM_CH_PROC | ||||
KAPVERSA | Version of Available Capacity | KAPVERSA | NUMC | 2 | Assigned to domain | KAPVERSION | |||
COLORDPROC | Collective order with/without automatic goods movement | CO_COLORDPRC | CHAR | 1 | CO_COLORDPRC | ||||
KZERB | Indicator: Project summarization via master data charact. | PS_KZERB | CHAR | 1 | XFELD | ||||
CONF_KEY | Identical object | CC_CONF_KEY | NUMC | 8 | CC_NUMC8 | ||||
ST_ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
VSNMR_V | Sales document version number | VSNMR_V | CHAR | 12 | VSNMR | ||||
TERHW | Scheduling note from order scheduling | TERHW | CHAR | 1 | TERHW | ||||
SPLSTAT | Status of an order in a split hierarchy | SPLIT_STAT | CHAR | 1 | SPLIT_STAT | ||||
COSTUPD | Costs are updated | CN_COSTUPD | CHAR | 1 | XFELD | ||||
MAX_GAMNG | Maximum Value of Total Order Quantity After Distribution | CO_MES_MAX_GAMNG | QUAN | 13(3) | MENG13 | ||||
MES_ROUTINGID | Key of a Routing from an ME System | CO_MES_INT_ROUTINGID | CHAR | 64 | CHAR64 | ||||
.INCLU--AP | 0 | ||||||||
ADPSP | PM/PS Reference Element | ADCOMPARE | CHAR | 40 | Assigned to domain | ADDCOMPARE | ADCP | ||
RMANR | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR_RMA | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
POSNV_RMA | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
CFB_MAXLZ | Maximum Storage Period | MAXLZ | DEC | 5 | DEC5 | ||||
CFB_LZEIH | Unit for maximum storage period | LZEIH | UNIT | 3 | T006 | CUNIT | MEINS | ||
CFB_ADTDAYS | Additional Days | CFB_ADTDAYS | DEC | 4 | DECV4 | ||||
CFB_DATOFM | Date of Manufacture | CFB_DATOFM | DATS | 8 | DATUM | ||||
CFB_BBDPI | Best-Before Date (BBD)/ Shelf Life Expiration Date (SLED) | CFB_BBD_PPPI | DATS | 8 | DATUM | ||||
OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | Assigned to domain | OIH_HANTYP | |||
.INCLU--AP | 0 | ||||||||
MILL_RATIO | Factor for Quantity-Based Settlement | MILL_RATIO | INT4 | 10 | CDINT4 | ||||
.INCLU--AP | 0 | ||||||||
BMEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BMENGE | Base quantity | BASMN | QUAN | 13(3) | MENG13 | ||||
MILL_OC_ZUSKZ | Combination Indicator | MILL_OC_ZUSKZ | CHAR | 1 | MILL_OC_ZUSKZ |
Key field | Non-key field |
How do I retrieve data from SAP table AFKO using ABAP code
The following ABAP code Example will allow you to do a basic selection on AFKO to SELECT all data from the tableDATA: WA_AFKO TYPE AFKO.
SELECT SINGLE *
FROM AFKO
INTO CORRESPONDING FIELDS OF WA_AFKO
WHERE...
How to access SAP table AFKO
Within an ECC or HANA version of SAP you can also view further information about AFKO 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