	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

165 COLUMNS | 10 INDEXES | ERP 6.0 | AFKO TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders
1	ERP EHP7	6.0	AFKO	165	10	Order Header Data PP Orders	Production Orders

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, AUFNR, GLTRP, GSTRP, FTRMS, GLTRS, GSTRS, GSTRI, GETRI, GLTRI, FTRMI, FTRMP, RSNUM, GASMG, GAMNG, GMEIN, PLNBEZ, PLNTY, PLNNR, PLNAW, PLNAL, PVERW, PLAUF, PLSVB, PLNME, PLSVN, PDATV, PAENR, PLGRP, LODIV, STLTY, STLBEZ, STLST, STLNR, SDATV, SBMNG, SBMEH, SAENR, STLAL, STLAN, SLSVN, SLSBS, AUFLD, DISPO, AUFPL, FEVOR, FHORI, TERKZ, REDKZ, APRIO, NTZUE, VORUE, PROFID, VORGZ, SICHZ, FREIZ, UPTER, BEDID, PRONR, ZAEHL, MZAEHL, ZKRIZ, PRUEFLOS, KLVARP, KLVARI, RGEKZ, PLART, FLG_AOB, FLG_ARBEI, GLTPP, GSTPP, GLTPS, GSTPS, FTRPS, RDKZP, TRKZP, RUECK, RMZHL, IGMNG, RATID, GROID, CUOBJ, GLUZS, GSUZS, REVLV, RSHTY, RSHID, RSNTY, RSNID, NAUTERM, NAUCOST, STUFE, WEGXX, VWEGX, ARSNR, ARSPS, MAUFNR, LKNOT, RKNOT, PRODNET, IASMG, ABARB, AUFNT, AUFPT, APLZT, NO_DISP, CSPLIT, AENNR, CY_SEQNR, BREAKS, VORGZ_TRM, SICHZ_TRM, TRMDT, GLUZP, GSUZP, GSUZI, GEUZI, GLUPP, GSUPP, GLUPS, GSUPS, CHSCH, KAPT_VORGZ, KAPT_SICHZ, LEAD_AUFNR, PNETSTARTD, PNETSTARTT, PNETENDD, PNETENDT, KBED, KKALKR, SFCPF, RMNGA, GSBTR, VFMNG, NOPCOST, NETZKONT, ATRKZ, OBJTYPE, CH_PROC, KAPVERSA, COLORDPROC, KZERB, CONF_KEY, ST_ARBID, VSNMR_V, TERHW, SPLSTAT, COSTUPD, MAX_GAMNG, MES_ROUTINGID, ADPSP, RMANR, POSNR_RMA, POSNV_RMA, CFB_MAXLZ, CFB_LZEIH, CFB_ADTDAYS, CFB_DATOFM, CFB_BBDPI, OIHANTYP, MILL_RATIO, BMEINS, BMENGE, MILL_OC_ZUSKZ FROM AFKO

TOP ERP 6.0 | AFKO COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	No	AUFK	AUFNR	Allow NULL?
3	GLTRP	Basic finish date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTRP	Allow NULL?
4	GSTRP	Basic Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PM_ORDGSTRP	Allow NULL?
5	FTRMS	Scheduled release date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_FTRMS	Allow NULL?
6	GLTRS	Scheduled finish	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTRS	Allow NULL?
7	GSTRS	Scheduled start	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GSTRS	Allow NULL?
8	GSTRI	Actual start date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GSTRI	Allow NULL?
9	GETRI	Confirmed Order Finish Date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GETRI	Allow NULL?
10	GLTRI	Actual finish date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTRI	Allow NULL?
11	FTRMI	Actual release date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_FTRMI	Allow NULL?
12	FTRMP	Planned release date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_FTRMP	Allow NULL?
13	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
14	GASMG	Total scrap quantity in the order	decimal	13	3	QUAN	((0))	Yes		GASMG
15	GAMNG	Total order quantity	decimal	13	3	QUAN	((0))	Yes		GAMNG
16	GMEIN	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
17	PLNBEZ	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
18	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	*	PLNTY	Allow NULL?
19	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
20	PLNAW	Application of the task list	char	1	0	CHAR	(N' ')	Yes	TCA09	PLNAW	Allow NULL?
21	PLNAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
22	PVERW	Task list usage	nvarchar	3	0	CHAR	(N' ')	Yes	T411	PLN_VERWE	Allow NULL?
23	PLAUF	Date for routing transfer	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_PLAUF	Allow NULL?
24	PLSVB	To lot size	decimal	13	3	QUAN	((0))	Yes		LOSGRBIS
25	PLNME	Task list unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	PLNME	Allow NULL?
26	PLSVN	From Lot Size	decimal	13	3	QUAN	((0))	Yes		LOSGRVON
27	PDATV	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUV	Allow NULL?
28	PAENR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
29	PLGRP	Responsible planner group/department	nvarchar	3	0	CHAR	(N' ')	Yes	T024A	VAGRP	Allow NULL?
30	LODIV	Lot size divisor	decimal	13	3	QUAN	((0))	Yes		LOSDIV
31	STLTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
32	STLBEZ	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
33	STLST	BOM status	nvarchar	2	0	NUMC	(N'00')	Yes	T415S	STLST	Allow NULL?
34	STLNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
35	SDATV	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUV	Allow NULL?
36	SBMNG	Base quantity	decimal	13	3	QUAN	((0))	Yes		BASMN
37	SBMEH	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
38	SAENR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
39	STLAL	Alternative BOM	nvarchar	2	0	CHAR	(N' ')	Yes		STALT	Allow NULL?
40	STLAN	BOM Usage	char	1	0	CHAR	(N' ')	Yes	T416	STLAN	Allow NULL?
41	SLSVN	From Lot Size	decimal	13	3	QUAN	((0))	Yes		LOSVN
42	SLSBS	To Lot Size	decimal	13	3	QUAN	((0))	Yes		LOSBS
43	AUFLD	Date of BOM Explosion/Routing Transfer	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_AUFLD	Allow NULL?
44	DISPO	MRP controller for the order	nvarchar	3	0	CHAR	(N' ')	Yes	T024D	CO_DISPO	Allow NULL?
45	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
46	FEVOR	Production Supervisor	nvarchar	3	0	CHAR	(N' ')	Yes	T024F	FEVOR	Allow NULL?
47	FHORI	Scheduling Margin Key for Floats	nvarchar	3	0	CHAR	(N' ')	Yes	T436A	FHORI	Allow NULL?
48	TERKZ	Scheduling type	char	1	0	CHAR	(N' ')	Yes	T482	TERMKZ	Allow NULL?
49	REDKZ	Reduction indicator for scheduling	char	1	0	CHAR	(N' ')	Yes		REDKZ	Allow NULL?
50	APRIO	Order priority	char	1	0	CHAR	(N' ')	Yes		CO_APRIO	Allow NULL?
51	NTZUE	Superior network number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NETZ_UEBER	Allow NULL?
52	VORUE	Superior activity	nvarchar	4	0	CHAR	(N' ')	Yes		VORG_UEBER	Allow NULL?
53	PROFID	Network profile	nvarchar	7	0	CHAR	(N' ')	Yes	TCN41	PROFIDNZPL	Allow NULL?
54	VORGZ	Float before production (in days)	nvarchar	3	0	NUMC	(N'000')	Yes		VORGZ	Allow NULL?
55	SICHZ	Float after production (in days)	nvarchar	3	0	NUMC	(N'000')	Yes		SICHZ	Allow NULL?
56	FREIZ	Release period (in days)	nvarchar	3	0	NUMC	(N'000')	Yes		FREIZ	Allow NULL?
57	UPTER	Indicator: Change to Scheduled Dates	char	1	0	CHAR	(N' ')	Yes		CO_UPTER	Allow NULL?
58	BEDID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
59	PRONR	Project definition	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	PS_PSP_PRO	Allow NULL?
60	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
61	MZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
62	ZKRIZ	Counter for additional criteria	nvarchar	7	0	NUMC	(N'0000000')	Yes		DZKRIZ	Allow NULL?
63	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	QPLOS	Allow NULL?
64	KLVARP	Costing variant for planned costs	nvarchar	4	0	CHAR	(N' ')	Yes	*	KALKVARPLN	Allow NULL?
65	KLVARI	Costing variant for actual costs	nvarchar	4	0	CHAR	(N' ')	Yes	*	KALKVARIST	Allow NULL?
66	RGEKZ	Indicator: Backflushing for order	char	1	0	CHAR	(N' ')	Yes		CO_RGEKZ	Allow NULL?
67	PLART	Basis for scheduling	char	1	0	CHAR	(N' ')	Yes		PS_PLART	Allow NULL?
68	FLG_AOB	Indicator: relationships	char	1	0	CHAR	(N' ')	Yes		FLG_AOB	Allow NULL?
69	FLG_ARBEI	Indicator: Default value work is relevant	char	1	0	CHAR	(N' ')	Yes		FLG_ARBEI	Allow NULL?
70	GLTPP	Finish date (forecast)	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTPP	Allow NULL?
71	GSTPP	Forecast start date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GSTPP	Allow NULL?
72	GLTPS	Scheduled forecast finish	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GLTPS	Allow NULL?
73	GSTPS	Scheduled forecast start	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GSTPS	Allow NULL?
74	FTRPS	Scheduled release date (forecast)	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_FTRPS	Allow NULL?
75	RDKZP	Reduction indicator for scheduling (forecast)	char	1	0	CHAR	(N' ')	Yes		REDKZP	Allow NULL?
76	TRKZP	Scheduling type (forecast)	char	1	0	CHAR	(N' ')	Yes	*	TERMKZP	Allow NULL?
77	RUECK	Completion confirmation number for the operation	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_RUECK	Allow NULL?
78	RMZHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
79	IGMNG	Yield confirmed from order confirmation	decimal	13	3	QUAN	((0))	Yes		CO_IGMNG
80	RATID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
81	GROID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
82	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
83	GLUZS	Scheduled finish time	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GLUZS	Allow NULL?
84	GSUZS	Scheduled Start (Time)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GSUZS	Allow NULL?
85	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
86	RSHTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
87	RSHID	Object ID of the resource	nvarchar	8	0	NUMC	(N'00000000')	Yes	CRID	CR_OBJID	Allow NULL?
88	RSNTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
89	RSNID	Object ID of the resource	nvarchar	8	0	NUMC	(N'00000000')	Yes	CRID	CR_OBJID	Allow NULL?
90	NAUTERM	Indicator: Do not schedule automatically	char	1	0	CHAR	(N' ')	Yes		CO_NAUTERM	Allow NULL?
91	NAUCOST	Indicator: Do not cost automatically	char	1	0	CHAR	(N' ')	Yes		CO_NAUCOST	Allow NULL?
92	STUFE	Level (in multi-level BOM explosions)	decimal	2	0	DEC	((0))	Yes		HISTU
93	WEGXX	Path (for multi-level BOM explosions)	decimal	4	0	DEC	((0))	Yes		WEGXX
94	VWEGX	Path (for multi-level BOM explosions)	decimal	4	0	DEC	((0))	Yes		WEGXX
95	ARSNR	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
96	ARSPS	Order Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		CO_POSNR	Allow NULL?
97	MAUFNR	Number of superior order	nvarchar	12	0	CHAR	(N' ')	Yes	*	MAUFNR	Allow NULL?
98	LKNOT	Left node in collective order	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_LKNOT	Allow NULL?
99	RKNOT	Right node of a collective order	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_RKNOT	Allow NULL?
100	PRODNET	Indicator: Order is part of collective order	char	1	0	CHAR	(N' ')	Yes		CO_PRODNET	Allow NULL?
101	IASMG	Scrap confirmed for order	decimal	13	3	QUAN	((0))	Yes		CO_IASMG
102	ABARB	Confirmation: Degree of processing	nvarchar	3	0	NUMC	(N'000')	Yes		CO_ABARB	Allow NULL?
103	AUFNT	Number of superior network	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_TEILNET	Allow NULL?
104	AUFPT	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
105	APLZT	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	CO_APLZL	Allow NULL?
106	NO_DISP	Effective for Materials Planning	char	1	0	CHAR	(N' ')	Yes		NO_DISP_PLUS	Allow NULL?
107	CSPLIT	Apportionment Structure	nvarchar	4	0	CHAR	(N' ')	Yes	MAKV	CSPLIT	Allow NULL?
108	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
109	CY_SEQNR	Seq. number order	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CY_SEQNR	Allow NULL?
110	BREAKS	Indicator: Scheduling allowing for breaks	char	1	0	CHAR	(N' ')	Yes		BREAKS	Allow NULL?
111	VORGZ_TRM	Scheduled float before production in days	decimal	6	3	DEC	((0))	Yes		VORGZ_TRM
112	SICHZ_TRM	Scheduled float after production in days	decimal	6	3	DEC	((0))	Yes		SICHZ_TRM
113	TRMDT	Date of the last scheduling	nvarchar	8	0	DATS	(N'00000000')	Yes		TRMDT	Allow NULL?
114	GLUZP	Basic finish (time)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GLUZP	Allow NULL?
115	GSUZP	Basic start time	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GSUZP	Allow NULL?
116	GSUZI	Actual start time	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GSUZI	Allow NULL?
117	GEUZI	Confirmed order finish (time)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GEUZI	Allow NULL?
118	GLUPP	Forecast finish (time)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GLUPP	Allow NULL?
119	GSUPP	Forecast start (time)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GSUPP	Allow NULL?
120	GLUPS	Scheduled forecast finish time	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GLUPS	Allow NULL?
121	GSUPS	Scheduled start time (Forecast)	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_GSUPS	Allow NULL?
122	CHSCH	Search procedure for batch determination	nvarchar	6	0	CHAR	(N' ')	Yes	T683	KALSMA_CH	Allow NULL?
123	KAPT_VORGZ	Float (bef. production) remaining after finite scheduling	nvarchar	3	0	NUMC	(N'000')	Yes		KAPT_VORGZ	Allow NULL?
124	KAPT_SICHZ	Remaining float after finite scheduling	nvarchar	3	0	NUMC	(N'000')	Yes		KAPT_SICHZ	Allow NULL?
125	LEAD_AUFNR	Leading order in current processing	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	CO_LAUFNR	Allow NULL?
126	PNETSTARTD	Outline start of collective network (date)	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_PSTARTD	Allow NULL?
127	PNETSTARTT	Start time of a collective order	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_PSTARTT	Allow NULL?
128	PNETENDD	Outline finish of collective order (date)	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_PENDD	Allow NULL?
129	PNETENDT	Outline finish time	nvarchar	6	0	TIMS	(N'000000')	Yes		CO_PENDT	Allow NULL?
130	KBED	Ind: do not create capacity requirements	char	1	0	CHAR	(N' ')	Yes		KBED_D	Allow NULL?
131	KKALKR	Indicator: Components will not be costed	char	1	0	CHAR	(N' ')	Yes		COMP_CALC	Allow NULL?
132	SFCPF	Production Scheduling Profile	nvarchar	6	0	CHAR	(N' ')	Yes	TCO43	CO_PRODPRF	Allow NULL?
133	RMNGA	Total confirmed rework quantity	decimal	13	3	QUAN	((0))	Yes		RMNGA
134	GSBTR	Overall commitment date	nvarchar	8	0	DATS	(N'00000000')	Yes		CO_GSBTR	Allow NULL?
135	VFMNG	Committed quantity for order acc. to ATP check components	decimal	13	3	QUAN	((0))	Yes		CO_VFMNG
136	NOPCOST	Do not calculate planned costs for order	char	1	0	CHAR	(N' ')	Yes		CO_NOPCOST	Allow NULL?
137	NETZKONT	Indicator for the account assignment of a network(hdr/act.)	char	1	0	CHAR	(N' ')	Yes		NETZKONT	Allow NULL?
138	ATRKZ	Request ID	char	1	0	CHAR	(N' ')	Yes		ATRKZ	Allow NULL?
139	OBJTYPE	Change indicator	char	1	0	CHAR	(N' ')	Yes		OCM_OBJ_TYPE	Allow NULL?
140	CH_PROC	Process that has lead to the change of an object	char	1	0	CHAR	(N' ')	Yes		OCM_CH_PROC	Allow NULL?
141	KAPVERSA	Version of Available Capacity	nvarchar	2	0	NUMC	(N'00')	Yes	*	KAPVERSA	Allow NULL?
142	COLORDPROC	Collective order with/without automatic goods movement	char	1	0	CHAR	(N' ')	Yes		CO_COLORDPRC	Allow NULL?
143	KZERB	Indicator: Project summarization via master data charact.	char	1	0	CHAR	(N' ')	Yes		PS_KZERB	Allow NULL?
144	CONF_KEY	Identical object	nvarchar	8	0	NUMC	(N'00000000')	Yes		CC_CONF_KEY	Allow NULL?
145	ST_ARBID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
146	VSNMR_V	Sales document version number	nvarchar	12	0	CHAR	(N' ')	Yes		VSNMR_V	Allow NULL?
147	TERHW	Scheduling note from order scheduling	char	1	0	CHAR	(N' ')	Yes		TERHW	Allow NULL?
148	SPLSTAT	Status of an order in a split hierarchy	char	1	0	CHAR	(N' ')	Yes		SPLIT_STAT	Allow NULL?
149	COSTUPD	Costs are updated	char	1	0	CHAR	(N' ')	Yes		CN_COSTUPD	Allow NULL?
150	MAX_GAMNG	Maximum Value of Total Order Quantity After Distribution	decimal	13	3	QUAN	((0))	Yes		CO_MES_MAX_GAMNG
151	MES_ROUTINGID	Key of a Routing from an ME System	nvarchar	64	0	CHAR	(N' ')	Yes		CO_MES_INT_ROUTINGID	Allow NULL?
152	ADPSP	PM/PS Reference Element	nvarchar	40	0	CHAR	(N' ')	Yes	*	ADCOMPARE	Allow NULL?
153	RMANR	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN	Allow NULL?
154	POSNR_RMA	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR	Allow NULL?
155	POSNV_RMA	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR	Allow NULL?
156	CFB_MAXLZ	Maximum Storage Period	decimal	5	0	DEC	((0))	Yes		MAXLZ
157	CFB_LZEIH	Unit for maximum storage period	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LZEIH	Allow NULL?
158	CFB_ADTDAYS	Additional Days	decimal	4	0	DEC	((0))	Yes		CFB_ADTDAYS
159	CFB_DATOFM	Date of Manufacture	nvarchar	8	0	DATS	(N'00000000')	Yes		CFB_DATOFM	Allow NULL?
160	CFB_BBDPI	Best-Before Date (BBD)/ Shelf Life Expiration Date (SLED)	nvarchar	8	0	DATS	(N'00000000')	Yes		CFB_BBD_PPPI	Allow NULL?
161	OIHANTYP	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	OIH_HANTYP	Allow NULL?
162	MILL_RATIO	Factor for Quantity-Based Settlement	int	10	0	INT4	((0))	Yes		MILL_RATIO	Allow NULL?
163	BMEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
164	BMENGE	Base quantity	decimal	13	3	QUAN	((0))	Yes		BASMN
165	MILL_OC_ZUSKZ	Combination Indicator	char	1	0	CHAR	(N' ')	Yes		MILL_OC_ZUSKZ	Allow NULL?

TOP ERP 6.0 | AFKO INDEXES

Name	Primary	Unique	Type	Columns
AFKO~0	Yes	Yes	CLUSTERED	AUFNR, MANDT
AFKO~1	No	No	NONCLUSTERED	AUFPL, MANDT
AFKO~2	No	No	NONCLUSTERED	PRONR, MANDT
AFKO~3	No	No	NONCLUSTERED	AUFNT, MANDT
AFKO~4	No	No	NONCLUSTERED	APLZT, AUFPT, MANDT
AFKO~5	No	No	NONCLUSTERED	PRODNET, MAUFNR, MANDT
AFKO~6	No	No	NONCLUSTERED	LEAD_AUFNR
AFKO~D	No	No	NONCLUSTERED	DISPO, MANDT
AFKO~F	No	No	NONCLUSTERED	FEVOR, MANDT
AFKO~P	No	No	NONCLUSTERED	PLNBEZ, PLNNR, PLNTY, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

165 COLUMNS | 10 INDEXES | ERP 6.0 | AFKO TABLE

TOP ERP 6.0 | AFKO COLUMNS

TOP ERP 6.0 | AFKO INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

165 COLUMNS | 10 INDEXES | ERP 6.0 | AFKO TABLE

TOPERP 6.0 | AFKO COLUMNS

TOPERP 6.0 | AFKO INDEXES

TOP ERP 6.0 | AFKO COLUMNS

TOP ERP 6.0 | AFKO INDEXES