SAP ABAP View V7EHS00_SRVUNCLO (EHS: All Services Not Closed)

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

View Type	D	Database View
Database View	V7EHS00_SRVUNCLO
Short Description	EHS: All Services Not Closed
Root table	T7EHS00_SERVICE	Medical Service (Main Table)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T7EHS00_SERVICE	T7EHS00_SERVICE
2	T7EHS00_SRV_STA
3	T7EHS00_SRV_STAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T7EHS00_SRV_STA	MANDT	JL	EQ				0	0
2	T7EHS00_SERVICE	MANDT	JR	EQ			AND	0	0
3	T7EHS00_SRV_STA	SRV_STATUS	JL	EQ				0	0
4	T7EHS00_SERVICE	SRV_STATUS	JR	EQ			AND	0	0
5	T7EHS00_SRV_STA	MANDT	JL	EQ				0	0
6	T7EHS00_SRV_STAT	MANDT	JR	EQ			AND	0	0
7	T7EHS00_SRV_STA	SRV_STATUS	JL	EQ				0	0
8	T7EHS00_SRV_STAT	SRV_STATUS	JR	EQ			AND	0	0
9	T7EHS00_SERVICE	SRV_STATUS		NE	'4'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T7EHS00_SERVICE	MANDT		☐	MANDT	☐	Client
2	SRV_NUMBER	T7EHS00_SERVICE	SRV_NUMBER		☐	EHS00_SRVNUMBER	☐	Number of Medical Service
3	PERNR	T7EHS00_SERVICE	PERNR		☐	EHS00_PERNR	☐	Personnel number
4	HEALTHCENTRE	T7EHS00_SERVICE	HEALTHCENTRE		☐	EHS00_HEALTHCENTRE	☐	Health Center
5	SRV_TYPE	T7EHS00_SERVICE	SRV_TYPE		☐	EHS00_SRVTYPE	☐	Appointment Type of Medical Service
6	SRV_STATUS	T7EHS00_SERVICE	SRV_STATUS		☐	EHS00_SRVSTATUS	☐	Status of Medical Service
7	SRV_REVIEW	T7EHS00_SERVICE	SRV_REVIEW		☐	EHS00_SRVREVIEW	☐	Check Criterion
8	SRV_INFOPERS	T7EHS00_SERVICE	SRV_INFOPERS		☐	EHS00_SRVINFOPERS	☐	Person Informed About Examination Results
9	SRV_OPENDATE	T7EHS00_SERVICE	SRV_OPENDATE		☐	EHS00_SRVBEGDA	☐	Date on Which a Medical Service Was Opened
10	SRV_SIGNOFFDATE	T7EHS00_SERVICE	SRV_SIGNOFFDATE		☐	EHS00_SIGNOFFDATE	☐	Sign-Off Date of Examination Cycle
11	SRV_CLOSUREDATE	T7EHS00_SERVICE	SRV_CLOSUREDATE		☐	EHS00_SRVENDDA	☐	Service Closed On
12	SRV_FOLLOWUP	T7EHS00_SERVICE	SRV_FOLLOWUP		☐	EHS00_FOLUPIND	☐	Follow-Up Activity for Medical Service
13	SRV_DECIND	T7EHS00_SERVICE	SRV_DECIND		☐	EHS00_DECIND	☐	Service Refused
14	SRV_REVFLAG	T7EHS00_SERVICE	SRV_REVFLAG		☐	EHS00_REVFLAG	☐	Reopen Service
15	SRV_REVDATE	T7EHS00_SERVICE	SRV_REVDATE		☐	EHS00_REVDATE	☐	Date Reopened
16	SRV_INVITPRI	T7EHS00_SERVICE	SRV_INVITPRI		☐	EHS00_INVITPRI	☐	Invitation to Examination Sent
17	SRV_PHYSICIAN	T7EHS00_SERVICE	SRV_PHYSICIAN		☐	EHS00_SRVPHYSICIAN	☐	Physician Responsible
18	PHYSFLAG	T7EHS00_SERVICE	PHYSFLAG		☐	EHS00_INEXFLAG	☐	Internal/External Person
19	SRV_DURA	T7EHS00_SERVICE	SRV_DURA		☐	EHS00_SRV_DURA	☐	Duration of Consultation in Minutes
20	COST_INT	T7EHS00_SERVICE	COST_INT		☐	EHS00_COSTINT	☐	Internal Costs
21	WAEHR_INT	T7EHS00_SERVICE	WAEHR_INT		☐	EHS00_WAERINT	☐	Costs Currency
22	DURATION_INT	T7EHS00_SERVICE	DURATION_INT		☐	EHS00_DURINT	☐	Internal Duration
23	COST_EXT	T7EHS00_SERVICE	COST_EXT		☐	EHS00_COSTEXT	☐	External Costs
24	WAEHR_EXT	T7EHS00_SERVICE	WAEHR_EXT		☐	EHS00_WAEREXT	☐	Costs Currency
25	DURATION_EXT	T7EHS00_SERVICE	DURATION_EXT		☐	EHS00_DUREXT	☐	External Duration
26	UNAME	T7EHS00_SERVICE	UNAME		☐	AENAM	☐	Name of Person Who Changed Object
27	AEDTM	T7EHS00_SERVICE	AEDTM		☐	AEDTM	☐	Changed on
28	SRV_PRESP	T7EHS00_SERVICE	SRV_PRESP		☐	EHS00_PRESP	☐	Service Provider/Person Responsible
29	RECNTOBJ	T7EHS00_SERVICE	RECNTOBJ		☐	ESERECN	☐	Sequential Number of Data Record
30	ACTNTOBJ	T7EHS00_SERVICE	ACTNTOBJ		☐	ESEACTN	☐	Sequential Number of the Change State
31	REFOBJ	T7EHS00_SERVICE	REFOBJ		☐	CCIHE_IHREFOBJ	☐	Reference Object
32	SPRAS	T7EHS00_SRV_STAT	SPRAS		☐	SPRAS	☐	Language Key
33	SRV_STATUST	T7EHS00_SRV_STAT	SRV_STATUST		☐	EHS00_SRVSTATUST	☐	Status of Medical Service

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	600