1. Home
  2. Resources
  3. SAP Tables
  4. EHS00S_PCP_DETAIL_IOT - EHS: Detail List for Planning Cockpit

SAP Table EHS00S_PCP_DETAIL_IOT

EHS: Detail List for Planning Cockpit

EHS00S_PCP_DETAIL_IOT (EHS: Detail List for Planning Cockpit) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EHS00S_PCP_DETAIL_IOT to other SAP tables.

EHS00S_PCP_DETAIL_IOT table fields

Field Data element Checktable Datatype Length Decimals
LINEMOD Processing status or mode of a record/step loop line ESELINEMOD CHAR 1 0
PERSON_MARK_FLG Row Is Selected ESEMARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PERSON_ID Person Identification EHS00_PERID CHAR 10 0
PERNR Personnel number EHS00_PERNR NUMC 8 0
PERSON_GRP Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
NACHN Last Name PAD_NACHN CHAR 40 0
VORNA First Name PAD_VORNA CHAR 40 0
GBDAT Date of Birth GBDAT DATS 8 0
GESCH Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
NAMEOFGESCH Description of Gender CCIHE_GENDERTEXT CHAR 60 0
BUKRS Company Code BUKRS CHAR 4 0
WERKS Personnel Area PERSA CHAR 4 0
PERSG Employee Group PERSG CHAR 1 0
VDSK1 Organizational Key VDSK1 CHAR 14 0
GSBER Business Area GSBER CHAR 4 0
PERSK Employee Subgroup PERSK CHAR 2 0
BTRTL Personnel Subarea BTRTL CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
ORGEH Organizational Unit ORGEH NUMC 8 0
ORGTX Short Text of Organizational Unit ORGTX CHAR 25 0
PLANS Position PLANS NUMC 8 0
PLSTX Position (Short Text) PLSTX CHAR 25 0
STELL Job STELL NUMC 8 0
STLTX Job Title STLTX CHAR 25 0
NATIO Nationality NATIO CHAR 15 0
NAMEOFNATIO Nationality NATIO CHAR 15 0
PERENQ Lock mode ENQMODE CHAR 1 0
E Write Lock
S Read Lock
X Exclusive, not cumulative
O Set Optimistic Lock
R Promote Optimistic Lock; Conversion from '0' to 'E'
U Only Collision Check Extended Write Lock, as with 'X'
V Only Collision Check Write Lock, as with 'E'
W Only Collision Check Read Lock, as with 'S'
C Only Promotion Check Opt. Lock, as with 'R'
T Reserved
+ Reserved
PERAUTH Activity category in SAP transaction AKTYP CHAR 1 0
HEALTHCENTRE Health Center EHS00_HEALTHCENTRE CHAR 10 0
HEACENNAME Description of Health Center EHS00_HEACENNAM CHAR 80 0
ABSENT Employee Absence EHS00_ABSENT CHAR 6 0
SRV_MARK_FLG Row Is Selected ESEMARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
SRV_NUMBER Number of Medical Service EHS00_SRVNUMBER NUMC 12 0
SRV_APPCOUNT No. of Appointments EHS00_SRVAPPCOUNT NUMC 4 0
SRV_AUTH Activity category in SAP transaction AKTYP CHAR 1 0
SRV_SCHED_ENQ Lock mode ENQMODE CHAR 1 0
E Write Lock
S Read Lock
X Exclusive, not cumulative
O Set Optimistic Lock
R Promote Optimistic Lock; Conversion from '0' to 'E'
U Only Collision Check Extended Write Lock, as with 'X'
V Only Collision Check Write Lock, as with 'E'
W Only Collision Check Read Lock, as with 'S'
C Only Promotion Check Opt. Lock, as with 'R'
T Reserved
+ Reserved
SRV_SCHED_DATE Date of Appointment at Health Center EHS00_SRV_SDATE DATS 8 0
SRV_SCHED_TIME Time of Appointment EHS00_SRV_STIME TIMS 6 0
SRV_SCHED_DURA Appointment Duration EHS00_SRV_SDURA DEC 5 0
SRV_SCHED_APPSTA Appointment confirmed EHS00_SRV_SSTAT2 CHAR 1 0
SRV_SCHED_STATUS Scheduling Status EHS00_SRVSSCH T7EHS00_SRV_SCHS CHAR 1 0
SRV_PHYSICIAN Physician Responsible EHS00_SRVPHYSICIAN CHAR 10 0
SRV_PHYSICIANT Physician/Health Center EHS00_PHYSICIANT CHAR 80 0
SRV_PROTCOMMENT Comment on Date EHS00_SRV_STXT CHAR 132 0
SCH_STATUST Description of Scheduling Status EHS00_SRVSSCHT CHAR 30 0
PROT_MARK_FLG Row Is Selected ESEMARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PGROUP Health Surveillance Protocol Category EHS00_PGROUP T7EHS00_PGROUP CHAR 3 0
PNUMBER Protocol Number EHS00_PNUMBER CHAR 3 0
PROT_TYPE Examination Type EHS00_FRTYP T7EHS00_FREQTYP CHAR 3 0
STATUS_SCHED Service Available EHS00_STAT_SCHED CHAR 1 0
NULL Blank
. Radio button
X Selection
LAST_SCHED Last Scheduled Appointment for Health Surveillance Protocol EHS00_LAST_SCHED DATS 8 0
NEXT_SCHED Next Due EHS00_NEXT_SCHED DATS 8 0
STATUS_PROT Status of Assignment EHS00_STAT_PROT T7EHS00_STATPR CHAR 1 0
BYHAND_FLAG Perform EHS00_MANFLG CHAR 1 0
I Yes
E No
A System default
PGROUPNAM Description of Health Surveillance Protocol Category EHS00_PGROUPNAM CHAR 20 0
PNAME Description of Health Surveillance Protocol EHS00_PNAME CHAR 40 0
PROT_FRTYPNAM Name of Examination Type EHS00_FRTYPNAM CHAR 40 0
PROT_STATUSNAM Description of Assignment Status EHS00_STAT_PROTT CHAR 50 0
BYHAND_FLAGT Perform EHS00_MANFLGT CHAR 20 0
POWNER Protocol Owner EHS00_POWNER CHAR 20 0
POWNERNAM Owner Name EHS00_POWNERNAM CHAR 40 0
SRV_PROT_UDAT Planned Examination Date EHS00_SRV_PCLT DATS 8 0
COUNTOPVU Number of Non-Selected Open Protocols EHS00_COUNTOPVU NUMC 2 0
CELLTAB LVC_T_STYL TTYP 0 0
SRV_HEALTHCENTRE Health Center of Medical Service EHS00E_SRV_HEALTHCENTRE BUT000 CHAR 10 0
SRV_HEALTHCENTRET Description of Health Center of Medical Service EHS00E_SRV_HEALTHCENTRE_TXT CHAR 80 0
SRV_PHYSFLAG_INT Internal Person EHS00E_INEXFLAG_APP_PHYS CHAR 1 0
NULL External Partner
X Internal Person

EHS00S_PCP_DETAIL_IOT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EHS00S_PCP_DETAIL_IOT PGROUP SYST MANDT T7EHS00_PGROUP Protocol Categories MANDT
EHS00S_PCP_DETAIL_IOT PGROUP EHS00S_PCP_DETAIL_IOT PGROUP T7EHS00_PGROUP Protocol Categories PGROUP
EHS00S_PCP_DETAIL_IOT PROT_TYPE SYST MANDT T7EHS00_FREQTYP Examination Type / Frequency Type MANDT
EHS00S_PCP_DETAIL_IOT PROT_TYPE EHS00S_PCP_DETAIL_IOT PROT_TYPE T7EHS00_FREQTYP Examination Type / Frequency Type PROT_FRTYP
EHS00S_PCP_DETAIL_IOT SRV_HEALTHCENTRE SYST MANDT BUT000 BP: General data I CLIENT
EHS00S_PCP_DETAIL_IOT SRV_HEALTHCENTRE EHS00S_PCP_DETAIL_IOT SRV_HEALTHCENTRE BUT000 BP: General data I PARTNER
EHS00S_PCP_DETAIL_IOT SRV_SCHED_STATUS EHS00S_PCP_DETAIL_IOT SRV_SCHED_STATUS T7EHS00_SRV_SCHS Status: Scheduling Med. Service SCH_STATUS
EHS00S_PCP_DETAIL_IOT SRV_SCHED_STATUS SYST MANDT T7EHS00_SRV_SCHS Status: Scheduling Med. Service MANDT
EHS00S_PCP_DETAIL_IOT STATUS_PROT SYST MANDT T7EHS00_STATPR Health Surveillance Protocol Assignment Status MANDT
EHS00S_PCP_DETAIL_IOT STATUS_PROT EHS00S_PCP_DETAIL_IOT STATUS_PROT T7EHS00_STATPR Health Surveillance Protocol Assignment Status STATUS_PROT