queryviz
tables/relationship path
open in builder
T002
SPRAS
T001
BUKRS
T001K
BWKEY
T001W
WERKS
CAUFV

CAUFV

production order master view (aufk + afko join view)
pp17f · 1k · 8r
Deprecated in S/4
CAUFV is a database VIEW in both ECC and S/4HANA — not a physical table. Joins AUFK and AFKO. Exists unchanged in S/4HANA. The standard view used in virtually all ABAP programs that read production order data. Never contains data of its own; always reads from underlying AUFK/AFKO.

fields (17)

fieldtypelengthkeydescription
AUFNRchar12pkorder number
AUARTchar4order type
BUKRSchar4company code
FTRMSdats8scheduled release date
GAMNGquan13total order quantity
GASMGquan13delivered quantity
GLTRPdats8scheduled finish date
GMEINunit3order unit of measure
GSTRPdats8scheduled start date
IGMNGquan13confirmed yield quantity
KOKRSchar4controlling area
KOSTVchar10responsible cost center
OBJNRchar22object number (for status management)
PLNNRchar8routing number
STATchar40system status
STLNRchar8bom number
WERKSchar4plant

relationships (8)

configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
T001W
WERKSWERKS
N:1
TKA01
KOKRSKOKRS
N:1
master lookup

reference to master data

references
PLKO
PLNNRPLNNR
N:1
STKO
STLNRSTLNR
N:1
AUFK
AUFNRAUFNR
M:1
AFKO
AUFNRAUFNR
1:1
header / item

parent-child document structure

references
AFPO
AUFNRAUFNR
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms