SAP ABAP Table CCDUTDGREL (Product Release)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
     ⤷ CBEHS_DGP (Package) Dangerous Goods Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CCDUTDGREL	Table Relationship Diagram
Short Description	Product Release

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	DG: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ADGE_DELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	MATNR	☐	BASE_MATID	BASD_MATID	CHAR	40	0	Material or Product (Internal Key)
19	LWDG	☐	THME_LWDG	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation	THM063
20	PACKAGE_MATNR	☐	CBDUE_PACK_MATID	BASD_MATID	CHAR	40	0	Packaging (Material or Product)
21	DAOR	☐	ADGE_DAOR	ADGD_DAOR	CHAR	1	0	Data Origin (Filling and Distribution)
22	.INCLUDE	☐				0	0	EHS: Application Data for Table CCDUTDGREL
23	PRIO_ALTERN	☐	CBDUE_PRIO_ALTERN	NUMC2	NUMC	2	0	Priority of Release
24	FLG_RELEASED	☐	CBDUE_FLG_RELEASED	X	CHAR	1	0	Product Released for Regulation
25	FLG_TRANS_PERM	☐	CBDUE_FLG_TRANS_PERM	X	CHAR	1	0	Transport Not Permitted
26	FLG_NO_DG	☐	CBDUE_FLG_NO_DG	X	CHAR	1	0	Not Dangerous Goods
27	FLG_LQ	☐	CBDUE_FLG_LQ	X	CHAR	1	0	Limited Quantity
28	FLG_RQ	☐	CBDUE_FLG_RQ	X	CHAR	1	0	Reportable Quantity
29	INSTR_ENCL	☐	CBDUE_INSTR_ENCL	CBUND_INSTR_ENCL	CHAR	10	0	Actual Instruction for Enclosure	CCUNC115
30	FLG_SINGLE_PACK	☐	CBDUE_FLG_SGL_PACK	X	CHAR	1	0	Single Packaging
31	PACOD	☐	CBDUE_PACOD	CBUND_PACOD	CHAR	10	0	Actual Packaging Code	CCUNC121
32	QUANT_OUT_PACK	☐	CBDUE_QUANT_OUT	HMD_QUAN	QUAN	8	2	Quantity Single/Outer Packaging
33	U_QUANT_OUT_PACK	☐	CBDUE_U_QUANT_OUT	MEINS	UNIT	3	0	Unit of Measurement for Quantity Outer Packaging	T006
34	PACK_NOTE	☐	CBDUE_PACK_NOTE	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Note for Release
35	RECN_SUB	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
36	RECN_CLASS	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
37	FLG_CC	☐	CBDUE_FLG_CC	X	CHAR	1	0	Consumer Commodity
38	FLG_PACKED	☐	CBDUE_FLG_PACKED	X	CHAR	1	0	Packed Goods
39	TRANSPORT_TYPE	☐	CBDUE_TRANSP_TYPE	HMD_MOS	NUMC	3	0	Actual Transport Type	THM003
40	APPROVAL_CODE	☐	CBDUE_APPROVAL_CODE	CHAR72	CHAR	72	0	Full UN Packaging Code
41	MAT_DAMAGED_CL7	☐	ADGE_MAT_DAMAGED_CL7	ADGD_YES_NO_NOT_DEFINED	CHAR	1	0	Damaged Material (Class 7)
42	MAX_GROSS_WEIGHT	☐	ADGE_MAX_GROSS_WEIGHT	HMD_QUAN	QUAN	8	2	Maximum Gross Mass
43	U_MAX_GROSS_WGHT	☐	ADGE_U_MAX_GROSS_WGHT	MEINS	UNIT	3	0	Unit for Maximum Gross Mass	*
44	SUBID_DG_CLASS	☐	ADGE_SUBID_CLASS	CHAR12	CHAR	12	0	Key (ID) of Dangerous Goods Classification
45	EMV_DYN	☐	ADGE_EMV_DYN	EHS_ADGD_CODE	CHAR	1	0	Electromagnetic Compatibility
46	LTSK_DYN	☐	ADGE_LTSK_DYN	EHS_ADGD_CODE	CHAR	1	0	Air Transport Safety Code
47	EXPL_NET_DYN	☐	ADGE_EXPL_NET_DYN	EHS_ADGD_Q93	QUAN	9	3	Net Explosive Substance Mass
48	EXPL_NET_DYN_U	☐	EHS_ADGE_EXPL_NET_U	MEINS	UNIT	3	0	Unit for Net Explosive Substance Mass	*
49	MAX_ACT_SGL	☐	ADGE_MAX_ACT_SGL_DYN	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Item
50	MAX_ACT_SGL_U	☐	ADGE_MAX_ACT_SGL_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Item	*
51	ACT_SGL_UNLIMIT	☐	ADGE_ACT_SGL_DYN_UNLIMIT	ESDFLAG	CHAR	1	0	Maximum Activity of Item Unlimited
52	MAX_ACT_PACK	☐	ADGE_MAX_ACT_PACK_DYN	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Package
53	MAX_ACT_PACK_U	☐	ADGE_MAX_ACT_PACK_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Package	*
54	ACT_PACK_UNLIMIT	☐	ADGE_ACT_PACK_DYN_UNLIMIT	ESDFLAG	CHAR	1	0	Maximum Activity of Package Unlimited
55	EXCEPT_PACK_OPT	☐	ADGE_EXCEPT_PACK_OPT	ESDFLAG	CHAR	1	0	Excepted Package: Optional
56	DG_USE_CASE	☐	ADGE_DG_USE_CASE	ADGD_DG_USE_CASE	CHAR	1	0	Dangerous Goods: Use
57	PRIO_DYNCL	☐	ADGE_PRIO_DYNCL	NUMC2	NUMC	2	0	Priority of Dynamic Classification
58	MAX_NEM	☐	ADGE_MAX_NEM_DYN	EHS_ADGD_Q93	QUAN	9	3	Maximum Net Explosive Substance Mass
59	MAX_NEM_U	☐	ADGE_MAX_NEM_DYN_U	MEINS	UNIT	3	0	Unit of Maximum Net Explosive Substance Mass	*
60	.INCLU--AP	☐				0	0	Structure Append Application Data Table CCDUTDGREL EhP5
61	FLG_EQ	☐	ADGE_EXC_QUANT	X	CHAR	1	0	Excepted Quantity
62	.INCLU--AP	☐				0	0	Structure Append Application Data Table CCDUTDGREL EhP6
63	.INCLUDE	☐				0	0	Structure for Transport Indicators in Product Release
64	DGREL_TRANSIND01	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
65	DGREL_TRANSIND02	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
66	DGREL_TRANSIND03	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
67	DGREL_TRANSIND04	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
68	DGREL_TRANSIND05	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
69	DGREL_TRANSIND06	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
70	DGREL_TRANSIND07	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
71	DGREL_TRANSIND08	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
72	MATNR_REPLACE	☐	ADGE_MATID_REPLACE	BASD_MATID	CHAR	40	0	Number of Replacement Material or Replacement Product

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCDUTDGREL	AENNR	AENR	AENNR	REF	1	CN
2	CCDUTDGREL	INSTR_ENCL	CCUNC115	INSTR_ENCL		1	CN
3	CCDUTDGREL	LWDG	THM063	LWDG		1	CN
4	CCDUTDGREL	MANDT	T000	MANDT
5	CCDUTDGREL	PACOD	CCUNC121	PACKCODE		1	CN
6	CCDUTDGREL	SRSID	TCG56	SRSID	REF	1	CN
7	CCDUTDGREL	TRANSPORT_TYPE	THM003	MOS		1	CN
8	CCDUTDGREL	U_QUANT_OUT_PACK	T006	MSEHI

History

Last changed by/on	SAP	20110908
SAP Release Created in	0207B0406C