SAP ABAP Table HSMS_DNBUF (EHS: Buffer Hazardous Substance Addit. Data 2 (Numeric Type))
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-HSM (Application Component) Hazardous Substance Management
⤷ CBHS (Package) Hazardous Substance Management
⤷ EHS-HSM (Application Component) Hazardous Substance Management
⤷ CBHS (Package) Hazardous Substance Management
Basic Data
Table Category | INTTAB | Structure |
Structure | HSMS_DNBUF | Table Relationship Diagram |
Short Description | EHS: Buffer Hazardous Substance Addit. Data 2 (Numeric Type) |
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 | EHS: Standard fields for buffer table | |||||
2 | VALFLG | ESEVALFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Data record is currently valid | ||
3 | CHCOFLG | ESECHCOFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Change number collision | ||
4 | LOCKMOD | ESELOCKMOD | CHAR1 | CHAR | 1 | 0 | Lock Mode (Shared, Exclusive) | ||
5 | LOGLOCKMOD | ESELGLCKMD | CHAR1 | CHAR | 1 | 0 | Logical Lock Mode | ||
6 | SAVEMOD | ESESAVEMOD | CHAR1 | CHAR | 1 | 0 | Processing type when saving: INSERT, UPDATE, DELETE | ||
7 | SPLIT | ESESPLIT | ESDSPLIT | CHAR | 1 | 0 | Record Split Indicator of a Buffer Record | ||
8 | BUF_ORIG_INDEX | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
9 | CHANGENO | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | * | |
10 | KEYDATE | ESEDIAGVD | DATUM | DATS | 8 | 0 | Key Date | ||
11 | .INCLUDE | 0 | 0 | EHS: Hazardous Substance Addit. Data 2 (Numeric Type) | |||||
12 | .INCLUDE | 0 | 0 | EHS: Structure for Standard Key Fields in Master Data | |||||
13 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
14 | RECN | BASE_RECNGUID | SYSUUID | RAW | 16 | 0 | Data Record ID (GUID) | ||
15 | ACTN | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
16 | .INCLUDE | 0 | 0 | EHS: Structure for General Administration Information | |||||
17 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
18 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
19 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
20 | DELFLG | ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
21 | PARKFLG | ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
22 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
23 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
24 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
25 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
26 | SRSID | ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
27 | OWNID | ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
28 | RECNROOT | BASE_RECNGUID | SYSUUID | RAW | 16 | 0 | Data Record ID (GUID) | ||
29 | .INCLUDE | 0 | 0 | EHS: Data Structure for Haz. Subs. Addit. Data 2 (Num. Type) | |||||
30 | NUMTYPE | HSME_NUMTYPE | HSMD_NUMTYPE | CHAR | 6 | 0 | Numeric Value Type | HSMC_019 | |
31 | AVGVAL | HSME_AVGVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Target Value | ||
32 | AVGVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
33 | AVGDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
34 | LOWOP | HSME_OPLOW | HSMD_OPLOW | CHAR | 5 | 0 | Operator for Lower Limit of Interval | ||
35 | LOWVAL | HSME_LOWVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Lower Limit of Interval | ||
36 | LOWVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
37 | LOWDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
38 | UPPOP | HSME_OPUPP | HSMD_OPUPP | CHAR | 5 | 0 | Operator for Upper Limit of Interval | ||
39 | UPPVAL | HSME_UPPVAL | HSMD_NUMVAL | FLTP | 16 | 16 | Upper Limit of Interval | ||
40 | UPPVALFLG | HSME_FLGVAL | ESDBOOLE | CHAR | 1 | 0 | Value Exists | ||
41 | UPPDEC | HSME_NUMDEC | INT4 | INT4 | 10 | 0 | Number of Decimal Places | ||
42 | 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 | HSMS_DNBUF | AENNR | AENR | AENNR | KEY | 1 | CN |
2 | HSMS_DNBUF | MANDT | T000 | MANDT | |||
3 | HSMS_DNBUF | NUMTYPE | HSMC_019 | NUMTYPE | 1 | N | |
4 | HSMS_DNBUF | SRSID | TCG56 | SRSID | KEY | 1 | CN |
5 | HSMS_DNBUF | UNIT | T006 | MSEHI | 1 | N |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |