SAP ABAP Table HSMT_DN (EHS: Hazardous Substance Addit. Data 2 (Numeric Type))
Hierarchy
☛
SAP_ABA (Software Component) Cross-Application Component
⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
⤷ CBEHS_HSM (Package) Hazardous Substance Master Data
⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
⤷ CBEHS_HSM (Package) Hazardous Substance Master Data
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | HSMT_DN | Table Relationship Diagram |
Short Description | EHS: Hazardous Substance Addit. Data 2 (Numeric Type) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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: Structure for Standard Key Fields in Master Data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | RECN | BASE_RECNGUID | SYSUUID | RAW | 16 | 0 | Data Record ID (GUID) | ||
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 | BASE_RECNGUID | SYSUUID | RAW | 16 | 0 | Data Record ID (GUID) | ||
18 | .INCLUDE | 0 | 0 | EHS: Data Structure for Haz. Subs. Addit. Data 2 (Num. Type) | |||||
19 | NUMTYPE | HSME_NUMTYPE | HSMD_NUMTYPE | CHAR | 6 | 0 | Numeric Value Type | HSMC_019 | |
20 | AVGVAL | HSME_AVGVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Target Value | ||
21 | AVGVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
22 | AVGDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
23 | LOWOP | HSME_OPLOW | HSMD_OPLOW | CHAR | 5 | 0 | Operator for Lower Limit of Interval | ||
24 | LOWVAL | HSME_LOWVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Lower Limit of Interval | ||
25 | LOWVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
26 | LOWDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
27 | UPPOP | HSME_OPUPP | HSMD_OPUPP | CHAR | 5 | 0 | Operator for Upper Limit of Interval | ||
28 | UPPVAL | HSME_UPPVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Upper Limit of Interval | ||
29 | UPPVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
30 | UPPDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
31 | UNIT | HSME_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure | T006 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HSMT_DN | AENNR | AENR | AENNR | REF | 1 | CN |
2 | HSMT_DN | MANDT | T000 | MANDT | 1 | CN | |
3 | HSMT_DN | NUMTYPE | HSMC_019 | NUMTYPE | REF | 1 | CN |
4 | HSMT_DN | SRSID | TCG56 | SRSID | REF | 1 | CN |
5 | HSMT_DN | UNIT | T006 | MSEHI | REF | 1 | CN |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 700 |