SAP table AFKO (Order Header Data PP Orders)

SAP table AFKO has 2 primary key fields being MANDT,AUFNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
GLTRP Basic finish date DATS 8 0 CO_GLTRP
GSTRP Basic Start Date DATS 8 0 PM_ORDGSTRP
FTRMS Scheduled release date DATS 8 0 CO_FTRMS
GLTRS Scheduled finish DATS 8 0 CO_GLTRS
GSTRS Scheduled start DATS 8 0 CO_GSTRS
GSTRI Actual start date DATS 8 0 CO_GSTRI
GETRI Confirmed Order Finish Date DATS 8 0 CO_GETRI
GLTRI Actual finish date DATS 8 0 CO_GLTRI
FTRMI Actual release date DATS 8 0 CO_FTRMI
FTRMP Planned Release Date DATS 8 0 CO_FTRMP
RSNUM Number of reservation/dependent requirements NUMC 10 0 * RSNUM
GASMG Total Scrap Quantity in the Order QUAN 13 3 GASMG
GAMNG Total Order Quantity QUAN 13 3 GAMNG
GMEIN Base Unit of Measure UNIT 3 0 T006 MEINS
PLNBEZ Material Number CHAR 40 0 MARA MATNR
PLNTY Task List Type CHAR 1 0 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAW Application of the task list CHAR 1 0 TCA09 PLNAW
PLNAL Group Counter CHAR 2 0 PLNAL
PVERW Task List Usage CHAR 3 0 T411 PLN_VERWE
PLAUF Date for Routing Explosion DATS 8 0 CO_PLAUF
PLSVB Maximum Lot Size QUAN 13 3 LOSGRBIS
PLNME Task List Unit of Measure UNIT 3 0 T006 PLNME
PLSVN Minimum Lot Size QUAN 13 3 LOSGRVON
PDATV Valid-From Date DATS 8 0 DATUV
PAENR Change Number CHAR 12 0 AENR AENNR
PLGRP Responsible Planner Group or Department CHAR 3 0 T024A VAGRP
LODIV Lot size divisor (not used) QUAN 13 3 LOSDIV
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLBEZ Material Number CHAR 40 0 MARA MATNR
STLST Bill of Material Status NUMC 2 0 T415S STLST
STLNR Bill of Material CHAR 8 0 STNUM
SDATV Valid-From Date DATS 8 0 DATUV
SBMNG Base quantity QUAN 13 3 BASMN
SBMEH Base Unit of Measure UNIT 3 0 T006 MEINS
SAENR Change Number CHAR 12 0 AENR AENNR
STLAL Alternative BOM CHAR 2 0 STALT
STLAN BOM Usage CHAR 1 0 T416 STLAN
SLSVN From Lot Size QUAN 13 3 LOSVN
SLSBS To Lot Size QUAN 13 3 LOSBS
AUFLD Date of BOM Explosion/Routing Transfer DATS 8 0 CO_AUFLD
DISPO MRP controller for the order CHAR 3 0 T024D CO_DISPO
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
FEVOR Production Supervisor CHAR 3 0 T024F FEVOR
FHORI Scheduling Margin Key for Floats CHAR 3 0 T436A FHORI
TERKZ Scheduling type CHAR 1 0 T482 TERMKZ
REDKZ Reduction indicator for scheduling CHAR 1 0 REDKZ
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 CHAR 1 0 CO_APRIO
NTZUE Superior network number CHAR 12 0 AUFK NETZ_UEBER
VORUE Superior activity CHAR 4 0 VORG_UEBER
PROFID Network Profile CHAR 7 0 TCN41 PROFIDNZPL
VORGZ Float before production (in days) NUMC 3 0 VORGZ
SICHZ Float after production (in days) NUMC 3 0 SICHZ
FREIZ Release period (in days) NUMC 3 0 FREIZ
UPTER Indicator: Change to Scheduled Dates CHAR 1 0 CO_UPTER
BEDID ID of the Capacity Requirements Record NUMC 12 0 * BEDID
PRONR Project definition NUMC 8 0 PROJ PS_PSP_PRO
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
MZAEHL Internal counter NUMC 8 0 CIM_COUNT
ZKRIZ Counter for Additional Criteria NUMC 7 0 DZKRIZ
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
KLVARP Costing Variant for Planned Costs CHAR 4 0 * KALKVARPLN
KLVARI Costing Variant For Actual Costs CHAR 4 0 * KALKVARIST
RGEKZ Indicator: Backflushing for order CHAR 1 0 CO_RGEKZ
1 Backflush components during goods receipt
2 Backflush all components during goods receipt
PLART Basis for scheduling CHAR 1 0 PS_PLART
1 Basic dates
2 Forecast dates
FLG_AOB Indicator: relationships CHAR 1 0 FLG_AOB
FLG_ARBEI Indicator: Default value work is relevant CHAR 1 0 FLG_ARBEI
GLTPP Finish date (forecast) DATS 8 0 CO_GLTPP
GSTPP Forecast start date DATS 8 0 CO_GSTPP
GLTPS Scheduled forecast finish DATS 8 0 CO_GLTPS
GSTPS Scheduled forecast start DATS 8 0 CO_GSTPS
FTRPS Scheduled release date (forecast) DATS 8 0 CO_FTRPS
RDKZP Reduction indicator for scheduling (forecast) CHAR 1 0 REDKZP
TRKZP Scheduling type (forecast) CHAR 1 0 * TERMKZP
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Internal counter NUMC 8 0 CIM_COUNT
IGMNG Confirmed Yield Quantity From Order Confirmation QUAN 13 3 CO_IGMNG
RATID -INVALID FOR S/4- Index for the rslts of schedg prod. rates NUMC 12 0 * RATID
GROID -INVALID FOR S/4- Index for rough scheduling results NUMC 12 0 * GROID
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
GLUZS Scheduled finish time TIMS 6 0 CO_GLUZS
GSUZS Scheduled Start (Time) TIMS 6 0 CO_GSUZS
REVLV Revision Level CHAR 2 0 REVLV
RSHTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
RSHID Object ID of the resource NUMC 8 0 CRID CR_OBJID
RSNTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
RSNID Object ID of the resource NUMC 8 0 CRID CR_OBJID
NAUTERM Indicator: Do not schedule automatically CHAR 1 0 CO_NAUTERM
NAUCOST Indicator: Do not cost automatically CHAR 1 0 CO_NAUCOST
STUFE Level (in multi-level BOM explosions) DEC 2 0 HISTU
WEGXX Path (for multi-level BOM explosions) DEC 4 0 WEGXX
VWEGX Path (for multi-level BOM explosions) DEC 4 0 WEGXX
ARSNR Number of reservation/dependent requirements NUMC 10 0 * RSNUM
ARSPS Order item number NUMC 4 0 CO_POSNR
MAUFNR Number of Superior Order CHAR 12 0 * MAUFNR
LKNOT Left node in collective order CHAR 12 0 * CO_LKNOT
RKNOT Right node of a collective order CHAR 12 0 * CO_RKNOT
PRODNET Order is Part of Collective Order CHAR 1 0 CO_PRODNET
IASMG Confirmed Scrap Quantity From Order Confirmation QUAN 13 3 CO_IASMG
ABARB Confirmation: Degree of processing NUMC 3 0 CO_ABARB
AUFNT Number of superior network CHAR 12 0 * CO_TEILNET
AUFPT Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZT General counter for order NUMC 8 0 * CO_APLZL
NO_DISP Effective for Materials Planning CHAR 1 0 NO_DISP_PLUS
Relevant to materials planning
1 Not relevant to materials planning
B Immediately with blocking indicator
X Relevant to materials planning at a defined time
CSPLIT Apportionment Structure CHAR 4 0 MAKV CSPLIT
AENNR Change Number CHAR 12 0 AENR AENNR
CY_SEQNR Sequence Number Order NUMC 14 0 CY_SEQNR
BREAKS Indicator: Scheduling allowing for breaks CHAR 1 0 BREAKS
VORGZ_TRM Scheduled float before production in days DEC 6 3 VORGZ_TRM
SICHZ_TRM Scheduled float after production in days DEC 6 3 SICHZ_TRM
TRMDT Date of the Last Scheduling DATS 8 0 TRMDT
GLUZP Basic Finish (Time) TIMS 6 0 CO_GLUZP
GSUZP Basic Start (Time) TIMS 6 0 CO_GSUZP
GSUZI Actual start time TIMS 6 0 CO_GSUZI
GEUZI Confirmed Order Finish (Time) TIMS 6 0 CO_GEUZI
GLUPP Forecast finish (time) TIMS 6 0 CO_GLUPP
GSUPP Forecast start (time) TIMS 6 0 CO_GSUPP
GLUPS Scheduled forecast finish time TIMS 6 0 CO_GLUPS
GSUPS Scheduled start time (Forecast) TIMS 6 0 CO_GSUPS
CHSCH Search Procedure for Batch Determination CHAR 6 0 T683 KALSMA_CH
KAPT_VORGZ Float (bef. production) remaining after finite scheduling NUMC 3 0 KAPT_VORGZ
KAPT_SICHZ Remaining float after finite scheduling NUMC 3 0 KAPT_SICHZ
LEAD_AUFNR Leading Order in Current Processing CHAR 12 0 AUFK CO_LAUFNR
PNETSTARTD Outline start of collective network (date) DATS 8 0 CO_PSTARTD
PNETSTARTT Start time of a collective order TIMS 6 0 CO_PSTARTT
PNETENDD Outline finish of collective order (date) DATS 8 0 CO_PENDD
PNETENDT Outline finish time TIMS 6 0 CO_PENDT
KBED Indicator: Do not Create Capacity Requirements CHAR 1 0 KBED_D
KKALKR Indicator: Components will not be costed CHAR 1 0 COMP_CALC
SFCPF Production Scheduling Profile CHAR 6 0 TCO43 CO_PRODPRF
RMNGA Total Confirmed Rework Quantity QUAN 13 3 RMNGA
GSBTR Total Commitment Date DATS 8 0 CO_GSBTR
VFMNG Committed quantity for order acc. to ATP check components QUAN 13 3 CO_VFMNG
NOPCOST Do not calculate planned costs for order CHAR 1 0 CO_NOPCOST
NETZKONT Indicator for the account assignment of a network(hdr/act.) CHAR 1 0 NETZKONT
Account assignment determined by status
1 Header-assigned network
2 Activity-assigned network
ATRKZ Request ID CHAR 1 0 ATRKZ
Standard request
B TOI - Order (created using BAPI)
E MOP - Order (previously EOG)
L LPP - Order
M Multi-Item Order
T Segmentation Order
U Original Order
Z Combined Order
OBJTYPE Change indicator CHAR 1 0 OCM_OBJ_TYPE
Normal object
+ Object created
- Object is to be deleted
0 Zero Object
C Object changed
M Object reassigned
CH_PROC Process that has lead to the change of an object CHAR 1 0 OCM_CH_PROC
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 NUMC 2 0 * KAPVERSA
COLORDPROC Collective order with/without automatic goods movement CHAR 1 0 CO_COLORDPRC
Collective order without automatic goods movement
X Collective order with automatic goods movement
KZERB Indicator: Project summarization via master data charact. CHAR 1 0 PS_KZERB
CONF_KEY Identical object NUMC 8 0 CC_CONF_KEY
ST_ARBID Object ID NUMC 8 0 OBJEKTID
VSNMR_V Sales document version number CHAR 12 0 VSNMR_V
TERHW Scheduling note from order scheduling CHAR 1 0 TERHW
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 CHAR 1 0 SPLIT_STAT
not split, not created by splitting
1 split
2 created by splitting
3 created by splitting and split
COSTUPD Costs are updated CHAR 1 0 CN_COSTUPD
MAX_GAMNG Maximum Value of Total Order Quantity After Distribution QUAN 13 3 CO_MES_MAX_GAMNG
MES_ROUTINGID Key of a Routing from an ME System CHAR 64 0 CO_MES_INT_ROUTINGID
TL_VERSN Routing Version CHAR 4 0 PLNVERSN
BOM_VERSN BOM Version CHAR 4 0 CS_VERSN
FLEXIBLE_PROCESSING Flexible Processing CHAR 1 0 MPE_FLEXIBLE_PROCESSING
ADPSP PM/PS Reference Element CHAR 40 0 ADCOMPARE
RMANR Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR_RMA Item number of the SD document NUMC 6 0 POSNR
POSNV_RMA Item number of the SD document NUMC 6 0 POSNR
CFB_MAXLZ Maximum Storage Period DEC 5 0 MAXLZ
CFB_LZEIH Unit for maximum storage period UNIT 3 0 T006 LZEIH
CFB_ADTDAYS Additional Days DEC 4 0 CFB_ADTDAYS
CFB_DATOFM Date of Manufacture DATS 8 0 CFB_DATOFM
CFB_BBDPI Best-Before Date (BBD)/ Shelf Life Expiration Date (SLED) DATS 8 0 CFB_BBD_PPPI
OIHANTYP Excise Duty Handling Type CHAR 2 0 OIH_HANTYP
FSH_MPROD_ORD Master Production Order Number CHAR 12 0 FSH_MPROD FSH_MPROD_ORD
FLG_BUNDLE Indicates Bundle Information Maintained CHAR 1 0 FLG_BUNDLE
MILL_RATIO Factor for Quantity-Based Settlement INT4 10 0 MILL_RATIO
BMEINS Base Unit of Measure UNIT 3 0 * MEINS
BMENGE Base quantity QUAN 13 3 BASMN
MILL_OC_ZUSKZ Combination Indicator CHAR 1 0 MILL_OC_ZUSKZ
H Combination by Order
O Combination by Operation

AFKO foreign key relationships

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