SAP ABAP Table /TDAG/CPS_DECSUB_LST (CP: IO structure to display the list of declarable substance)
Hierarchy
☛
TDAGBCA (Software Component) TechniData Basic Components
⤷
EHS (Application Component) Environment, Health and Safety
⤷
/TDAG/CP (Package) Compliance for products
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_LST |
Table Relationship Diagram 
|
| Short Description | CP: IO structure to display the list of declarable substance |
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 |  ROW_NO |
/TDAG/CPE_ROWNUMBER | INT4 | INT4 | 10 | 0 | Row Number | ||
| 2 | CELLS_COLOR_TAB |
LVC_T_SCOL | TTYP | 0 | 0 | ||||
| 3 | CELLS_STYLE_TAB |
LVC_T_STYL | TTYP | 0 | 0 | ||||
| 4 | .INCLUDE |
0 | 0 | CP: Declarables with regulation information | |||||
| 5 | RECNROOT |
ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
| 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) | ||
| 35 | .INCLUDE |
0 | 0 | CP: Additional fields for declarable structures | |||||
| 36 | MODE |
ESEMODE | CHAR1 | CHAR | 1 | 0 | Processing Mode | ||
| 37 | LOCKMOD |
ESELOCKMOD | CHAR1 | CHAR | 1 | 0 | Lock Mode (Shared, Exclusive) | ||
| 38 | SPEC_ID |
/TDAG/CPE_PURESUBID | ESDSUBID | CHAR | 12 | 0 | Pure Substance ID | ||
| 39 | HOMOGMAT_SPEC_ID |
/TDAG/CPE_HOMSUBID | ESDSUBID | CHAR | 12 | 0 | Homogeneous Material ID | ||
| 40 | PROH |
/TDAG/CPE_PROHIBIT | /TDAG/CPD_FLG_01 | CHAR | 1 | 0 | Prohibited Substance | ||
| 41 | DECL |
/TDAG/CPE_DECLARE | /TDAG/CPD_FLG_01 | CHAR | 1 | 0 | Declarable Substance | ||
| 42 | THRE_NUM |
/TDAG/CPE_THRESHOLD_NUM | FLTP | FLTP | 16 | 16 | Threshold | ||
| 43 | THRE_TXT |
/TDAG/CPE_THRESHOLD | TEXT30 | CHAR | 30 | 0 | Threshold | ||
| 44 | THRE_UNIT |
/TDAG/CPE_THRE_UNIT | MEINS | UNIT | 3 | 0 | Unit (Threshold) | T006 | |
| 45 | EXCEED |
/TDAG/CPE_EXCEED | /TDAG/CPD_FLG_01 | CHAR | 1 | 0 | Thresholds Exceeded | ||
| 46 | .INCLUDE |
0 | 0 | CP: Normalized weight and proportion values of a declarable | |||||
| 47 | FLG_NORM |
ESEBOOLE | ESDBOOLE | CHAR | 1 | 0 | Truth Value | ||
| 48 | NORM_VALUEMIN |
/TDAG/CPE_DECSVMIN_NORM | FLTP | 16 | 16 | Norm. Minimum Proportion Value in % (Homogenous Material) | |||
| 49 | NORM_VALUE |
/TDAG/CPE_DECSVAVG_NORM | FLTP | 16 | 16 | Normalized Mean Proportion Value in % (Homogenous Material) | |||
| 50 | NORM_VALUEMAX |
/TDAG/CPE_DECSVMAX_NORM | FLTP | 16 | 16 | Norm. Maximum Proportion Value in % (Homogenous Material) | |||
| 51 | NORM_WEIGHT |
/TDAG/CPE_DECSMAVG_NORM | FLTP | 16 | 16 | Normalized Mean Weight in Grams (Homogenous Material) | |||
| 52 | NORM_VALUEMIN_IN_PART |
/TDAG/CPE_DECSVMIN_PART_NORM | FLTP | 16 | 16 | Norm. Minimum Proportion Value in % (Part) | |||
| 53 | NORM_VALUE_IN_PART |
/TDAG/CPE_DECSVAVG_PART_NORM | FLTP | 16 | 16 | Normalized Mean Proportion Value in % (Part) | |||
| 54 | NORM_VALUEMAX_IN_PART |
/TDAG/CPE_DECSVMAX_PART_NORM | FLTP | 16 | 16 | Normalized Maximum Proportion Value in % (Part) | |||
| 55 | NORM_PART_WEIGHT |
/TDAG/CPE_DECSMAVG_PART_NORM | FLTP | 16 | 16 | Normalized Mean Weight in Grams (Part) | |||
| 56 | MATCAT |
/TDAG/CPE_MATCAT | /TDAG/CPD_MATCAT | CHAR | 12 | 0 | Material Category | * | |
| 57 | FLG_REL_CHANGE |
ESEESNTFLG | ESDFLAG | CHAR | 1 | 0 | Relevant Change Has Been Made | ||
| 58 | EXCEED_PART |
/TDAG/CPE_EXCEED_PART | /TDAG/CPD_FLG_EXCEED | CHAR | 1 | 0 | Threshold Exceeded (Part) | ||
| 59 | HOMOGMAT_RECNOLD |
/TDAG/CPE_HOMRECN | ESDRECN | NUMC | 20 | 0 | Internal Key of Homogeneous Material | ||
| 60 | HOMOGMAT_NAMEOLD |
/TDAG/CPE_HOMNAM | TEXT40 | CHAR | 40 | 0 | Homogeneous Material Name | ||
| 61 | PART_RECNOLD |
/TDAG/CPE_PART_RECN | ESDRECN | NUMC | 20 | 0 | Internal Key of Part | ||
| 62 | PART_NAMEOLD |
/TDAG/CPE_PART_NAME | TEXT40 | CHAR | 40 | 0 | Part Name | ||
| 63 | CONTAINED_TXT |
/TDAG/CPE_DECSCONT_TXT | /TDAG/CPD_DECSCONT_TXT | STRG | 0 | 0 | Contained Substance Description | ||
| 64 | SUBST_NAME |
ESEIDENT | TEXT132 | CHAR | 132 | 0 | Identifier | ||
| 65 | EXEMPTCODE |
/TDAG/CPE_EXEMPTCODE | TEXT40 | CHAR | 40 | 0 | Exemption Code | ||
| 66 | EXEMPT_PHR |
ESEPHRKEY | CHAR21 | CHAR | 21 | 0 | Phrase Library with Phrase Key |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /TDAG/CPS_DECSUB_LST | CLASS |  /TDAG/CPC_CLASS |
CLASS |
REF | 1 | CN |
| 2 | /TDAG/CPS_DECSUB_LST | EXEMPTION | /TDAG/CPC_SREGEX |
EXEMPTION |
KEY | 1 | CN |
| 3 | /TDAG/CPS_DECSUB_LST | PART_VUNIT | T006 |
MSEHI |
KEY | 1 | CN |
| 4 | /TDAG/CPS_DECSUB_LST | PART_WUNIT | T006 |
MSEHI |
REF | 1 | CN |
| 5 | /TDAG/CPS_DECSUB_LST | REGLIST | /TDAG/CPC_SREG |
REGLIST |
KEY | 1 | N |
| 6 | /TDAG/CPS_DECSUB_LST | THRE_UNIT | T006 |
MSEHI |
REF | 1 | CN |
| 7 | /TDAG/CPS_DECSUB_LST | VUNIT | T006 |
MSEHI |
KEY | 1 | N |
| 8 | /TDAG/CPS_DECSUB_LST | WUNIT | T006 |
MSEHI |
KEY | 1 | N |
History
| Last changed by/on | SAP | 20141109 |
| SAP Release Created in | 0207B0406C |
