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	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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
Financial Accounting :: Accounts Payable :: Basic Functions :: Payment Transactions
1	ERP EHP7	6.0	FPRL_ITEM	174	4	Item Data	Payment Transactions

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	GUID	UUID in X form (binary)	varbinary	16	0
3	LIST_ID	Payment Release List ID	nvarchar	10	0	Allow NULL?
4	STATUS	Item Status ID	nvarchar	3	0	Allow NULL?
5	ALEVEL	Approval Level	nvarchar	2	0	Allow NULL?
6	CREA_USER	Created By	nvarchar	12	0	Allow NULL?
7	CREA_TIME	Created On	decimal	15	0
8	CHANGE_USER	Last Changed By	nvarchar	12	0	Allow NULL?
9	CHANGE_TIME	Last Changed On	decimal	15	0
10	APPLIC	Payment Release List Application ID	nvarchar	10	0	Allow NULL?
11	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
12	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
13	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
14	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
15	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
16	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
17	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
18	EMPFB	Payee/Payer	nvarchar	10	0	Allow NULL?
19	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
20	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
21	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
22	WRBTR	Amount in document currency	decimal	13	2
23	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2
24	WSKTO	Cash discount amount in document currency	decimal	13	2
25	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2
26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
27	PSWBT	Amount for Updating in General Ledger	decimal	13	2
28	PSSKT	Cash Discount Deduction for the Item	decimal	13	2
29	BLART	Document Type	nvarchar	2	0	Allow NULL?
30	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
31	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
32	KOART	Account Type	char	1	0	Allow NULL?
33	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
34	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
35	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
36	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
37	GSBER	Business Area	nvarchar	4	0	Allow NULL?
38	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
39	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
40	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
41	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
42	ZBD1T	Cash discount days 1	decimal	3	0
43	ZBD2T	Cash discount days 2	decimal	3	0
44	ZBD3T	Net Payment Terms Period	decimal	3	0
45	ZBD1P	Cash Discount Percentage 1	decimal	5	3
46	ZBD2P	Cash Discount Percentage 2	decimal	5	3
47	XREBZ	Indicator: Item is an Invoice-Related Credit Memo	char	1	0	Allow NULL?
48	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
49	ESRRE	ISR Reference Number	nvarchar	27	0	Allow NULL?
50	ESRPZ	ISR Check Digit	nvarchar	2	0	Allow NULL?
51	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
52	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
53	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
54	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
55	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
56	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
57	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
58	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
59	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
60	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
61	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
62	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
63	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
64	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
65	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
66	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
67	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
68	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
69	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
70	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
71	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
72	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
73	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
74	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
75	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
76	XCPDD	Indicator: Address and bank data set individually	char	1	0	Allow NULL?
77	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
78	PPRCT	Partner Profit Center	nvarchar	10	0	Allow NULL?
79	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
80	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
81	GEBER	Fund	nvarchar	10	0	Allow NULL?
82	XINVE	Indicator: Capital Goods Affected?	char	1	0	Allow NULL?
83	KEYNO	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
84	PAMTF	Payment Request Amount in Payment Currency	decimal	13	2
85	ORIGIN	Origin Indicator	nvarchar	8	0	Allow NULL?
86	EPIC_PROCESSOR	Processor	nvarchar	12	0	Allow NULL?
87	EPIC_STATUS	Item Status	nvarchar	3	0	Allow NULL?
88	AVC_STATUS	Cash Control Status	char	1	0	Allow NULL?
89	AVC_PRIORITY	Cash Control Priority	nvarchar	6	0	Allow NULL?
90	FIPOS_ES	Commitment Item	nvarchar	14	0	Allow NULL?
91	FISTL_ES	Funds Center	nvarchar	16	0	Allow NULL?
92	GRANT_NBR_ES	Grant	nvarchar	20	0	Allow NULL?
93	FKBER_ES	Functional Area	nvarchar	16	0	Allow NULL?
94	GEBER_ES	Fund	nvarchar	10	0	Allow NULL?
95	PROJK_ES	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
96	CISUB1_ES	Substring 1 of Commitment Item	nvarchar	10	0	Allow NULL?
97	CISUB2_ES	Substring 2 of Commitment Item	nvarchar	10	0	Allow NULL?
98	CISUB3_ES	Substring 3 of Commitment Item	nvarchar	10	0	Allow NULL?
99	CISUB4_ES	Substring 4 of Commitment Item	nvarchar	10	0	Allow NULL?
100	CISUB5_ES	Substring 5 of Commitment Item	nvarchar	10	0	Allow NULL?
101	LOTKZ_ES	Lot Number for Requests	nvarchar	10	0	Allow NULL?
102	EBELN_CO	Purchasing Document Number	nvarchar	10	0	Allow NULL?
103	SAPLONGNUM	Smart Number	nvarchar	40	0	Allow NULL?
104	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
105	ACCOUNTANT	Accountant	nvarchar	6	0	Allow NULL?
106	CO_STATUS	Status of Garnishment	nvarchar	2	0	Allow NULL?
107	STCD2	Tax Number 2	nvarchar	11	0	Allow NULL?
108	POKEN	Item Indicator	nvarchar	3	0	Allow NULL?
109	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
110	LAUFD_PAY	Date on Which the Program Is to Be Run	nvarchar	8	0	Allow NULL?
111	LAUFI_PAY	Additional Identification	nvarchar	6	0	Allow NULL?
112	VBLNR_PAY	Document Number of the Payment Document	nvarchar	10	0	Allow NULL?
113	PYORD_PAY	Payment Order	nvarchar	10	0	Allow NULL?
114	XF110_EXEC	General Flag	char	1	0	Allow NULL?
115	LAUFD	Date of Proposal Run	nvarchar	8	0	Allow NULL?
116	LAUFI	Payment Proposal	nvarchar	6	0	Allow NULL?
117	JOBCOUNT	Job ID	nvarchar	8	0	Allow NULL?
118	ZBUKR	Paying company code	nvarchar	4	0	Allow NULL?
119	ABSBU	Sending company code	nvarchar	4	0	Allow NULL?
120	ZNME1	Name of the payee	nvarchar	35	0	Allow NULL?
121	ZPSTL	Postal code of the payee	nvarchar	10	0	Allow NULL?
122	ZORT1	City of the payee	nvarchar	35	0	Allow NULL?
123	ZLAND	Country Key	nvarchar	3	0	Allow NULL?
124	ZREGI	Regional code of the payee	nvarchar	3	0	Allow NULL?
125	ZSPRA	Language key of the payee	char	1	0	Allow NULL?
126	NAME1	Name 1	nvarchar	35	0	Allow NULL?
127	ZBVTY	Bank Data Indicator for the Payee	nvarchar	4	0	Allow NULL?
128	ZBNKS	Country Key	nvarchar	3	0	Allow NULL?
129	ZBNKY	Bank key of the payee's bank	nvarchar	15	0	Allow NULL?
130	ZBNKL	Bank number of the payee's bank	nvarchar	15	0	Allow NULL?
131	ZBNKN	Bank account number of the payee	nvarchar	18	0	Allow NULL?
132	ZBKON	Bank Control Key of the Payee's Bank	nvarchar	2	0	Allow NULL?
133	BKREF	Reference specifications for bank details	nvarchar	20	0	Allow NULL?
134	ZSWIF	SWIFT/BIC for International Payments	nvarchar	11	0	Allow NULL?
135	ZIBAN	IBAN (International Bank Account Number)	nvarchar	34	0	Allow NULL?
136	KOINH	Account Holder Name	nvarchar	60	0	Allow NULL?
137	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
138	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
139	UBNKS	Bank country key	nvarchar	3	0	Allow NULL?
140	UBNKY	Bank key of our bank	nvarchar	15	0	Allow NULL?
141	UBNKL	Bank number of our bank	nvarchar	15	0	Allow NULL?
142	UBKNT	Our account number at the bank	nvarchar	18	0	Allow NULL?
143	UBKON	Bank control key at our bank	nvarchar	2	0	Allow NULL?
144	UBHKT	G/L Account Number for Our Bank Account / Bank Sub-Account	nvarchar	10	0	Allow NULL?
145	RZAWE	Payment Method	char	1	0	Allow NULL?
146	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
147	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	Allow NULL?
148	ZALDT	Posting date of the payment document	nvarchar	8	0	Allow NULL?
149	VALUT	Value date	nvarchar	8	0	Allow NULL?
150	AUSFD	Due date of the paid items	nvarchar	8	0	Allow NULL?
151	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	Allow NULL?
152	WEFAE	Bill of Exchange Due Date	nvarchar	8	0	Allow NULL?
153	WDATE	Bill of Exchange Issue Date	nvarchar	8	0	Allow NULL?
154	BUSAB	Accounting clerk	nvarchar	2	0	Allow NULL?
155	EIKTO	Shipper's (Our) Account Number at the Customer or Vendor	nvarchar	12	0	Allow NULL?
156	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
157	RFTTRN	Payment code	nvarchar	20	0	Allow NULL?
158	BTYP1	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	Allow NULL?
159	BNKS1	Bank country key	nvarchar	3	0	Allow NULL?
160	BNKL1	Bank Keys	nvarchar	15	0	Allow NULL?
161	BNKN1	Bank account number	nvarchar	18	0	Allow NULL?
162	BTYP2	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	Allow NULL?
163	BNKS2	Bank country key	nvarchar	3	0	Allow NULL?
164	BNKL2	Bank Keys	nvarchar	15	0	Allow NULL?
165	BNKN2	Bank account number	nvarchar	18	0	Allow NULL?
166	BTYP3	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	Allow NULL?
167	BNKS3	Bank country key	nvarchar	3	0	Allow NULL?
168	BNKL3	Bank Keys	nvarchar	15	0	Allow NULL?
169	BNKN3	Bank account number	nvarchar	18	0	Allow NULL?
170	MGUID	SEPA Mandate: GUID of Mandate	varbinary	16	0
171	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	Allow NULL?
172	INV_NO	Document Number or Invoice Reference Number	nvarchar	10	0	Allow NULL?
173	INV_YEAR	Fiscal Year of DocNo/Inf.ref.	nvarchar	4	0	Allow NULL?
174	INV_ITEM	Line Item within Accounting Document or Relevant Invoice	nvarchar	3	0	Allow NULL?

Name	Primary	Unique	Type	Columns
FPRL_ITEM~0	Yes	Yes	CLUSTERED	GUID, MANDT
FPRL_ITEM~1	No	No	NONCLUSTERED	BUZEI, GJAHR, BELNR, BUKRS
FPRL_ITEM~2	No	No	NONCLUSTERED	LIST_ID
FPRL_ITEM~3	No	No	NONCLUSTERED	KEYNO

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

174 COLUMNS | 4 INDEXES | ERP 6.0 | FPRL_ITEM TABLE

TOP ERP 6.0 | FPRL_ITEM COLUMNS

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

174 COLUMNS | 4 INDEXES | ERP 6.0 | FPRL_ITEM TABLE

TOPERP 6.0 | FPRL_ITEM COLUMNS

TOPERP 6.0 | FPRL_ITEM INDEXES

TOP ERP 6.0 | FPRL_ITEM COLUMNS

TOP ERP 6.0 | FPRL_ITEM INDEXES