SAP ABAP Table T7EHS00_EXA_LAB (Examination Results: Lab. Tests)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | T7EHS00_EXA_LAB | Table Relationship Diagram |
Short Description | Examination Results: Lab. Tests |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SRV_NUMBER | EHS00_SRVNUMBER | NUMC12 | NUMC | 12 | 0 | Number of Medical Service | T7EHS00_SRV_EXA | |
3 | EXAM_GROUP | EHS00_EGROUP | NUMC02 | NUMC | 2 | 0 | Examination Category | ||
4 | EXAM_CODE | EHS00_ECODE | CHAR17 | CHAR | 17 | 0 | Examination Number | ||
5 | EXAM_COUNT | EHS00_EXAMCOUNT | NUMC04 | NUMC | 4 | 0 | Number of Individual Examinations | ||
6 | TEST_NO | EHS00_TESTNO | CHAR08 | CHAR | 8 | 0 | Medical Test Number | T7EHS00_LABTEST | |
7 | TEST_VALUE | EHS00_PHYVAL | TEXT60 | CHAR | 60 | 0 | Physical Value of a Medical Test | ||
8 | UNIT | EHS00_RESULTUOM | MEINS | UNIT | 3 | 0 | Unit of Measurement of Result | T006 | |
9 | NORM_RANGE | EHS00_NORRANGE | TEXT60 | CHAR | 60 | 0 | Normal Range in Medical Tests | ||
10 | NORMAL_LOW | EHS00_RESULTNORMLOW | TEXT20 | CHAR | 20 | 0 | Lowest Normal Result | ||
11 | NORMAL_HIGH | EHS00_RESULTNORMHIGH | TEXT20 | CHAR | 20 | 0 | Highest Normal Result | ||
12 | TEST_RESULT | EHS00_TESTRES | CHAR02 | CHAR | 2 | 0 | Value Assignment of Test Result | T7EHS00_TESTRES | |
13 | NATURE_ABNORM1 | EHS00_NATABN1 | CHAR01 | CHAR | 1 | 0 | Reason for Significant Results (1) | T7EHS00_TESTAB1 | |
14 | NATURE_ABNORM2 | EHS00_NATABN2 | CHAR01 | CHAR | 1 | 0 | Reason for Significant Results (2) | T7EHS00_TESTAB1 | |
15 | RESULT_STATUS | EHS00_TRSTAT | CHAR01 | CHAR | 1 | 0 | Status of Test Result | T7EHS00_TRSTAT | |
16 | LAB_CODE | EHS00_LABCODE | TEXT8 | CHAR | 8 | 0 | Laboratory ID | ||
17 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
18 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | T7EHS00_EXA_LAB | MANDT | T000 | MANDT | KEY | 1 | CN |
2 | T7EHS00_EXA_LAB | NATURE_ABNORM1 | T7EHS00_TESTAB1 | NATURE_ABNORM | REF | C | CN |
3 | T7EHS00_EXA_LAB | NATURE_ABNORM2 | T7EHS00_TESTAB1 | NATURE_ABNORM | REF | C | CN |
4 | T7EHS00_EXA_LAB | RESULT_STATUS | T7EHS00_TRSTAT | RESULT_STATUS | REF | 1 | CN |
5 | T7EHS00_EXA_LAB | SRV_NUMBER | T7EHS00_SRV_EXA | SRV_NUMBER | KEY | 1 | CN |
6 | T7EHS00_EXA_LAB | TEST_NO | T7EHS00_LABTEST | TEST_NO | KEY | 1 | CN |
7 | T7EHS00_EXA_LAB | TEST_RESULT | T7EHS00_TESTRES | TEST_RESULT | REF | C | CN |
8 | T7EHS00_EXA_LAB | UNIT | T006 | MSEHI | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |