CCDUTDGREL SAP (Product Release) Table details

Dictionary Type: Table
Description: Product Release




ABAP Code to SELECT data from CCDUTDGREL
Related tables to CCDUTDGREL
Access table CCDUTDGREL




Table field list including key, data, relationships and ABAP select examples

CCDUTDGREL is a standard SAP Table which is used to store Product Release data and is available within R/3 SAP systems depending on the version and release level.

The CCDUTDGREL table consists of various fields, each holding specific information or linking keys about Product Release data available in SAP. These include MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State), VALFR (Valid-From Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CCDUTDGREL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
RECNSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
ACTNSequential Number of the Change State ESEACTNNUMC20ALPHAESDACTN
VALFRValid-From Date ESEVALFRDATS8DATUM
VALTOValid-To Date ESEVALTODATS8DATUM
AENNRChange Number ESEAENNRCHAR12AENRAENNRAENNRAEN
DELFLGDeletion Indicator ADGE_DELFLGCHAR1ESDFLAG
PARKFLGData Record Is Inactive ESEPARKFLGCHAR1ESDFLAG
CRDATCreated On ESECRDATDATS8DATUM
CRNAMCreated By ESECRNAMCHAR12USNAM
UPDDATChanged On ESEUPDDATDATS8DATUM
UPDNAMLast Changed By ESEUPDNAMCHAR12USNAM
SRSIDSource of Data ESESRSIDCHAR10TCG56ESDSRSID
OWNIDData Provider ESEVENDRIDCHAR10Assigned to domainALPHAAD_ADDRNUM
RECNROOTSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
MATNRMaterial or Product (Internal Key) BASE_MATIDCHAR40EHSMABASD_MATIDEHS_BAS_MATID
LWDGDangerous Goods Regulation THME_LWDGCHAR12THM063HMD_LWDGD6L
PACKAGE_MATNRPackaging (Material or Product) CBDUE_PACK_MATIDCHAR40EHSMABASD_MATID
DAORData Origin (Filling and Distribution) ADGE_DAORCHAR1ADGD_DAOR
PRIO_ALTERNPriority of Release CBDUE_PRIO_ALTERNNUMC2NUMC2
FLG_RELEASEDProduct Released for Regulation CBDUE_FLG_RELEASEDCHAR1X
FLG_TRANS_PERMTransport Not Permitted CBDUE_FLG_TRANS_PERMCHAR1X
FLG_NO_DGNot Dangerous Goods CBDUE_FLG_NO_DGCHAR1X
FLG_LQLimited Quantity CBDUE_FLG_LQCHAR1X
FLG_RQReportable Quantity CBDUE_FLG_RQCHAR1X
INSTR_ENCLActual Instruction for Enclosure CBDUE_INSTR_ENCLCHAR10CCUNC115CBUND_INSTR_ENCL
FLG_SINGLE_PACKSingle Packaging CBDUE_FLG_SGL_PACKCHAR1X
PACODActual Packaging Code CBDUE_PACODCHAR10CCUNC121CBUND_PACOD
QUANT_OUT_PACKQuantity Single/Outer Packaging CBDUE_QUANT_OUTQUAN8(2) HMD_QUAN
U_QUANT_OUT_PACKUnit of Measurement for Quantity Outer Packaging CBDUE_U_QUANT_OUTUNIT3T006CUNITMEINS
PACK_NOTENote for Release CBDUE_PACK_NOTECHAR21CBDUD_FIELD_WITH_PHRASE
RECN_SUBSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
RECN_CLASSSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
FLG_CCConsumer Commodity CBDUE_FLG_CCCHAR1X
FLG_PACKEDPacked Goods CBDUE_FLG_PACKEDCHAR1X
TRANSPORT_TYPEActual Transport Type CBDUE_TRANSP_TYPENUMC3THM003HMD_MOS
APPROVAL_CODEFull UN Packaging Code CBDUE_APPROVAL_CODECHAR72CHAR72
MAT_DAMAGED_CL7Damaged Material (Class 7) ADGE_MAT_DAMAGED_CL7CHAR1ADGD_YES_NO_NOT_DEFINED
MAX_GROSS_WEIGHTMaximum Gross Mass ADGE_MAX_GROSS_WEIGHTQUAN8(2) HMD_QUAN
U_MAX_GROSS_WGHTUnit for Maximum Gross Mass ADGE_U_MAX_GROSS_WGHTUNIT3Assigned to domainCUNITMEINS
SUBID_DG_CLASSKey (ID) of Dangerous Goods Classification ADGE_SUBID_CLASSCHAR12CHAR12
EMV_DYNElectromagnetic Compatibility ADGE_EMV_DYNCHAR1EHS_ADGD_CODE
LTSK_DYNAir Transport Safety Code ADGE_LTSK_DYNCHAR1EHS_ADGD_CODE
EXPL_NET_DYNNet Explosive Substance Mass ADGE_EXPL_NET_DYNQUAN9(3) EHS_ADGD_Q93
EXPL_NET_DYN_UUnit for Net Explosive Substance Mass EHS_ADGE_EXPL_NET_UUNIT3Assigned to domainCUNITMEINS
MAX_ACT_SGLMaximum Activity: Item ADGE_MAX_ACT_SGL_DYNQUAN11(4) ADGD_QUAN_11_4
MAX_ACT_SGL_UMaximum Activity Unit: Item ADGE_MAX_ACT_SGL_DYN_UUNIT3Assigned to domainCUNITMEINS
ACT_SGL_UNLIMITMaximum Activity of Item Unlimited ADGE_ACT_SGL_DYN_UNLIMITCHAR1ESDFLAG
MAX_ACT_PACKMaximum Activity: Package ADGE_MAX_ACT_PACK_DYNQUAN11(4) ADGD_QUAN_11_4
MAX_ACT_PACK_UMaximum Activity Unit: Package ADGE_MAX_ACT_PACK_DYN_UUNIT3Assigned to domainCUNITMEINS
ACT_PACK_UNLIMITMaximum Activity of Package Unlimited ADGE_ACT_PACK_DYN_UNLIMITCHAR1ESDFLAG
EXCEPT_PACK_OPTExcepted Package: Optional ADGE_EXCEPT_PACK_OPTCHAR1ESDFLAG
DG_USE_CASEDangerous Goods: Use Case ADGE_DG_USE_CASECHAR1ADGD_DG_USE_CASE
PRIO_DYNCLPriority of Dynamic Classification ADGE_PRIO_DYNCLNUMC2NUMC2
MAX_NEMMaximum Net Explosive Substance Mass ADGE_MAX_NEM_DYNQUAN9(3) EHS_ADGD_Q93
MAX_NEM_UUnit of Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DYN_UUNIT3Assigned to domainCUNITMEINS
.INCLU--AP 0
DUMMY_RCBDUDGREL Dummy Fld0
.INCLU--AP 0
FLG_EQExcepted Quantity ADGE_EXC_QUANTCHAR1X
.INCLU--AP 0
DGREL_TRANSIND01Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND02Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND03Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND04Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND05Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND06Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND07Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND08Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10ADGD_TRANSPORT_INDICATOR
MATNR_REPLACENumber of Replacement Material or Replacement Product ADGE_MATID_REPLACECHAR40EHSMABASD_MATID
.INCLU--AP 0
DUMMY_CCDUTDGRELSingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP table CCDUTDGREL using ABAP code

The following ABAP code Example will allow you to do a basic selection on CCDUTDGREL to SELECT all data from the table
DATA: WA_CCDUTDGREL TYPE CCDUTDGREL.

SELECT SINGLE *
FROM CCDUTDGREL
INTO CORRESPONDING FIELDS OF WA_CCDUTDGREL
WHERE...

How to access SAP table CCDUTDGREL

Within an ECC or HANA version of SAP you can also view further information about CCDUTDGREL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!