SAP ABAP Table EHS00S_SERVICE (Structure: 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	EHS00S_SERVICE	Table Relationship Diagram
Short Description	Structure: 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	*
33	PERSON_ID	☐	EHS00_PERID	CHAR10	CHAR	10	0	Person Identification
34	PERSON_FLAG	☐	EHS00_PERSFLAG	EHS00_PERSFLAG	CHAR	1	0	Person Group: Employee / Applicant / External Person
35	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
36	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
37	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
38	SRV_STATUS_TXT	☐	EHS00_SRVSTATUST	TEXT25	CHAR	25	0	Status of Medical Service
39	SRV_TYPE_TXT	☐	EHS00_SRVTYPETXT	TEXT20	CHAR	20	0	Appointment Type of Medical Service
40	FB_CREATED	☐	EHS00_FBSTAT	BOOLEAN	CHAR	1	0	Status of Questionnaire in Medical Service
41	FB_COMPLETED	☐	EHS00_FBSTAT	BOOLEAN	CHAR	1	0	Status of Questionnaire in Medical Service
42	FB_SCANNED	☐	EHS00_FBSTAT	BOOLEAN	CHAR	1	0	Status of Questionnaire in Medical Service
43	FB_PRINTED	☐	EHS00_FBSTAT	BOOLEAN	CHAR	1	0	Status of Questionnaire in Medical Service
44	SRV_PHYSNAM	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
45	SRV_PHYSNAM_S	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
46	RB_NACHNAME	☐	EHS00_SRV_RNAM	XFLAG	CHAR	1	0	Radio button for last name
47	RB_PERNR	☐	EHS00_SRV_RPNR	XFLAG	CHAR	1	0	Radio button for personnel number
48	RB_SRVNUMBER	☐	EHS00_SRV_RSNR	XFLAG	CHAR	1	0	Radiobutton for Service Number
49	PROTINSRV	☐	EHS00_YESCRIT	BOOLEAN	CHAR	1	0	Question Answered with 'Yes'
50	SRV_HEACENNAM	☐	EHS00_HEACENNAM	TEXT80	CHAR	80	0	Description of Health Center
51	SRV_HEACENNAM_S	☐	EHS00_HEACENNAM	TEXT80	CHAR	80	0	Description of Health Center

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_SERVICE	MANDT	T000	MANDT
2	EHS00S_SERVICE	SRV_FOLLOWUP	T7EHS00_SRV_FOL	SRV_FOLL	REF	C	CN
3	EHS00S_SERVICE	SRV_REVIEW	T7EHS00_SRV_REV	SRV_REVIEW	REF	1	CN
4	EHS00S_SERVICE	SRV_STATUS	T7EHS00_SRV_STA	SRV_STATUS	REF	1	CN
5	EHS00S_SERVICE	SRV_TYPE	T7EHS00_SRV_TYP	SRV_TYPE	REF	1	CN
6	EHS00S_SERVICE	WAEHR_EXT	TCURC	WAERS
7	EHS00S_SERVICE	WAEHR_INT	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in