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
Global Trade Services :: Global Trade Services
1	ERP EHP7	6.0	/SAPSLL/CUSWLO	94	7	Worklist for Transactions with Reference to Delivery or PO	Global Trade Services

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	GUID_CUSWLO	Primary Key as GUID in 'RAW' Format	varbinary	16	0
3	MDDNO	External ID for Material Document from Feeder System	nvarchar	35	0	Allow NULL?
4	MDDYR	External ID for Document Year from Feeder System	nvarchar	4	0	Allow NULL?
5	MDDIN	External ID for Material Document Item from Feeder System	nvarchar	10	0	Allow NULL?
6	MDDSY	Logical System of Original Object	nvarchar	10	0	Allow NULL?
7	MDDAP	Reference Application	nvarchar	10	0	Allow NULL?
8	MDOBJ	Object Type of Reference Document	nvarchar	10	0	Allow NULL?
9	LGREG	Legal Regulation	nvarchar	5	0	Allow NULL?
10	GUID_FTORG	Primary Key of Business Partner	varbinary	16	0
11	GUID_FTVBS	Primary Key of Business Partner	varbinary	16	0
12	MOVTY	External ID for Movement Type from Feeder System	nvarchar	5	0	Allow NULL?
13	MDDPM	Goods Movement: Receipt/Issue	char	1	0	Allow NULL?
14	MDCCL	Indicator for Material Document Cancellation	char	1	0	Allow NULL?
15	TEMST	Indicator: Goods Movement to Safekeeping	char	1	0	Allow NULL?
16	ECPID	Customs ID for Customs Procedure with Economic Significance	nvarchar	10	0	Allow NULL?
17	CSTAT	Customs Status	char	1	0	Allow NULL?
18	IBLIS	Category of Goods Movement	char	1	0	Allow NULL?
19	PARID	Parent ID for Transfer Postings	nvarchar	10	0	Allow NULL?
20	PRVSY	Product Number	nvarchar	40	0	Allow NULL?
21	GUID_PR	Primary Key as GUID in 'RAW' Format	varbinary	16	0
22	OPQUA_FLT	Unrestricted-Use Quantity in Base Unit of Measure	float	15	16
23	MDBUQ_FLT	Material Document Qty in Base Unit of Measure	float	15	16
24	BAUOM	Base Unit of Measure	nvarchar	3	0	Allow NULL?
25	MDWGR_FLT	Gross Weight as Floating Point Field	float	15	16
26	MDWNT_FLT	Net Weight as Floating Point Field	float	15	16
27	MDWEI	Unit of Weight	nvarchar	3	0	Allow NULL?
28	MDDDT	Document Date of Material Document	nvarchar	8	0	Allow NULL?
29	MDPDT	Posting Date of Material Document	nvarchar	8	0	Allow NULL?
30	MDCDT	Entry Date of Material Document	decimal	15	0
31	DLDNO	External ID for Inbound Delivery from Feeder System	nvarchar	20	0	Allow NULL?
32	DLDIN	External Document Item ID from Feeder System	nvarchar	10	0	Allow NULL?
33	DLDSY	Logical System of Original Object	nvarchar	10	0	Allow NULL?
34	DLDAP	Reference Application	nvarchar	10	0	Allow NULL?
35	DLOBJ	Object Type of Reference Document	nvarchar	10	0	Allow NULL?
36	PODNO	External ID for Purchasing Document from Feeder System	nvarchar	20	0	Allow NULL?
37	PODIN	External Document Item ID from Feeder System	nvarchar	10	0	Allow NULL?
38	PODSY	Logical System of Original Object	nvarchar	10	0	Allow NULL?
39	PODAP	Reference Application	nvarchar	10	0	Allow NULL?
40	POOBJ	Object Type of Reference Document	nvarchar	10	0	Allow NULL?
41	CREFT	Type of Customs/Transit Reference Number	nvarchar	3	0	Allow NULL?
42	CREFN	Customs/Transit Reference Number	nvarchar	30	0	Allow NULL?
43	PARVD	Business Partner: Vendor	nvarchar	10	0	Allow NULL?
44	PARGS	Business Partner: Supplying Vendor	nvarchar	10	0	Allow NULL?
45	PAFVD	Business Partner - Vendor from Feeder System	nvarchar	10	0	Allow NULL?
46	PAFGS	Business Partner - Vendor from Feeder System	nvarchar	10	0	Allow NULL?
47	INCOT	Incoterm	nvarchar	3	0	Allow NULL?
48	INCOLO	Incoterm Location	nvarchar	40	0	Allow NULL?
49	CUPRO	Place into a Customs Status (Procedure)	nvarchar	8	0	Allow NULL?
50	CUCOO	Custom Product's Country of Origin	nvarchar	3	0	Allow NULL?
51	MDENQ_FLT	Material Document Quantity in Unit of Entry	float	15	16
52	ENUOM	Unit of Entry	nvarchar	3	0	Allow NULL?
53	MDOPQ_FLT	Material Document Qty in Purchase Order Price Unit	float	15	16
54	OPUOM	Purchase Order Price Unit	nvarchar	3	0	Allow NULL?
55	NCPRP	Numerator for Conversion of OPUn to BUoM	decimal	5	0
56	DCPRP	Denominator for Conversion of OPUn to BUoM	decimal	5	0
57	POVAL_FLT	Order Value	float	15	16
58	OPPVA_FLT	Open Purchase Order Value	float	15	16
59	POPRC_FLT	Purchase Order Price	float	15	16
60	PRCUP	Price Unit in Relation to PO Price Unit	decimal	5	0
61	POCUR	Purchase Order Currency	nvarchar	5	0	Allow NULL?
62	CVRTF	Indicator: Exchange Rate Fixed for Customs Duties	char	1	0	Allow NULL?
63	CVRAT	Exchange Rate	decimal	9	5
64	ADDDA1	Additional Data 1	nvarchar	10	0	Allow NULL?
65	ADDDA2	Additional Data 2	nvarchar	15	0	Allow NULL?
66	ADDDA3	Additional Data 3	nvarchar	30	0	Allow NULL?
67	MDRNO	External Material Document Reference ID from Feeder System	nvarchar	35	0	Allow NULL?
68	MDRYR	External ID for Document Year from Feeder System	nvarchar	4	0	Allow NULL?
69	MDRIN	External Document Item ID from Feeder System	nvarchar	10	0	Allow NULL?
70	MDRSY	Logical System of Original Object	nvarchar	10	0	Allow NULL?
71	MDRAP	Reference Application	nvarchar	10	0	Allow NULL?
72	CRTSP	UTC Time Stamp When Object Was Added	decimal	15	0
73	ERNAM	Name of User Who Created the Object	nvarchar	12	0	Allow NULL?
74	MANNI	Indicator: Entry Generated Manually	char	1	0	Allow NULL?
75	IDGDS	Additional ID for Stock Separation in CWH, IP, PUCC	nvarchar	20	0	Allow NULL?
76	ENDUSE	End Use of a Customs Product (for Classification)	nvarchar	5	0	Allow NULL?
77	LOCID	Location ID	nvarchar	3	0	Allow NULL?
78	ECPID_OP	Customs ID for Outward Processing Customs Procedure	nvarchar	10	0	Allow NULL?
79	IDGDSP	Additional ID for Stock Separation in Outward Processing	nvarchar	20	0	Allow NULL?
80	GUID_DOC_DUP_RES	Inventory Management: Header Posting ID	nvarchar	32	0	Allow NULL?
81	POSID_DUP_RES	Inventory Management: Item ID	nvarchar	6	0	Allow NULL?
82	VIDNO	Vehicle Identification Number	nvarchar	30	0	Allow NULL?
83	ECBWH	Bonded Warehouse Relevance	char	1	0	Allow NULL?
84	ECIPR	Relevant for Inward Processing	char	1	0	Allow NULL?
85	SAKEM	Method of Processing for Safekeeping	char	1	0	Allow NULL?
86	PMEMO	Manual Reprocessing of the Item Necessary	char	1	0	Allow NULL?
87	PRDES	Target Procedure	nvarchar	2	0	Allow NULL?
88	OPPRO	Product from Outward Processing	char	1	0	Allow NULL?
89	PUCCO	Component for Processing Under Customs Control	char	1	0	Allow NULL?
90	GUID_DOC	Inventory Management: Header Posting ID	nvarchar	32	0	Allow NULL?
91	POSID	Inventory Management: Item ID	nvarchar	6	0	Allow NULL?
92	FLMDE	Quantity Change: Manual Decision Flag	char	1	0	Allow NULL?
93	FLRNC	Quantity Change: Flag: Reference Not Modifiable	char	1	0	Allow NULL?
94	ADDDA0	Additional Data for Unrestricted Use	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/SAPSLL/CUSWLO~0	Yes	Yes	CLUSTERED	GUID_CUSWLO, MANDT
/SAPSLL/CUSWLO~DLN	No	No	NONCLUSTERED	IBLIS, DLDSY, DLDNO, MANDT
/SAPSLL/CUSWLO~IBL	No	No	NONCLUSTERED	IBLIS, MANDT
/SAPSLL/CUSWLO~ORG	No	No	NONCLUSTERED	IBLIS, GUID_FTVBS, GUID_FTORG, MANDT
/SAPSLL/CUSWLO~PON	No	No	NONCLUSTERED	IBLIS, PODSY, PODNO, MANDT
/SAPSLL/CUSWLO~SK	No	Yes	NONCLUSTERED	MDDAP, MDDSY, MDDIN, MDDYR, MDDNO, MANDT
/SAPSLL/CUSWLO~VD	No	No	NONCLUSTERED	IBLIS, PARVD, 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

94 COLUMNS | 7 INDEXES | ERP 6.0 | /SAPSLL/CUSWLO TABLE

TOP ERP 6.0 | /SAPSLL/CUSWLO COLUMNS

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

94 COLUMNS | 7 INDEXES | ERP 6.0 | /SAPSLL/CUSWLO TABLE

TOPERP 6.0 | /SAPSLL/CUSWLO COLUMNS

TOPERP 6.0 | /SAPSLL/CUSWLO INDEXES

TOP ERP 6.0 | /SAPSLL/CUSWLO COLUMNS

TOP ERP 6.0 | /SAPSLL/CUSWLO INDEXES