SAP Table: AFKO - Order header data PP orders

AFKO is a standard Production Orders Transparent Table in SAP PP application, which stores Order header data PP orders data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for AFKO. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

Description:	Order header data PP orders
Main Category:	PP
Sub Category:	Production Orders
Table type:	Transparent Table (TRANSP)

Position	Column Name	Description	Primary Key	Data Type	Length	Check Table
1	MANDT	Client	X	CLNT	3	T000
2	AUFNR	Order	X	CHAR	12	AUFK
3	.INCLUDE				0
4	GLTRP	Basic fin. date		DATS	8
5	GSTRP	Bas. Start Date		DATS	8
6	FTRMS	Scheduled release date		DATS	8
7	GLTRS	Scheduled finish		DATS	8
8	GSTRS	Scheduled start		DATS	8
9	GSTRI	Actual start date		DATS	8
10	GETRI	Confirmed Order Finish Date		DATS	8
11	GLTRI	Updated information in related user data field		DATS	8
12	FTRMI	Actual release date		DATS	8
13	FTRMP	Updated information in related user data field		DATS	8
14	RSNUM	Number of Reservation/Dependent Requirement		NUMC	10	*
15	GASMG	Text field length 14		QUAN	13
16	GAMNG	Text field length 14		QUAN	13
17	GMEIN	Base Unit of Measure		UNIT	3	T006
18	PLNBEZ	Material Number		CHAR	40	MARA
19	PLNTY	Task List Type		CHAR	1
20	PLNNR	Key for task list group		CHAR	8
21	PLNAW	Updated information in related user data field		CHAR	1	TCA09
22	PLNAL	Group Counter		CHAR	2
23	PVERW	Updated information in related user data field		CHAR	3	T411
24	PLAUF	Updated information in related user data field		DATS	8
25	PLSVB	Text field length 14		QUAN	13
26	PLNME	Header unit		UNIT	3	T006
27	PLSVN	Text field length 14		QUAN	13
28	PDATV	Trip Segment: Beginning Date		DATS	8
29	PAENR	Change Number		CHAR	12	AENR
30	PLGRP	Updated information in related user data field		CHAR	3	T024A
31	LODIV	Text field length 14		QUAN	13
32	STLTY	BOM category		CHAR	1
33	STLBEZ	Material Number		CHAR	40	MARA
34	STLST	BOM Status (from Table T415S)		NUMC	2	T415S
35	STLNR	Bill of material		CHAR	8
36	SDATV	Valid-From Date		DATS	8
37	SBMNG	Base quantity		QUAN	13
38	SBMEH	Base Unit of Measure		UNIT	3	T006
39	SAENR	Change Number		CHAR	12	AENR
40	STLAL	Alternative BOM		CHAR	2
41	STLAN	BOM Usage		CHAR	1	T416
42	SLSVN	Text field length 14		QUAN	13
43	SLSBS	Text field length 14		QUAN	13
44	AUFLD	Date		DATS	8
45	DISPO	MRP controller		CHAR	3	T024D
46	AUFPL	Routing number of operations in the order		NUMC	10
47	FEVOR	Checkbox		CHAR	3	T024F
48	FHORI	Checkbox		CHAR	3	T436A
49	TERKZ	Scheduling type		CHAR	1	T482
50	REDKZ	Updated information in related user data field		CHAR	1
51	APRIO	Order priority		CHAR	1
52	NTZUE	Superior network number		CHAR	12	AUFK
53	VORUE	Superior activity		CHAR	4
54	PROFID	Network profile		CHAR	7	TCN41
55	VORGZ	Updated information in related user data field		NUMC	3
56	SICHZ	Updated information in related user data field		NUMC	3
57	FREIZ	Updated information in related user data field		NUMC	3
58	UPTER	Updated information in related user data field		CHAR	1
59	BEDID	ID of Capacity Requirements Record		NUMC	12	*
60	PRONR	Number of the implementation project in Customizing		NUMC	8	PROJ
61	ZAEHL	Internal counter		NUMC	8
62	MZAEHL	Internal counter		NUMC	8
63	ZKRIZ	Updated information in related user data field		NUMC	7
64	PRUEFLOS	Inspection Lot Number		NUMC	12
65	KLVARP	Updated information in related user data field		CHAR	4	*
66	KLVARI	Updated information in related user data field		CHAR	4	*
67	RGEKZ	Indicator: Backflush		CHAR	1
68	PLART	Planning type		CHAR	1
69	FLG_AOB	Updated information in related user data field		CHAR	1
70	FLG_ARBEI	Updated information in related user data field		CHAR	1
71	GLTPP	Finish date (forecast)		DATS	8
72	GSTPP	Forecast start date		DATS	8
73	GLTPS	Scheduled forecast finish		DATS	8
74	GSTPS	Scheduled forecast start		DATS	8
75	FTRPS	Scheduled release date (forecast)		DATS	8
76	RDKZP	Updated information in related user data field		CHAR	1
77	TRKZP	Scheduling type (forecast)		CHAR	1	*
78	RUECK	Completion confirmation number for the operation		NUMC	10
79	RMZHL	Internal counter		NUMC	8
80	IGMNG	Text field length 14		QUAN	13
81	RATID	Updated information in related user data field		NUMC	12	*
82	GROID	Updated information in related user data field		NUMC	12	*
83	CUOBJ	Configuration (internal object number)		NUMC	18
84	GLUZS	Earliest scheduled finish: Execution (time)		TIMS	6
85	GSUZS	Earliest scheduled start: Execution (time)		TIMS	6
86	REVLV	Revision Level		CHAR	2
87	RSHTY	Updated information in related user data field		CHAR	2
88	RSHID	Updated information in related user data field		NUMC	8	CRID
89	RSNTY	Single-Character Flag		CHAR	2
90	RSNID	Updated information in related user data field		NUMC	8	CRID
91	NAUTERM	Indicator: Do not schedule automatically		CHAR	1
92	NAUCOST	Indicator: Do not cost automatically		CHAR	1
93	STUFE	Level		DEC	2
94	WEGXX	Path (Predecessor)		DEC	4
95	VWEGX	Path (for Multi-Level BOM Explosions)		DEC	4
96	ARSNR	Number of reservation/dependent requirements		NUMC	10	*
97	ARSPS	Order item number		NUMC	4
98	MAUFNR	Order Number		CHAR	12	*
99	LKNOT	Updated information in related user data field		CHAR	12	*
100	RKNOT	Updated information in related user data field		CHAR	12	*
101	PRODNET	Updated information in related user data field		CHAR	1
102	IASMG	Text field length 14		QUAN	13
103	ABARB	Int1		NUMC	3
104	AUFNT	Updated information in related user data field		CHAR	12	*
105	AUFPT	Routing number of operations in the order		NUMC	10
106	APLZT	Updated information in related user data field		NUMC	8	*
107	NO_DISP	WF: Flag 'Never display again'		CHAR	1
108	CSPLIT	Apportionment structure		CHAR	4	MAKV
109	AENNR	Change Number		CHAR	12	AENR
110	CY_SEQNR	Updated information in related user data field		NUMC	14
111	BREAKS	Checkbox		CHAR	1
112	VORGZ_TRM	Updated information in related user data field		DEC	6
113	SICHZ_TRM	Updated information in related user data field		DEC	6
114	TRMDT	Termination date		DATS	8
115	GLUZP	Field of type TIMS		TIMS	6
116	GSUZP	Field of type TIMS		TIMS	6
117	GSUZI	Updated information in related user data field		TIMS	6
118	GEUZI	Updated information in related user data field		TIMS	6
119	GLUPP	Updated information in related user data field		TIMS	6
120	GSUPP	Updated information in related user data field		TIMS	6
121	GLUPS	Updated information in related user data field		TIMS	6
122	GSUPS	Updated information in related user data field		TIMS	6
123	CHSCH	Updated information in related user data field		CHAR	6	T683
124	KAPT_VORGZ	Float (bef. production) remaining after finite scheduling		NUMC	3
125	KAPT_SICHZ	Remaining float after finite scheduling		NUMC	3
126	LEAD_AUFNR	Order Number		CHAR	12	AUFK
127	PNETSTARTD	Updated information in related user data field		DATS	8
128	PNETSTARTT	Updated information in related user data field		TIMS	6
129	PNETENDD	Updated information in related user data field		DATS	8
130	PNETENDT	Updated information in related user data field		TIMS	6
131	KBED	Updated information in related user data field		CHAR	1
132	KKALKR	Updated information in related user data field		CHAR	1
133	SFCPF	Checkbox		CHAR	6	TCO43
134	RMNGA	Text field length 14		QUAN	13
135	GSBTR	Updated information in related user data field		DATS	8
136	VFMNG	Text field length 14		QUAN	13
137	NOPCOST	Updated information in related user data field		CHAR	1
138	NETZKONT	Updated information in related user data field		CHAR	1
139	ATRKZ	Updated information in related user data field		CHAR	1
140	OBJTYPE	Object type		CHAR	1
141	CH_PROC	Updated information in related user data field		CHAR	1
142	KAPVERSA	Updated information in related user data field		NUMC	2	*
143	COLORDPROC	Updated information in related user data field		CHAR	1
144	KZERB	Updated information in related user data field		CHAR	1
145	CONF_KEY	Identical object		NUMC	8
146	ST_ARBID	Object ID		NUMC	8
147	VSNMR_V	Sales document version number		CHAR	12
148	TERHW	Updated information in related user data field		CHAR	1
149	SPLSTAT	Updated information in related user data field		CHAR	1
150	COSTUPD	Updated information in related user data field		CHAR	1
151	MAX_GAMNG	Maximum Value of Total Order Quantity After Distribution		QUAN	13
152	MES_ROUTINGID	Key of a Routing from an ME System		CHAR	64
153	TL_VERSN			CHAR	4
154	BOM_VERSN			CHAR	4
155	.INCLU--AP				0
156	ADPSP	Updated information in related user data field		CHAR	40
157	.INCLUDE				0
158	RMANR	Sales and Distribution Document Number		CHAR	10
159	POSNR_RMA	Item number of the SD document		NUMC	6	*
160	POSNV_RMA	Item number of the SD document		NUMC	6	*
161	.INCLUDE				0
162	CFB_MAXLZ	Maximum storage period		DEC	5
163	CFB_LZEIH	Unit for maximum storage period		UNIT	3	T006
164	CFB_ADTDAYS	Additional Days		DEC	4
165	CFB_DATOFM	Date of Manufacture		DATS	8
166	CFB_BBDPI	Best-Before Date (BBD)/ Shelf Life Expiration Date (SLED)		DATS	8
167	OIHANTYP	Excise Duty Handling Type		CHAR	2
168	.INCLU--AP				0
169	FSH_MPROD_ORD			CHAR	12	FSH_MPROD
170	FLG_BUNDLE			CHAR	1
171	.INCLU--AP				0
172	MILL_RATIO	Factor for Quantity-Based Settlement		INT4	10
173	.INCLU--AP				0
174	BMEINS	Base Unit of Measure		UNIT	3	*
175	BMENGE	Base quantity		QUAN	13
176	MILL_OC_ZUSKZ	Combination Indicator		CHAR	1

Question about AFKO-GLTRI | SCN
Check the Oss Note: Note 595916 - Application 04: Actual finish date (AFKO-GLTRI) not filled

http://scn.sap.com/message/9135235
Relation ship between AUFK, AFKO, AFPO , MKPF, TCC02 and T132T tables
Actually we need to capture the some xxxx fileds from Production Order(CO03). by using the below realtion we can pull the data.

http://scn.sap.com/message/8752738
Process order closing and determining process order in table AUFK/AFKO.
First of all I want to know which among AUFK/AFKO is the header table for process orders.

http://scn.sap.com/message/5828752
GLTRI- AFKO changed to LTRMI-AFPO | SCN
I was making some test whit the field GLTRI from AFKO table, and suddenly I found SAP Note 595916 and it said that the field GLTRI is no longer used so it change to LTRMI-AFPO but I can't find where I can see in the COR2 or COR3.

http://scn.sap.com/message/8200778
Problem on select command for table AFKO-GSTRS,AFKO-GSUZS
I faced a problem on using select command to select out the records from table AFKO (Production order header)

http://scn.sap.com/message/1802862
LINK BETWEEN AFKO AND AFVC | SCN
How to link AFKO with afvc, i know the common field is AUFPL, but AFVC is table for operation, so how to choose exact row from multiple row. My coding is as follows

http://scn.sap.com/message/7971767
Problem with Data Selection from AFKO | SCN
But the entries in der internal Table It_AFKO are not korrekt. The Entry must bei the Same like in TA SE16.

http://scn.sap.com/message/1821430
AFKO without CBO statistics | SCN
in a ECC 6.0 with Oracle 10.2.04 on Solaris 10 SPARC box, AFKO table is without statistics. This system is just installed as hom-sys-copy, during Sapinst statistics was performed and all other tables have got statistics.

http://scn.sap.com/message/8662943
Need to update AFKO table custom field | SCN
My requirement is to update AFKO table with out using UPDATE command. There is a custom field in AFKO table , that field needs to updated on certain conditions. Is there any function module to update this table(AFKO) using production order number.

http://scn.sap.com/message/10731351
REL, CRTD status based on the production order ( AFKO-aufnr)
I want to get the status of a Production order i.e released (REL) or unreleased (CRTD) based on the production order (AFKO-AUFNR).

http://scn.sap.com/message/3416991
AUFK/AFKO table Delta not working in | SCN
created date/changed date are the fields available in AUFK table, and i created delta field on Created date.

http://scn.sap.com/message/13552824

TABLE	Description	Functional Area
AUFK	Order master data	CO - Overhead Cost Orders
AFPO	Order item	PP - Production Orders
AFVC	Operation within an order	PP - Production Orders
AFRU	Order Confirmations	PP - Confirmations
RESB	Reservation/dependent requirements	MM - Inventory Management
AFVV	DB structure of the quantities/dates/values in the operation	PP - Production Orders
JEST	Individual Object Status	Cross Application - General status management

TCODE	Description	Functional Area
SPRO	Customizing - Edit Project	Basis - Customizing Project Management (IMG)
COOIS	Production Order Information System	PP - Production Orders
SE11	ABAP Dictionary Maintenance	Basis - Dictionary Maintenance
CO03	Display Production Order	PP - Production Orders
CO02	Change Production Order	PP - Production Orders
SE16	Data Browser	Basis - Workbench Utilities
AFAB	Post depreciation	FI - Basic Functions
MIGO	Goods Movement	MM - Inventory Management

FM	Description	Functional Area
REUSE_ALV_GRID_DISPLAY	Output of a simple list (single-line)	Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE	List body comment block output	BC - SAP List Viewer
READ_TEXT	SAPscript: Read text	BC - SAPscript
STATUS_READ	Read Object Status (JSTO and JEST)	Cross Application - General status management
BAPI_TRANSACTION_COMMIT	Execute external Commit when using BAPIs	Basis - ALE Integration Technology
GUI_DOWNLOAD	Download an Internal Table to the PC	Basis - Graphical User Interface
STATUS_TEXT_EDIT	The 4 Character Status is Edited within One Line (40 Character)	Cross Application - General status management
REUSE_ALV_EVENTS_GET	Returns table of possible events for a list type	BC - SAP List Viewer

ABAP REPORT	Description	Functional Area
SPRSL	TEXT	630 - Workbench Tools: Editors
SAPLCOVG	Operation Processing PP
RSPRTBEZ	List All Relationships for a Table	Cross Application - Global Organization Customizing
BCALV_TREE_DEMO	Demo for ALV tree control	Basis - SAP List Viewer
BCALV_TREE_SIMPLE_DEMO	Program BCALV_TREE_SIMPLE_DEMO	Basis - SAP List Viewer
SAPLBSVA	Status Processing
DISPLAY_LOG	DISPLAY LOG	SRM - Purchase Contract
BC_ALV_DEMO_HTML_D0100	Include BC_ALV_DEMO_HTML_D0100	Basis - SAP List Viewer

BW DATASOURCE	Description	Functional Area
2LIS_04_P_MATNR	Material View from PP/PP-PI	PP - Production Planning and Control
2LIS_04_P_COMP	Component View from PP/PP-PI	PP - Production Planning and Control
2LIS_04_P_ARBPL	Work Center View from PP/PP-PI	PP - Production Planning and Control
2LIS_17_I3OPER	Plant Maintenance Order Process	PM - Plant Maintenance
2LIS_02_ITM	Purchasing Data (Item Level)	MM - Materials Management
2LIS_11_VAITM	Sales Document Item Data	SD - Sales and Distribution
2LIS_03_BF	Goods Movements From Inventory Management	MM - Materials Management
0PRODORDER_ATTR	Order number (production order)	PP - Production Planning and Control

AUTHORIZATION OBJECT	Description	Functional Area
C_AFKO_AWK	CIM: Plant for order type of order
C_SIGN	Authorization for Digital Signature
C_MESS_WRK	PP-PI: Process Messages - Plant
CRM_KNOART	Auth. Object - CRM Knowledge Article
E_GRID	Authorization Object for Grid
I_IWERK	PM: Maintenance Planning Plant
CRM_ISUITY	Authorization Object for Processing of Item Categories

SAP Table: AFKO - Order header data PP orders

AFKO — Meta Data

AFKO — Table Structure, Fields(Columns) and Definitions

SAP Help, Wiki Resources, and Forum Discussions on AFKO

Related Tables

Transaction Codes for SAP Table AFKO

FMs for SAP Table AFKO

ABAP Reports for SAP Table AFKO

BW Datasources for SAP Table AFKO

Authorization Objects for SAP Table AFKO

Most searched SAP Production Planning and Control Tables