SAP AFKO Order Header Data PP Orders Table

Overview

AFKO is a standard SAP S/4HANA table that stores Order Header Data PP Orders data. There are total 170 fields in the AFKO table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AFKO belongs to Production Orders (PP-SFC) module and is located in the package Application Development ERP PP Production Orders (CO).

In addition, following links provide an overview of foreign key relationships, if any, that link AFKO to other SAP tables and standard CDS views available based on AFKO table in S/4HANA 2020.

Foreign Key Relations
AFKO CDS Views

Techincal Settings of AFKO

Below are technical details of the table AFKO

Buffering not allowed
No buffering
Storage type is Column Store

List of AFKO Fields

The following table gives you an overview of the fields available in AFKO

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFKO

Table Name	Field	Cardinality	Check Table
AFKO	AENNR	:	AENR
AFKO	AUFNR	1: 1	AUFK
AFKO	CFB_LZEIH	C: CN	T006
AFKO	CHSCH	:	T683
AFKO	CSPLIT	:	MAKV
AFKO	DISPO	1: CN	T024D
AFKO	FEVOR	:	T024F
AFKO	FHORI	C: CN	T436A
AFKO	FSH_MPROD_ORD	1: N	FSH_MPROD
AFKO	GMEIN	1: CN	T006
AFKO	LEAD_AUFNR	:	AUFK
AFKO	MANDT	1: CN	T000
AFKO	NTZUE	C: C	AUFK
AFKO	PAENR	1: CN	AENR
AFKO	PLGRP	C: CN	T024A
AFKO	PLNAW	C: CN	TCA09
AFKO	PLNBEZ	C: CN	MARA
AFKO	PLNME	1: CN	T006
AFKO	PROFID	C: CN	TCN41
AFKO	PRONR	C: CN	PROJ
AFKO	PVERW	1: CN	T411
AFKO	RSHID	C: CN	CRID
AFKO	RSNID	C: CN	CRID
AFKO	SAENR	C: CN	AENR
AFKO	SBMEH	C: CN	T006
AFKO	SFCPF	:	TCO43
AFKO	STLAN	C: CN	T416
AFKO	STLBEZ	C: CN	MARA
AFKO	STLST	C: CN	T415S
AFKO	TERKZ	1: CN	T482

SAP AFKO Order Header Data PP Orders Table

Overview

Techincal Settings of AFKO

List of AFKO Fields

Foreign Key Relationships

Other References