ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	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

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

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