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	PDBKNW	81	1	Construction Industry Social Fund Proced: Employee Statement	Construction Industry

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
3	INPER	In-Period for Evaluation for Social Fund Procedure	nvarchar	6	0	Allow NULL?
4	FPPER	For-Period for Evaluation for Social Fund Procedure	nvarchar	6	0	Allow NULL?
5	SEQNO	Key Field Sequence Number for SFP Data Records	nvarchar	2	0	Allow NULL?
6	KENID	Identifier of Record	nvarchar	5	0	Allow NULL?
7	ZVKAN	Employee Number at a Construction Social Insurance Fund	nvarchar	13	0	Allow NULL?
8	BNRSK	Company Number at a Social Fund - Construction Industry	nvarchar	8	0	Allow NULL?
9	BEGDA	Start of Notification Period	nvarchar	8	0	Allow NULL?
10	ENDDA	End of Notification Period	nvarchar	8	0	Allow NULL?
11	RVJUT	Number of Leave Days	decimal	2	0
12	RVJUV	Leave Remuneration	decimal	7	2
13	RVJGT	Number of Leave Days	decimal	2	0
14	RVJGV	Leave Remuneration	decimal	7	2
15	RVJVT	Number of Leave Days	decimal	2	0
16	RVJVV	Leave Remuneration	decimal	7	2
17	BTAGE	Employment Days for Employee Statement	decimal	3	0
18	BLOHN	Gross Wage for Employee Statement	decimal	9	2
19	PSATZ	Percentage for Leave Remuneration	nvarchar	4	0	Allow NULL?
20	UVERG	Leave Remuneration	decimal	7	2
21	AGLST	Number of Lost Hours	decimal	6	2
22	AGLBT	Adjustment Amount	decimal	7	2
23	ULJUT	Number of Leave Days	decimal	2	0
24	ULJUV	Leave Remuneration	decimal	7	2
25	ULJGT	Number of Leave Days	decimal	2	0
26	ULJGV	Leave Remuneration	decimal	7	2
27	ULJVT	Number of Leave Days	decimal	2	0
28	ULJVV	Leave Remuneration	decimal	7	2
29	LAGBT	Leave Remuneration	decimal	7	2
30	ULJRT	Number of Leave Days	decimal	2	0
31	ULJRV	Leave Remuneration	decimal	7	2
32	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
33	MSCHL	Notification Key for Data Record ANMEL	nvarchar	4	0	Allow NULL?
34	BTAGE_VAG	Employment Days for Employee Statement (Prev.ER, Current Yr)	decimal	3	0
35	BLOHN_VAG	Gross Wage for Employee Statement (Prev. ER, Current Year)	decimal	9	2
36	PSATZ_VAG	Percentage for Leave Remuneration (Prev. ER, Current Year)	nvarchar	4	0	Allow NULL?
37	ULJUT_VAG	Number of Leave Days (Previous Employer, Current Year)	decimal	2	0
38	ULJUV_VAG	Leave Remuneration (Previous Employer, Current Year)	decimal	7	2
39	AGLST_VAG	Number of Lost Hours (Previous Employer, Current Year)	decimal	6	2
40	AGLBT_VAG	Adjustment Amount (Previous Employer, Current Year)	decimal	7	2
41	ULJRT_VAG	Remaining Leave Days (Previous Employer, Current Year)	decimal	2	0
42	ULJRV_VAG	Remaining Leave Remunation (Previous Employer, Current Year)	decimal	7	2
43	RVJUT_VAG	Leave Days from Previous Year from Previous Employer	decimal	2	0
44	RVJUV_VAG	Leave Remuneration from Previous Year from Previous Employer	decimal	7	2
45	RVJGT_VAG	Leave Days Granted in Previous Year by Previous Employer	decimal	2	0
46	RVJGV_VAG	Leave Remuneration Granted in Previous Year by Previous ER	decimal	7	2
47	DATUM_VAG	Date for Infotype 0190	nvarchar	8	0	Allow NULL?
48	BTAGE_INSG	Employment Days Current Year (PER + Current Work Relations.)	decimal	3	0
49	BLOHN_INSG	Gross Wage Current Year (PER + Current Working Relationship)	decimal	9	2
50	ULJUT_INSG	Leave Days Entitlement (PER Curr. Yr + Curr. ER in Curr. Yr)	decimal	2	0
51	ULJUV_INSG	Leave Remuneration Entitl. (PER Curr. Year + CER Curr. Year)	decimal	7	2
52	ULJRT_NVG_LFD	Total Available Leave Days Entitlement Current Year	decimal	2	0
53	ULJRV_NVG_LFD	Available Total Entitlement Leave Remuneration in Current Yr	decimal	7	2
54	VA_T_VJ_LFDJ	Total Available Leave Days Entitlement (Prev. + Curr. Years)	decimal	2	0
55	VA_V_VJ_LFDJ	Total Available Entitlement to Leave Remuneration (PY + CY)	decimal	7	2
56	UDIVI	Divisor: Leave Accrual	decimal	4	2
57	UDIVI_VAG	Divisor: Leave Accrual Previous Employer	decimal	4	2
58	UVERG_VAG	Leave Remuneration from Gross Pay All Prev. ERs Current Year	decimal	7	2
59	ULJGT_VAG	Leave Days Granted (Previous Employer, Current Year)	decimal	2	0
60	ULJGV_VAG	Leave Remuneration Granted (Previous Employer, Current Year)	decimal	7	2
61	ULJGT_INSG	Leave Days Granted (PER Current Year + Current in Curr. Yr)	decimal	2	0
62	ULJGV_INSG	Leave Remuneration Granted (Prev. ER Curr. Year + Curr. Yr.)	decimal	7	2
63	BEGDA_AUSB	Start Date of Traineeship	nvarchar	8	0	Allow NULL?
64	ENDDA_AUSB	End Date of Traineeship	nvarchar	8	0	Allow NULL?
65	BEGDA_DPFL	Start Date of Statutory Official Duty	nvarchar	8	0	Allow NULL?
66	ENDDA_DPFL	End Date of Statutory Official Duty	nvarchar	8	0	Allow NULL?
67	BNRSK_VAG	Previous Employer's Company Number at CI Social Fund	nvarchar	8	0	Allow NULL?
68	MKLJA	MLR from Illness, Current Year, Entitlement	decimal	7	2
69	MKLJS	MLR from Illness, Current Year, Lost Hours	decimal	6	2
70	MSLJA	MLR from SRHC, Current Year, Entitlement	decimal	7	2
71	MSLJS	MLR from SRHC, Current Year, Lost Hours	decimal	5	2
72	MKLJA_VAG	MLR from Illness, Current Year, Entitlement Previous ER	decimal	7	2
73	MKLJS_VAG	MLR from Illness, Current Year, Lost Hours Previous ER	decimal	6	2
74	MSLJA_VAG	MLR from SRHC, Current Year, Entitlement Previous ER	decimal	7	2
75	MSLJS_VAG	MLR from SRHC, Current Year, Lost Hours Previous ER	decimal	5	2
76	MKVJA	MLR from Illness, Previous Year, Entitlement	decimal	7	2
77	MSVJA	MLR from SRHC, Previous Year, Entitlement	decimal	7	2
78	MKVJA_VAG	MLR from Illness, Previous Year, Entitlement Previous ER	decimal	7	2
79	MSVJA_VAG	MLR from SRHC, Previous Year, Entitlement Previous ER	decimal	7	2
80	MKVVA	MLR from Illness, 2 Years Ago, Entitlement	decimal	7	2
81	MKVVA_VAG	MLR from Illness, 2 Years Ago, Entitlement, Previous ER	decimal	7	2

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

81 COLUMNS | 1 INDEXES | ERP 6.0 | PDBKNW TABLE

TOP ERP 6.0 | PDBKNW COLUMNS

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

81 COLUMNS | 1 INDEXES | ERP 6.0 | PDBKNW TABLE

TOPERP 6.0 | PDBKNW COLUMNS

TOPERP 6.0 | PDBKNW INDEXES

TOP ERP 6.0 | PDBKNW COLUMNS

TOP ERP 6.0 | PDBKNW INDEXES