SAP ABAP Table /TDAG/CPT_DECSUB (CP: Declarable 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 TRANSP    Transparent table 
Transparent table /TDAG/CPT_DECSUB   Table Relationship Diagram
Short Description CP: Declarable Substances    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   EHS: Structure for key info of master data  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 RECN ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
4 ACTN ESEACTN ESDACTN NUMC 20   0   Sequential Number of the Change State  
5 .INCLUDE       0   0   EHS: Structure for General Administration Information  
6 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
7 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
8 AENNR ESEAENNR AENNR CHAR 12   0   Change Number AENR
9 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
10 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
11 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
12 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
13 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
14 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
15 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data TCG56
16 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider *
17 RECNROOT ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
18 .INCLUDE       0   0   CP: Declarable database table fields  
19 REGLIST /TDAG/CPE_REGLIST /TDAG/CPD_REGLIST CHAR 20   0   Regulatory/Customer List /TDAG/CPC_SREG
20 SUBST_RECN /TDAG/CPE_SUBST_RECN ESDRECN NUMC 20   0   Internal Substance Key  
21 HOMOGMAT_RECN /TDAG/CPE_HOMRECN ESDRECN NUMC 20   0   Internal Key of Homogeneous Material  
22 HOMOGMAT_NAME /TDAG/CPE_HOMNAM TEXT40 CHAR 40   0   Homogeneous Material Name  
23 VALUE /TDAG/CPE_DECSVAVG /TDAG/CPD_DECSV QUAN 15   7   Mean Value for Declarable Substance (Part)  
24 VALUEMIN /TDAG/CPE_DECSVMIN /TDAG/CPD_DECSV QUAN 15   7   Minimum Value for Declarable Substance  
25 VALUEMAX /TDAG/CPE_DECSVMAX /TDAG/CPD_DECSV QUAN 15   7   Maximum Value for Declarable Substance  
26 VUNIT /TDAG/CPE_PROP_UNIT MEINS UNIT 3   0   Unit of Proportion T006
27 WEIGHT /TDAG/CPE_DECSMAVG   QUAN 17   7   Mean Weight of Declarable Substance  
28 WUNIT /TDAG/CPE_MASS_UNIT MEINS UNIT 3   0   Unit of Mass T006
29 CONTAINED /TDAG/CPE_DECSCONT /TDAG/CPD_DECSCONT CHAR 3   0   Contained Substance  
30 REMARK /TDAG/CPE_DECSREM TEXT80 CHAR 80   0   Remark  
31 ORIGIN /TDAG/CPE_DECSORIGIN /TDAG/CPD_DECSORIGIN CHAR 1   0   Source of Declarable Substance  
32 EXEMPTION /TDAG/CPE_EXEMPT /TDAG/CPD_EXEMPT CHAR 10   0   Exemption /TDAG/CPC_SREGEX
33 CLASS /TDAG/CPE_CLASSIFICATION /TDAG/CPD_CLASSIFICATION CHAR 1   0   Classification for compliance /TDAG/CPC_CLASS
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /TDAG/CPT_DECSUB AENNR AENR AENNR REF 1 CN
2 /TDAG/CPT_DECSUB CLASS /TDAG/CPC_CLASS CLASS REF 1 CN
3 /TDAG/CPT_DECSUB EXEMPTION /TDAG/CPC_SREGEX EXEMPTION REF 1 CN
4 /TDAG/CPT_DECSUB MANDT T000 MANDT KEY 1 CN
5 /TDAG/CPT_DECSUB REGLIST /TDAG/CPC_SREG REGLIST REF 1 CN
6 /TDAG/CPT_DECSUB SRSID TCG56 SRSID REF 1 CN
7 /TDAG/CPT_DECSUB VUNIT T006 MSEHI REF 1 N
8 /TDAG/CPT_DECSUB WUNIT T006 MSEHI REF 1 N
History
Last changed by/on SAP  20141109 
SAP Release Created in 0207B0406C