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	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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Global Trade Services :: Global Trade Services
1	ERP EHP7	6.0	/SAPSLL/CUIT	111	3	Customs Document: Item	Global Trade Services

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	GUID_CUIT	Primary Key as GUID in 'RAW' Format	varbinary	16	0
3	GUID_CUHD	Primary Key as GUID in 'RAW' Format	varbinary	16	0
4	ITVSY	External Document Item ID from Feeder System	nvarchar	10	0	Allow NULL?
5	ERNAM	Name of User Who Created the Object	nvarchar	12	0	Allow NULL?
6	CRTSP	UTC Time Stamp When Object Was Added	decimal	15	0
7	AENAM	Name of User Who Changed the Object	nvarchar	12	0	Allow NULL?
8	CHTSP	UTC Time Stamp When Object Was Changed	decimal	15	0
9	CUITA	Item Category in SAP GTS	nvarchar	6	0	Allow NULL?
10	GUID_FTVBS	Primary Key of Business Partner	varbinary	16	0
11	ITLEG	Indicator: Item Is Active	char	1	0	Allow NULL?
12	ITREC	Indicator: Item Is Relevant for New Check	char	1	0	Allow NULL?
13	CTYPL	Country of Actual Physical Location	nvarchar	3	0	Allow NULL?
14	CTYDP	Country of Departure Key	nvarchar	3	0	Allow NULL?
15	CTYAR	Country of Destination Key	nvarchar	3	0	Allow NULL?
16	CTYIV	Billing Country	nvarchar	3	0	Allow NULL?
17	CTYTR	Trading Country for Legal and Logistics Services	nvarchar	3	0	Allow NULL?
18	GUID_PR	Primary Key as GUID in 'RAW' Format	varbinary	16	0
19	PRBUM	Base Unit of Measure in Product Master	nvarchar	3	0	Allow NULL?
20	DOCUM	Weight Unit and Quantity Unit of Business Transaction	nvarchar	3	0	Allow NULL?
21	CVQDP_FLT	Conversion Factor: Doc. Unit/Base Unit as Floating Pt. Field	float	15	16
22	CUCOO	Custom Product's Country of Origin	nvarchar	3	0	Allow NULL?
23	CUROO	Product's Region of Origin (CIC)	nvarchar	3	0	Allow NULL?
24	DOCUR	Currency of Business Transaction	nvarchar	5	0	Allow NULL?
25	RPTDT	Time Stamp for Business Transaction	decimal	15	0
26	NETVAL_FLT	Net Value as Floating Point Field for SLL	float	15	16
27	NTCUR	Currency of a Value	nvarchar	5	0	Allow NULL?
28	GROVAL_FLT	Gross Value as Floating Point Field	float	15	16
29	GRCUR	Currency of a Value	nvarchar	5	0	Allow NULL?
30	TAXVAL_FLT	Tax Value as Floating Point Field	float	15	16
31	TXCUR	Currency of a Value	nvarchar	5	0	Allow NULL?
32	QUANT_FLT	Quantity as Floating Point Field	float	15	16
33	QUAUM	Unit of Measurement of a Dimension	nvarchar	3	0	Allow NULL?
34	WEINET_FLT	Net Weight as Floating Point Field	float	15	16
35	WEIGRO_FLT	Gross Weight as Floating Point Field	float	15	16
36	WEIDIM	Unit of Weight	nvarchar	3	0	Allow NULL?
37	INCOT	Incoterm	nvarchar	3	0	Allow NULL?
38	INCOL	Incoterm Location	nvarchar	40	0	Allow NULL?
39	FRCHG	Free-of-Charge Item	char	1	0	Allow NULL?
40	EXART	Customs Business Transaction Type	nvarchar	2	0	Allow NULL?
41	AUART	ExportType	nvarchar	2	0	Allow NULL?
42	DCTYP	Customs Status/Declaration	nvarchar	10	0	Allow NULL?
43	FLCNF	Conformity Indicator	char	1	0	Allow NULL?
44	CCNGA	Range of Goods	nvarchar	2	0	Allow NULL?
45	ITSTA	Item Status	char	1	0	Allow NULL?
46	ITREF	Reference Document Item	nvarchar	10	0	Allow NULL?
47	CRECO	Method of Entry	nvarchar	2	0	Allow NULL?
48	SVMEB	Indicator: Additional Information/Export Restriction	char	1	0	Allow NULL?
49	SVMEA	Ind.: Additional Information / Export Duties	char	1	0	Allow NULL?
50	SVMEX	Ind.: Additional Information / Export	char	1	0	Allow NULL?
51	SVMEE	Ind.: Additional Information / Export EU	char	1	0	Allow NULL?
52	SVMCO	Ind.: Additional Information / Export Country	nvarchar	3	0	Allow NULL?
53	SGICD	SGI Code	nvarchar	2	0	Allow NULL?
54	SGIQU_FLT	Sensitive SGI Quantity	float	15	16
55	GUID_CUIV	Primary Key as GUID in 'RAW' Format	varbinary	16	0
56	ITNEX	External Identification Number of Doc. Item for EDI Commun.	nvarchar	20	0	Allow NULL?
57	GUID_BOPHD	Primary Key as GUID in 'RAW' Format	varbinary	16	0
58	PRMET	Preference: Comparison Method	char	1	0	Allow NULL?
59	EPVAL_FLT	Comparison Value Preference from Document Item	float	15	16
60	CPVAL_FLT	Preference Threshold Value	float	15	16
61	PRCUR	Currency of Comparison Value for Preference Processing	nvarchar	5	0	Allow NULL?
62	PRECD	Preference Indicator for Customs Document	nvarchar	3	0	Allow NULL?
63	PREFL	Preference Status: 0 - No / 1 - Yes	char	1	0	Allow NULL?
64	SUPGA	Number of Packages in Safekeeping	int	10	0	Allow NULL?
65	SUPGB	Number of Declared Packages	int	10	0	Allow NULL?
66	RRATEDIM_FLT	Base Weight for Restitution Rate	float	15	16
67	RRATEUM	Unit of Measurement of a Dimension	nvarchar	3	0	Allow NULL?
68	RRATEAMNT_FLT	Restitution Rate by Base Weight	float	15	16
69	RRATECU	Currency of a Value	nvarchar	5	0	Allow NULL?
70	IVMST	Update Status for Inventory Management	char	1	0	Allow NULL?
71	PRDES	Target Procedure	nvarchar	2	0	Allow NULL?
72	PRSRC	Source Procedure	nvarchar	2	0	Allow NULL?
73	ECPID	Customs ID for Customs Procedures CWH, IP, PUCC	nvarchar	10	0	Allow NULL?
74	CUFIS	Customs Status	char	1	0	Allow NULL?
75	IVMIT	Inventory Management: Item ID	nvarchar	6	0	Allow NULL?
76	ZTERM	Term of Payment	nvarchar	6	0	Allow NULL?
77	IVMRE	Reservation Status for Inventory Management	char	1	0	Allow NULL?
78	QUABU_FLT	Document Quantity in Product's Base Unit of Measure	float	15	16
79	IZUAB	Indicator: Receipt/Issue	char	1	0	Allow NULL?
80	NORDES	'Normal Treatment' Indicator	char	1	0	Allow NULL?
81	IBLIS	Category of Goods Movement	char	1	0	Allow NULL?
82	IKMAT	Indicator for KMAT	char	1	0	Allow NULL?
83	IDGDS	Additional ID for Stock Separation in CWH, IP, PUCC	nvarchar	20	0	Allow NULL?
84	LOCID	Location ID	nvarchar	3	0	Allow NULL?
85	ADDDA1	Additional Data 1	nvarchar	10	0	Allow NULL?
86	ADDDA2	Additional Data 2	nvarchar	15	0	Allow NULL?
87	ADDDA3	Additional Data 3	nvarchar	30	0	Allow NULL?
88	ADDDA0	Additional Data for Unrestricted Use	char	1	0	Allow NULL?
89	ENDUSE	End Use of a Customs Product (for Classification)	nvarchar	5	0	Allow NULL?
90	OPREL	Declaration for Outward Processing	char	1	0	Allow NULL?
91	ECPID_OP	Customs ID for Outward Processing Customs Procedure	nvarchar	10	0	Allow NULL?
92	IDGDSP	Additional ID for Stock Separation in Outward Processing	nvarchar	20	0	Allow NULL?
93	IVMST_OP	Posting Status of Inventory Management for Outw. Processing	char	1	0	Allow NULL?
94	STDEX	Standard Exchange (Indicator)	char	1	0	Allow NULL?
95	ORGVS	Identification of Organizational Unit from Feeder System	nvarchar	10	0	Allow NULL?
96	BPTVS	Document Item Category ID from Feeder System	nvarchar	5	0	Allow NULL?
97	PRONR	Project Number	nvarchar	20	0	Allow NULL?
98	SCPREL	Declaration in Special Customs Procedure	char	1	0	Allow NULL?
99	IVMST_SCP	Posting Status of Inv. Mgt. for Special Customs Procedure	char	1	0	Allow NULL?
100	GUID_REFPR	GUID of Ref. Product for Special Customs Proc. (IP/PUCC)	varbinary	16	0
101	CUSWEI	Base for Customs Duty Calculation by Weight	char	1	0	Allow NULL?
102	BOMID	Unique Identification of a Document BOP	nvarchar	32	0	Allow NULL?
103	ITMMN	Item Number of Main Item	nvarchar	10	0	Allow NULL?
104	LCLPR	Type of Logistics Process for Legal Control	nvarchar	2	0	Allow NULL?
105	IVMST_FCP	Posting Status of Inventory Management for FC w/PEU	char	1	0	Allow NULL?
106	FCPREL	Relevancy for Free Circulation for Prescribed End Use	char	1	0	Allow NULL?
107	FLMVQ	Flag: Minimum Values and Quantities Exist	char	1	0	Allow NULL?
108	FLEMC	Flag: Relevant for Excise Duty	char	1	0	Allow NULL?
109	TAX_GROUP	Product Tax Group	nvarchar	20	0	Allow NULL?
110	CVRTS	Fixed Exchange Rate (Indicator)	char	1	0	Allow NULL?
111	CVRTQ	Indirect Quoted Exchange Rate	decimal	9	5

Name	Primary	Unique	Type	Columns
/SAPSLL/CUIT~0	Yes	Yes	CLUSTERED	GUID_CUIT, MANDT
/SAPSLL/CUIT~PRO	No	No	NONCLUSTERED	PRONR, MANDT
/SAPSLL/CUIT~SK	No	Yes	NONCLUSTERED	ITVSY, GUID_CUHD, MANDT

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

111 COLUMNS | 3 INDEXES | ERP 6.0 | /SAPSLL/CUIT TABLE

TOP ERP 6.0 | /SAPSLL/CUIT COLUMNS

TOP ERP 6.0 | /SAPSLL/CUIT 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

111 COLUMNS | 3 INDEXES | ERP 6.0 | /SAPSLL/CUIT TABLE

TOPERP 6.0 | /SAPSLL/CUIT COLUMNS

TOPERP 6.0 | /SAPSLL/CUIT INDEXES

TOP ERP 6.0 | /SAPSLL/CUIT COLUMNS

TOP ERP 6.0 | /SAPSLL/CUIT INDEXES