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

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