SAP ABAP Table /TDAG/CPT_DEC_IN (CP: Declarable Substances, Independent 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_IN	Table Relationship Diagram
Short Description	CP: Declarable Substances, Independent 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: Independent declarable database table fields
19	SUBST_RECN	☐	/TDAG/CPE_SUBST_RECN	ESDRECN	NUMC	20	0	Internal Substance Key
20	HOMOGMAT_RECN	☐	/TDAG/CPE_HOMRECN	ESDRECN	NUMC	20	0	Internal Key of Homogeneous Material
21	HOMOGMAT_NAME	☐	/TDAG/CPE_HOMNAM	TEXT40	CHAR	40	0	Homogeneous Material Name
22	VALUE	☐	/TDAG/CPE_DECSVAVG	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
23	VALUEMIN	☐	/TDAG/CPE_DECSVMIN	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance
24	VALUEMAX	☐	/TDAG/CPE_DECSVMAX	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance
25	VUNIT	☐	/TDAG/CPE_PROP_UNIT	MEINS	UNIT	3	0	Unit of Proportion	T006
26	WEIGHT	☐	/TDAG/CPE_DECSMAVG		QUAN	17	7	Mean Weight of Declarable Substance
27	WUNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	T006
28	CONTAINED	☐	/TDAG/CPE_DECSCONT	/TDAG/CPD_DECSCONT	CHAR	3	0	Contained Substance
29	REMARK	☐	/TDAG/CPE_DECSREM	TEXT80	CHAR	80	0	Remark
30	ORIGIN	☐	/TDAG/CPE_DECSORIGIN	/TDAG/CPD_DECSORIGIN	CHAR	1	0	Source of Declarable Substance
31	.INCLUDE	☐				0	0	CP: database table fields that are used independent and dep.
32	VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
33	VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance (Part)
34	VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance (Part)
35	PART_VUNIT	☐	/TDAG/CPE_PROP_UNIT_PART	MEINS	UNIT	3	0	Unit of Proportion (Part)	T006
36	PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART		QUAN	17	7	Mean Weight of Declarable Substance (Part)
37	PART_WUNIT	☐	/TDAG/CPE_MASS_UNIT_PART	MEINS	UNIT	3	0	Unit of Mass (Part)	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPT_DEC_IN	AENNR	AENR	AENNR	REF	1	CN
2	/TDAG/CPT_DEC_IN	MANDT	T000	MANDT
3	/TDAG/CPT_DEC_IN	PART_VUNIT	T006	MSEHI	REF	1	CN
4	/TDAG/CPT_DEC_IN	PART_WUNIT	T006	MSEHI	REF	1	CN
5	/TDAG/CPT_DEC_IN	SRSID	TCG56	SRSID	REF	1	CN
6	/TDAG/CPT_DEC_IN	VUNIT	T006	MSEHI	REF	1	CN
7	/TDAG/CPT_DEC_IN	WUNIT	T006	MSEHI	REF	1	CN

History

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