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