SAP ABAP Table EHS_SERVICE (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 | EHS_SERVICE | Table Relationship Diagram |
Short Description | 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 | Medical Service (Main Table) | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | SRV_NUMBER | EHS00_SRVNUMBER | NUMC12 | NUMC | 12 | 0 | Number of Medical Service | ||
4 | PERNR | EHS00_PERNR | EHS00_PERNR | NUMC | 8 | 0 | Personnel number | * | |
5 | HEALTHCENTRE | EHS00_HEALTHCENTRE | BU_PARTNER | CHAR | 10 | 0 | Health Center | * | |
6 | SRV_TYPE | EHS00_SRVTYPE | CHAR01 | CHAR | 1 | 0 | Appointment Type of Medical Service | T7EHS00_SRV_TYP | |
7 | SRV_STATUS | EHS00_SRVSTATUS | CHAR01 | CHAR | 1 | 0 | Status of Medical Service | T7EHS00_SRV_STA | |
8 | SRV_REVIEW | EHS00_SRVREVIEW | CHAR01 | CHAR | 1 | 0 | Check Criterion | T7EHS00_SRV_REV | |
9 | SRV_INFOPERS | EHS00_SRVINFOPERS | XFLAG | CHAR | 1 | 0 | Person Informed About Examination Results | ||
10 | SRV_OPENDATE | EHS00_SRVBEGDA | DATUM | DATS | 8 | 0 | Date on Which a Medical Service Was Opened | ||
11 | SRV_SIGNOFFDATE | EHS00_SIGNOFFDATE | DATUM | DATS | 8 | 0 | Sign-Off Date of Examination Cycle | ||
12 | SRV_CLOSUREDATE | EHS00_SRVENDDA | DATUM | DATS | 8 | 0 | Service Closed On | ||
13 | SRV_FOLLOWUP | EHS00_FOLUPIND | CHAR03 | CHAR | 3 | 0 | Follow-Up Activity for Medical Service | T7EHS00_SRV_FOL | |
14 | SRV_DECIND | EHS00_DECIND | XFLAG | CHAR | 1 | 0 | Service Refused | ||
15 | SRV_REVFLAG | EHS00_REVFLAG | XFLAG | CHAR | 1 | 0 | Reopen Service | ||
16 | SRV_REVDATE | EHS00_REVDATE | DATUM | DATS | 8 | 0 | Date Reopened | ||
17 | SRV_INVITPRI | EHS00_INVITPRI | XFLAG | CHAR | 1 | 0 | Invitation to Examination Sent | ||
18 | SRV_PHYSICIAN | EHS00_SRVPHYSICIAN | BU_PARTNER | CHAR | 10 | 0 | Physician Responsible | * | |
19 | PHYSFLAG | EHS00_INEXFLAG | EHS00_INEXFLAG | CHAR | 1 | 0 | Internal/External Person | ||
20 | SRV_DURA | EHS00_SRV_DURA | DEC_5 | DEC | 5 | 0 | Duration of Consultation in Minutes | * | |
21 | COST_INT | EHS00_COSTINT | WERT8 | CURR | 15 | 2 | Internal Costs | ||
22 | WAEHR_INT | EHS00_WAERINT | WAERS | CUKY | 5 | 0 | Costs Currency | TCURC | |
23 | DURATION_INT | EHS00_DURINT | DEC_5 | DEC | 5 | 0 | Internal Duration | ||
24 | COST_EXT | EHS00_COSTEXT | WERT8 | CURR | 15 | 2 | External Costs | ||
25 | WAEHR_EXT | EHS00_WAEREXT | WAERS | CUKY | 5 | 0 | Costs Currency | TCURC | |
26 | DURATION_EXT | EHS00_DUREXT | DEC_5 | DEC | 5 | 0 | External Duration | ||
27 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
28 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
29 | SRV_PRESP | EHS00_PRESP | EHS00_PARNR | CHAR | 10 | 0 | Service Provider/Person Responsible | ||
30 | RECNTOBJ | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
31 | ACTNTOBJ | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
32 | REFOBJ | CCIHE_IHREFOBJ | CCIHD_IHREFOBJ | CHAR | 3 | 0 | Reference Object | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EHS_SERVICE | MANDT | T000 | MANDT | |||
2 | EHS_SERVICE | SRV_FOLLOWUP | T7EHS00_SRV_FOL | SRV_FOLL | REF | C | CN |
3 | EHS_SERVICE | SRV_REVIEW | T7EHS00_SRV_REV | SRV_REVIEW | REF | 1 | CN |
4 | EHS_SERVICE | SRV_STATUS | T7EHS00_SRV_STA | SRV_STATUS | REF | 1 | CN |
5 | EHS_SERVICE | SRV_TYPE | T7EHS00_SRV_TYP | SRV_TYPE | REF | 1 | CN |
6 | EHS_SERVICE | WAEHR_EXT | TCURC | WAERS | |||
7 | EHS_SERVICE | WAEHR_INT | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |