Follow us on LinkedIn for your next SAP project

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 Possible values
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
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
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
PLART
Basis for scheduling
PS_PLART
CHAR
1 0
FLG_AOB
Indicator: relationships
FLG_AOB
CHAR
1 0
FLG_ARBEI
Indicator: Default value work is relevant
FLG_ARBEI
CHAR
1 0
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
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
RSHID
Object ID of the resource
CR_OBJID CRID
NUMC
8 0
RSNTY
Object types of the CIM resource
CR_OBJTY
CHAR
2 0
RSNID
Object ID of the resource
CR_OBJID CRID
NUMC
8 0
NAUTERM
Indicator: Do not schedule automatically
CO_NAUTERM
CHAR
1 0
NAUCOST
Indicator: Do not cost automatically
CO_NAUCOST
CHAR
1 0
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
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
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
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
KKALKR
Indicator: Components will not be costed
COMP_CALC
CHAR
1 0
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
NETZKONT
Indicator for the account assignment of a network(hdr/act.)
NETZKONT
CHAR
1 0
ATRKZ
Request ID
ATRKZ
CHAR
1 0
OBJTYPE
Change indicator
OCM_OBJ_TYPE
CHAR
1 0
CH_PROC
Process that has lead to the change of an object
OCM_CH_PROC
CHAR
1 0
KAPVERSA
Version of Available Capacity
KAPVERSA
NUMC
2 0
COLORDPROC
Collective order with/without automatic goods movement
CO_COLORDPRC
CHAR
1 0
KZERB
Indicator: Project summarization via master data charact.
PS_KZERB
CHAR
1 0
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
SPLSTAT
Status of an order in a split hierarchy
SPLIT_STAT
CHAR
1 0
COSTUPD
Costs are updated
CN_COSTUPD
CHAR
1 0
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

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