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