SAP ABAP Table T7EHS00_SERVICE (Medical Service (Main Table))

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	TRANSP	Transparent table
Transparent table	T7EHS00_SERVICE	Table Relationship Diagram
Short Description	Medical Service (Main Table)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

History

Last changed by/on	SAP	20130529
SAP Release Created in