SAP ABAP Table /TDAG/CPS_DECSUB_ERROR (CP: Declarable substances with error information)

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_DECSUB_ERROR	Table Relationship Diagram
Short Description	CP: Declarable substances with error information

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	.INCLUDE	☐				0	0	EHS: Standard Fields for EHS API Structures
2	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
3	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
4	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
5	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
6	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
7	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
8	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
9	.INCLUDE	☐				0	0	CP: Buffer structure for declareable substances
10	.INCLUDE	☐				0	0	CP: Declarable Substances
11	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
14	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
15	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
16	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
17	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
18	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
19	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
20	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
21	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
22	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
23	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
24	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
25	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
26	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
27	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
28	.INCLUDE	☐				0	0	CP: Declarable database table fields
29	REGLIST	☐	/TDAG/CPE_REGLIST	/TDAG/CPD_REGLIST	CHAR	20	0	Regulatory/Customer List	/TDAG/CPC_SREG
30	SUBST_RECN	☐	/TDAG/CPE_SUBST_RECN	ESDRECN	NUMC	20	0	Internal Substance Key
31	HOMOGMAT_RECN	☐	/TDAG/CPE_HOMRECN	ESDRECN	NUMC	20	0	Internal Key of Homogeneous Material
32	HOMOGMAT_NAME	☐	/TDAG/CPE_HOMNAM	TEXT40	CHAR	40	0	Homogeneous Material Name
33	VALUE	☐	/TDAG/CPE_DECSVAVG	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
34	VALUEMIN	☐	/TDAG/CPE_DECSVMIN	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance
35	VALUEMAX	☐	/TDAG/CPE_DECSVMAX	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance
36	VUNIT	☐	/TDAG/CPE_PROP_UNIT	MEINS	UNIT	3	0	Unit of Proportion	T006
37	WEIGHT	☐	/TDAG/CPE_DECSMAVG		QUAN	17	7	Mean Weight of Declarable Substance
38	WUNIT	☐	/TDAG/CPE_MASS_UNIT	MEINS	UNIT	3	0	Unit of Mass	T006
39	CONTAINED	☐	/TDAG/CPE_DECSCONT	/TDAG/CPD_DECSCONT	CHAR	3	0	Contained Substance
40	REMARK	☐	/TDAG/CPE_DECSREM	TEXT80	CHAR	80	0	Remark
41	ORIGIN	☐	/TDAG/CPE_DECSORIGIN	/TDAG/CPD_DECSORIGIN	CHAR	1	0	Source of Declarable Substance
42	EXEMPTION	☐	/TDAG/CPE_EXEMPT	/TDAG/CPD_EXEMPT	CHAR	10	0	Exemption	/TDAG/CPC_SREGEX
43	CLASS	☐	/TDAG/CPE_CLASSIFICATION	/TDAG/CPD_CLASSIFICATION	CHAR	1	0	Classification for compliance	/TDAG/CPC_CLASS
44	.INCLUDE	☐				0	0	CP: Buffer structure for declareable substances, dependent
45	PART_RECN	☐	/TDAG/CPE_PART_RECN	ESDRECN	NUMC	20	0	Internal Key of Part
46	PART_NAME	☐	/TDAG/CPE_PART_NAME	TEXT40	CHAR	40	0	Part Name
47	VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART	/TDAG/CPD_DECSV	QUAN	15	7	Mean Value for Declarable Substance (Part)
48	VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART	/TDAG/CPD_DECSV	QUAN	15	7	Minimum Value for Declarable Substance (Part)
49	VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART	/TDAG/CPD_DECSV	QUAN	15	7	Maximum Value for Declarable Substance (Part)
50	PART_VUNIT	☐	/TDAG/CPE_PROP_UNIT_PART	MEINS	UNIT	3	0	Unit of Proportion (Part)	T006
51	PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART		QUAN	17	7	Mean Weight of Declarable Substance (Part)
52	PART_WUNIT	☐	/TDAG/CPE_MASS_UNIT_PART	MEINS	UNIT	3	0	Unit of Mass (Part)	T006
53	FLG_AGAINST_PART	☐	/TDAG/CPE_AGAINST_PART	/TDAG/CPD_FLG_01	CHAR	1	0	Check Against Part
54	FLG_GROUP	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
55	GROUP_ID	☐	/TDAG/CPE_ORD	NUMC6	NUMC	6	0	Order
56	FLG_GROUP_ALT	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
57	.INCLUDE	☐				0	0	CP: Additional fields for declarable structures
58	MODE	☐	ESEMODE	CHAR1	CHAR	1	0	Processing Mode
59	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
60	SPEC_ID	☐	/TDAG/CPE_PURESUBID	ESDSUBID	CHAR	12	0	Pure Substance ID
61	HOMOGMAT_SPEC_ID	☐	/TDAG/CPE_HOMSUBID	ESDSUBID	CHAR	12	0	Homogeneous Material ID
62	PROH	☐	/TDAG/CPE_PROHIBIT	/TDAG/CPD_FLG_01	CHAR	1	0	Prohibited Substance
63	DECL	☐	/TDAG/CPE_DECLARE	/TDAG/CPD_FLG_01	CHAR	1	0	Declarable Substance
64	THRE_NUM	☐	/TDAG/CPE_THRESHOLD_NUM	FLTP	FLTP	16	16	Threshold
65	THRE_TXT	☐	/TDAG/CPE_THRESHOLD	TEXT30	CHAR	30	0	Threshold
66	THRE_UNIT	☐	/TDAG/CPE_THRE_UNIT	MEINS	UNIT	3	0	Unit (Threshold)	T006
67	EXCEED	☐	/TDAG/CPE_EXCEED	/TDAG/CPD_FLG_01	CHAR	1	0	Thresholds Exceeded
68	.INCLUDE	☐				0	0	CP: Normalized weight and proportion values of a declarable
69	FLG_NORM	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
70	NORM_VALUEMIN	☐	/TDAG/CPE_DECSVMIN_NORM		FLTP	16	16	Norm. Minimum Proportion Value in % (Homogenous Material)
71	NORM_VALUE	☐	/TDAG/CPE_DECSVAVG_NORM		FLTP	16	16	Normalized Mean Proportion Value in % (Homogenous Material)
72	NORM_VALUEMAX	☐	/TDAG/CPE_DECSVMAX_NORM		FLTP	16	16	Norm. Maximum Proportion Value in % (Homogenous Material)
73	NORM_WEIGHT	☐	/TDAG/CPE_DECSMAVG_NORM		FLTP	16	16	Normalized Mean Weight in Grams (Homogenous Material)
74	NORM_VALUEMIN_IN_PART	☐	/TDAG/CPE_DECSVMIN_PART_NORM		FLTP	16	16	Norm. Minimum Proportion Value in % (Part)
75	NORM_VALUE_IN_PART	☐	/TDAG/CPE_DECSVAVG_PART_NORM		FLTP	16	16	Normalized Mean Proportion Value in % (Part)
76	NORM_VALUEMAX_IN_PART	☐	/TDAG/CPE_DECSVMAX_PART_NORM		FLTP	16	16	Normalized Maximum Proportion Value in % (Part)
77	NORM_PART_WEIGHT	☐	/TDAG/CPE_DECSMAVG_PART_NORM		FLTP	16	16	Normalized Mean Weight in Grams (Part)
78	MATCAT	☐	/TDAG/CPE_MATCAT	/TDAG/CPD_MATCAT	CHAR	12	0	Material Category	*
79	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_DECSUB_ERROR	AENNR	AENR	AENNR	REF	1	CN
2	/TDAG/CPS_DECSUB_ERROR	CLASS	/TDAG/CPC_CLASS	CLASS	REF	1	CN
3	/TDAG/CPS_DECSUB_ERROR	EXEMPTION	/TDAG/CPC_SREGEX	EXEMPTION	KEY	1	CN
4	/TDAG/CPS_DECSUB_ERROR	MANDT	T000	MANDT
5	/TDAG/CPS_DECSUB_ERROR	PART_VUNIT	T006	MSEHI	REF	1	CN
6	/TDAG/CPS_DECSUB_ERROR	PART_WUNIT	T006	MSEHI	REF	1	CN
7	/TDAG/CPS_DECSUB_ERROR	REGLIST	/TDAG/CPC_SREG	REGLIST	REF	1	CN
8	/TDAG/CPS_DECSUB_ERROR	SRSID	TCG56	SRSID	REF	1	CN
9	/TDAG/CPS_DECSUB_ERROR	THRE_UNIT	T006	MSEHI	REF	1	CN
10	/TDAG/CPS_DECSUB_ERROR	VUNIT	T006	MSEHI	REF	1	CN
11	/TDAG/CPS_DECSUB_ERROR	WUNIT	T006	MSEHI	REF	1	CN

History

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