1. Home
  2. Resources
  3. SAP Tables
  4. AFKO - Order Header Data PP Orders

SAP Table AFKO

Order Header Data PP Orders

AFKO (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 AFKO to other SAP tables.

AFKO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
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
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
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
GASMG Total scrap quantity in the order GASMG QUAN 13 3
GAMNG Total order quantity GAMNG QUAN 13 3
GMEIN Base Unit of Measure MEINS T006 UNIT 3 0
PLNBEZ Material Number MATNR MARA CHAR 18 0
PLNTY Task List Type PLNTY CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAW Application of the task list PLNAW TCA09 CHAR 1 0
PLNAL Group Counter PLNAL CHAR 2 0
PVERW Task list usage PLN_VERWE T411 CHAR 3 0
PLAUF Date for routing transfer CO_PLAUF DATS 8 0
PLSVB To lot size LOSGRBIS QUAN 13 3
PLNME Task list unit of measure PLNME T006 UNIT 3 0
PLSVN From Lot Size LOSGRVON QUAN 13 3
PDATV Valid-From Date DATUV DATS 8 0
PAENR Change Number AENNR AENR CHAR 12 0
PLGRP Responsible planner group/department VAGRP T024A CHAR 3 0
LODIV Lot size divisor LOSDIV QUAN 13 3
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLBEZ Material Number MATNR MARA CHAR 18 0
STLST BOM status STLST T415S NUMC 2 0
STLNR Bill of material STNUM CHAR 8 0
SDATV Valid-From Date DATUV DATS 8 0
SBMNG Base quantity BASMN QUAN 13 3
SBMEH Base Unit of Measure MEINS T006 UNIT 3 0
SAENR Change Number AENNR AENR CHAR 12 0
STLAL Alternative BOM STALT CHAR 2 0
STLAN BOM Usage STLAN T416 CHAR 1 0
SLSVN From Lot Size LOSVN QUAN 13 3
SLSBS To Lot Size LOSBS QUAN 13 3
AUFLD Date of BOM Explosion/Routing Transfer CO_AUFLD DATS 8 0
DISPO MRP controller for the order CO_DISPO T024D CHAR 3 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
FEVOR Production Supervisor FEVOR T024F CHAR 3 0
FHORI Scheduling Margin Key for Floats FHORI T436A CHAR 3 0
TERKZ Scheduling type TERMKZ T482 CHAR 1 0
REDKZ Reduction indicator for scheduling REDKZ CHAR 1 0
NULL No reduction carried out
1 Reduction level 1
2 Reduction level 2
3 Reduction level 3
4 Reduction level 4
5 Reduction level 5
6 Reduction level 6
APRIO Order priority CO_APRIO CHAR 1 0
NTZUE Superior network number NETZ_UEBER AUFK CHAR 12 0
VORUE Superior activity VORG_UEBER CHAR 4 0
PROFID Network profile PROFIDNZPL TCN41 CHAR 7 0
VORGZ Float before production (in days) VORGZ NUMC 3 0
SICHZ Float after production (in days) SICHZ NUMC 3 0
FREIZ Release period (in days) FREIZ NUMC 3 0
UPTER Indicator: Change to Scheduled Dates CO_UPTER CHAR 1 0
BEDID ID of the capacity requirements record BEDID NUMC 12 0
PRONR Project definition PS_PSP_PRO PROJ NUMC 8 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
MZAEHL Internal counter CIM_COUNT NUMC 8 0
ZKRIZ Counter for additional criteria DZKRIZ NUMC 7 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
KLVARP Costing variant for planned costs KALKVARPLN CHAR 4 0
KLVARI Costing variant for actual costs KALKVARIST CHAR 4 0
RGEKZ Indicator: Backflushing for order CO_RGEKZ CHAR 1 0
1 Backflush components during goods receipt
2 Backflush all components during goods receipt
PLART Basis for scheduling PS_PLART CHAR 1 0
1 Basic dates
2 Forecast dates
FLG_AOB Indicator: relationships FLG_AOB CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
FLG_ARBEI Indicator: Default value work is relevant FLG_ARBEI CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
GLTPP Finish date (forecast) CO_GLTPP DATS 8 0
GSTPP Forecast start date CO_GSTPP DATS 8 0
GLTPS Scheduled forecast finish CO_GLTPS DATS 8 0
GSTPS Scheduled forecast start CO_GSTPS DATS 8 0
FTRPS Scheduled release date (forecast) CO_FTRPS DATS 8 0
RDKZP Reduction indicator for scheduling (forecast) REDKZP CHAR 1 0
NULL No reduction carried out
1 Reduction level 1
2 Reduction level 2
3 Reduction level 3
4 Reduction level 4
5 Reduction level 5
6 Reduction level 6
TRKZP Scheduling type (forecast) TERMKZP CHAR 1 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Internal counter CIM_COUNT NUMC 8 0
IGMNG Yield confirmed from order confirmation CO_IGMNG QUAN 13 3
RATID ID of the capacity requirements record BEDID NUMC 12 0
GROID ID of the capacity requirements record BEDID NUMC 12 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
GLUZS Scheduled finish time CO_GLUZS TIMS 6 0
GSUZS Scheduled Start (Time) CO_GSUZS TIMS 6 0
REVLV Revision Level REVLV CHAR 2 0
RSHTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
RSHID Object ID of the resource CR_OBJID CRID NUMC 8 0
RSNTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
RSNID Object ID of the resource CR_OBJID CRID NUMC 8 0
NAUTERM Indicator: Do not schedule automatically CO_NAUTERM CHAR 1 0
X
NULL
NAUCOST Indicator: Do not cost automatically CO_NAUCOST CHAR 1 0
X
NULL
STUFE Level (in multi-level BOM explosions) HISTU DEC 2 0
WEGXX Path (for multi-level BOM explosions) WEGXX DEC 4 0
VWEGX Path (for multi-level BOM explosions) WEGXX DEC 4 0
ARSNR Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
ARSPS Order Item Number CO_POSNR NUMC 4 0
MAUFNR Number of superior order MAUFNR CHAR 12 0
LKNOT Left node in collective order CO_LKNOT CHAR 12 0
RKNOT Right node of a collective order CO_RKNOT CHAR 12 0
PRODNET Indicator: Order is part of collective order CO_PRODNET CHAR 1 0
X
NULL
IASMG Scrap confirmed for order CO_IASMG QUAN 13 3
ABARB Confirmation: Degree of processing CO_ABARB NUMC 3 0
AUFNT Number of superior network CO_TEILNET CHAR 12 0
AUFPT Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZT General counter for order CO_APLZL NUMC 8 0
NO_DISP Effective for Materials Planning NO_DISP_PLUS CHAR 1 0
1 Not relevant to materials planning
X Relevant to materials planning at a defined time
NULL Relevant to materials planning
CSPLIT Apportionment Structure CSPLIT MAKV CHAR 4 0
AENNR Change Number AENNR AENR CHAR 12 0
CY_SEQNR Seq. number order CY_SEQNR NUMC 14 0
BREAKS Indicator: Scheduling allowing for breaks BREAKS CHAR 1 0
X Yes
NULL No
VORGZ_TRM Scheduled float before production in days VORGZ_TRM DEC 6 3
SICHZ_TRM Scheduled float after production in days SICHZ_TRM DEC 6 3
TRMDT Date of the last scheduling TRMDT DATS 8 0
GLUZP Basic finish (time) CO_GLUZP TIMS 6 0
GSUZP Basic start time CO_GSUZP TIMS 6 0
GSUZI Actual start time CO_GSUZI TIMS 6 0
GEUZI Confirmed order finish (time) CO_GEUZI TIMS 6 0
GLUPP Forecast finish (time) CO_GLUPP TIMS 6 0
GSUPP Forecast start (time) CO_GSUPP TIMS 6 0
GLUPS Scheduled forecast finish time CO_GLUPS TIMS 6 0
GSUPS Scheduled start time (Forecast) CO_GSUPS TIMS 6 0
CHSCH Search procedure for batch determination KALSMA_CH T683 CHAR 6 0
KAPT_VORGZ Float (bef. production) remaining after finite scheduling KAPT_VORGZ NUMC 3 0
KAPT_SICHZ Remaining float after finite scheduling KAPT_SICHZ NUMC 3 0
LEAD_AUFNR Leading order in current processing CO_LAUFNR AUFK CHAR 12 0
PNETSTARTD Outline start of collective network (date) CO_PSTARTD DATS 8 0
PNETSTARTT Start time of a collective order CO_PSTARTT TIMS 6 0
PNETENDD Outline finish of collective order (date) CO_PENDD DATS 8 0
PNETENDT Outline finish time CO_PENDT TIMS 6 0
KBED Ind: do not create capacity requirements KBED_D CHAR 1 0
X Yes
NULL No
KKALKR Indicator: Components will not be costed COMP_CALC CHAR 1 0
X Yes
NULL No
SFCPF Production Scheduling Profile CO_PRODPRF TCO43 CHAR 6 0
RMNGA Total confirmed rework quantity RMNGA QUAN 13 3
GSBTR Overall commitment date CO_GSBTR DATS 8 0
VFMNG Committed quantity for order acc. to ATP check components CO_VFMNG QUAN 13 3
NOPCOST Do not calculate planned costs for order CO_NOPCOST CHAR 1 0
X Yes
NULL No
NETZKONT Indicator for the account assignment of a network(hdr/act.) NETZKONT CHAR 1 0
NULL Account assignment determined by status
1 Header-assigned network
2 Activity-assigned network
ATRKZ Request ID ATRKZ CHAR 1 0
NULL Standard request
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1 0
+ Object created
- Object is to be deleted
C Object changed
M Object reassigned
NULL Normal object
0 Zero Object
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1 0
NULL Not changed
1 Manually changed
2 Change sales order
3 Release of change number
4 Change assembly order
5 Change number supplement
6 Change number shift
7 Direct assignment
KAPVERSA Version of Available Capacity KAPVERSA NUMC 2 0
COLORDPROC Collective order with/without automatic goods movement CO_COLORDPRC CHAR 1 0
NULL Collective order without automatic goods movement
X Collective order with automatic goods movement
KZERB Indicator: Project summarization via master data charact. PS_KZERB CHAR 1 0
X Yes
NULL No
CONF_KEY Identical object CC_CONF_KEY NUMC 8 0
ST_ARBID Object ID OBJEKTID NUMC 8 0
VSNMR_V Sales document version number VSNMR_V CHAR 12 0
TERHW Scheduling note from order scheduling TERHW CHAR 1 0
NULL No scheduling note
1 Basic finish date is before scheduled finish
2 Automatically carried out today scheduling
SPLSTAT Status of an order in a split hierarchy SPLIT_STAT CHAR 1 0
NULL not split, not created by splitting
1 split
2 created by splitting
3 created by splitting and split
COSTUPD Costs are updated CN_COSTUPD CHAR 1 0
X Yes
NULL No
MAX_GAMNG Maximum Value of Total Order Quantity After Distribution CO_MES_MAX_GAMNG QUAN 13 3
MES_ROUTINGID Key of a Routing from an ME System CO_MES_INT_ROUTINGID CHAR 64 0
ADPSP PM/PS Reference Element ADCOMPARE CHAR 40 0
RMANR Sales and Distribution Document Number VBELN CHAR 10 0
POSNR_RMA Item number of the SD document POSNR NUMC 6 0
POSNV_RMA Item number of the SD document POSNR NUMC 6 0
CFB_MAXLZ Maximum Storage Period MAXLZ DEC 5 0
CFB_LZEIH Unit for maximum storage period LZEIH T006 UNIT 3 0
CFB_ADTDAYS Additional Days CFB_ADTDAYS DEC 4 0
CFB_DATOFM Date of Manufacture CFB_DATOFM DATS 8 0
CFB_BBDPI Best-Before Date (BBD)/ Shelf Life Expiration Date (SLED) CFB_BBD_PPPI DATS 8 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
MILL_RATIO Factor for Quantity-Based Settlement MILL_RATIO INT4 10 0
BMEINS Base Unit of Measure MEINS UNIT 3 0
BMENGE Base quantity BASMN QUAN 13 3
MILL_OC_ZUSKZ Combination Indicator MILL_OC_ZUSKZ CHAR 1 0
H Combination by Order
O Combination by Operation

AFKO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFKO AENNR AFKO MANDT AENR Change Master MANDT
AFKO AENNR AFKO AENNR AENR Change Master AENNR
AFKO AUFNR AFKO MANDT AUFK Order master data MANDT
AFKO AUFNR AFKO AUFNR AUFK Order master data AUFNR
AFKO CFB_LZEIH SYST MANDT T006 Units of Measurement MANDT
AFKO CFB_LZEIH AFKO CFB_LZEIH T006 Units of Measurement MSEHI
AFKO CHSCH 'PP' T683 Pricing procedures KAPPL
AFKO CHSCH AFKO CHSCH T683 Pricing procedures KALSM
AFKO CHSCH AFKO MANDT T683 Pricing procedures MANDT
AFKO CHSCH 'H' T683 Pricing procedures KVEWE
AFKO CSPLIT AFKO MANDT MAKV Material Cost Distribution MANDT
AFKO CSPLIT AFKO STLBEZ MAKV Material Cost Distribution MATNR
AFKO CSPLIT AUFK WERKS MAKV Material Cost Distribution WERKS
AFKO CSPLIT AFKO CSPLIT MAKV Material Cost Distribution CSPLIT
AFKO DISPO AFKO MANDT T024D MRP controllers MANDT
AFKO DISPO AUFK WERKS T024D MRP controllers WERKS
AFKO DISPO AFKO DISPO T024D MRP controllers DISPO
AFKO FEVOR AFKO MANDT T024F Production scheduler MANDT
AFKO FEVOR AUFK WERKS T024F Production scheduler WERKS
AFKO FEVOR AFKO FEVOR T024F Production scheduler FEVOR
AFKO FHORI AFKO FHORI T436A Floats for scheduling FHORI
AFKO FHORI AFKO MANDT T436A Floats for scheduling MANDT
AFKO FHORI AUFK WERKS T436A Floats for scheduling WERKS
AFKO GMEIN AFKO GMEIN T006 Units of Measurement MSEHI
AFKO GMEIN AFKO MANDT T006 Units of Measurement MANDT
AFKO LEAD_AUFNR AFKO MANDT AUFK Order master data MANDT
AFKO LEAD_AUFNR AFKO LEAD_AUFNR AUFK Order master data AUFNR
AFKO MANDT AFKO MANDT T000 Clients MANDT
AFKO NTZUE AFKO NTZUE AUFK Order master data AUFNR
AFKO NTZUE AFKO MANDT AUFK Order master data MANDT
AFKO PAENR AFKO MANDT AENR Change Master MANDT
AFKO PAENR AFKO PAENR AENR Change Master AENNR
AFKO PLGRP AUFK WERKS T024A Planner group WERKS
AFKO PLGRP AFKO PLGRP T024A Planner group FEVOR
AFKO PLGRP AFKO MANDT T024A Planner group MANDT
AFKO PLNAW AFKO MANDT TCA09 Task list applications MANDT
AFKO PLNAW AFKO PLNAW TCA09 Task list applications PLNAW
AFKO PLNBEZ AFKO MANDT MARA General Material Data MANDT
AFKO PLNBEZ AFKO PLNBEZ MARA General Material Data MATNR
AFKO PLNME AFKO MANDT T006 Units of Measurement MANDT
AFKO PLNME AFKO PLNME T006 Units of Measurement MSEHI
AFKO PROFID AFKO PLNAW TCN41 Network Defaults PLNAW
AFKO PROFID AFKO PROFID TCN41 Network Defaults PROFIDNETZ
AFKO PROFID AFKO MANDT TCN41 Network Defaults MANDT
AFKO PRONR AFKO PRONR PROJ Project definition PSPNR
AFKO PRONR AFKO MANDT PROJ Project definition MANDT
AFKO PVERW AFKO MANDT T411 Task list usage MANDT
AFKO PVERW AFKO PVERW T411 Task list usage VERWE
AFKO RSHID AFKO MANDT CRID CIM Resource - Entities MANDT
AFKO RSHID AFKO RSHTY CRID CIM Resource - Entities OBJTY
AFKO RSHID AFKO RSHID CRID CIM Resource - Entities OBJID
AFKO RSNID AFKO RSNTY CRID CIM Resource - Entities OBJTY
AFKO RSNID AFKO RSNID CRID CIM Resource - Entities OBJID
AFKO RSNID AFKO MANDT CRID CIM Resource - Entities MANDT
AFKO SAENR AFKO MANDT AENR Change Master MANDT
AFKO SAENR AFKO SAENR AENR Change Master AENNR
AFKO SBMEH AFKO MANDT T006 Units of Measurement MANDT
AFKO SBMEH AFKO SBMEH T006 Units of Measurement MSEHI
AFKO SFCPF AFKO MANDT TCO43 PP-SFC Order Profile MANDT
AFKO SFCPF AUFK WERKS TCO43 PP-SFC Order Profile WERKS
AFKO SFCPF AFKO SFCPF TCO43 PP-SFC Order Profile CO_PRODPRF
AFKO STLAN AFKO MANDT T416 BOM Usage - Item Statuses MANDT
AFKO STLAN AFKO STLAN T416 BOM Usage - Item Statuses STLAN
AFKO STLBEZ AFKO MANDT MARA General Material Data MANDT
AFKO STLBEZ AFKO STLBEZ MARA General Material Data MATNR
AFKO STLST AFKO MANDT T415S BOM status MANDT
AFKO STLST AFKO STLST T415S BOM status STLST
AFKO TERKZ AFKO MANDT T482 Table of scheduling types MANDT
AFKO TERKZ AFKO TERKZ T482 Table of scheduling types TERMKZ