SAP Table P0168

HR Master Record: Infotype 0168 (Insurance Plans)

P0168 (HR Master Record: Infotype 0168 (Insurance Plans)) 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 P0168 to other SAP tables.

P0168 table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY T582A CHAR 4 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
BAREA Benefit area BEN_AREA T5UB3 CHAR 2 0
PLTYP Benefit plan type BEN_TYPE T5UB1 CHAR 4 0
BPLAN Benefit plan BEN_PLAN T5UBA CHAR 4 0
BENGR Benefit First Program Grouping BEN_GROUP T5UBT CHAR 4 0
BSTAT Benefit Second Program Grouping BEN_EESTAT T5UB9 CHAR 4 0
ELIDT Benefit calculated eligibility date BEN_ELIDT DATS 8 0
ELDTO Benefit override eligibility date BEN_ELIDTO DATS 8 0
PARDT Benefit date of first participation in plan BEN_PARTDT DATS 8 0
BCOVR Benefit Insurance Option BEN_COVLVL T74FA CHAR 4 0
SALOV Benefit salary override amount BEN_SALOVR CURR 15 2
COVOV Benefit Alternative Amount for Insurance Coverage Amount BEN_COVOVR CURR 15 2
ADDNO Benefit Number of Additional Insurance Coverage Units BEN_ADDNO DEC 9 0
CURRE Benefit Currency Key BEN_CURR TCURC CUKY 5 0
ENRTY Benefit Type of Plan Enrollment BEN_ENRTYP CHAR 1 0
A Automatic
D Default
M Manually
W Waived
E Using an adjustment reason
O Using open enrollment
B Automatic via open enrollment
C Defaulted via open enrollment
EVENT Benefit adjustment reason BEN_EVENT T74HA CHAR 4 0
EOGRP Benefits End of Grace Period BEN_EOGRP DATS 8 0
EOIRQ Benefit Statement of Insurability Required BEN_EOIRQ CHAR 1 0
X Yes
NULL No
EOIPR Benefit Insurability Proven BEN_EOIPR CHAR 1 0
X Yes
NULL No
PRETX Benefit Indicator Deductions Based on Pre-Tax BEN_PRETX CHAR 1 0
X Yes
NULL No
CSTOV Benefit Alternative Amount for Costs BEN_CSTOV CURR 13 2
BNCST Benefit Costs for Bonus Payment BEN_BNCST CURR 13 2
PERIO Benefit Period for Calculations BEN_PERIOD NUMC 2 0
01 Monthly
02 Semi-monthly
03 Weekly
04 Bi-weekly
05 Every four weeks
06 Annually
07 Quarterly
08 Half-yearly
ITS01 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY01 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID01 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT01 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS02 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY02 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID02 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT02 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS03 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY03 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID03 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT03 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS04 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY04 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID04 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT04 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS05 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY05 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID05 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT05 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS06 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY06 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID06 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT06 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS07 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY07 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID07 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT07 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS08 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY08 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID08 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT08 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS09 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY09 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID09 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT09 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS10 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY10 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID10 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT10 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS11 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY11 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID11 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT11 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS12 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY12 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID12 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT12 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS13 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY13 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID13 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT13 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS14 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY14 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID14 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT14 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS15 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY15 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID15 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT15 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS16 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY16 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID16 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT16 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS17 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY17 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID17 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT17 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS18 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY18 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID18 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT18 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS19 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY19 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID19 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT19 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
ITS20 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
DTY20 Benefit dependent type BEN_DEPTYP CHAR 4 0
DID20 Benefit dependent object ID BEN_DEPID CHAR 2 0
BPT20 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS01 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY01 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID01 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT01 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS02 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY02 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID02 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT02 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS03 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY03 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID03 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT03 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS04 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY04 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID04 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT04 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS05 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY05 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID05 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT05 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS06 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY06 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID06 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT06 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS07 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY07 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID07 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT07 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS08 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY08 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID08 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT08 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS09 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY09 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID09 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT09 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0
CIS10 Benefit Infotype Switch BEN_INFTYS NUMC 1 0
CTY10 Benefit dependent type BEN_DEPTYP CHAR 4 0
CID10 Benefit dependent object ID BEN_DEPID CHAR 2 0
CPT10 Benefit Payout Percentage for Beneficiaries BEN_BPRCNT DEC 3 0

P0168 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0168 BAREA SYST MANDT T5UB3 Benefit area MANDT
P0168 BAREA P0168 BAREA T5UB3 Benefit area BAREA
P0168 BCOVR * T74FA Benefit insurance plan ENDDA
P0168 BCOVR SYST MANDT T74FA Benefit insurance plan MANDT
P0168 BCOVR P0168 BAREA T74FA Benefit insurance plan BAREA
P0168 BCOVR P0168 BPLAN T74FA Benefit insurance plan BPLAN
P0168 BCOVR P0168 BCOVR T74FA Benefit insurance plan BCOVR
P0168 BENGR P0168 BENGR T5UBT Benefit first program grouping BENGR
P0168 BENGR SYST MANDT T5UBT Benefit first program grouping MANDT
P0168 BENGR P0168 BAREA T5UBT Benefit first program grouping BAREA
P0168 BPLAN P0168 BAREA T5UBA Benefit plan BAREA
P0168 BPLAN P0168 BPLAN T5UBA Benefit plan BPLAN
P0168 BPLAN * T5UBA Benefit plan ENDDA
P0168 BPLAN SYST MANDT T5UBA Benefit plan MANDT
P0168 BSTAT SYST MANDT T5UB9 Benefit second program grouping MANDT
P0168 BSTAT P0168 BAREA T5UB9 Benefit second program grouping BAREA
P0168 BSTAT P0168 BSTAT T5UB9 Benefit second program grouping BSTAT
P0168 CURRE SYST MANDT TCURC Currency Codes MANDT
P0168 CURRE P0168 CURRE TCURC Currency Codes WAERS
P0168 EVENT SYST MANDT T74HA Benefit adjustment reason MANDT
P0168 EVENT P0168 BAREA T74HA Benefit adjustment reason BAREA
P0168 EVENT P0168 EVENT T74HA Benefit adjustment reason EVENT
P0168 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0168 INFTY P0168 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0168 PLTYP SYST MANDT T5UB1 Benefit plan type MANDT
P0168 PLTYP P0168 BAREA T5UB1 Benefit plan type BAREA
P0168 PLTYP P0168 PLTYP T5UB1 Benefit plan type PLTYP
P0168 PREAS SYST MADNT T530E Reasons for Changes MANDT
P0168 PREAS P0168 INFTY T530E Reasons for Changes INFTY
P0168 PREAS P0168 PREAS T530E Reasons for Changes PREAS