SAP ABAP Table EHS00S_PCP_SEL (EHS: Selection Structure 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_SEL	Table Relationship Diagram
Short Description	EHS: Selection Structure 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	PERSON_ID	☐	EHS00_PERID	CHAR10	CHAR	10	0	Person Identification
2	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number
3	PERSON_GRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
4	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
5	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
6	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
7	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
8	NAMEOFGESCH	☐	CCIHE_GENDERTEXT	CHAR60	CHAR	60	0	Description of Gender
9	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
10	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
11	.INCLUDE	☐				0	0	EHS: Personnel Structure
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
14	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
15	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
16	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
17	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
18	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	*
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
20	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
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	.INCLUDE	☐				0	0	EHS: Selection Structure via Medical Data
27	HEALTHCENTRE	☐	EHS00_HEALTHCENTRE	BU_PARTNER	CHAR	10	0	Health Center	*
28	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
29	SRV_NUMBER_TO	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
30	SRV_OPENDATE	☐	EHS00_SRVBEGDA	DATUM	DATS	8	0	Date on Which a Medical Service Was Opened
31	SRV_OPENDATE_TO	☐	EHS00_SRVBEGDA	DATUM	DATS	8	0	Date on Which a Medical Service Was Opened
32	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
33	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
34	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
35	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
36	PGROUPNAM	☐	EHS00_PGROUPNAM	TEXT20	CHAR	20	0	Description of Health Surveillance Protocol Category
37	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
38	WITH_SERVICES	☐	EHS00E_WITH_SERVICES_FLG	ESDFLAG	CHAR	1	0	OH Search by HSP: Including HSPs with Service Assignment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_PCP_SEL	BTRTL	T001P	BTRTL
2	EHS00S_PCP_SEL	BUKRS	T001	BUKRS
3	EHS00S_PCP_SEL	ORGEH	T527X	ORGEH
4	EHS00S_PCP_SEL	PERSG	T501	PERSG
5	EHS00S_PCP_SEL	PERSK	T503K	PERSK
6	EHS00S_PCP_SEL	PGROUP	T7EHS00_PGROUP	PGROUP	KEY	1	CN
7	EHS00S_PCP_SEL	PNUMBER	T7EHS00_PROT	PNUMBER	KEY	1	CN
8	EHS00S_PCP_SEL	WERKS	T500P	PERSA

History

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