SAP ABAP Table AFKO (Order Header Data PP Orders)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AFKO	Table Relationship Diagram
Short Description	Order Header Data PP Orders

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	.INCLUDE	☐				0	0	Order Header Data PP Orders
4	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
5	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
6	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
7	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
8	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
9	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
10	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
11	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
12	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
13	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
14	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
15	GASMG	☐	GASMG	MENG13	QUAN	13	3	Total scrap quantity in the order
16	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
17	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	PLNBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
20	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
21	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	*
22	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
23	PVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	*
24	PLAUF	☐	CO_PLAUF	DATUM	DATS	8	0	Date for routing transfer
25	PLSVB	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
26	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
27	PLSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
28	PDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
29	PAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
30	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
31	LODIV	☐	LOSDIV	MENG13	QUAN	13	3	Lot size divisor
32	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
33	STLBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
34	STLST	☐	STLST	STLST	NUMC	2	0	BOM Statuses	*
35	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
36	SDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
37	SBMNG	☐	BASMN	MENG13	QUAN	13	3	Base quantity
38	SBMEH	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
39	SAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
40	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
41	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
42	SLSVN	☐	LOSVN	MENG13	QUAN	13	3	From Lot Size
43	SLSBS	☐	LOSBS	MENG13	QUAN	13	3	To Lot Size
44	AUFLD	☐	CO_AUFLD	DATUM	DATS	8	0	Date of BOM Explosion/Routing Transfer
45	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	*
46	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
47	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
48	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	*
49	TERKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	*
50	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
51	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
52	NTZUE	☐	NETZ_UEBER	AUFNR	CHAR	12	0	Superior network number	AUFK
53	VORUE	☐	VORG_UEBER	VORNR	CHAR	4	0	Superior activity
54	PROFID	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	*
55	VORGZ	☐	VORGZ	NUM3	NUMC	3	0	Float before production (in days)
56	SICHZ	☐	SICHZ	NUM3	NUMC	3	0	Float after production (in days)
57	FREIZ	☐	FREIZ	NUM3	NUMC	3	0	Release period (in days)
58	UPTER	☐	CO_UPTER	CHAR1	CHAR	1	0	Indicator: Change to Scheduled Dates
59	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
60	PRONR	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	PROJ
61	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
62	MZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
63	ZKRIZ	☐	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
64	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
65	KLVARP	☐	KALKVARPLN	KLVAR	CHAR	4	0	Costing variant for planned costs	*
66	KLVARI	☐	KALKVARIST	KLVAR	CHAR	4	0	Costing variant for actual costs	*
67	RGEKZ	☐	CO_RGEKZ	CO_RGEKZ	CHAR	1	0	Indicator: Backflushing for order
68	PLART	☐	PS_PLART	PS_PLART	CHAR	1	0	Basis for scheduling
69	FLG_AOB	☐	FLG_AOB	FLAG	CHAR	1	0	Indicator: relationships
70	FLG_ARBEI	☐	FLG_ARBEI	FLAG	CHAR	1	0	Indicator: Default value work is relevant
71	GLTPP	☐	CO_GLTPP	DATUM	DATS	8	0	Finish date (forecast)
72	GSTPP	☐	CO_GSTPP	DATUM	DATS	8	0	Forecast start date
73	GLTPS	☐	CO_GLTPS	DATUM	DATS	8	0	Scheduled forecast finish
74	GSTPS	☐	CO_GSTPS	DATUM	DATS	8	0	Scheduled forecast start
75	FTRPS	☐	CO_FTRPS	DATUM	DATS	8	0	Scheduled release date (forecast)
76	RDKZP	☐	REDKZP	REDKZ	CHAR	1	0	Reduction indicator for scheduling (forecast)
77	TRKZP	☐	TERMKZP	TERART	CHAR	1	0	Scheduling type (forecast)	*
78	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
79	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
80	IGMNG	☐	CO_IGMNG	MENG13	QUAN	13	3	Yield confirmed from order confirmation
81	RATID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
82	GROID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
83	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
84	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
85	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
86	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
87	RSHTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
88	RSHID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
89	RSNTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
90	RSNID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
91	NAUTERM	☐	CO_NAUTERM	KREUZ	CHAR	1	0	Indicator: Do not schedule automatically
92	NAUCOST	☐	CO_NAUCOST	KREUZ	CHAR	1	0	Indicator: Do not cost automatically
93	STUFE	☐	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
94	WEGXX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
95	VWEGX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
96	ARSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
97	ARSPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
98	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order	*
99	LKNOT	☐	CO_LKNOT	AUFNR	CHAR	12	0	Left node in collective order	*
100	RKNOT	☐	CO_RKNOT	AUFNR	CHAR	12	0	Right node of a collective order	*
101	PRODNET	☐	CO_PRODNET	KREUZ	CHAR	1	0	Indicator: Order is part of collective order
102	IASMG	☐	CO_IASMG	MENG13	QUAN	13	3	Scrap confirmed for order
103	ABARB	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
104	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	*
105	AUFPT	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
106	APLZT	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
107	NO_DISP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
108	CSPLIT	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	*
109	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
110	CY_SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
111	BREAKS	☐	BREAKS	XFELD	CHAR	1	0	Indicator: Scheduling allowing for breaks
112	VORGZ_TRM	☐	VORGZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float before production in days
113	SICHZ_TRM	☐	SICHZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float after production in days
114	TRMDT	☐	TRMDT	DATUM	DATS	8	0	Date of the last scheduling
115	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
116	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
117	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
118	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
119	GLUPP	☐	CO_GLUPP	UHRZT	TIMS	6	0	Forecast finish (time)
120	GSUPP	☐	CO_GSUPP	UHRZT	TIMS	6	0	Forecast start (time)
121	GLUPS	☐	CO_GLUPS	UHRZT	TIMS	6	0	Scheduled forecast finish time
122	GSUPS	☐	CO_GSUPS	UHRZT	TIMS	6	0	Scheduled start time (Forecast)
123	CHSCH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
124	KAPT_VORGZ	☐	KAPT_VORGZ	NUM3	NUMC	3	0	Float (bef. production) remaining after finite scheduling
125	KAPT_SICHZ	☐	KAPT_SICHZ	NUM3	NUMC	3	0	Remaining float after finite scheduling
126	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
127	PNETSTARTD	☐	CO_PSTARTD	DATUM	DATS	8	0	Outline start of collective network (date)
128	PNETSTARTT	☐	CO_PSTARTT	ATIME	TIMS	6	0	Start time of a collective order
129	PNETENDD	☐	CO_PENDD	DATUM	DATS	8	0	Outline finish of collective order (date)
130	PNETENDT	☐	CO_PENDT	ATIME	TIMS	6	0	Outline finish time
131	KBED	☐	KBED_D	XFELD	CHAR	1	0	Ind: do not create capacity requirements
132	KKALKR	☐	COMP_CALC	XFELD	CHAR	1	0	Indicator: Components will not be costed
133	SFCPF	☐	CO_PRODPRF	CO_PRODPRF	CHAR	6	0	Production Scheduling Profile	*
134	RMNGA	☐	RMNGA	MENG13	QUAN	13	3	Total confirmed rework quantity
135	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
136	VFMNG	☐	CO_VFMNG	MENG13	QUAN	13	3	Committed quantity for order acc. to ATP check components
137	NOPCOST	☐	CO_NOPCOST	XFELD	CHAR	1	0	Do not calculate planned costs for order
138	NETZKONT	☐	NETZKONT	NETZKONT	CHAR	1	0	Indicator for the account assignment of a network(hdr/act.)
139	ATRKZ	☐	ATRKZ	ATRKZ	CHAR	1	0	Request ID
140	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
141	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
142	KAPVERSA	☐	KAPVERSA	KAPVERSION	NUMC	2	0	Version of Available Capacity	*
143	COLORDPROC	☐	CO_COLORDPRC	CO_COLORDPRC	CHAR	1	0	Collective order with/without automatic goods movement
144	KZERB	☐	PS_KZERB	XFELD	CHAR	1	0	Indicator: Project summarization
145	CONF_KEY	☐	CC_CONF_KEY	CC_NUMC8	NUMC	8	0	Identical object
146	ST_ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
147	VSNMR_V	☐	VSNMR_V	VSNMR	CHAR	12	0	Sales document version number
148	TERHW	☐	TERHW	TERHW	CHAR	1	0	Scheduling note from order scheduling
149	.INCLUDE	☐				0	0	Include RMA for AUFK
150	RMANR	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
151	POSNR_RMA	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
152	POSNV_RMA	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFKO	AENNR	AENR	AENNR
2	AFKO	AUFNR	AUFK	AUFNR	KEY	1	1
3	AFKO	CHSCH	T683	KALSM
4	AFKO	GMEIN	T006	MSEHI	KEY	1	CN
5	AFKO	LEAD_AUFNR	AUFK	AUFNR
6	AFKO	MANDT	T000	MANDT	KEY	1	CN
7	AFKO	NTZUE	AUFK	AUFNR	REF	C	C
8	AFKO	PAENR	AENR	AENNR	REF	1	CN
9	AFKO	PLNME	T006	MSEHI	REF	1	CN
10	AFKO	PRONR	PROJ	PSPNR	REF	C	CN
11	AFKO	SAENR	AENR	AENNR	REF	C	CN
12	AFKO	SBMEH	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in