The CVDDH table in SAP ERP or S/4HANA stores Report shipping orders data. There are total 137 fields in CVDDH table. The Report shipping orders table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CVDDH table. It is in EH&S: Report Shipping (CVDD) ABAP package and is part of the Product Safety (EHS-SAF) module.
SAP CVDDH Table Fields
Following is the list of fields that are available in SAP CVDDH table. The primary key fields of the table are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC (20) | |
| VALFR | Valid-From Date | ESEVALFR | DATS (8) | |
| VALTO | Valid-To Date | ESEVALTO | DATS (8) | |
| AENNR | Change Number | ESEAENNR | AENR | CHAR (12) |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR (1) | |
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR (1) | |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR (10) |
| OWNID | Data Provider | ESEVENDRID | * | CHAR (10) |
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| DDOID | Key of Initial Shipping Order | CVDEDDOID | NUMC (20) | |
| DDBID | Shipping Order Bundle Number | CVDEDDBID | NUMC (20) | |
| DDPID | Key of Shipping Order Package | CVDEDDPID | NUMC (20) | |
| STATUS | Status of a Shipping Order (Internal) | CVDESTATUS | CHAR (2) | |
| DDOCTYPE | Shipping Order Type | CVDEDDOCTY | CHAR (3) | |
| REASONTYP | Reason/Origin Category | CVDERETYP | CVCRT | CHAR (10) |
| REASONCAT | Reason/Origin Type | CVDERECAT | CVCRCAT | CHAR (10) |
| REASONBPR | Business Process | CVDEBPRID | CVCBP | CHAR (10) |
| INITIATOR | Initiator of a Shipping Order | CVDEINIT | TVKO | CHAR (4) |
| DISTSUBID | Shipping Order Specification Key | CVDESUBID | CHAR (12) | |
| RECTYPE | Type of recipient number | CVDERECIDT | CHAR (2) | |
| RECGROUP | Recipient group | CVDERECGRP | CHAR (4) | |
| RECADR_C | Generic recipient number | CVDERECID | CHAR (20) | |
| RECADR_P | Recipient Key (Person) | CVDERECIDP | CHAR (20) | |
| RECTITLE_C | Form of address text | AD_TITLE_T | CHAR (20) | |
| RECNAME_C | Name 1 | AD_NAME1 | CHAR (40) | |
| RECLAND_C | Country/Region Key | LAND1 | T005 | CHAR (3) |
| RECREGIO_C | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
| RECCITY_C | City | AD_CITY1 | CHAR (40) | |
| RECCODE_C | City postal code | AD_PSTCD1 | CHAR (10) | |
| RECLANGU_C | Language Key | SPRAS | T002 | LANG (1) |
| RECTITLE_P | Form of address text | AD_TITLE_T | CHAR (20) | |
| RECFNAME_P | First name | AD_NAMEFIR | CHAR (40) | |
| RECLNAME_P | Last name | AD_NAMELAS | CHAR (40) | |
| RECLAND_P | Country/Region Key | LAND1 | T005 | CHAR (3) |
| RECREGIO_P | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
| RECCITY_P | City | AD_CITY1 | CHAR (40) | |
| RECCODE_P | City postal code | AD_PSTCD1 | CHAR (10) | |
| RECLANGU_P | Language Key | SPRAS | T002 | LANG (1) |
| RECDEFCOM | Addresses: Communication type | COM_ART | CHAR (3) | |
| RECADR_INT | Communication Address Exists | CVDECOMSET | CHAR (1) | |
| RECADR_RML | Communication Address Exists | CVDECOMSET | CHAR (1) | |
| RECADR_FAX | Communication Address Exists | CVDECOMSET | CHAR (1) | |
| RECADR_LET | Communication Address Exists | CVDECOMSET | CHAR (1) | |
| RECSAPNAME | SAP name of a SAPoffice user | SO_SAP_NAM | CHAR (12) | |
| SUBID | Specification | ESESUBID | CHAR (12) | |
| SBGVID | Report Generation Variant | ESELDEPID | CHAR (10) | |
| LANGU | Language | ESELANGU | * | LANG (1) |
| EHSDOCCAT | Reporting – Document Type | ESEEHDOKAR | CHAR (3) | |
| INTVERSION | Report Version | ESEREPVERS | NUMC (5) | |
| REPTYPE | Report Category | ESEREPTYPE | TCGL1 | CHAR (10) |
| REPSTATUS | Report Status | ESEREPSTAT | CHAR (2) | |
| VERSION | Report Version | ESEREPVERS | NUMC (5) | |
| SUBVERSION | Report Version | ESEREPVERS | NUMC (5) | |
| GENDAT | Generation Date of a Report | ESEREPGDAT | DATS (8) | |
| VALDAT | Validity Date of a Report | ESEREPVDAT | DATS (8) | |
| REQREASON | Reason for Report Request | ESEREQREAS | CHAR (14) | |
| RELCHGFLG | Relevant Change Has Been Made | ESEESNTFLG | CHAR (1) | |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| MATNAM | Material Name | CVDEMATNAM | CHAR (132) | |
| RAWMATNR | Raw material number | CVDERMATNR | MARA | CHAR (40) |
| DMSCAT | Document Management System Type | ESEDMSCAT | CHAR (3) | |
| DMSKEY | Generic Key of a Document | ESEDMSKEY | CHAR (70) | |
| DOCFORMAT1 | Document Format 1 | CVDEDOCFR1 | CHAR (3) | |
| DOCFORMAT2 | Document Format 2 | CVDEDOCFR2 | CHAR (3) | |
| NUMBYTES | Size of a document in bytes | ESENUMBYTE | NUMC (12) | |
| NUMPAGES | Size of a document in pages | ESENUMPAGE | NUMC (3) | |
| SENDELEM | Shipping Object Number | CVDESELID | CHAR (10) | |
| COM_ART | Addresses: Communication type | COM_ART | * | CHAR (3) |
| COM_GROUP | Communication Group | CVDECOMGRP | * | CHAR (3) |
| PDEST | Spool Parameter: Name of Device | SYPRI_PDEST | * | CHAR (4) |
| PRCOP | Spool Parameter: Number of Copies | SYPRI_PRCOP | NUMC (3) | |
| PLIST | Spool Parameter: Name of Spool Request | SYPRI_PLIST | CHAR (12) | |
| PRTXT | Spool Parameter: Description Text | SYPRI_PRTXT | CHAR (68) | |
| PRIMM | Spool Parameter: Print Now | SYPRI_PRIMM | CHAR (1) | |
| PRREL | Spool Parameter: Delete Spool Request Immediately | SYPRI_PRREL | CHAR (1) | |
| PRNEW | Spool Parameter: New Print Request | SYPRI_PRNEW | CHAR (1) | |
| PEXPI | Spool-Parameter: Retention | SYPRI_PEXPI | NUMC (1) | |
| LINCT | Spool Parameter: Page Length | SYPRI_LINCT | INT4 (10) | |
| LINSZ | Spool Parameter: List Width | SYPRI_LINSZ | INT4 (10) | |
| PAART | Spool Parameter: Page Format | SYPRI_PAART | * | CHAR (16) |
| PRBIG | Spool Parameter: Cover Page | SYPRI_PRBIG | CHAR (1) | |
| PRSAP | Spool Parameter: Standard Cover Page | SYPRI_PRSAP | CHAR (1) | |
| PRREC | Spool Parameter: Recipient Name | SYPRI_PRREC | CHAR (12) | |
| PRABT | Spool Parameter: Department Name | SYPRI_PRABT | CHAR (12) | |
| PRBER | Spool Parameter: Authorization Value | SYPRI_PRBER | CHAR (12) | |
| PRDSN | Spool Parameter: Name of Spool File | SYPRI_PRDSN | CHAR (6) | |
| PTYPE | Spool Parameter: Type of Spool Request | SYPRI_PTYPE | CHAR (12) | |
| ARMOD | Spool Parameter: Storage Mode | SYPRI_ARMOD | CHAR (1) | |
| FOOTL | Spool Parameter: Footer | SYPRI_FOOTL | CHAR (1) | |
| PRIOT | Spool Parameter: Priority | SYPRI_PRIOR | NUMC (1) | |
| PRUNX | Spool Parameter: Operating System Cover Page | SYPRI_PRUNX | CHAR (1) | |
| PRKEYEXT | Spool Parameter: Keys | SYPRI_PRKEY | CHAR (16) | |
| PRCHK | Spool Parameter: Dheck Total | SYPRI_CHECK | INT4 (10) | |
| RSPOID | Spool request number | RSPOID | INT4 (10) | |
| SO_OBJ_ID | SAPoffice: ID of a SAPoffice object | SO_OBJ_ID | CHAR (17) | |
| OHORDERNO | Job Number of a WWI Job | ESEOHORDER | NUMC (20) | |
| OHORDERCNT | Item counter for WWI job | ESEORDERCN | NUMC (5) | |
| JOBID | Processing Cycle ID Number | CVDEJOBID | NUMC (20) | |
| WPJOBNAME | Background job name | BTCJOB | CHAR (32) | |
| WPJOBCOUNT | Job ID | BTCJOBCNT | CHAR (8) | |
| STARTDAT | Target Shipping Date | CVDESENDAT | DATS (8) | |
| CRTIM | Entry Time | CVDECRTIM | TIMS (6) | |
| UPDTIM | Time of last change | CVDEUPDTIM | TIMS (6) | |
| OCDAT | Output check date | CVDEOCDAT | DATS (8) | |
| OCTIM | Output check time | CVDEOCTIM | TIMS (6) | |
| OCNAM | Output check user | CVDEOCNAM | CHAR (12) | |
| ACKDAT | Date of acknowledgement of receipt | CVDEICDAT | DATS (8) | |
| ACKTIM | Time of Acknowledgement of Receipt | CVDEICTIM | TIMS (6) | |
| ACKNAM | Acknowledgement of receipt processor | CVDEICNAM | CHAR (12) | |
| SEDAT | Send date | CVDESEDAT | DATS (8) | |
| SETIM | Send time | CVDESETIM | TIMS (6) | |
| RESFLG | Shipping Order is Relevant for Subsequent Shipping | CVDERESFLG | CHAR (1) | |
| OCFLG | Execute Output Check | CVDEOCFLG | CHAR (1) | |
| SAVFLG | Save Final Report | CVDESAVFLG | CHAR (1) | |
| DDBFLG | Bundle Shipping Order | CVDEDDBFLG | CHAR (1) | |
| RERFLG | Redetermine Report Body | CVDERERFLG | CHAR (1) | |
| HPFLG | Generate Cover Sheet for Shipping Order | CVDEHPFLG | CHAR (1) | |
| ACKFLG | Generate Acknowledgement of Receipt | CVDEACKFLG | CHAR (1) | |
| DDPORD | Sorting Shipping Order Packages | CVDEDDPORD | NUMC (4) | |
| DDOCNR | Sequence of Shipping Orders in One Order Package | CVDEDDOCNR | NUMC (4) | |
| DMSSRCCAT | Document Management System Type | ESEDMSCAT | CHAR (3) | |
| DMSSRCKEY | Generic Key of a Document | ESEDMSKEY | CHAR (70) | |
| PROCESSCAT | Process Type of Report Shipping Order | CVDEPROCAT | CHAR (1) | |
| EVENTID | Background Processing Event | BTCEVENTID | CHAR (32) | |
| EVENTPARM | Background Event Parameters (Such as, Jobname/Jobcount) | BTCEVTPARM | CHAR (64) | |
| ADDOBJFLG | Flag for Internal Use | ESEINTRFLG | CHAR (1) | |
| REPVIEW | Report View | ESEREPUSVIEW | CHAR (3) | |
| ADD_DOC_IND | Additional Document Exists | CVDEADD_DOC_IND | CHAR (1) | |
| RDO_HAS_ADD_DOC_IND | Additional Document for Shipping Order Exists | CVDEADD_RDO_HAS_ADD_DOC_IND | CHAR (1) | |
| KEEP_COMM_TYPE | Keep Communication Type | CVDEADD_KEEP_COMM_TYPE | CHAR (1) | |
| BLOCKFLG | Lock Indicator | EHSBE_BLK_FLG | CHAR (1) |
