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
Materials Management :: Purchasing
1	ERP EHP7	6.0	T163P	128	1	Release Creation Profile	Purchasing

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	WERKS	Plant	nvarchar	4	Allow NULL?
3	ABUEB	Release Creation Profile	nvarchar	4	Allow NULL?
4	RUSKZ	Backlog and/or immediate requirement exist(s)	char	1	Allow NULL?
5	FRUSA	JIT: Show Backlog and Immediate Requirement	char	1	Allow NULL?
6	LRUSA	FRC Delivery Schedule: Show Backlog and Imm. Requirement	char	1	Allow NULL?
7	FABHO	JIT deliv. schedule horizon (SA release horizon) in workdays	nvarchar	3	Allow NULL?
8	LABHO	Forecast delivery schedule horizon in workdays	nvarchar	3	Allow NULL?
9	FKAGG	JIT Delivery Schedule Creation Without Aggregation	nvarchar	3	Allow NULL?
10	LKAGG	Forecast Delivery Schedule Creation Without Aggregation	nvarchar	3	Allow NULL?
11	FTAGG	JIT Delivery Schedule Creation with Daily Aggregation	nvarchar	3	Allow NULL?
12	LTAGG	Forecast Delivery Schedule Creation with Daily Aggregation	nvarchar	3	Allow NULL?
13	FPAGG	Creation of JIT Schedules with Aggreg. Acc. to Planning Cal.	nvarchar	3	Allow NULL?
14	FKALA	Planning Calendar for Aggregation	nvarchar	3	Allow NULL?
15	LPAGG	Creation of FRC Schedules with Aggreg. Acc. to Planning Cal.	nvarchar	3	Allow NULL?
16	LKALA	Planning Calendar for Aggregation	nvarchar	3	Allow NULL?
17	LWAGG	Forecast Delivery Schedule Creation with Weekly Aggregation	nvarchar	3	Allow NULL?
18	LMAGG	Forecast Schedule Creation with Monthly Aggregation	nvarchar	3	Allow NULL?
19	FKUEB	No periodic transmission of JIT delivery schedules	char	1	Allow NULL?
20	LKUEB	No periodic transmission of forecast delivery schedules	char	1	Allow NULL?
21	FTUEB	Periodic transmission of JIT delivery schedules (daily)	char	1	Allow NULL?
22	LTUEB	Periodic transmission of forecast delivery schedules (daily)	char	1	Allow NULL?
23	FPUEB	Periodic transm. of JIT schedules acc. to planning calendar	char	1	Allow NULL?
24	FKALU	Planning calendar for periodic transmission	nvarchar	3	Allow NULL?
25	LPUEB	Periodic transm. of FRC schedules acc. to planning calendar	char	1	Allow NULL?
26	LKALU	Planning calendar for periodic transmission	nvarchar	3	Allow NULL?
27	FWUEB	Periodic transmission of JIT delivery schedules (weekly)	char	1	Allow NULL?
28	LWUEB	Periodic transmission of forecast deliv. schedules (weekly)	char	1	Allow NULL?
29	LMUEB	Periodic transmission of forecast deliv. schedules (monthly)	char	1	Allow NULL?
30	LPLT1	Length of Checking Period 1 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
31	LPLT2	Length of Checking Period 2 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
32	LPLT3	Length of Checking Period 3 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
33	FPLT1	Length of Checking Period 1 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
34	FPLT2	Length of Checking Period 2 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
35	FPLT3	Length of Checking Period 3 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
36	LOTO1	Upper Tolerance Limit for FRC Schedules in Checking Period 1	nvarchar	3	Allow NULL?
37	LOTO2	Upper Tolerance Limit for FRC Schedules in Checking Period 2	nvarchar	3	Allow NULL?
38	LOTO3	Upper Tolerance Limit for FRC Schedules in Checking Period 3	nvarchar	3	Allow NULL?
39	FOTO1	Upper Tolerance Limit for JIT Schedules in Checking Period 1	nvarchar	3	Allow NULL?
40	FOTO2	Upper Tolerance Limit for JIT Schedules in Checking Period 2	nvarchar	3	Allow NULL?
41	FOTO3	Upper Tolerance Limit for JIT Schedules in Checking Period 3	nvarchar	3	Allow NULL?
42	LUTO1	Lower Tolerance Limit for FRC Schedules in Checking Period 1	nvarchar	3	Allow NULL?
43	LUTO2	Lower Tolerance Limit for FRC Schedules in Checking Period 2	nvarchar	3	Allow NULL?
44	LUTO3	Lower Tolerance Limit for FRC Schedules in Checking Period 3	nvarchar	3	Allow NULL?
45	FUTO1	Lower Tolerance Limit for JIT Schedules in Checking Period 1	nvarchar	3	Allow NULL?
46	FUTO2	Lower Tolerance Limit for JIT Schedules in Checking Period 2	nvarchar	3	Allow NULL?
47	FUTO3	Lower Tolerance Limit for JIT Schedules in Checking Period 3	nvarchar	3	Allow NULL?
48	LPRA1	Type of Check for Forecast Delivery Schedules in Period 1	char	1	Allow NULL?
49	LPRA2	Type of Check for Forecast Delivery Schedules in Period 2	char	1	Allow NULL?
50	LPRA3	Type of Check for Forecast Delivery Schedules in Period 3	char	1	Allow NULL?
51	FPRA1	Type of Check for JIT Delivery Schedules in Period 1	char	1	Allow NULL?
52	FPRA2	Type of Check for JIT Delivery Schedules in Period 2	char	1	Allow NULL?
53	FPRA3	Type of Check for JIT Delivery Schedules in Period 3	char	1	Allow NULL?
54	LRUEC	Backlog in FRC Delivery Schedules is Transmission-Relevant	char	1	Allow NULL?
55	FRUEC	Backlog in JIT Delivery Schedules is Transmission-Relevant	char	1	Allow NULL?
56	FAEODT	Creation Strategy for JIT Del. Sched.: Changed or Next Date	char	1	Allow NULL?
57	FAEN	Creation Strategy for JIT Delivery Schedule: Changed Only	char	1	Allow NULL?
58	FDT	Creation Strategy for JIT Delivery Schedule: Next Date Only	char	1	Allow NULL?
59	FAEUDT	Creation Strategy for JIT Del. Sched.: Changed and Next Date	char	1	Allow NULL?
60	FNO	JIT: No Past Dates/Times	char	1	Allow NULL?
61	LAEODT	Creation Strategy for FRC Schedule: Changed or Next Date	char	1	Allow NULL?
62	LAEN	Creation Strategy for Forecast Deliv. Schedule: Changed Only	char	1	Allow NULL?
63	LDT	Creation Strategy for FRC Schedule: Next Date Only	char	1	Allow NULL?
64	LAEUDT	Creation Strategy for FRC Schedule: Changed and Next Date	char	1	Allow NULL?
65	LNO	FRC: No Past Dates/Times	char	1	Allow NULL?
66	FPRHO	Checking Horizon for JIT Schedule	nvarchar	3	Allow NULL?
67	LPRHO	Checking Horizon for Forecast Delivery Schedule	nvarchar	3	Allow NULL?
68	IFAB	JIT: Internet Release	char	1	Allow NULL?
69	ILAB	FRC: Internet Release	char	1	Allow NULL?
70	FBEST	JIT: Acknowledgment of Internet Release by Vendor	char	1	Allow NULL?
71	LBEST	FRC: Acknowledgment of Internet Release by Vendor	char	1	Allow NULL?
72	LAGGR	FRC: Aggregation	char	1	Allow NULL?
73	FRSVZ	JIT: Bring Forward Backlog and Immediate Requirement	char	1	Allow NULL?
74	LRSVZ	FRC: Bring Forward Backlog and Immediate Requirement	char	1	Allow NULL?
75	FVWE	JIT: Activate Number of GRs/Deliveries Greater Than 1	char	1	Allow NULL?
76	LWE	FRC: Activate No. of GRs/Inbound Deliveries Greater Than 1	char	1	Allow NULL?
77	FZWEFZ	JIT: 2nd Cumulative Received Quantity (2nd CRQ)	char	1	Allow NULL?
78	LZWEFZ	FRC: 2nd Cumulative Received Quantity (2nd CRQ)	char	1	Allow NULL?
79	FAASN	JIT: No. of Inbound Deliveries	char	1	Allow NULL?
80	LAASN	FRC: Number of Deliveries	char	1	Allow NULL?
81	FAWE	JIT: No. of Last Goods Receipts Against SA Release	char	1	Allow NULL?
82	LAWE	FRC: Number of Last GRs Against SA Release	char	1	Allow NULL?
83	FSORT1	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
84	LSORT1	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
85	FSORT2	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
86	LSORT2	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
87	FSORT3	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
88	LSORT3	Sort Criterion for Last GRs/Shipping Notifications	nvarchar	30	Allow NULL?
89	FBMAIL	JIT: Workflow for Acknowledgment of Release by Vendor	char	1	Allow NULL?
90	LBMAIL	FRC: Workflow in Case of Acknowledgment of Release by Vendor	char	1	Allow NULL?
91	FLMAIL	JIT: Mail to Vendor on Generation of Internet Release	char	1	Allow NULL?
92	LLMAIL	FRC: Mail to Vendor on Creation of an Internet Release	char	1	Allow NULL?
93	FPAGE2	Automotive Print with Smart Forms: Print More Than One Page	char	1	Allow NULL?
94	FLASTDEL	Automotive Print with Smart Forms: Print Last Deliveries	char	1	Allow NULL?
95	FCHANGES	Automotive Print with Smart Forms: Print Change Statuses	char	1	Allow NULL?
96	FPACKING	Automotive Print with Smart Forms: Print Packing Info	char	1	Allow NULL?
97	FFOLLOWM	Automotive Print with Smart Forms: Print Follow-Up Material	char	1	Allow NULL?
98	FSUBCON	Automotive Print with Smart Form: Print Subcontr. Components	char	1	Allow NULL?
99	LSTOPPLT1	Length of Checking Period 1 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
100	LSTOPPLT2	Length of Checking Period 2 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
101	LSTOPPLT3	Length of Checking Period 3 for FRC Schedules in Workdays	nvarchar	3	Allow NULL?
102	FSTOPPLT1	Length of Checking Period 1 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
103	FSTOPPLT2	Length of Checking Period 2 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
104	FSTOPPLT3	Length of Checking Period 3 for JIT Schedules in Workdays	nvarchar	3	Allow NULL?
105	LSTOPOTO1	Upper Tolerance Limit for Checking Period 1	nvarchar	3	Allow NULL?
106	LSTOPOTO2	Upper Tolerance Limit for Checking Period 2	nvarchar	3	Allow NULL?
107	LSTOPOTO3	Upper Tolerance Limit for Checking Period 3	nvarchar	3	Allow NULL?
108	FSTOPOTO1	Upper Tolerance Limit for Checking Period 1	nvarchar	3	Allow NULL?
109	FSTOPOTO2	Upper Tolerance Limit for Checking Period 2	nvarchar	3	Allow NULL?
110	FSTOPOTO3	Upper Tolerance Limit for Checking Period 3	nvarchar	3	Allow NULL?
111	LSTOPUTO1	Lower Tolerance Limit for Checking Period 1	nvarchar	3	Allow NULL?
112	LSTOPUTO2	Lower Tolerance Limit for Checking Period 2	nvarchar	3	Allow NULL?
113	LSTOPUTO3	Lower Tolerance Limit for Checking Period 3	nvarchar	3	Allow NULL?
114	FSTOPUTO1	Lower Tolerance Limit for Checking Period 1	nvarchar	3	Allow NULL?
115	FSTOPUTO2	Lower Tolerance Limit for Checking Period 2	nvarchar	3	Allow NULL?
116	FSTOPUTO3	Lower Tolerance Limit for Checking Period 3	nvarchar	3	Allow NULL?
117	LSTOPPRA1	Type of Check for Forecast Delivery Schedules in Period 1	char	1	Allow NULL?
118	LSTOPPRA2	Type of Check for Forecast Delivery Schedules in Period 2	char	1	Allow NULL?
119	LSTOPPRA3	Type of Check for Forecast Delivery Schedules in Period 3	char	1	Allow NULL?
120	FSTOPPRA1	Type of Check for JIT Delivery Schedules in Period 1	char	1	Allow NULL?
121	FSTOPPRA2	Type of Check for JIT Delivery Schedules in Period 2	char	1	Allow NULL?
122	FSTOPPRA3	Type of Check for JIT Delivery Schedules in Period 3	char	1	Allow NULL?
123	FABREV	JIT Delivery Schedule: Change in Revision Level	char	1	Allow NULL?
124	LABREV	Forecast Delivery Schedule: Change of Revision Level	char	1	Allow NULL?
125	FANACHF	JIT Delivery Schedule: Follow-Up Material	char	1	Allow NULL?
126	LANACHF	Forecast Delivery Schedule: Follow-up Material	char	1	Allow NULL?
127	FSTOPPRHO	Checking Horizon for JIT Schedule	nvarchar	3	Allow NULL?
128	LSTOPPRHO	Checking Horizon for Forecast Delivery Schedule	nvarchar	3	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

128 COLUMNS | 1 INDEXES | ERP 6.0 | T163P TABLE

TOP ERP 6.0 | T163P COLUMNS

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

128 COLUMNS | 1 INDEXES | ERP 6.0 | T163P TABLE

TOPERP 6.0 | T163P COLUMNS

TOPERP 6.0 | T163P INDEXES

TOP ERP 6.0 | T163P COLUMNS

TOP ERP 6.0 | T163P INDEXES