SAP ABAP Table EHS00S_PCP_DETAIL_IOT (EHS: Detail List for Planning Cockpit)

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_PCP_DETAIL_IOT	Table Relationship Diagram
Short Description	EHS: Detail List for Planning Cockpit

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	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
2	PERSON_MARK_FLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	.INCLUDE	☐				0	0	EHS: Hit List for Planning Cockpit
4	PERSON_ID	☐	EHS00_PERID	CHAR10	CHAR	10	0	Person Identification
5	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number
6	PERSON_GRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
7	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
8	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
9	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
10	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
11	NAMEOFGESCH	☐	CCIHE_GENDERTEXT	CHAR60	CHAR	60	0	Description of Gender
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
13	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
14	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
15	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	*
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
17	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
18	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
19	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
20	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
21	ORGTX	☐	ORGTX	TEXT25	CHAR	25	0	Short Text of Organizational Unit
22	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	*
23	PLSTX	☐	PLSTX	TEXT25	CHAR	25	0	Short Text of Position
24	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
25	STLTX	☐	STLTX	TEXT25	CHAR	25	0	Job Title
26	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
27	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
28	PERENQ	☐	ENQMODE	ENQMODE	CHAR	1	0	Lock mode
29	PERAUTH	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
30	HEALTHCENTRE	☐	EHS00_HEALTHCENTRE	BU_PARTNER	CHAR	10	0	Health Center	*
31	HEACENNAME	☐	EHS00_HEACENNAM	TEXT80	CHAR	80	0	Description of Health Center
32	ABSENT	☐	EHS00_ABSENT	CHAR6	CHAR	6	0	Employee Absence
33	SRV_MARK_FLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
34	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
35	SRV_APPCOUNT	☐	EHS00_SRVAPPCOUNT	NUMC04	NUMC	4	0	No. of Appointments
36	SRV_AUTH	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
37	SRV_SCHED_ENQ	☐	ENQMODE	ENQMODE	CHAR	1	0	Lock mode
38	SRV_SCHED_DATE	☐	EHS00_SRV_SDATE	DATUM	DATS	8	0	Date of Appointment at Health Center
39	SRV_SCHED_TIME	☐	EHS00_SRV_STIME	TIMES	TIMS	6	0	Time of Appointment
40	SRV_SCHED_DURA	☐	EHS00_SRV_SDURA	DEC_5	DEC	5	0	Appointment Duration
41	SRV_SCHED_APPSTA	☐	EHS00_SRV_SSTAT2	CHAR01	CHAR	1	0	Appointment confirmed
42	SRV_SCHED_STATUS	☐	EHS00_SRVSSCH	CHAR01	CHAR	1	0	Scheduling Status	T7EHS00_SRV_SCHS
43	SRV_PHYSICIAN	☐	EHS00_SRVPHYSICIAN	BU_PARTNER	CHAR	10	0	Physician Responsible	*
44	SRV_PHYSICIANT	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
45	SRV_PROTCOMMENT	☐	EHS00_SRV_STXT	TEXT132	CHAR	132	0	Comment on Date
46	SCH_STATUST	☐	EHS00_SRVSSCHT	TEXT30	CHAR	30	0	Description of Scheduling Status
47	PROT_MARK_FLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
48	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
49	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number
50	PROT_TYPE	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type	T7EHS00_FREQTYP
51	STATUS_SCHED	☐	EHS00_STAT_SCHED	XFLAG	CHAR	1	0	Service Available
52	LAST_SCHED	☐	EHS00_LAST_SCHED	DATUM	DATS	8	0	Last Scheduled Appointment for Health Surveillance Protocol
53	NEXT_SCHED	☐	EHS00_NEXT_SCHED	DATS	DATS	8	0	Next Due
54	STATUS_PROT	☐	EHS00_STAT_PROT	CHAR1	CHAR	1	0	Status of Assignment	T7EHS00_STATPR
55	BYHAND_FLAG	☐	EHS00_MANFLG	EHS00_MANFLG	CHAR	1	0	Perform
56	PGROUPNAM	☐	EHS00_PGROUPNAM	TEXT20	CHAR	20	0	Description of Health Surveillance Protocol Category
57	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
58	PROT_FRTYPNAM	☐	EHS00_FRTYPNAM	TEXT40	CHAR	40	0	Name of Examination Type
59	PROT_STATUSNAM	☐	EHS00_STAT_PROTT	TEXT50	CHAR	50	0	Description of Assignment Status
60	BYHAND_FLAGT	☐	EHS00_MANFLGT	TEXT20	CHAR	20	0	Perform
61	POWNER	☐	EHS00_POWNER	EHS00_POWNER	CHAR	20	0	Protocol Owner	*
62	POWNERNAM	☐	EHS00_POWNERNAM	TEXT40	CHAR	40	0	Owner Name
63	SRV_PROT_UDAT	☐	EHS00_SRV_PCLT	DATUM	DATS	8	0	Planned Examination Date
64	COUNTOPVU	☐	EHS00_COUNTOPVU	NUMC2	NUMC	2	0	Number of Non-Selected Open Protocols
65	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
66	SRV_HEALTHCENTRE	☐	EHS00E_SRV_HEALTHCENTRE	BU_PARTNER	CHAR	10	0	Health Center of Medical Service	BUT000
67	SRV_HEALTHCENTRET	☐	EHS00E_SRV_HEALTHCENTRE_TXT	TEXT80	CHAR	80	0	Description of Health Center of Medical Service
68	SRV_PHYSFLAG_INT	☐	EHS00E_INEXFLAG_APP_PHYS	EHS00D_INEXFLAG_APP_PHYS	CHAR	1	0	Internal Person

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_PCP_DETAIL_IOT	PGROUP	T7EHS00_PGROUP	PGROUP
2	EHS00S_PCP_DETAIL_IOT	PROT_TYPE	T7EHS00_FREQTYP	PROT_FRTYP
3	EHS00S_PCP_DETAIL_IOT	SRV_HEALTHCENTRE	BUT000	PARTNER
4	EHS00S_PCP_DETAIL_IOT	SRV_SCHED_STATUS	T7EHS00_SRV_SCHS	SCH_STATUS
5	EHS00S_PCP_DETAIL_IOT	STATUS_PROT	T7EHS00_STATPR	STATUS_PROT

History

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