SAP ABAP Table VCCDUTDGREL (Aenderungsbelegstruktur; generiert durch RSSCD000)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ EHS-DGP (Application Component) Dangerous Goods Management
     ⤷ CBDG (Package) PI-EH&S Dangerous Goods Management

Basic Data

Table Category	INTTAB	Structure
Structure	VCCDUTDGREL	Table Relationship Diagram
Short Description	Aenderungsbelegstruktur; generiert durch RSSCD000

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	600