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	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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
Environment, Health and Safety :: Product Safety
1	ERP EHP7	6.0	CVDDH	136	6	EHS: Report shipping orders	Product Safety

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	RECN	Sequential Number of Data Record	nvarchar	20	Allow NULL?
3	ACTN	Sequential Number of the Change State	nvarchar	20	Allow NULL?
4	VALFR	Valid-From Date	nvarchar	8	Allow NULL?
5	VALTO	Valid-To Date	nvarchar	8	Allow NULL?
6	AENNR	Change Number	nvarchar	12	Allow NULL?
7	DELFLG	Deletion Indicator	char	1	Allow NULL?
8	PARKFLG	Data Record Is Inactive	char	1	Allow NULL?
9	CRDAT	Created On	nvarchar	8	Allow NULL?
10	CRNAM	Created By	nvarchar	12	Allow NULL?
11	UPDDAT	Changed On	nvarchar	8	Allow NULL?
12	UPDNAM	Last Changed By	nvarchar	12	Allow NULL?
13	SRSID	Source of Data	nvarchar	10	Allow NULL?
14	OWNID	Data Provider	nvarchar	10	Allow NULL?
15	RECNROOT	Sequential Number of Data Record	nvarchar	20	Allow NULL?
16	DDOID	Key of Initial Shipping Order	nvarchar	20	Allow NULL?
17	DDBID	Shipping Order Bundle Number	nvarchar	20	Allow NULL?
18	DDPID	Key of Shipping Order Package	nvarchar	20	Allow NULL?
19	STATUS	Status of a Shipping Order (Internal)	nvarchar	2	Allow NULL?
20	DDOCTYPE	Shipping Order Type	nvarchar	3	Allow NULL?
21	REASONTYP	Reason/Origin Category	nvarchar	10	Allow NULL?
22	REASONCAT	Reason/Origin Type	nvarchar	10	Allow NULL?
23	REASONBPR	Business Process	nvarchar	10	Allow NULL?
24	INITIATOR	Initiator of a Shipping Order	nvarchar	4	Allow NULL?
25	DISTSUBID	Shipping Order Specification Key	nvarchar	12	Allow NULL?
26	RECTYPE	Type of recipient number	nvarchar	2	Allow NULL?
27	RECGROUP	Recipient group	nvarchar	4	Allow NULL?
28	RECADR_C	Generic recipient number	nvarchar	20	Allow NULL?
29	RECADR_P	Recipient Key (Person)	nvarchar	20	Allow NULL?
30	RECTITLE_C	Form of address text	nvarchar	20	Allow NULL?
31	RECNAME_C	Name 1	nvarchar	40	Allow NULL?
32	RECLAND_C	Country Key	nvarchar	3	Allow NULL?
33	RECREGIO_C	Region (State, Province, County)	nvarchar	3	Allow NULL?
34	RECCITY_C	City	nvarchar	40	Allow NULL?
35	RECCODE_C	City postal code	nvarchar	10	Allow NULL?
36	RECLANGU_C	Language Key	char	1	Allow NULL?
37	RECTITLE_P	Form of address text	nvarchar	20	Allow NULL?
38	RECFNAME_P	First name	nvarchar	40	Allow NULL?
39	RECLNAME_P	Last name	nvarchar	40	Allow NULL?
40	RECLAND_P	Country Key	nvarchar	3	Allow NULL?
41	RECREGIO_P	Region (State, Province, County)	nvarchar	3	Allow NULL?
42	RECCITY_P	City	nvarchar	40	Allow NULL?
43	RECCODE_P	City postal code	nvarchar	10	Allow NULL?
44	RECLANGU_P	Language Key	char	1	Allow NULL?
45	RECDEFCOM	Addresses: Communication type	nvarchar	3	Allow NULL?
46	RECADR_INT	Communication Address Exists	char	1	Allow NULL?
47	RECADR_RML	Communication Address Exists	char	1	Allow NULL?
48	RECADR_FAX	Communication Address Exists	char	1	Allow NULL?
49	RECADR_LET	Communication Address Exists	char	1	Allow NULL?
50	RECSAPNAME	SAP name of a SAPoffice user	nvarchar	12	Allow NULL?
51	SUBID	Specification	nvarchar	12	Allow NULL?
52	SBGVID	Report Generation Variant	nvarchar	10	Allow NULL?
53	LANGU	Language	char	1	Allow NULL?
54	EHSDOCCAT	EH&S Reporting - Document Type	nvarchar	3	Allow NULL?
55	INTVERSION	Report Version	nvarchar	5	Allow NULL?
56	REPTYPE	Report Category	nvarchar	10	Allow NULL?
57	REPSTATUS	Report Status	nvarchar	2	Allow NULL?
58	VERSION	Report Version	nvarchar	5	Allow NULL?
59	SUBVERSION	Report Version	nvarchar	5	Allow NULL?
60	GENDAT	Generation Date of a Report	nvarchar	8	Allow NULL?
61	VALDAT	Validity Date of a Report	nvarchar	8	Allow NULL?
62	REQREASON	Reason for Report Request	nvarchar	14	Allow NULL?
63	RELCHGFLG	Relevant Change Has Been Made	char	1	Allow NULL?
64	MATNR	Material Number	nvarchar	18	Allow NULL?
65	MATNAM	Material Name	nvarchar	132	Allow NULL?
66	RAWMATNR	Raw material number	nvarchar	18	Allow NULL?
67	DMSCAT	Document Management System Type	nvarchar	3	Allow NULL?
68	DMSKEY	Generic Key of a Document	nvarchar	70	Allow NULL?
69	DOCFORMAT1	Document Format 1	nvarchar	3	Allow NULL?
70	DOCFORMAT2	Document Format 2	nvarchar	3	Allow NULL?
71	NUMBYTES	Size of a document in bytes	nvarchar	12	Allow NULL?
72	NUMPAGES	Size of a document in pages	nvarchar	3	Allow NULL?
73	SENDELEM	Shipping Object Number	nvarchar	10	Allow NULL?
74	COM_ART	Addresses: Communication type	nvarchar	3	Allow NULL?
75	COM_GROUP	Communication Group	nvarchar	3	Allow NULL?
76	PDEST	Spool Parameter: Name of Device	nvarchar	4	Allow NULL?
77	PRCOP	Spool Parameter: Number of Copies	nvarchar	3	Allow NULL?
78	PLIST	Spool Parameter: Name of Spool Request	nvarchar	12	Allow NULL?
79	PRTXT	Spool Parameter: Description Text	nvarchar	68	Allow NULL?
80	PRIMM	Spool Parameter: Print Now	char	1	Allow NULL?
81	PRREL	Spool Parameter: Delete Spool Request Immediately	char	1	Allow NULL?
82	PRNEW	Spool Parameter: New Print Request	char	1	Allow NULL?
83	PEXPI	Spool-Parameter: Retention	char	1	Allow NULL?
84	LINCT	Spool Parameter: Page Length	int	10	Allow NULL?
85	LINSZ	Spool Parameter: List Width	int	10	Allow NULL?
86	PAART	Spool Parameter: Page Format	nvarchar	16	Allow NULL?
87	PRBIG	Spool Parameter: Cover Page	char	1	Allow NULL?
88	PRSAP	Spool Parameter: Standard Cover Page	char	1	Allow NULL?
89	PRREC	Spool Parameter: Recipient Name	nvarchar	12	Allow NULL?
90	PRABT	Spool Parameter: Department Name	nvarchar	12	Allow NULL?
91	PRBER	Spool Parameter: Authorization Value	nvarchar	12	Allow NULL?
92	PRDSN	Spool Parameter: Name of Spool File	nvarchar	6	Allow NULL?
93	PTYPE	Spool Parameter: Type of Spool Request	nvarchar	12	Allow NULL?
94	ARMOD	Spool Parameter: Storage Mode	char	1	Allow NULL?
95	FOOTL	Spool Parameter: Footer	char	1	Allow NULL?
96	PRIOT	Spool Parameter: Priority	char	1	Allow NULL?
97	PRUNX	Spool Parameter: Operating System Cover Page	char	1	Allow NULL?
98	PRKEYEXT	Spool Parameter: Keys	nvarchar	16	Allow NULL?
99	PRCHK	Spool Parameter: Dheck Total	int	10	Allow NULL?
100	RSPOID	Spool request number	int	10	Allow NULL?
101	SO_OBJ_ID	SAPoffice: ID of a SAPoffice object	nvarchar	17	Allow NULL?
102	OHORDERNO	Job Number of a WWI Job	nvarchar	20	Allow NULL?
103	OHORDERCNT	Item counter for WWI job	nvarchar	5	Allow NULL?
104	JOBID	Processing Cycle ID Number	nvarchar	20	Allow NULL?
105	WPJOBNAME	Background job name	nvarchar	32	Allow NULL?
106	WPJOBCOUNT	Job ID	nvarchar	8	Allow NULL?
107	STARTDAT	Target Shipping Date	nvarchar	8	Allow NULL?
108	CRTIM	Entry Time	nvarchar	6	Allow NULL?
109	UPDTIM	Time of last change	nvarchar	6	Allow NULL?
110	OCDAT	Output check date	nvarchar	8	Allow NULL?
111	OCTIM	Output check time	nvarchar	6	Allow NULL?
112	OCNAM	Output check user	nvarchar	12	Allow NULL?
113	ACKDAT	Date of acknowledgement of receipt	nvarchar	8	Allow NULL?
114	ACKTIM	Time of Acknowledgement of Receipt	nvarchar	6	Allow NULL?
115	ACKNAM	Acknowledgement of receipt processor	nvarchar	12	Allow NULL?
116	SEDAT	Send date	nvarchar	8	Allow NULL?
117	SETIM	Send time	nvarchar	6	Allow NULL?
118	RESFLG	Shipping Order is Relevant for Subsequent Shipping	char	1	Allow NULL?
119	OCFLG	Execute Output Check	char	1	Allow NULL?
120	SAVFLG	Save Final Report	char	1	Allow NULL?
121	DDBFLG	Bundle Shipping Order	char	1	Allow NULL?
122	RERFLG	Redetermine Report Body	char	1	Allow NULL?
123	HPFLG	Generate Cover Sheet for Shipping Order	char	1	Allow NULL?
124	ACKFLG	Generate Acknowledgement of Receipt	char	1	Allow NULL?
125	DDPORD	Sorting Shipping Order Packages	nvarchar	4	Allow NULL?
126	DDOCNR	Sequence of Shipping Orders in One Order Package	nvarchar	4	Allow NULL?
127	DMSSRCCAT	Document Management System Type	nvarchar	3	Allow NULL?
128	DMSSRCKEY	Generic Key of a Document	nvarchar	70	Allow NULL?
129	PROCESSCAT	Process Type of Report Shipping Order	char	1	Allow NULL?
130	EVENTID	Background Processing Event	nvarchar	32	Allow NULL?
131	EVENTPARM	Background Event Parameters (Such as, Jobname/Jobcount)	nvarchar	64	Allow NULL?
132	ADDOBJFLG	Flag for Internal Use	char	1	Allow NULL?
133	REPVIEW	Report View	nvarchar	3	Allow NULL?
134	ADD_DOC_IND	Additional Document Exists	char	1	Allow NULL?
135	RDO_HAS_ADD_DOC_IND	Additional Document for Shipping Order Exists	char	1	Allow NULL?
136	KEEP_COMM_TYPE	Keep Communication Type	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
CVDDH~0	Yes	Yes	CLUSTERED	ACTN, RECN, MANDT
CVDDH~I01	No	No	NONCLUSTERED	MANDT, JOBID, STATUS
CVDDH~I02	No	No	NONCLUSTERED	MANDT, MATNAM, RECADR_C
CVDDH~I03	No	No	NONCLUSTERED	MANDT, DDOCTYPE, SUBID
CVDDH~I04	No	No	NONCLUSTERED	MANDT, DDPID
CVDDH~I05	No	No	NONCLUSTERED	CRDAT, 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

136 COLUMNS | 6 INDEXES | ERP 6.0 | CVDDH TABLE

TOP ERP 6.0 | CVDDH COLUMNS

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

136 COLUMNS | 6 INDEXES | ERP 6.0 | CVDDH TABLE

TOPERP 6.0 | CVDDH COLUMNS

TOPERP 6.0 | CVDDH INDEXES

TOP ERP 6.0 | CVDDH COLUMNS

TOP ERP 6.0 | CVDDH INDEXES