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
Payroll :: Germany :: Construction Industry
1	ERP EHP7	6.0	PDBKAN	46	1	Construction Industry Social Fund Proced: ANMEL Data Records	Construction Industry

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PERNR	Personnel Number	nvarchar	8	Allow NULL?
3	INPER	In-Period for Evaluation for Social Fund Procedure	nvarchar	6	Allow NULL?
4	FPPER	For-Period for Evaluation for Social Fund Procedure	nvarchar	6	Allow NULL?
5	SEQNO	Key Field Sequence Number for SFP Data Records	nvarchar	2	Allow NULL?
6	KENID	Identifier of Record	nvarchar	5	Allow NULL?
7	RZNSK	Data Center Number of Social Fund (R)	nvarchar	8	Allow NULL?
8	RZNAG	Data Center Number for Company for Social Fund (R)	nvarchar	8	Allow NULL?
9	BNRSK	Company Number at a Social Fund - Construction Industry	nvarchar	8	Allow NULL?
10	NUS01	Unused Numeric Field - Length 7	nvarchar	7	Allow NULL?
11	NUS02	Version Number Component	nvarchar	2	Allow NULL?
12	RZDAT	Creation Date of Data Medium	nvarchar	8	Allow NULL?
13	VERNR	Version of Data Medium Exchange	nvarchar	2	Allow NULL?
14	FNAME	Name of Company for Social Fund	nvarchar	22	Allow NULL?
15	ZVKAN	Employee Number at a Construction Social Insurance Fund	nvarchar	13	Allow NULL?
16	SKPNR	Personnel Number for Notifications in SFP	nvarchar	13	Allow NULL?
17	MSCHL	Notification Key for Data Record ANMEL	nvarchar	4	Allow NULL?
18	BEGDA	Start of Notification Period	nvarchar	8	Allow NULL?
19	ENDDA	End of Notification Period	nvarchar	8	Allow NULL?
20	ANGRP	Employee Group for Data Record ANMEL	nvarchar	4	Allow NULL?
21	NACHN	Last Name	nvarchar	30	Allow NULL?
22	VORNA	First Name	nvarchar	30	Allow NULL?
23	GBDAT	Date of Birth	nvarchar	8	Allow NULL?
24	GBORT	Birthplace	nvarchar	30	Allow NULL?
25	STRAS	House Number and Street	nvarchar	30	Allow NULL?
26	ORT01	City	nvarchar	25	Allow NULL?
27	LAND1	Country Indicator	nvarchar	3	Allow NULL?
28	EMAIL	E-mail Address	nvarchar	50	Allow NULL?
29	GESCH	Gender Key	char	1	Allow NULL?
30	WOSTD	Weekly Working Time for Social Fund Procedure	nvarchar	4	Allow NULL?
31	NATIO	Nationality	nvarchar	3	Allow NULL?
32	SPRSL	Language of Communication	nvarchar	3	Allow NULL?
33	BANKL	Bank Number	nvarchar	8	Allow NULL?
34	BANKN	Bank Account Number	nvarchar	10	Allow NULL?
35	EMFTX	Payee Text	nvarchar	8	Allow NULL?
36	BANKS	Bank Country Key	nvarchar	3	Allow NULL?
37	HEFTA	Book Request for Data Record ANMEL	char	1	Allow NULL?
38	NUS03	Field of length 16	nvarchar	16	Allow NULL?
39	PSTLZ	Postal Code	nvarchar	7	Allow NULL?
40	BANKA	Foreign Bank Details	nvarchar	35	Allow NULL?
41	BANKI	Bank Account Holder	nvarchar	30	Allow NULL?
42	NUS04	3-Byte field	nvarchar	3	Allow NULL?
43	NUS05	Character field, 8 characters long	nvarchar	8	Allow NULL?
44	TSCHL	Occupational Code	nvarchar	9	Allow NULL?
45	IBAN	IBAN	nvarchar	34	Allow NULL?
46	BIC	BIC	nvarchar	11	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

46 COLUMNS | 1 INDEXES | ERP 6.0 | PDBKAN TABLE

TOP ERP 6.0 | PDBKAN COLUMNS

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

46 COLUMNS | 1 INDEXES | ERP 6.0 | PDBKAN TABLE

TOPERP 6.0 | PDBKAN COLUMNS

TOPERP 6.0 | PDBKAN INDEXES

TOP ERP 6.0 | PDBKAN COLUMNS

TOP ERP 6.0 | PDBKAN INDEXES