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
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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	RECN	Sequential Number of Data Record	nvarchar	20	NUMC	(N'00000000000000000000')	No		ESERECN	Allow NULL?
3	ACTN	Sequential Number of the Change State	nvarchar	20	NUMC	(N'00000000000000000000')	No		ESEACTN	Allow NULL?
4	VALFR	Valid-From Date	nvarchar	8	DATS	(N'00000000')	Yes		ESEVALFR	Allow NULL?
5	VALTO	Valid-To Date	nvarchar	8	DATS	(N'00000000')	Yes		ESEVALTO	Allow NULL?
6	AENNR	Change Number	nvarchar	12	CHAR	(N' ')	Yes	AENR	ESEAENNR	Allow NULL?
7	DELFLG	Deletion Indicator	char	1	CHAR	(N' ')	Yes		ESEDELFLG	Allow NULL?
8	PARKFLG	Data Record Is Inactive	char	1	CHAR	(N' ')	Yes		ESEPARKFLG	Allow NULL?
9	CRDAT	Created On	nvarchar	8	DATS	(N'00000000')	Yes		ESECRDAT	Allow NULL?
10	CRNAM	Created By	nvarchar	12	CHAR	(N' ')	Yes		ESECRNAM	Allow NULL?
11	UPDDAT	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		ESEUPDDAT	Allow NULL?
12	UPDNAM	Last Changed By	nvarchar	12	CHAR	(N' ')	Yes		ESEUPDNAM	Allow NULL?
13	SRSID	Source of Data	nvarchar	10	CHAR	(N' ')	Yes	TCG56	ESESRSID	Allow NULL?
14	OWNID	Data Provider	nvarchar	10	CHAR	(N' ')	Yes	*	ESEVENDRID	Allow NULL?
15	RECNROOT	Sequential Number of Data Record	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		ESERECN	Allow NULL?
16	DDOID	Key of Initial Shipping Order	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		CVDEDDOID	Allow NULL?
17	DDBID	Shipping Order Bundle Number	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		CVDEDDBID	Allow NULL?
18	DDPID	Key of Shipping Order Package	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		CVDEDDPID	Allow NULL?
19	STATUS	Status of a Shipping Order (Internal)	nvarchar	2	CHAR	(N' ')	Yes	*	CVDESTATUS	Allow NULL?
20	DDOCTYPE	Shipping Order Type	nvarchar	3	CHAR	(N' ')	Yes		CVDEDDOCTY	Allow NULL?
21	REASONTYP	Reason/Origin Category	nvarchar	10	CHAR	(N' ')	Yes	CVCRT	CVDERETYP	Allow NULL?
22	REASONCAT	Reason/Origin Type	nvarchar	10	CHAR	(N' ')	Yes	CVCRCAT	CVDERECAT	Allow NULL?
23	REASONBPR	Business Process	nvarchar	10	CHAR	(N' ')	Yes	CVCBP	CVDEBPRID	Allow NULL?
24	INITIATOR	Initiator of a Shipping Order	nvarchar	4	CHAR	(N' ')	Yes	TVKO	CVDEINIT	Allow NULL?
25	DISTSUBID	Shipping Order Specification Key	nvarchar	12	CHAR	(N' ')	Yes		CVDESUBID	Allow NULL?
26	RECTYPE	Type of recipient number	nvarchar	2	CHAR	(N' ')	Yes		CVDERECIDT	Allow NULL?
27	RECGROUP	Recipient group	nvarchar	4	CHAR	(N' ')	Yes		CVDERECGRP	Allow NULL?
28	RECADR_C	Generic recipient number	nvarchar	20	CHAR	(N' ')	Yes		CVDERECID	Allow NULL?
29	RECADR_P	Recipient Key (Person)	nvarchar	20	CHAR	(N' ')	Yes		CVDERECIDP	Allow NULL?
30	RECTITLE_C	Form of address text	nvarchar	20	CHAR	(N' ')	Yes		AD_TITLE_T	Allow NULL?
31	RECNAME_C	Name 1	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME1	Allow NULL?
32	RECLAND_C	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
33	RECREGIO_C	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
34	RECCITY_C	City	nvarchar	40	CHAR	(N' ')	Yes		AD_CITY1	Allow NULL?
35	RECCODE_C	City postal code	nvarchar	10	CHAR	(N' ')	Yes		AD_PSTCD1	Allow NULL?
36	RECLANGU_C	Language Key	char	1	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
37	RECTITLE_P	Form of address text	nvarchar	20	CHAR	(N' ')	Yes		AD_TITLE_T	Allow NULL?
38	RECFNAME_P	First name	nvarchar	40	CHAR	(N' ')	Yes		AD_NAMEFIR	Allow NULL?
39	RECLNAME_P	Last name	nvarchar	40	CHAR	(N' ')	Yes		AD_NAMELAS	Allow NULL?
40	RECLAND_P	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
41	RECREGIO_P	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
42	RECCITY_P	City	nvarchar	40	CHAR	(N' ')	Yes		AD_CITY1	Allow NULL?
43	RECCODE_P	City postal code	nvarchar	10	CHAR	(N' ')	Yes		AD_PSTCD1	Allow NULL?
44	RECLANGU_P	Language Key	char	1	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
45	RECDEFCOM	Addresses: Communication type	nvarchar	3	CHAR	(N' ')	Yes		COM_ART	Allow NULL?
46	RECADR_INT	Communication Address Exists	char	1	CHAR	(N' ')	Yes		CVDECOMSET	Allow NULL?
47	RECADR_RML	Communication Address Exists	char	1	CHAR	(N' ')	Yes		CVDECOMSET	Allow NULL?
48	RECADR_FAX	Communication Address Exists	char	1	CHAR	(N' ')	Yes		CVDECOMSET	Allow NULL?
49	RECADR_LET	Communication Address Exists	char	1	CHAR	(N' ')	Yes		CVDECOMSET	Allow NULL?
50	RECSAPNAME	SAP name of a SAPoffice user	nvarchar	12	CHAR	(N' ')	Yes		SO_SAP_NAM	Allow NULL?
51	SUBID	Specification	nvarchar	12	CHAR	(N' ')	Yes		ESESUBID	Allow NULL?
52	SBGVID	Report Generation Variant	nvarchar	10	CHAR	(N' ')	Yes		ESELDEPID	Allow NULL?
53	LANGU	Language	char	1	LANG	(N' ')	Yes	*	ESELANGU	Allow NULL?
54	EHSDOCCAT	EH&S Reporting - Document Type	nvarchar	3	CHAR	(N' ')	Yes		ESEEHDOKAR	Allow NULL?
55	INTVERSION	Report Version	nvarchar	5	NUMC	(N'00000')	Yes		ESEREPVERS	Allow NULL?
56	REPTYPE	Report Category	nvarchar	10	CHAR	(N' ')	Yes	TCGL1	ESEREPTYPE	Allow NULL?
57	REPSTATUS	Report Status	nvarchar	2	CHAR	(N' ')	Yes		ESEREPSTAT	Allow NULL?
58	VERSION	Report Version	nvarchar	5	NUMC	(N'00000')	Yes		ESEREPVERS	Allow NULL?
59	SUBVERSION	Report Version	nvarchar	5	NUMC	(N'00000')	Yes		ESEREPVERS	Allow NULL?
60	GENDAT	Generation Date of a Report	nvarchar	8	DATS	(N'00000000')	Yes		ESEREPGDAT	Allow NULL?
61	VALDAT	Validity Date of a Report	nvarchar	8	DATS	(N'00000000')	Yes		ESEREPVDAT	Allow NULL?
62	REQREASON	Reason for Report Request	nvarchar	14	CHAR	(N' ')	Yes		ESEREQREAS	Allow NULL?
63	RELCHGFLG	Relevant Change Has Been Made	char	1	CHAR	(N' ')	Yes		ESEESNTFLG	Allow NULL?
64	MATNR	Material Number	nvarchar	18	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
65	MATNAM	Material Name	nvarchar	132	CHAR	(N' ')	Yes		CVDEMATNAM	Allow NULL?
66	RAWMATNR	Raw material number	nvarchar	18	CHAR	(N' ')	Yes	MARA	CVDERMATNR	Allow NULL?
67	DMSCAT	Document Management System Type	nvarchar	3	CHAR	(N' ')	Yes		ESEDMSCAT	Allow NULL?
68	DMSKEY	Generic Key of a Document	nvarchar	70	CHAR	(N' ')	Yes		ESEDMSKEY	Allow NULL?
69	DOCFORMAT1	Document Format 1	nvarchar	3	CHAR	(N' ')	Yes		CVDEDOCFR1	Allow NULL?
70	DOCFORMAT2	Document Format 2	nvarchar	3	CHAR	(N' ')	Yes		CVDEDOCFR2	Allow NULL?
71	NUMBYTES	Size of a document in bytes	nvarchar	12	NUMC	(N'000000000000')	Yes		ESENUMBYTE	Allow NULL?
72	NUMPAGES	Size of a document in pages	nvarchar	3	NUMC	(N'000')	Yes		ESENUMPAGE	Allow NULL?
73	SENDELEM	Shipping Object Number	nvarchar	10	CHAR	(N' ')	Yes		CVDESELID	Allow NULL?
74	COM_ART	Addresses: Communication type	nvarchar	3	CHAR	(N' ')	Yes	*	COM_ART	Allow NULL?
75	COM_GROUP	Communication Group	nvarchar	3	CHAR	(N' ')	Yes	*	CVDECOMGRP	Allow NULL?
76	PDEST	Spool Parameter: Name of Device	nvarchar	4	CHAR	(N' ')	Yes	*	SYPRI_PDEST	Allow NULL?
77	PRCOP	Spool Parameter: Number of Copies	nvarchar	3	NUMC	(N'000')	Yes		SYPRI_PRCOP	Allow NULL?
78	PLIST	Spool Parameter: Name of Spool Request	nvarchar	12	CHAR	(N' ')	Yes		SYPRI_PLIST	Allow NULL?
79	PRTXT	Spool Parameter: Description Text	nvarchar	68	CHAR	(N' ')	Yes		SYPRI_PRTXT	Allow NULL?
80	PRIMM	Spool Parameter: Print Now	char	1	CHAR	(N' ')	Yes		SYPRI_PRIMM	Allow NULL?
81	PRREL	Spool Parameter: Delete Spool Request Immediately	char	1	CHAR	(N' ')	Yes		SYPRI_PRREL	Allow NULL?
82	PRNEW	Spool Parameter: New Print Request	char	1	CHAR	(N' ')	Yes		SYPRI_PRNEW	Allow NULL?
83	PEXPI	Spool-Parameter: Retention	char	1	NUMC	(N'0')	Yes		SYPRI_PEXPI	Allow NULL?
84	LINCT	Spool Parameter: Page Length	int	10	INT4	((0))	Yes		SYPRI_LINCT	Allow NULL?
85	LINSZ	Spool Parameter: List Width	int	10	INT4	((0))	Yes		SYPRI_LINSZ	Allow NULL?
86	PAART	Spool Parameter: Page Format	nvarchar	16	CHAR	(N' ')	Yes	*	SYPRI_PAART	Allow NULL?
87	PRBIG	Spool Parameter: Cover Page	char	1	CHAR	(N' ')	Yes		SYPRI_PRBIG	Allow NULL?
88	PRSAP	Spool Parameter: Standard Cover Page	char	1	CHAR	(N' ')	Yes		SYPRI_PRSAP	Allow NULL?
89	PRREC	Spool Parameter: Recipient Name	nvarchar	12	CHAR	(N' ')	Yes		SYPRI_PRREC	Allow NULL?
90	PRABT	Spool Parameter: Department Name	nvarchar	12	CHAR	(N' ')	Yes		SYPRI_PRABT	Allow NULL?
91	PRBER	Spool Parameter: Authorization Value	nvarchar	12	CHAR	(N' ')	Yes		SYPRI_PRBER	Allow NULL?
92	PRDSN	Spool Parameter: Name of Spool File	nvarchar	6	CHAR	(N' ')	Yes		SYPRI_PRDSN	Allow NULL?
93	PTYPE	Spool Parameter: Type of Spool Request	nvarchar	12	CHAR	(N' ')	Yes		SYPRI_PTYPE	Allow NULL?
94	ARMOD	Spool Parameter: Storage Mode	char	1	CHAR	(N' ')	Yes		SYPRI_ARMOD	Allow NULL?
95	FOOTL	Spool Parameter: Footer	char	1	CHAR	(N' ')	Yes		SYPRI_FOOTL	Allow NULL?
96	PRIOT	Spool Parameter: Priority	char	1	NUMC	(N'0')	Yes		SYPRI_PRIOR	Allow NULL?
97	PRUNX	Spool Parameter: Operating System Cover Page	char	1	CHAR	(N' ')	Yes		SYPRI_PRUNX	Allow NULL?
98	PRKEYEXT	Spool Parameter: Keys	nvarchar	16	CHAR	(N' ')	Yes		SYPRI_PRKEY	Allow NULL?
99	PRCHK	Spool Parameter: Dheck Total	int	10	INT4	((0))	Yes		SYPRI_CHECK	Allow NULL?
100	RSPOID	Spool request number	int	10	INT4	((0))	Yes		RSPOID	Allow NULL?
101	SO_OBJ_ID	SAPoffice: ID of a SAPoffice object	nvarchar	17	CHAR	(N' ')	Yes		SO_OBJ_ID	Allow NULL?
102	OHORDERNO	Job Number of a WWI Job	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		ESEOHORDER	Allow NULL?
103	OHORDERCNT	Item counter for WWI job	nvarchar	5	NUMC	(N'00000')	Yes		ESEORDERCN	Allow NULL?
104	JOBID	Processing Cycle ID Number	nvarchar	20	NUMC	(N'00000000000000000000')	Yes		CVDEJOBID	Allow NULL?
105	WPJOBNAME	Background job name	nvarchar	32	CHAR	(N' ')	Yes		BTCJOB	Allow NULL?
106	WPJOBCOUNT	Job ID	nvarchar	8	CHAR	(N' ')	Yes		BTCJOBCNT	Allow NULL?
107	STARTDAT	Target Shipping Date	nvarchar	8	DATS	(N'00000000')	Yes		CVDESENDAT	Allow NULL?
108	CRTIM	Entry Time	nvarchar	6	TIMS	(N'000000')	Yes		CVDECRTIM	Allow NULL?
109	UPDTIM	Time of last change	nvarchar	6	TIMS	(N'000000')	Yes		CVDEUPDTIM	Allow NULL?
110	OCDAT	Output check date	nvarchar	8	DATS	(N'00000000')	Yes		CVDEOCDAT	Allow NULL?
111	OCTIM	Output check time	nvarchar	6	TIMS	(N'000000')	Yes		CVDEOCTIM	Allow NULL?
112	OCNAM	Output check user	nvarchar	12	CHAR	(N' ')	Yes		CVDEOCNAM	Allow NULL?
113	ACKDAT	Date of acknowledgement of receipt	nvarchar	8	DATS	(N'00000000')	Yes		CVDEICDAT	Allow NULL?
114	ACKTIM	Time of Acknowledgement of Receipt	nvarchar	6	TIMS	(N'000000')	Yes		CVDEICTIM	Allow NULL?
115	ACKNAM	Acknowledgement of receipt processor	nvarchar	12	CHAR	(N' ')	Yes		CVDEICNAM	Allow NULL?
116	SEDAT	Send date	nvarchar	8	DATS	(N'00000000')	Yes		CVDESEDAT	Allow NULL?
117	SETIM	Send time	nvarchar	6	TIMS	(N'000000')	Yes		CVDESETIM	Allow NULL?
118	RESFLG	Shipping Order is Relevant for Subsequent Shipping	char	1	CHAR	(N' ')	Yes		CVDERESFLG	Allow NULL?
119	OCFLG	Execute Output Check	char	1	CHAR	(N' ')	Yes		CVDEOCFLG	Allow NULL?
120	SAVFLG	Save Final Report	char	1	CHAR	(N' ')	Yes		CVDESAVFLG	Allow NULL?
121	DDBFLG	Bundle Shipping Order	char	1	CHAR	(N' ')	Yes		CVDEDDBFLG	Allow NULL?
122	RERFLG	Redetermine Report Body	char	1	CHAR	(N' ')	Yes		CVDERERFLG	Allow NULL?
123	HPFLG	Generate Cover Sheet for Shipping Order	char	1	CHAR	(N' ')	Yes		CVDEHPFLG	Allow NULL?
124	ACKFLG	Generate Acknowledgement of Receipt	char	1	CHAR	(N' ')	Yes		CVDEACKFLG	Allow NULL?
125	DDPORD	Sorting Shipping Order Packages	nvarchar	4	NUMC	(N'0000')	Yes		CVDEDDPORD	Allow NULL?
126	DDOCNR	Sequence of Shipping Orders in One Order Package	nvarchar	4	NUMC	(N'0000')	Yes		CVDEDDOCNR	Allow NULL?
127	DMSSRCCAT	Document Management System Type	nvarchar	3	CHAR	(N' ')	Yes		ESEDMSCAT	Allow NULL?
128	DMSSRCKEY	Generic Key of a Document	nvarchar	70	CHAR	(N' ')	Yes		ESEDMSKEY	Allow NULL?
129	PROCESSCAT	Process Type of Report Shipping Order	char	1	CHAR	(N' ')	Yes		CVDEPROCAT	Allow NULL?
130	EVENTID	Background Processing Event	nvarchar	32	CHAR	(N' ')	Yes		BTCEVENTID	Allow NULL?
131	EVENTPARM	Background Event Parameters (Such as, Jobname/Jobcount)	nvarchar	64	CHAR	(N' ')	Yes		BTCEVTPARM	Allow NULL?
132	ADDOBJFLG	Flag for Internal Use	char	1	CHAR	(N' ')	Yes		ESEINTRFLG	Allow NULL?
133	REPVIEW	Report View	nvarchar	3	CHAR	(N' ')	Yes	*	ESEREPUSVIEW	Allow NULL?
134	ADD_DOC_IND	Additional Document Exists	char	1	CHAR	(N' ')	Yes		CVDEADD_DOC_IND	Allow NULL?
135	RDO_HAS_ADD_DOC_IND	Additional Document for Shipping Order Exists	char	1	CHAR	(N' ')	Yes		CVDEADD_RDO_HAS_ADD_DOC_IND	Allow NULL?
136	KEEP_COMM_TYPE	Keep Communication Type	char	1	CHAR	(N' ')	Yes		CVDEADD_KEEP_COMM_TYPE	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