SAP ABAP Table /TDAG/CPS_DECLARABLECHANGED (CP: Structure to describe a changed declarables entry)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_DECLARABLECHANGED	Table Relationship Diagram
Short Description	CP: Structure to describe a changed declarables entry

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CHANGE_MODE	☐	/TDAG/CPE_CHANGEMODE	CHAR1	CHAR	1	0	Change Mode
2	.INCLUDE	☐				0	0	CP: Declarables with regulation information
3	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	.INCLUDE	☐				0	0	CP: Declarable database table fields
5	REGLIST	☐	/TDAG/CPE_REGLIST	/TDAG/CPD_REGLIST	CHAR	20	0	Regulatory/Customer List	/TDAG/CPC_SREG
6	SUBST_RECN	☐	/TDAG/CPE_SUBST_RECN	ESDRECN	NUMC	20	0	Internal Substance Key
7	HOMOGMAT_RECN	☐	/TDAG/CPE_HOMRECN	ESDRECN	NUMC	20	0	Internal Key of Homogeneous Material
8	HOMOGMAT_NAME	☐	/TDAG/CPE_HOMNAM	TEXT40	CHAR	40	0	Homogeneous Material Name
9	VALUE	☐	/TDAG/CPE_DECSVAVG	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
10	VALUEMIN	☐	/TDAG/CPE_DECSVMIN	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance
11	VALUEMAX	☐	/TDAG/CPE_DECSVMAX	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance
12	VUNIT	☐	/TDAG/CPE_PROP_UNIT	MEINS	UNIT	3	0	Unit of Proportion	T006
13	WEIGHT	☐	/TDAG/CPE_DECSMAVG		QUAN	17	7	Mean Weight of Declarable Substance
14	WUNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	T006
15	CONTAINED	☐	/TDAG/CPE_DECSCONT	/TDAG/CPD_DECSCONT	CHAR	3	0	Contained Substance
16	REMARK	☐	/TDAG/CPE_DECSREM	TEXT80	CHAR	80	0	Remark
17	ORIGIN	☐	/TDAG/CPE_DECSORIGIN	/TDAG/CPD_DECSORIGIN	CHAR	1	0	Source of Declarable Substance
18	EXEMPTION	☐	/TDAG/CPE_EXEMPT	/TDAG/CPD_EXEMPT	CHAR	10	0	Exemption	/TDAG/CPC_SREGEX
19	CLASS	☐	/TDAG/CPE_CLASSIFICATION	/TDAG/CPD_CLASSIFICATION	CHAR	1	0	Classification for compliance	/TDAG/CPC_CLASS
20	.INCLUDE	☐				0	0	CP: Buffer structure for declareable substances, dependent
21	PART_RECN	☐	/TDAG/CPE_PART_RECN	ESDRECN	NUMC	20	0	Internal Key of Part
22	PART_NAME	☐	/TDAG/CPE_PART_NAME	TEXT40	CHAR	40	0	Part Name
23	VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
24	VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance (Part)
25	VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance (Part)
26	PART_VUNIT	☐	/TDAG/CPE_PROP_UNIT_PART	MEINS	UNIT	3	0	Unit of Proportion (Part)	*
27	PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART		QUAN	17	7	Mean Weight of Declarable Substance (Part)
28	PART_WUNIT	☐	/TDAG/CPE_MASS_UNIT_PART	MEINS	UNIT	3	0	Unit of Mass (Part)	T006
29	FLG_AGAINST_PART	☐	/TDAG/CPE_AGAINST_PART	/TDAG/CPD_FLG_01	CHAR	1	0	Check Against Part
30	FLG_GROUP	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
31	GROUP_ID	☐	/TDAG/CPE_ORD	NUMC6	NUMC	6	0	Order
32	FLG_GROUP_ALT	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
33	.INCLUDE	☐				0	0	CP: Additional fields for declarable structures
34	MODE	☐	ESEMODE	CHAR1	CHAR	1	0	Processing Mode
35	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
36	SPEC_ID	☐	/TDAG/CPE_PURESUBID	ESDSUBID	CHAR	12	0	Pure Substance ID
37	HOMOGMAT_SPEC_ID	☐	/TDAG/CPE_HOMSUBID	ESDSUBID	CHAR	12	0	Homogeneous Material ID
38	PROH	☐	/TDAG/CPE_PROHIBIT	/TDAG/CPD_FLG_01	CHAR	1	0	Prohibited Substance
39	DECL	☐	/TDAG/CPE_DECLARE	/TDAG/CPD_FLG_01	CHAR	1	0	Declarable Substance
40	THRE_NUM	☐	/TDAG/CPE_THRESHOLD_NUM	FLTP	FLTP	16	16	Threshold
41	THRE_TXT	☐	/TDAG/CPE_THRESHOLD	TEXT30	CHAR	30	0	Threshold
42	THRE_UNIT	☐	/TDAG/CPE_THRE_UNIT	MEINS	UNIT	3	0	Unit (Threshold)	T006
43	EXCEED	☐	/TDAG/CPE_EXCEED	/TDAG/CPD_FLG_01	CHAR	1	0	Thresholds Exceeded
44	.INCLUDE	☐				0	0	CP: Normalized weight and proportion values of a declarable
45	FLG_NORM	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
46	NORM_VALUEMIN	☐	/TDAG/CPE_DECSVMIN_NORM		FLTP	16	16	Norm. Minimum Proportion Value in % (Homogenous Material)
47	NORM_VALUE	☐	/TDAG/CPE_DECSVAVG_NORM		FLTP	16	16	Normalized Mean Proportion Value in % (Homogenous Material)
48	NORM_VALUEMAX	☐	/TDAG/CPE_DECSVMAX_NORM		FLTP	16	16	Norm. Maximum Proportion Value in % (Homogenous Material)
49	NORM_WEIGHT	☐	/TDAG/CPE_DECSMAVG_NORM		FLTP	16	16	Normalized Mean Weight in Grams (Homogenous Material)
50	NORM_VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART_NORM		FLTP	16	16	Norm. Minimum Proportion Value in % (Part)
51	NORM_VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART_NORM		FLTP	16	16	Normalized Mean Proportion Value in % (Part)
52	NORM_VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART_NORM		FLTP	16	16	Normalized Maximum Proportion Value in % (Part)
53	NORM_PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART_NORM		FLTP	16	16	Normalized Mean Weight in Grams (Part)
54	MATCAT	☐	/TDAG/CPE_MATCAT	/TDAG/CPD_MATCAT	CHAR	12	0	Material Category	*
55	FLG_REL_CHANGE	☐	ESEESNTFLG	ESDFLAG	CHAR	1	0	Relevant Change Has Been Made

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPS_DECLARABLECHANGED	CLASS	/TDAG/CPC_CLASS	CLASS	REF	1	CN
2	/TDAG/CPS_DECLARABLECHANGED	EXEMPTION	/TDAG/CPC_SREGEX	EXEMPTION	REF	1	CN
3	/TDAG/CPS_DECLARABLECHANGED	PART_WUNIT	T006	MSEHI	REF	1	CN
4	/TDAG/CPS_DECLARABLECHANGED	REGLIST	/TDAG/CPC_SREG	REGLIST	KEY	1	N
5	/TDAG/CPS_DECLARABLECHANGED	THRE_UNIT	T006	MSEHI	REF	1	CN
6	/TDAG/CPS_DECLARABLECHANGED	VUNIT	T006	MSEHI	KEY	1	N
7	/TDAG/CPS_DECLARABLECHANGED	WUNIT	T006	MSEHI	KEY	1	N

History

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