CCDUTDGREL SAP (Product Release) Table details
Dictionary Type: Table
Description: Product Release
Description: Product Release
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
ACTN | Sequential Number of the Change State | ESEACTN | NUMC | 20 | ALPHA | ESDACTN | |||
VALFR | Valid-From Date | ESEVALFR | DATS | 8 | DATUM | ||||
VALTO | Valid-To Date | ESEVALTO | DATS | 8 | DATUM | ||||
AENNR | Change Number | ESEAENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
DELFLG | Deletion Indicator | ADGE_DELFLG | CHAR | 1 | ESDFLAG | ||||
PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | ESDFLAG | ||||
CRDAT | Created On | ESECRDAT | DATS | 8 | DATUM | ||||
CRNAM | Created By | ESECRNAM | CHAR | 12 | USNAM | ||||
UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | DATUM | ||||
UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | USNAM | ||||
SRSID | Source of Data | ESESRSID | CHAR | 10 | TCG56 | ESDSRSID | |||
OWNID | Data Provider | ESEVENDRID | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
MATNR | Material or Product (Internal Key) | BASE_MATID | CHAR | 40 | EHSMA | BASD_MATID | EHS_BAS_MATID | ||
LWDG | Dangerous Goods Regulation | THME_LWDG | CHAR | 12 | THM063 | HMD_LWDG | D6L | ||
PACKAGE_MATNR | Packaging (Material or Product) | CBDUE_PACK_MATID | CHAR | 40 | EHSMA | BASD_MATID | |||
DAOR | Data Origin (Filling and Distribution) | ADGE_DAOR | CHAR | 1 | ADGD_DAOR | ||||
PRIO_ALTERN | Priority of Release | CBDUE_PRIO_ALTERN | NUMC | 2 | NUMC2 | ||||
FLG_RELEASED | Product Released for Regulation | CBDUE_FLG_RELEASED | CHAR | 1 | X | ||||
FLG_TRANS_PERM | Transport Not Permitted | CBDUE_FLG_TRANS_PERM | CHAR | 1 | X | ||||
FLG_NO_DG | Not Dangerous Goods | CBDUE_FLG_NO_DG | CHAR | 1 | X | ||||
FLG_LQ | Limited Quantity | CBDUE_FLG_LQ | CHAR | 1 | X | ||||
FLG_RQ | Reportable Quantity | CBDUE_FLG_RQ | CHAR | 1 | X | ||||
INSTR_ENCL | Actual Instruction for Enclosure | CBDUE_INSTR_ENCL | CHAR | 10 | CCUNC115 | CBUND_INSTR_ENCL | |||
FLG_SINGLE_PACK | Single Packaging | CBDUE_FLG_SGL_PACK | CHAR | 1 | X | ||||
PACOD | Actual Packaging Code | CBDUE_PACOD | CHAR | 10 | CCUNC121 | CBUND_PACOD | |||
QUANT_OUT_PACK | Quantity Single/Outer Packaging | CBDUE_QUANT_OUT | QUAN | 8(2) | HMD_QUAN | ||||
U_QUANT_OUT_PACK | Unit of Measurement for Quantity Outer Packaging | CBDUE_U_QUANT_OUT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PACK_NOTE | Note for Release | CBDUE_PACK_NOTE | CHAR | 21 | CBDUD_FIELD_WITH_PHRASE | ||||
RECN_SUB | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
RECN_CLASS | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
FLG_CC | Consumer Commodity | CBDUE_FLG_CC | CHAR | 1 | X | ||||
FLG_PACKED | Packed Goods | CBDUE_FLG_PACKED | CHAR | 1 | X | ||||
TRANSPORT_TYPE | Actual Transport Type | CBDUE_TRANSP_TYPE | NUMC | 3 | THM003 | HMD_MOS | |||
APPROVAL_CODE | Full UN Packaging Code | CBDUE_APPROVAL_CODE | CHAR | 72 | CHAR72 | ||||
MAT_DAMAGED_CL7 | Damaged Material (Class 7) | ADGE_MAT_DAMAGED_CL7 | CHAR | 1 | ADGD_YES_NO_NOT_DEFINED | ||||
MAX_GROSS_WEIGHT | Maximum Gross Mass | ADGE_MAX_GROSS_WEIGHT | QUAN | 8(2) | HMD_QUAN | ||||
U_MAX_GROSS_WGHT | Unit for Maximum Gross Mass | ADGE_U_MAX_GROSS_WGHT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SUBID_DG_CLASS | Key (ID) of Dangerous Goods Classification | ADGE_SUBID_CLASS | CHAR | 12 | CHAR12 | ||||
EMV_DYN | Electromagnetic Compatibility | ADGE_EMV_DYN | CHAR | 1 | EHS_ADGD_CODE | ||||
LTSK_DYN | Air Transport Safety Code | ADGE_LTSK_DYN | CHAR | 1 | EHS_ADGD_CODE | ||||
EXPL_NET_DYN | Net Explosive Substance Mass | ADGE_EXPL_NET_DYN | QUAN | 9(3) | EHS_ADGD_Q93 | ||||
EXPL_NET_DYN_U | Unit for Net Explosive Substance Mass | EHS_ADGE_EXPL_NET_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MAX_ACT_SGL | Maximum Activity: Item | ADGE_MAX_ACT_SGL_DYN | QUAN | 11(4) | ADGD_QUAN_11_4 | ||||
MAX_ACT_SGL_U | Maximum Activity Unit: Item | ADGE_MAX_ACT_SGL_DYN_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACT_SGL_UNLIMIT | Maximum Activity of Item Unlimited | ADGE_ACT_SGL_DYN_UNLIMIT | CHAR | 1 | ESDFLAG | ||||
MAX_ACT_PACK | Maximum Activity: Package | ADGE_MAX_ACT_PACK_DYN | QUAN | 11(4) | ADGD_QUAN_11_4 | ||||
MAX_ACT_PACK_U | Maximum Activity Unit: Package | ADGE_MAX_ACT_PACK_DYN_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACT_PACK_UNLIMIT | Maximum Activity of Package Unlimited | ADGE_ACT_PACK_DYN_UNLIMIT | CHAR | 1 | ESDFLAG | ||||
EXCEPT_PACK_OPT | Excepted Package: Optional | ADGE_EXCEPT_PACK_OPT | CHAR | 1 | ESDFLAG | ||||
DG_USE_CASE | Dangerous Goods: Use Case | ADGE_DG_USE_CASE | CHAR | 1 | ADGD_DG_USE_CASE | ||||
PRIO_DYNCL | Priority of Dynamic Classification | ADGE_PRIO_DYNCL | NUMC | 2 | NUMC2 | ||||
MAX_NEM | Maximum Net Explosive Substance Mass | ADGE_MAX_NEM_DYN | QUAN | 9(3) | EHS_ADGD_Q93 | ||||
MAX_NEM_U | Unit of Maximum Net Explosive Substance Mass | ADGE_MAX_NEM_DYN_U | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
.INCLU--AP | 0 | ||||||||
DUMMY_RCBDUDGREL | Dummy Fld | 0 | |||||||
.INCLU--AP | 0 | ||||||||
FLG_EQ | Excepted Quantity | ADGE_EXC_QUANT | CHAR | 1 | X | ||||
.INCLU--AP | 0 | ||||||||
DGREL_TRANSIND01 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND02 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND03 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND04 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND05 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND06 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND07 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
DGREL_TRANSIND08 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | CHAR | 10 | ADGD_TRANSPORT_INDICATOR | ||||
MATNR_REPLACE | Number of Replacement Material or Replacement Product | ADGE_MATID_REPLACE | CHAR | 40 | EHSMA | BASD_MATID | |||
.INCLU--AP | 0 | ||||||||
DUMMY_CCDUTDGREL | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects