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
Personnel Management :: Personnel Administration :: Italy
1	ERP EHP7	6.0	PA0483	105	1	Infotype 0483 - Data entry from CAAF - Italy only	Italy

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	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	ANNOF	Year stored	nvarchar	4	0	Allow NULL?
25	COFIS	Tax number of the fiscal office (CAF) that provided support	nvarchar	16	0	Allow NULL?
26	CORIT	Correction Month for Adjustment or Late Tax Declaration	nvarchar	2	0	Allow NULL?
27	ITWAE	Currency Key for Italy	nvarchar	5	0	Allow NULL?
28	IMTIR	Amount to withhold IRPEF	decimal	12	2
29	IMTSS	Amount to withhold CSSN	decimal	12	2
30	ACTSE	Separate taxation instalment	decimal	12	2
31	IMRIR	Amount to be refunded IRPEF	decimal	12	2
32	IMRSS	Amount to be refunded CSSN	decimal	12	2
33	RAAC1	1st IRPEF down payment instalment - Tax payer + husband/wife	decimal	12	2
34	RAAC2	Second or only IRPEF advance instalment	decimal	12	2
35	NRATE	No.of instalments for settl.payments and poss.down payments	nvarchar	3	0	Allow NULL?
36	CRED1	Declarant Regional Code for Deduction Purposes	nvarchar	2	0	Allow NULL?
37	IMTRD	Regional Surcharge to Deduct - Declarant	decimal	12	2
38	CREC1	Spouse Regional Code for Deduction Purposes	nvarchar	2	0	Allow NULL?
39	IMTRC	Regional Surcharge to Deduct - Spouse	decimal	12	2
40	IMTRT	Amount to withhold - total local additional charge	decimal	12	2
41	CRED2	Declarant Regional Code for Refund Purposes	nvarchar	2	0	Allow NULL?
42	IMRRD	Regional Surcharge to Refund - Declarant	decimal	12	2
43	CREC2	Spouse Regional Code for Refund Purposes	nvarchar	2	0	Allow NULL?
44	IMRRC	Regional Surcharge to Refund - Spouse	decimal	12	2
45	IMRRT	Total local additional charge to refund	decimal	12	2
46	ACTSD	Separate Taxation Advance Pay - Declarant	decimal	12	2
47	ACTSC	Separate Taxation Advance Pay - Spouse	decimal	12	2
48	CELD1	Cadastral indicator for Munic.Surch. - Declarant and Spouse	nvarchar	4	0	Allow NULL?
49	IMTCD	Municipal Surcharge to Deduct - Declarant	decimal	12	2
50	CELC1	Cadastral indicator for Munic.Surch. - Declarant and Spouse	nvarchar	4	0	Allow NULL?
51	IMTCC	Municipal Surcharge to Deduct - Spouse	decimal	12	2
52	IMTCT	Total District Additional Charge to be withheld	decimal	12	2
53	CELD2	Cadastral indicator for Munic.Surch. - Declarant and Spouse	nvarchar	4	0	Allow NULL?
54	IMRCD	Municipal Surcharge to refund - Declarant	decimal	12	2
55	CELC2	Cadastral indicator for Munic.Surch. - Declarant and Spouse	nvarchar	4	0	Allow NULL?
56	IMRCC	Municipal Surcharge to refund - Spouse	decimal	12	2
57	IMRCT	Total District Additional Amount to refund	decimal	12	2
58	ENDDATA	Center for Fiscal Assistance (CAF) validity end	nvarchar	8	0	Allow NULL?
59	RAAC1D	First IRPEF advance installment - Declarant	decimal	12	2
60	RAAC1C	1st Installment IRPEF Advance Pay - Spouse	decimal	12	2
61	RAAC2D	2nd or Single IRPEF Advance Installment - Declarant	decimal	12	2
62	RAAC2C	2nd or single IRPEF advance installment - Spouse	decimal	12	2
63	TIPOC	Settlement type	char	1	0	Allow NULL?
64	TIPOR	Adjustment type	char	1	0	Allow NULL?
65	BLOAC	CAF: down payment block	char	1	0	Allow NULL?
66	NOCON	CAF: settlement was not carried out	char	1	0	Allow NULL?
67	INTEG	Type of Integration 730	char	1	0	Allow NULL?
68	DATAC	Uploading date of CAF data	nvarchar	8	0	Allow NULL?
69	IMTIRD	IRPEF amount to be withheld for declarant	decimal	12	2
70	IMTIRC	IRPEF amount to be withheld for declarant's spouse	decimal	12	2
71	IMRIRD	IRPEF amount to be refunded to declarant	decimal	12	2
72	IMRIRC	IRPEF amount to be refunded to declarant's spouse	decimal	12	2
73	AACOMD	Municipal Surcharge Advance Pay to IRPEF for Declarant	decimal	12	2
74	AACOMC	Municipal Surcharge Advance Pay to IRPEF for Spouse	decimal	12	2
75	AACOM	Total PIT Municipal Surcharge Down Payment	decimal	12	2
76	CAACD	Municipal surcharge down payment indicator for declarant	nvarchar	4	0	Allow NULL?
77	CAACC	Municipal surcharge down payment indicator for spouse	nvarchar	4	0	Allow NULL?
78	CONGLR	Tax Declaration to be done in July - Refund	decimal	12	2
79	CONGLT	Tax Declaration to be done in July - Deduction	decimal	12	2
80	ISLSD	Substitution Tax for Extra Work - Declarant	decimal	12	2
81	ISLSC	Substitute Tax for Extra Work - Spouse	decimal	12	2
82	ISLST	Substitution Tax for Extra Work (Total)	decimal	12	2
83	RSLSD	Substitution Tax Refund for Extra Work (730 Int.) - Decl.	decimal	12	2
84	RSLSC	Substitution Tax Refund for Extra Work (730 Int.) - Spouse	decimal	12	2
85	RSLST	Substitute Tax Refund for Extra Work (Total)	decimal	12	2
86	RACTD	Advance Pay Refund on Sep.Taxation (730 Integr.) Declarant	decimal	12	2
87	RACTC	Advance Pay Refund on Sep. Taxation (730 Integr.) - Spouse	decimal	12	2
88	RACTE	Advance Payment Refund on Separate Taxation (Total)	decimal	12	2
89	ISLOD	Declarant rent substitute tax	decimal	12	2
90	ISLOC	Spouse rent substitute tax	decimal	12	2
91	RISLD	Declarant rent substitute tax refund	decimal	12	2
92	RISLC	Spouse rent substitute tax refund	decimal	12	2
93	TIPOA	Adjustment special conditions	char	1	0	Allow NULL?
94	CETSLD	Flat Tax on rental income to be deducted to declarant	decimal	12	2
95	CETSLC	Flat tax on rental inc. to be deducted to spouse FlTxRIDedSp	decimal	12	2
96	CERSLD	Refund of flat tax on rental income Declarant	decimal	12	2
97	CERSLC	Refund of spouse flat tax on rental income	decimal	12	2
98	RASL1D	1st adv. payment installment of Flat Tax on rent.inc. -Decl.	decimal	12	2
99	RASL1C	First adv. payment installment Flat Tax on rent.inc.- Spouse	decimal	12	2
100	RASL2D	Second AdvPaymInst of flat tax on rental income - Declarant	decimal	12	2
101	RASL2C	Second AP installment of flat tax on rental income - Spouse	decimal	12	2
102	CONTSTD	Solidarity contribution to be deducted - Declarant	decimal	12	2
103	CONTSTC	Solidarity contribution to be deducted - Spouse	decimal	12	2
104	RCSOD	Solidarity Contribution refund - Declarant	decimal	12	2
105	RCSOC	Solidarity Contribution refund - Spouse	decimal	12	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

105 COLUMNS | 1 INDEXES | ERP 6.0 | PA0483 TABLE

TOP ERP 6.0 | PA0483 COLUMNS

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

105 COLUMNS | 1 INDEXES | ERP 6.0 | PA0483 TABLE

TOPERP 6.0 | PA0483 COLUMNS

TOPERP 6.0 | PA0483 INDEXES

TOP ERP 6.0 | PA0483 COLUMNS

TOP ERP 6.0 | PA0483 INDEXES