SAP ABAP Table EHS00S_SRV_EXA (Structure: Individual Examinations for the Medical Service)
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 | INTTAB | Structure |
Structure | EHS00S_SRV_EXA | Table Relationship Diagram |
Short Description | Structure: Individual Examinations for the Medical Service |
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 | Individual Examinations in a Medical Service | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | SRV_NUMBER | EHS00_SRVNUMBER | NUMC12 | NUMC | 12 | 0 | Number of Medical Service | T7EHS00_SERVICE | |
4 | EXAM_GROUP | EHS00_EGROUP | NUMC02 | NUMC | 2 | 0 | Examination Category | T7EHS00_EGROUP | |
5 | EXAM_CODE | EHS00_ECODE | CHAR17 | CHAR | 17 | 0 | Examination Number | T7EHS00_EXAM | |
6 | EXAM_COUNT | EHS00_EXAMCOUNT | NUMC04 | NUMC | 4 | 0 | Number of Individual Examinations | ||
7 | SRV_EXAM_DATE | EHS00_SRV_EXADATE | DATUM | DATS | 8 | 0 | Examination Date | ||
8 | SRV_EXAM_TIME | EHS00_SRV_EXATIME | SYTIME | TIMS | 6 | 0 | Time of Examination | ||
9 | SRV_EXAM_PRFLG | EHS00_EXA_PRFLG | XFLAG | CHAR | 1 | 0 | Date an Examination Was Checked and Locked | ||
10 | SRV_EXAM_IMFLG | EHS00_EXA_IMFLG | XFLAG | CHAR | 1 | 0 | Data for an Examination Imported | ||
11 | SRV_EXAM_RES | EHS00_SRV_EXARES | CHAR01 | CHAR | 1 | 0 | Value Assignment of Examination Result | T7EHS00_EXA_RES | |
12 | SRV_EXAM_RESDATE | EHS00_SRV_ERESDAT | DATUM | DATS | 8 | 0 | Date of Examination Result | ||
13 | EXAM_INTERNAL | EHS00_EXA_EXINT | CHAR10 | CHAR | 10 | 0 | Internal Examiner in Medical Service | ||
14 | EXAM_EXTERNAL | EHS00_EXA_EXEXT | BU_PARTNER | CHAR | 10 | 0 | External Examiner in Medical Service | * | |
15 | EXAM_INTREF | EHS00_EXA_INTREF | TEXT20 | CHAR | 20 | 0 | Internal Reference for Examination Results | ||
16 | EXAM_EXTREF | EHS00_EXA_EXTREF | TEXT20 | CHAR | 20 | 0 | External Reference for Examination Results | ||
17 | EXAM_NEWFLAG | EHS00_EXA_NEWFLG | BOOLEAN | CHAR | 1 | 0 | New Examination - Added to Service | ||
18 | PNUMBER | EHS00_PNUMBER | CHAR3 | CHAR | 3 | 0 | Protocol Number | ||
19 | PGROUP | EHS00_PGROUP | EHS00_PGROUP | CHAR | 3 | 0 | Health Surveillance Protocol Category | * | |
20 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
21 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
22 | SRV_PROVIDER1 | CBOHCSE_SRV_PROVIDER1 | CHAR012 | CHAR | 12 | 0 | Service Provider (Work Center/Vendor) | ||
23 | RECN | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
24 | EXAM_PROVIDER | EHS00_EPROVIDER | BU_PARTNER | CHAR | 10 | 0 | Service Provider | * | |
25 | EXAM_PROVCODE | EHS00_ECODEEX | CHAR6 | CHAR | 6 | 0 | Examination | ||
26 | EGROUPNAM | EHS00_GROUPNAM | TEXT40 | CHAR | 40 | 0 | Description of Examination Category | ||
27 | ENAME | EHS00_ENAME | TEXT75 | CHAR | 75 | 0 | Name of Examination | ||
28 | EPROVNAM | EHS00_PROVNAM | TEXT80 | CHAR | 80 | 0 | Description of Service Provider | ||
29 | SRV_EXAM_RESTXT | EHS00_EXARESTXT | TEXT20 | CHAR | 20 | 0 | Value Assignment of Examination Result | ||
30 | EXAM_INTNAM | EHS00_EXA_INTNAM | TEXT80 | CHAR | 80 | 0 | Name of Internal Examiner | ||
31 | EXAM_EXTNAM | EHS00_EXA_EXTNAM | TEXT80 | CHAR | 80 | 0 | Name of External Examiner | ||
32 | PGFLG | EHS00_PGFLG | EHS00_PGFLG | CHAR | 2 | 0 | Delimitation of Health Surveillance Protocols | ||
33 | PNAME | EHS00_PNAME | TEXT40 | CHAR | 40 | 0 | Description of Health Surveillance Protocol |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EHS00S_SRV_EXA | EXAM_CODE | T7EHS00_EXAM | EXAM_CODE | KEY | ||
2 | EHS00S_SRV_EXA | EXAM_GROUP | T7EHS00_EGROUP | EXAM_GROUP | KEY | ||
3 | EHS00S_SRV_EXA | MANDT | T000 | MANDT | |||
4 | EHS00S_SRV_EXA | SRV_EXAM_RES | T7EHS00_EXA_RES | SRV_ERES | REF | 1 | CN |
5 | EHS00S_SRV_EXA | SRV_NUMBER | T7EHS00_SERVICE | SRV_NUMBER | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |