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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
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	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
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	T399X	82	1	Parameters dependent on order type	Production Orders

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	WERKS	Plant	nvarchar	4	Allow NULL?
3	AUART	Order Type	nvarchar	4	Allow NULL?
4	PLNTY	Task List Type	char	1	Allow NULL?
5	PRF_GROUPE	Profile group (sort graphics profiles)	nvarchar	4	Allow NULL?
6	PRF_NAME	Name of graphic profile in Network/Hierarchy Graphics	nvarchar	12	Allow NULL?
7	PRF_INDEX	Profile index for graphics profiles	char	1	Allow NULL?
8	OBJNR_VORG	Indicator: Account assignment on activity level	char	1	Allow NULL?
9	DFREG	Default Rule	nvarchar	3	Allow NULL?
10	ARBPA	Routing selection	char	1	Allow NULL?
11	CAPID	Application	nvarchar	4	Allow NULL?
12	CPSLID	Selection ID for routings	nvarchar	2	Allow NULL?
13	AUTYP	Order category	nvarchar	2	Allow NULL?
14	KLVARP	Costing variant for planned costs	nvarchar	4	Allow NULL?
15	KLVARI	Costing variant for actual costs	nvarchar	4	Allow NULL?
16	DPROBO	Indicator: Check of op. dtl screens during routing transfer	char	1	Allow NULL?
17	DPROBC	Indicator: Detail screen check of comp. during BOM explosion	char	1	Allow NULL?
18	FLG_DOC	Indicator: creation of change documents active	char	1	Allow NULL?
19	AWSLS	Variance Key	nvarchar	6	Allow NULL?
20	ABGSL	Results Analysis Key	nvarchar	6	Allow NULL?
21	ALTSEQ	Indicator: Alternative sequences copied into the order	char	1	Allow NULL?
22	FLG_STAT	Indicator: Statistical order	char	1	Allow NULL?
23	VORNR_DEL	Increment for automatic operation/activity numbering	nvarchar	4	Allow NULL?
24	FLG_ERF_H	Activate/deactivate entry tool	char	1	Allow NULL?
25	RSTRA	Reduction strategy per operation/activity	nvarchar	2	Allow NULL?
26	STATISTIK	Indicator: LIS statistics are active	char	1	Allow NULL?
27	SEQ_CHANGE	Sequence exchange manual/auto	char	1	Allow NULL?
28	CHGKZ_HEAD	Status change document for header order/network	char	1	Allow NULL?
29	CHGKZ_OPR	Indicator: Status change document active for operations	char	1	Allow NULL?
30	CHGKZ_CMP	Indicator: Status change document active for materials	char	1	Allow NULL?
31	CHGKZ_PRT	Indicator: Status change document active for PRTs	char	1	Allow NULL?
32	PLTRM	Indicator: Copy planned order scheduling	char	1	Allow NULL?
33	AOB_KEY	Key: View of relationships	char	1	Allow NULL?
34	PROFIDGRAF	Order profile	nvarchar	7	Allow NULL?
35	AOB_DARST	Relationship display	char	1	Allow NULL?
36	VRG_DARST	Operation display in graphic	char	1	Allow NULL?
37	PHS_DARST	Display of phase in graphics	char	1	Allow NULL?
38	E_DISPO	Substitute MRP controller	nvarchar	3	Allow NULL?
39	E_FEVOR	Substitute production scheduler	nvarchar	3	Allow NULL?
40	NAUCOST	Indicator: Do not cost automatically	char	1	Allow NULL?
41	STRAT	Strategy for determining a settlement rule	nvarchar	2	Allow NULL?
42	EBR_ERF	Indicator: Process data documentation required	char	1	Allow NULL?
43	CHSCH	Search procedure for batch determination	nvarchar	6	Allow NULL?
44	MC_VHEAD	Release version for production order header = active	char	1	Allow NULL?
45	MC_VITEM	Release version for production order item = active	char	1	Allow NULL?
46	MC_VOPER	Release version for production order operation = active	char	1	Allow NULL?
47	CO_STAUF	BOM selection key	char	1	Allow NULL?
48	PRUEB	Ind.: Copy Net Price from Requisition into Purchase Order	char	1	Allow NULL?
49	ALT_PLANW	Alternative task list application	char	1	Allow NULL?
50	WF_MAT_CHG	Indicator: Workflow for purchase order change	char	1	Allow NULL?
51	PDC_ACTIVE	Indicator: PDC active	char	1	Allow NULL?
52	NO_DISP	Effective for Materials Planning	char	1	Allow NULL?
53	PROF_GR	Graphics profile for collective order	nvarchar	6	Allow NULL?
54	PRUEFART	Inspection Type	nvarchar	8	Allow NULL?
55	ORD_BANF	Indicator: One collective purchase requisition per order	char	1	Allow NULL?
56	MBWEB	Goods receipt for purchase order	char	1	Allow NULL?
57	MBWEF	Goods receipt for production order	char	1	Allow NULL?
58	MBWAP	Planned goods issue (for reservation)	char	1	Allow NULL?
59	MBWAU	Unplanned goods issue	char	1	Allow NULL?
60	NOPCOST	Do not calculate planned costs for order	char	1	Allow NULL?
61	FLG_SCRAP	Indicator: Planning and recording of scrap	char	1	Allow NULL?
62	VAL_REC	Indicator: Order requires approval	char	1	Allow NULL?
63	KZCHP	Indicator: Check of the batch entered is active	char	1	Allow NULL?
64	CHP_ERF	Indicator: Batch record is required	char	1	Allow NULL?
65	CHP_DAUER	Availability period of batch record in years	nvarchar	2	Allow NULL?
66	PKOSA	Use Product Cost Collector as Cost Object	char	1	Allow NULL?
67	PVSEL	Indicator: Selection of production version	char	1	Allow NULL?
68	FTLPROF	Profile display missing parts list	nvarchar	6	Allow NULL?
69	FTLPROFNET	Profile display missing parts list collective orders	nvarchar	6	Allow NULL?
70	DWBPROF	Profile documentation goods movements for order (AUFM)	nvarchar	6	Allow NULL?
71	KZFORT	Indicator: Determine progress values for production order	char	1	Allow NULL?
72	OCM_PROF	Profile for OCM PP / PS	nvarchar	6	Allow NULL?
73	ROUT_TEXT	Indicator: Copy text from routing header	char	1	Allow NULL?
74	UPD_ONLY	Costs are only updated	char	1	Allow NULL?
75	MBWEW	Material Documents: Goods Receipt for WIP Batch	char	1	Allow NULL?
76	WIPBATCH_GM	Indicator: Goods Movement for a WIP Batch	char	1	Allow NULL?
77	LFE_DEF_RULE	Linear Data - Order Operation Default Rules	char	1	Allow NULL?
78	FLG_READ	Read BOM when Converting Planned Order	char	1	Allow NULL?
79	/CUM/INDCU	CU: Order is Used for Compatible Units	char	1	Allow NULL?
80	/CUM/AUEST	CU: Automatic Copy of Estimated Costs	char	1	Allow NULL?
81	OIHANTYP	Excise Duty Handling Type	nvarchar	2	Allow NULL?
82	BWTAR	Valuation Type	nvarchar	10	Allow NULL?

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

82 COLUMNS | 1 INDEXES | ERP 6.0 | T399X TABLE

TOP ERP 6.0 | T399X COLUMNS

TOP ERP 6.0 | T399X 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

82 COLUMNS | 1 INDEXES | ERP 6.0 | T399X TABLE

TOPERP 6.0 | T399X COLUMNS

TOPERP 6.0 | T399X INDEXES

TOP ERP 6.0 | T399X COLUMNS

TOP ERP 6.0 | T399X INDEXES