queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
STKO
STLNR, STLAL, STLTY
AFKO

AFKO

order header data pp orders
pp25f · 1k · 14r
Unchanged in S/4
AFKO is unchanged in S/4HANA. Production orders continue to use AFKO as the header table. Cost and quantity actuals flow into ACDOCA (Universal Journal) but AFKO retains its structural role.

fields (25)

fieldtypelengthkeydescription
AUFNRchar12pkorder number
ARBPLchar8work center
AUFPLnumc10routing number of production order
FTRMSdats8scheduled release date
GAMNGquan13total order quantity
GASMGquan13quantity delivered to warehouse
GETRIdats8actual finish date
GLTRPdats8scheduled finish date
GLTRStims6scheduled finish time
GMEINunit3unit of measure for order quantity
GSTRIdats8actual start date
GSTRPdats8scheduled start date
GSTRStims6scheduled start time
IGMNGquan13confirmed yield quantity
PLKTRchar10cost center for order
PLNALchar2group counter for routing
PLNBEZchar18material number for routing
PLNNRchar8key for task list group (routing)
PLNTYchar1task list type
RMNGAquan13confirmed scrap quantity
STLALchar2alternative bom
STLBEZchar18material number for bom explosion
STLNRchar8bill of materials number
STLTYchar1bom category
WERKSchar4plant

relationships (14)

master lookup

reference to master data

references
STKO
STLNRSTLNR
N:1
CSKS
PLKTRKOSTL
N:1
PLKO
PLNNRPLNNR
N:1
STPO
STLNRSTLNR
1:N
AUFK
AUFNRAUFNR
M:1
referenced by
AFFL
AUFPLAUFPL
M:1
RESB
AUFNRAUFNR
M:1
STKO
STLNRSTLNR
STLALSTLAL
STLTYSTLTY
1:N
CAUFV
AUFNRAUFNR
1:1
header / item

parent-child document structure

references
AFPO
AUFNRAUFNR
1:N
RESB
AUFNRAUFNR
1:N
referenced by
AFVC
AUFPLAUFPL
M:1
AFPO
AUFNRAUFNR
M:1
configuration

reference to config tables

references
T001W
WERKSWERKS
N:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms