SAP ABAP Table /TDAG/CPS_IMDECSUB (Import Declareable Substances)

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_IMDECSUB	Table Relationship Diagram
Short Description	Import Declareable Substances

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	EXTID	☐	/TDAG/CPE_EXTID	ESDRECN	NUMC	20	0	External ID
2	EXTID_SUB	☐	/TDAG/CPE_EXTID	ESDRECN	NUMC	20	0	External ID
3	EXTID_MAT	☐	/TDAG/CPE_EXTID	ESDRECN	NUMC	20	0	External ID
4	EXTID_PART	☐	/TDAG/CPE_EXTID	ESDRECN	NUMC	20	0	External ID
5	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
6	.INCLUDE	☐				0	0	CP: Declarable database table fields
7	REGLIST	☐	/TDAG/CPE_REGLIST	/TDAG/CPD_REGLIST	CHAR	20	0	Regulatory/Customer List	/TDAG/CPC_SREG
8	SUBST_RECN	☐	/TDAG/CPE_SUBST_RECN	ESDRECN	NUMC	20	0	Internal Substance Key
9	HOMOGMAT_RECN	☐	/TDAG/CPE_HOMRECN	ESDRECN	NUMC	20	0	Internal Key of Homogeneous Material
10	HOMOGMAT_NAME	☐	/TDAG/CPE_HOMNAM	TEXT40	CHAR	40	0	Homogeneous Material Name
11	VALUE	☐	/TDAG/CPE_DECSVAVG	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
12	VALUEMIN	☐	/TDAG/CPE_DECSVMIN	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance
13	VALUEMAX	☐	/TDAG/CPE_DECSVMAX	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance
14	VUNIT	☐	/TDAG/CPE_PROP_UNIT	MEINS	UNIT	3	0	Unit of Proportion	T006
15	WEIGHT	☐	/TDAG/CPE_DECSMAVG		QUAN	17	7	Mean Weight of Declarable Substance
16	WUNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	T006
17	CONTAINED	☐	/TDAG/CPE_DECSCONT	/TDAG/CPD_DECSCONT	CHAR	3	0	Contained Substance
18	REMARK	☐	/TDAG/CPE_DECSREM	TEXT80	CHAR	80	0	Remark
19	ORIGIN	☐	/TDAG/CPE_DECSORIGIN	/TDAG/CPD_DECSORIGIN	CHAR	1	0	Source of Declarable Substance
20	EXEMPTION	☐	/TDAG/CPE_EXEMPT	/TDAG/CPD_EXEMPT	CHAR	10	0	Exemption	/TDAG/CPC_SREGEX
21	CLASS	☐	/TDAG/CPE_CLASSIFICATION	/TDAG/CPD_CLASSIFICATION	CHAR	1	0	Classification for compliance	/TDAG/CPC_CLASS
22	.INCLUDE	☐				0	0	CP: Buffer structure for declareable substances, dependent
23	PART_RECN	☐	/TDAG/CPE_PART_RECN	ESDRECN	NUMC	20	0	Internal Key of Part
24	PART_NAME	☐	/TDAG/CPE_PART_NAME	TEXT40	CHAR	40	0	Part Name
25	VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
26	VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance (Part)
27	VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance (Part)
28	PART_VUNIT	☐	/TDAG/CPE_PROP_UNIT_PART	MEINS	UNIT	3	0	Unit of Proportion (Part)	T006
29	PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART		QUAN	17	7	Mean Weight of Declarable Substance (Part)
30	PART_WUNIT	☐	/TDAG/CPE_MASS_UNIT_PART	MEINS	UNIT	3	0	Unit of Mass (Part)	T006
31	FLG_AGAINST_PART	☐	/TDAG/CPE_AGAINST_PART	/TDAG/CPD_FLG_01	CHAR	1	0	Check Against Part
32	FLG_GROUP	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
33	GROUP_ID	☐	/TDAG/CPE_ORD	NUMC6	NUMC	6	0	Order
34	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/CPS_IMDECSUB	CLASS	/TDAG/CPC_CLASS	CLASS	REF	1	CN
2	/TDAG/CPS_IMDECSUB	EXEMPTION	/TDAG/CPC_SREGEX	EXEMPTION	REF	1	CN
3	/TDAG/CPS_IMDECSUB	PART_VUNIT	T006	MSEHI	REF	1	CN
4	/TDAG/CPS_IMDECSUB	PART_WUNIT	T006	MSEHI	REF	1	CN
5	/TDAG/CPS_IMDECSUB	REGLIST	/TDAG/CPC_SREG	REGLIST	KEY	1	N
6	/TDAG/CPS_IMDECSUB	VUNIT	T006	MSEHI	REF	1	CN
7	/TDAG/CPS_IMDECSUB	WUNIT	T006	MSEHI	KEY	1	N

History

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