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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DCT_PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
3	DCT_SEQNR	Sequence Number	nvarchar	5	0	Allow NULL?
4	KVBEZ	Pension Payment Indicator	nvarchar	4	0	Allow NULL?
5	PNRVE	Personnel Number of Pension Holder (HR-PSG)	nvarchar	8	0	Allow NULL?
6	EINVF	Entry: Pension Event	nvarchar	8	0	Allow NULL?
7	EINBV	Date of Creation of Status of Public Officer	nvarchar	8	0	Allow NULL?
8	GRDVF	Reason for Incidence of Pension Event	nvarchar	2	0	Allow NULL?
9	STATV	Statistics Indicator for Pensions	nvarchar	2	0	Allow NULL?
10	VHSMX	Upper Limit Percentage Pension 55	decimal	5	2
11	VHSVB	Personal Pension Percentage	decimal	5	2
12	VHSVA	Percentage for Pension Equalization Payment	decimal	5	2
13	ERH14	Exception: No Increase Amount	char	1	0	Allow NULL?
14	SBERE	Special Processing of Minimum Pension	char	1	0	Allow NULL?
15	KNZER	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
16	VHSER	Percentage Reimbursement	decimal	5	2
17	TRGER	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
18	KUZHL	Numerator for Reduction 1	decimal	8	4
19	KUENE	Denominator for Reduction 1	decimal	6	2
20	ANTKZ	Proportional Family Reduction	nvarchar	3	0	Allow NULL?
21	KNZVR	Early Retirement Indicator	char	1	0	Allow NULL?
22	KNZRG	Legal Basis of Pension Calculation	nvarchar	2	0	Allow NULL?
23	ANZKD	Number of Children	decimal	3	0
24	OZFKD	Number of Children Entitled to Cost-of-Living Allowance	decimal	3	0
25	OZAEG	Numerator for Competition: Spouse Component	decimal	8	4
26	KGBSL	Entitlement Reason	nvarchar	2	0	Allow NULL?
27	KNZBV	Indicator: Special Pension Calculation	nvarchar	2	0	Allow NULL?
28	KNZE2	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
29	VHSE2	Percentage Reimbursement	decimal	5	2
30	TRGE2	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
31	KNZE3	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
32	VHSE3	Percentage Reimbursement	decimal	5	2
33	TRGE3	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
34	VHSAB	Reduction of Pension Percentage Pension	decimal	5	2
35	VHSWI	Percentage: Widow's Pension	decimal	5	2
36	BOXAB	Checkbox: Specify Pension Reduction	char	1	0	Allow NULL?
37	STAT2	Statistics Indicator for Pensions	nvarchar	2	0	Allow NULL?
38	VHSVB_VRGL	Comparison Pension Percentage	decimal	5	2
39	VHSMX_CAL	Automatically Calculated Upper Limit Percentage	decimal	5	2
40	VHSVB_CAL	Automatic Personal Pension Percentage	decimal	5	2
41	VHSAB_CAL	Automatic Percentage Reduction of Pension BeamtVG Sec.14 P.3	decimal	5	2
42	VHSVB_VRGL_CAL	Automatic Comparison Pension Percentage BeamtVG Sec.14 Par.4	decimal	5	2
43	RGBGD	Calculation Base of Pension Percentage	char	1	0	Allow NULL?
44	DURYYP69	Employment Period of PS Employee Acc. to Sec69d Par4 (Years)	decimal	3	0
45	DURMMP69	Employment Period of PS Employee Acc. to Sec69d Par4 (Mnths)	decimal	2	0
46	DURDDP69	Employment Period of PS Employee Acc. to Sec69d Par4 (Days)	decimal	7	4
47	BOXP69	Checkbox: Standard Employment Period Sec.69d Para.4	char	1	0	Allow NULL?
48	DURYYP6C	Employment Period of PS Employee Acc. to Sec69d Par4 (Years)	decimal	3	0
49	DURMMP6C	Employment Period of PS Employee Acc. to Sec69d Par4 (Mnths)	decimal	2	0
50	DURDDP6C	Employment Period of PS Employee Acc. to Sec69d Par4 (Days)	decimal	7	4
51	ANZ_MON_GES	No. of Months with Entitlemt Child Bonus for Widow's Pension	decimal	3	0
52	ANZ_MON_ABW_LE36	No. of Months with Diff. Pay Scale Area in First 36 Months	decimal	3	0
53	ANZ_MON_ABW_GT36	No. of Months with Diff. Pay Scale Area After First 36 Mnths	decimal	3	0
54	BES_RGSK_F1991	Specific Pension Scale Section 14, 1991 Version	char	1	0	Allow NULL?
55	GRD1_KUERZ_Z_N	Reduction Reason 1 Numerator/Denominator	nvarchar	2	0	Allow NULL?
56	GRD2_KUERZ_Z_N	Reduction Reason 2 Numerator/Denominator	nvarchar	2	0	Allow NULL?
57	ZUSTZL_KNZRG	Additional Legal Basis of Pension Calculation	nvarchar	2	0	Allow NULL?
58	DURYYZRN	Total Actual Time of Earlier Assessment (Years)	decimal	3	0
59	DURMMZRN	Total Actual Time of Earlier Assessment (Months)	decimal	2	0
60	DURDDZRN	Total Actual Time of Earlier Assessment (Days)	decimal	7	4
61	DURYYZRU	Total Actual Time of Earlier Assessment (Years)	decimal	3	0
62	DURMMZRU	Total Actual Time of Earlier Assessment (Months)	decimal	2	0
63	DURDDZRU	Total Actual Time of Earlier Assessment (Days)	decimal	7	4
64	DURYYZRA	Total Actual Time of Earlier Assessment (Years)	decimal	3	0
65	DURMMZRA	Total Actual Time of Earlier Assessment (Months)	decimal	2	0
66	DURDDZRA	Total Actual Time of Earlier Assessment (Days)	decimal	7	4
67	KNZRGP18	Legal Basis Sec.18 Death Benefit	nvarchar	2	0	Allow NULL?
68	ANTL_Z_P18	Proportion of Death Benefit Acc. to Sec. 18 Numerator	decimal	3	0
69	ANTL_N_P18	Proportion of Death Benefit According to Sec. 18 Denominator	decimal	3	0
70	DURYYZRZ	Total Actual Time of Earlier Assessment (Years)	decimal	3	0
71	DURMMZRZ	Total Actual Time of Earlier Assessment (Months)	decimal	2	0
72	DURDDZRZ	Total Actual Time of Earlier Assessment (Days)	decimal	7	4
73	KNZE4	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
74	VHSE4	Percentage Reimbursement	decimal	5	2
75	TRGE4	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
76	KNZE5	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
77	VHSE5	Percentage Reimbursement	decimal	5	2
78	TRGE5	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
79	KNZE6	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
80	VHSE6	Percentage Reimbursement	decimal	5	2
81	TRGE6	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
82	KNZE7	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
83	VHSE7	Percentage Reimbursement	decimal	5	2
84	TRGE7	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
85	KNZE8	Basis for Reimbursement	nvarchar	2	0	Allow NULL?
86	VHSE8	Percentage Reimbursement	decimal	5	2
87	TRGE8	Provider of Reimbursement	nvarchar	2	0	Allow NULL?
88	ANZ_MON_P14A	Leading Months - Pension Percentage Increase (Manual)	decimal	3	0
89	ANZ_MON_P14A_CAL	Appl. Months - Pension Percentage Increase Sec.14a (Calc.)	decimal	3	0
90	UNTERH_BEITRAG	Basis for Maintenance Payment	nvarchar	2	0	Allow NULL?
91	KUZHL_2	Numerator for Reduction 2	decimal	8	4
92	KUENE_2	Denominator for Reduction 2	decimal	6	2
93	EHENUMMER	Marriage Number	nvarchar	2	0	Allow NULL?
94	DATUM_URTEIL_VOM	Start Date	nvarchar	8	0	Allow NULL?
95	VERSAUSGL_MAN	Pension Eqlztn Paymt Specified Manually Acc. to VersAusglG	decimal	9	2
96	VERSAUSGL_MAN_WA	Currency Key	nvarchar	5	0	Allow NULL?
97	VERSAUSGL_MAN_DT	Key Date of Pension Equalization Payment Specified Manually	char	1	0	Allow NULL?
98	KEINE_AUT_ANPSNG	Indicator: No Automatic Adjustment Pension Equalztn Payment	char	1	0	Allow NULL?
99	VERS_AUFSCHL_CAL	Percentage of Automatically Calculated Pension Pay Increase	decimal	5	2
100	VERS_AUFSCHL_MAN	Percentage of Manual Entry of Pension Pay Increase	decimal	5	2
101	VERS_AUFSCHL_BOX	Checkbox: Manual Entry of Pension Pay Increase	char	1	0	Allow NULL?
102	VERS_MKM	Pension Feature	nvarchar	2	0	Allow NULL?
103	ZUSCHLAG_WITWE	Manually Entered Child Bonus for Widow's Pension	decimal	9	2
104	ZUSCHLAG_WITWE_W	Currency Key	nvarchar	5	0	Allow NULL?
105	ERHOEHUNG_RGVH	Increase of Pension Percent Due to Stat. Insurance Periods	char	1	0	Allow NULL?
106	GRUND_WAISENGELD	Reason for Orphan's Benefit	nvarchar	2	0	Allow NULL?
107	KEINE_ZAHLUNG	Interruption of Payment	char	1	0	Allow NULL?
108	ALTERSGELD	Retirement Pension	nvarchar	2	0	Allow NULL?
109	ANTRAGSDATUM	Application Date	nvarchar	8	0	Allow NULL?
110	EP_RENTE	Remuneration Points	decimal	7	4

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

110 COLUMNS | 1 INDEXES | ERP 6.0 | P2RD_VERSORGUNG TABLE

TOP ERP 6.0 | P2RD_VERSORGUNG COLUMNS

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

110 COLUMNS | 1 INDEXES | ERP 6.0 | P2RD_VERSORGUNG TABLE

TOPERP 6.0 | P2RD_VERSORGUNG COLUMNS

TOPERP 6.0 | P2RD_VERSORGUNG INDEXES

TOP ERP 6.0 | P2RD_VERSORGUNG COLUMNS

TOP ERP 6.0 | P2RD_VERSORGUNG INDEXES