SAP ABAP Table /TDAG/CPT_DEC_DE (CP: Declarable Substances, Dependent attributes)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/TDAG/CPT_DEC_DE	Table Relationship Diagram
Short Description	CP: Declarable Substances, Dependent attributes

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	EHS: 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	☐	ESEDELFLG	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	.INCLUDE	☐				0	0	CP: Dependent declarable database table fields
19	REGLIST_DEP	☐	/TDAG/CPE_REGLIST	/TDAG/CPD_REGLIST	CHAR	20	0	Regulatory/Customer List	/TDAG/CPC_SREG
20	PART_RECN_DEP	☐	/TDAG/CPE_PART_RECN	ESDRECN	NUMC	20	0	Internal Key of Part
21	PART_NAME_DEP	☐	/TDAG/CPE_PART_NAME	TEXT40	CHAR	40	0	Part Name
22	VALUE_P_DEP	☐	/TDAG/CPE_DECSVAVG_PART	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
23	VALUEMIN_P_DEP	☐	/TDAG/CPE_DECSVMIN_PART	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance (Part)
24	VALUEMAX_P_DEP	☐	/TDAG/CPE_DECSVMAX_PART	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance (Part)
25	VUNIT_DEP	☐	/TDAG/CPE_PROP_UNIT_PART	MEINS	UNIT	3	0	Unit of Proportion (Part)	T006
26	PART_WEIGHT_DEP	☐	/TDAG/CPE_DECSMAVG_PART		QUAN	17	7	Mean Weight of Declarable Substance (Part)
27	PART_WUNIT_DEP	☐	/TDAG/CPE_MASS_UNIT_PART	MEINS	UNIT	3	0	Unit of Mass (Part)	T006
28	EXEMPTION_DEP	☐	/TDAG/CPE_EXEMPT	/TDAG/CPD_EXEMPT	CHAR	10	0	Exemption	/TDAG/CPC_SREGEX
29	CLASS_DEP	☐	/TDAG/CPE_CLASSIFICATION	/TDAG/CPD_CLASSIFICATION	CHAR	1	0	Classification for compliance	/TDAG/CPC_CLASS
30	ORIGIN_DEP	☐	/TDAG/CPE_DECSORIGIN	/TDAG/CPD_DECSORIGIN	CHAR	1	0	Source of Declarable Substance
31	RECN_INDEP	☐	/TDAG/CPE_DECL_RECN_INDEP	ESDRECN	NUMC	20	0	Connection to RECN Declarable-Independent Table	*
32	FLG_AGAINST_PART	☐	/TDAG/CPE_AGAINST_PART	/TDAG/CPD_FLG_01	CHAR	1	0	Check Against Part
33	FLG_GROUP	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
34	GROUP_ID	☐	/TDAG/CPE_ALTGROUP_ID		NUMC	2	0	Alternative Group ID
35	FLG_GROUP_ALT	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPT_DEC_DE	AENNR	AENR	AENNR	REF	1	CN
2	/TDAG/CPT_DEC_DE	CLASS_DEP	/TDAG/CPC_CLASS	CLASS	REF	1	CN
3	/TDAG/CPT_DEC_DE	EXEMPTION_DEP	/TDAG/CPC_SREGEX	EXEMPTION	REF	1	CN
4	/TDAG/CPT_DEC_DE	MANDT	T000	MANDT
5	/TDAG/CPT_DEC_DE	PART_WUNIT_DEP	T006	MSEHI	REF	1	CN
6	/TDAG/CPT_DEC_DE	REGLIST_DEP	/TDAG/CPC_SREG	REGLIST	REF	1	CN
7	/TDAG/CPT_DEC_DE	SRSID	TCG56	SRSID	REF	1	CN
8	/TDAG/CPT_DEC_DE	VUNIT_DEP	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in	222_46C