SAP Table CVDDH

EHS: Report shipping orders

CVDDH (EHS: Report shipping orders) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CVDDH to other SAP tables.

CVDDH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
VALFR Valid-From Date ESEVALFR DATS 8 0
VALTO Valid-To Date ESEVALTO DATS 8 0
AENNR Change Number ESEAENNR AENR CHAR 12 0
DELFLG Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CRDAT Created On ESECRDAT DATS 8 0
CRNAM Created By ESECRNAM CHAR 12 0
UPDDAT Changed On ESEUPDDAT DATS 8 0
UPDNAM Last Changed By ESEUPDNAM CHAR 12 0
SRSID Source of Data ESESRSID TCG56 CHAR 10 0
OWNID Data Provider ESEVENDRID CHAR 10 0
RECNROOT Sequential Number of Data Record ESERECN NUMC 20 0
DDOID Key of Initial Shipping Order CVDEDDOID NUMC 20 0
DDBID Shipping Order Bundle Number CVDEDDBID NUMC 20 0
DDPID Key of Shipping Order Package CVDEDDPID NUMC 20 0
STATUS Status of a Shipping Order (Internal) CVDESTATUS CHAR 2 0
DDOCTYPE Shipping Order Type CVDEDDOCTY CHAR 3 0
REASONTYP Reason/Origin Category CVDERETYP CVCRT CHAR 10 0
REASONCAT Reason/Origin Type CVDERECAT CVCRCAT CHAR 10 0
REASONBPR Business Process CVDEBPRID CVCBP CHAR 10 0
INITIATOR Initiator of a Shipping Order CVDEINIT TVKO CHAR 4 0
DISTSUBID Shipping Order Specification Key CVDESUBID CHAR 12 0
RECTYPE Type of recipient number CVDERECIDT CHAR 2 0
RECGROUP Recipient group CVDERECGRP CHAR 4 0
RECADR_C Generic recipient number CVDERECID CHAR 20 0
RECADR_P Recipient Key (Person) CVDERECIDP CHAR 20 0
RECTITLE_C Form of address text AD_TITLE_T CHAR 20 0
RECNAME_C Name 1 AD_NAME1 CHAR 40 0
RECLAND_C Country Key LAND1 T005 CHAR 3 0
RECREGIO_C Region (State, Province, County) REGIO T005S CHAR 3 0
RECCITY_C City AD_CITY1 CHAR 40 0
RECCODE_C City postal code AD_PSTCD1 CHAR 10 0
RECLANGU_C Language Key SPRAS T002 LANG 1 0
RECTITLE_P Form of address text AD_TITLE_T CHAR 20 0
RECFNAME_P First name AD_NAMEFIR CHAR 40 0
RECLNAME_P Last name AD_NAMELAS CHAR 40 0
RECLAND_P Country Key LAND1 T005 CHAR 3 0
RECREGIO_P Region (State, Province, County) REGIO T005S CHAR 3 0
RECCITY_P City AD_CITY1 CHAR 40 0
RECCODE_P City postal code AD_PSTCD1 CHAR 10 0
RECLANGU_P Language Key SPRAS T002 LANG 1 0
RECDEFCOM Addresses: Communication type COM_ART CHAR 3 0
RECADR_INT Communication Address Exists CVDECOMSET CHAR 1 0
NULL Communication address is not maintained
C Communication address is maintained for the company
P Communication address is maintained for the person
RECADR_RML Communication Address Exists CVDECOMSET CHAR 1 0
NULL Communication address is not maintained
C Communication address is maintained for the company
P Communication address is maintained for the person
RECADR_FAX Communication Address Exists CVDECOMSET CHAR 1 0
NULL Communication address is not maintained
C Communication address is maintained for the company
P Communication address is maintained for the person
RECADR_LET Communication Address Exists CVDECOMSET CHAR 1 0
NULL Communication address is not maintained
C Communication address is maintained for the company
P Communication address is maintained for the person
RECSAPNAME SAP name of a SAPoffice user SO_SAP_NAM CHAR 12 0
SUBID Specification ESESUBID CHAR 12 0
SBGVID Report Generation Variant ESELDEPID CHAR 10 0
LANGU Language ESELANGU LANG 1 0
EHSDOCCAT EH&S Reporting - Document Type ESEEHDOKAR CHAR 3 0
SBV Report Template
SBR Report - draft
SBE Report - final version
DBV Cover Sheet Template
DBE Cover sheet - final version
EBV Acknowledgement of receipt
EBE Acknowledgement of receipt - final version
IBD Inbound document
RDO Report Shipping Order
LDO Template shipping order
ISX Excel macro specification information system
MPX Excel macro measurement project
OH1 Occupational Health Document for Person
OH2 Occupational Health Document for Medical Service
OH3 Occupational Health Document for Examination
IAL Industrial Hygiene & Safety Doc. for Incident/Accident Log
WAH Industrial Hygiene & Safety Doc. for Work Area
ERH Industrial Hygiene & Safety Doc. for Risk Assessment
CPD Inbound Documents
CPT Inbound Data Reports
CPE Electronic Data Reports
RTB Building Block
INTVERSION Report Version ESEREPVERS NUMC 5 0
REPTYPE Report Category ESEREPTYPE TCGL1 CHAR 10 0
REPSTATUS Report Status ESEREPSTAT CHAR 2 0
VERSION Report Version ESEREPVERS NUMC 5 0
SUBVERSION Report Version ESEREPVERS NUMC 5 0
GENDAT Generation Date of a Report ESEREPGDAT DATS 8 0
VALDAT Validity Date of a Report ESEREPVDAT DATS 8 0
REQREASON Reason for Report Request ESEREQREAS CHAR 14 0
MANUAL Manual report request via dialog
SELECTION Automatic request triggered by faulty selection
SUBCHANGES Automatic request triggered by change in specification data
PHRCHANGES Automatic request triggered by change in phrase data
RELCHGFLG Relevant Change Has Been Made ESEESNTFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MATNR Material Number MATNR MARA CHAR 18 0
MATNAM Material Name CVDEMATNAM CHAR 132 0
RAWMATNR Raw material number CVDERMATNR MARA CHAR 18 0
DMSCAT Document Management System Type ESEDMSCAT CHAR 3 0
DMS Document Management
DMSKEY Generic Key of a Document ESEDMSKEY CHAR 70 0
DOCFORMAT1 Document Format 1 CVDEDOCFR1 CHAR 3 0
ASC Text format
DOC Word document
PDF Portable document format
PS Postscript
WWI Word document for WWI generation
PCL Printer control language
RTF Rich text format
ANY All file formats supported by Word
XML Extensible Markup Language
DOCFORMAT2 Document Format 2 CVDEDOCFR2 CHAR 3 0
ASC Text format
DOC Word document
PDF Portable document format
PS Postscript
WWI Word document for WWI generation
PCL Printer control language
RTF Rich text format
ANY All file formats supported by Word
XML Extensible Markup Language
NUMBYTES Size of a document in bytes ESENUMBYTE NUMC 12 0
NUMPAGES Size of a document in pages ESENUMPAGE NUMC 3 0
SENDELEM Shipping Object Number CVDESELID CHAR 10 0
COM_ART Addresses: Communication type COM_ART CHAR 3 0
COM_GROUP Communication Group CVDECOMGRP CHAR 3 0
PDEST Spool Parameter: Name of Device SYPRI_PDEST CHAR 4 0
PRCOP Spool Parameter: Number of Copies SYPRI_PRCOP NUMC 3 0
PLIST Spool Parameter: Name of Spool Request SYPRI_PLIST CHAR 12 0
PRTXT Spool Parameter: Description Text SYPRI_PRTXT CHAR 68 0
PRIMM Spool Parameter: Print Now SYPRI_PRIMM CHAR 1 0
PRREL Spool Parameter: Delete Spool Request Immediately SYPRI_PRREL CHAR 1 0
PRNEW Spool Parameter: New Print Request SYPRI_PRNEW CHAR 1 0
PEXPI Spool-Parameter: Retention SYPRI_PEXPI NUMC 1 0
LINCT Spool Parameter: Page Length SYPRI_LINCT INT4 10 0
LINSZ Spool Parameter: List Width SYPRI_LINSZ INT4 10 0
PAART Spool Parameter: Page Format SYPRI_PAART CHAR 16 0
PRBIG Spool Parameter: Cover Page SYPRI_PRBIG CHAR 1 0
PRSAP Spool Parameter: Standard Cover Page SYPRI_PRSAP CHAR 1 0
NULL Do Not Print
X Print
D Default (Printer Setting)
PRREC Spool Parameter: Recipient Name SYPRI_PRREC CHAR 12 0
PRABT Spool Parameter: Department Name SYPRI_PRABT CHAR 12 0
PRBER Spool Parameter: Authorization Value SYPRI_PRBER CHAR 12 0
PRDSN Spool Parameter: Name of Spool File SYPRI_PRDSN CHAR 6 0
PTYPE Spool Parameter: Type of Spool Request SYPRI_PTYPE CHAR 12 0
ARMOD Spool Parameter: Storage Mode SYPRI_ARMOD CHAR 1 0
1 Print only
2 Archive only
3 Print and archive
FOOTL Spool Parameter: Footer SYPRI_FOOTL CHAR 1 0
PRIOT Spool Parameter: Priority SYPRI_PRIOR NUMC 1 0
PRUNX Spool Parameter: Operating System Cover Page SYPRI_PRUNX CHAR 1 0
NULL Do Not Print
X Print
D Default (Printer Setting)
PRKEYEXT Spool Parameter: Keys SYPRI_PRKEY CHAR 16 0
PRCHK Spool Parameter: Dheck Total SYPRI_CHECK INT4 10 0
RSPOID Spool request number RSPOID INT4 10 0
SO_OBJ_ID SAPoffice: ID of a SAPoffice object SO_OBJ_ID CHAR 17 0
OHORDERNO Job Number of a WWI Job ESEOHORDER NUMC 20 0
OHORDERCNT Item counter for WWI job ESEORDERCN NUMC 5 0
JOBID Processing Cycle ID Number CVDEJOBID NUMC 20 0
WPJOBNAME Background job name BTCJOB CHAR 32 0
WPJOBCOUNT Job ID BTCJOBCNT CHAR 8 0
STARTDAT Target Shipping Date CVDESENDAT DATS 8 0
CRTIM Entry Time CVDECRTIM TIMS 6 0
UPDTIM Time of last change CVDEUPDTIM TIMS 6 0
OCDAT Output check date CVDEOCDAT DATS 8 0
OCTIM Output check time CVDEOCTIM TIMS 6 0
OCNAM Output check user CVDEOCNAM CHAR 12 0
ACKDAT Date of acknowledgement of receipt CVDEICDAT DATS 8 0
ACKTIM Time of Acknowledgement of Receipt CVDEICTIM TIMS 6 0
ACKNAM Acknowledgement of receipt processor CVDEICNAM CHAR 12 0
SEDAT Send date CVDESEDAT DATS 8 0
SETIM Send time CVDESETIM TIMS 6 0
RESFLG Shipping Order is Relevant for Subsequent Shipping CVDERESFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
OCFLG Execute Output Check CVDEOCFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
SAVFLG Save Final Report CVDESAVFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
DDBFLG Bundle Shipping Order CVDEDDBFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
RERFLG Redetermine Report Body CVDERERFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
HPFLG Generate Cover Sheet for Shipping Order CVDEHPFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
ACKFLG Generate Acknowledgement of Receipt CVDEACKFLG CHAR 1 0
NULL Blank stands for "incorrect" (flag deleted)
X "X" stands for "true" (flag set)
* "*" stands for "true" or "wrong"
DDPORD Sorting Shipping Order Packages CVDEDDPORD NUMC 4 0
DDOCNR Sequence of Shipping Orders in One Order Package CVDEDDOCNR NUMC 4 0
DMSSRCCAT Document Management System Type ESEDMSCAT CHAR 3 0
DMS Document Management
DMSSRCKEY Generic Key of a Document ESEDMSKEY CHAR 70 0
PROCESSCAT Process Type of Report Shipping Order CVDEPROCAT CHAR 1 0
B Background processing using dispatcher process
I Background processing with start "Immediately"
EVENTID Background Processing Event BTCEVENTID CHAR 32 0
EVENTPARM Background Event Parameters (Such as, Jobname/Jobcount) BTCEVTPARM CHAR 64 0
ADDOBJFLG Flag for Internal Use ESEINTRFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
REPVIEW Report View ESEREPUSVIEW CHAR 3 0

CVDDH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CVDDH AENNR SY MANDT AENR Change Master MANDT
CVDDH AENNR CVDDH AENNR AENR Change Master AENNR
CVDDH INITIATOR SY-MANDT MANDT TVKO Organizational Unit: Sales Organizations MANDT
CVDDH INITIATOR CVDDH INITIATOR TVKO Organizational Unit: Sales Organizations VKORG
CVDDH MANDT CVDDH MANDT T000 Clients MANDT
CVDDH MATNR SY-MANDT MANDT MARA General Material Data MANDT
CVDDH MATNR CVDDH MATNR MARA General Material Data MATNR
CVDDH RAWMATNR SY-MANDT MANDT MARA General Material Data MANDT
CVDDH RAWMATNR CVDDH RAWMATNR MARA General Material Data MATNR
CVDDH REASONBPR SY-MANDT MANDT CVCBP EHS: Business process - valid business process IDs MANDT
CVDDH REASONBPR CVDDH REASONBPR CVCBP EHS: Business process - valid business process IDs BPRID
CVDDH REASONCAT CVDDH REASONCAT CVCRCAT EHS: Cause Type REASONCAT
CVDDH REASONTYP CVDDH REASONTYP CVCRT EHS: Origin Category REASONTYP
CVDDH RECLAND_C SY-MANDT MANDT T005 Countries MANDT
CVDDH RECLAND_C CVDDH RECLAND_C T005 Countries LAND1
CVDDH RECLAND_P SY-MANDT MANDT T005 Countries MANDT
CVDDH RECLAND_P CVDDH RECLAND_P T005 Countries LAND1
CVDDH RECLANGU_C CVDDH RECLANGU_C T002 Language Keys (Component BC-I18) SPRAS
CVDDH RECLANGU_P CVDDH RECLANGU_P T002 Language Keys (Component BC-I18) SPRAS
CVDDH RECREGIO_C SY-MANDT MANDT T005S Taxes: Region (Province) Key MANDT
CVDDH RECREGIO_C CVDDH RECLAND_C T005S Taxes: Region (Province) Key LAND1
CVDDH RECREGIO_C CVDDH RECREGIO_C T005S Taxes: Region (Province) Key BLAND
CVDDH RECREGIO_P SY-MANDT MANDT T005S Taxes: Region (Province) Key MANDT
CVDDH RECREGIO_P CVDDH RECLAND_P T005S Taxes: Region (Province) Key LAND1
CVDDH RECREGIO_P CVDDH RECREGIO_P T005S Taxes: Region (Province) Key BLAND
CVDDH REPTYPE CVDDH REPTYPE TCGL1 EHS: Report types REPTYPE
CVDDH REPTYPE SY-MANDT MANDT TCGL1 EHS: Report types MANDT
CVDDH SRSID * TCG56 EHS: Data Origin MANDT
CVDDH SRSID CVDDH SRSID TCG56 EHS: Data Origin SRSID