SAP Table PA0795

HR Master Record: Infotype 0795

PA0795 (HR Master Record: Infotype 0795) 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 PA0795 to other SAP tables.

Source: PA0795 (HR Master Record: Infotype 0795)

PA0795 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 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
TYPEC Certificate Category P10P_TYPEC T5UPBSTC11 CHAR 4 0
CTNUM Certificate Identification P10P_CTNUM CHAR 10 0
CTBEG Certificate Effective Begin Date P10P_CTBEG DATS 8 0
CTEND Certificate Effective End Date P10P_CTEND DATS 8 0
CSTAT Certificate and Area Status P10P_CSTAT T5UPBSTC30 CHAR 1 0
RENCD Renewal Code P10P_RENCD T5UPBSTC21 CHAR 4 0
SBG01 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN01 Area Effective End Date P10P_SENDD DATS 8 0
SCD01 Code (Classification, Area and Level) P10P_SCODE T5UPBSTC16 CHAR 6 0
SCL01 Classification P10P_CLASS T5UPBSTC03 CHAR 4 0
SDN01 Area Document Number P10P_SDNUM CHAR 10 0
SST01 Area Status P10P_SSTAT T5UPBSTC30 CHAR 1 0
SHQ01 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG02 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN02 Area Effective End Date P10P_SENDD DATS 8 0
SCD02 Code (Classification, Area and Level) P10P_SCODE T5UPBSTC16 CHAR 6 0
SCL02 Classification P10P_CLASS T5UPBSTC03 CHAR 4 0
SDN02 Area Document Number P10P_SDNUM CHAR 10 0
SST02 Area Status P10P_SSTAT T5UPBSTC30 CHAR 1 0
SHQ02 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG03 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN03 Area Effective End Date P10P_SENDD DATS 8 0
SCD03 Code (Classification, Area and Level) P10P_SCODE T5UPBSTC16 CHAR 6 0
SCL03 Classification P10P_CLASS T5UPBSTC03 CHAR 4 0
SDN03 Area Document Number P10P_SDNUM CHAR 10 0
SST03 Area Status P10P_SSTAT T5UPBSTC30 CHAR 1 0
SHQ03 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG04 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN04 Area Effective End Date P10P_SENDD DATS 8 0
SCD04 Code (Classification, Area and Level) P10P_SCODE T5UPBSTC16 CHAR 6 0
SCL04 Classification P10P_CLASS T5UPBSTC03 CHAR 4 0
SDN04 Area Document Number P10P_SDNUM CHAR 10 0
SST04 Area Status P10P_SSTAT T5UPBSTC30 CHAR 1 0
SHQ04 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG05 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN05 Area Effective End Date P10P_SENDD DATS 8 0
SCD05 Code (Classification, Area and Level) P10P_SCODE T5UPBSTC16 CHAR 6 0
SCL05 Classification P10P_CLASS T5UPBSTC03 CHAR 4 0
SDN05 Area Document Number P10P_SDNUM CHAR 10 0
SST05 Area Status P10P_SSTAT T5UPBSTC30 CHAR 1 0
SHQ05 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG06 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN06 Area Effective End Date P10P_SENDD DATS 8 0
SCD06 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL06 Classification P10P_CLASS CHAR 4 0
SDN06 Area Document Number P10P_SDNUM CHAR 10 0
SST06 Area Status P10P_SSTAT CHAR 1 0
SHQ06 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG07 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN07 Area Effective End Date P10P_SENDD DATS 8 0
SCD07 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL07 Classification P10P_CLASS CHAR 4 0
SDN07 Area Document Number P10P_SDNUM CHAR 10 0
SST07 Area Status P10P_SSTAT CHAR 1 0
SHQ07 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG08 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN08 Area Effective End Date P10P_SENDD DATS 8 0
SCD08 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL08 Classification P10P_CLASS CHAR 4 0
SDN08 Area Document Number P10P_SDNUM CHAR 10 0
SST08 Area Status P10P_SSTAT CHAR 1 0
SHQ08 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG09 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN09 Area Effective End Date P10P_SENDD DATS 8 0
SCD09 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL09 Classification P10P_CLASS CHAR 4 0
SDN09 Area Document Number P10P_SDNUM CHAR 10 0
SST09 Area Status P10P_SSTAT CHAR 1 0
SHQ09 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG10 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN10 Area Effective End Date P10P_SENDD DATS 8 0
SCD10 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL10 Classification P10P_CLASS CHAR 4 0
SDN10 Area Document Number P10P_SDNUM CHAR 10 0
SST10 Area Status P10P_SSTAT CHAR 1 0
SHQ10 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG11 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN11 Area Effective End Date P10P_SENDD DATS 8 0
SCD11 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL11 Classification P10P_CLASS CHAR 4 0
SDN11 Area Document Number P10P_SDNUM CHAR 10 0
SST11 Area Status P10P_SSTAT CHAR 1 0
SHQ11 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG12 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN12 Area Effective End Date P10P_SENDD DATS 8 0
SCD12 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL12 Classification P10P_CLASS CHAR 4 0
SDN12 Area Document Number P10P_SDNUM CHAR 10 0
SST12 Area Status P10P_SSTAT CHAR 1 0
SHQ12 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG13 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN13 Area Effective End Date P10P_SENDD DATS 8 0
SCD13 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL13 Classification P10P_CLASS CHAR 4 0
SDN13 Area Document Number P10P_SDNUM CHAR 10 0
SST13 Area Status P10P_SSTAT CHAR 1 0
SHQ13 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG14 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN14 Area Effective End Date P10P_SENDD DATS 8 0
SCD14 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL14 Classification P10P_CLASS CHAR 4 0
SDN14 Area Document Number P10P_SDNUM CHAR 10 0
SST14 Area Status P10P_SSTAT CHAR 1 0
SHQ14 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG15 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN15 Area Effective End Date P10P_SENDD DATS 8 0
SCD15 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL15 Classification P10P_CLASS CHAR 4 0
SDN15 Area Document Number P10P_SDNUM CHAR 10 0
SST15 Area Status P10P_SSTAT CHAR 1 0
SHQ15 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG16 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN16 Area Effective End Date P10P_SENDD DATS 8 0
SCD16 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL16 Classification P10P_CLASS CHAR 4 0
SDN16 Area Document Number P10P_SDNUM CHAR 10 0
SST16 Area Status P10P_SSTAT CHAR 1 0
SHQ16 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG17 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN17 Area Effective End Date P10P_SENDD DATS 8 0
SCD17 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL17 Classification P10P_CLASS CHAR 4 0
SDN17 Area Document Number P10P_SDNUM CHAR 10 0
SST17 Area Status P10P_SSTAT CHAR 1 0
SHQ17 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG18 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN18 Area Effective End Date P10P_SENDD DATS 8 0
SCD18 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL18 Classification P10P_CLASS CHAR 4 0
SDN18 Area Document Number P10P_SDNUM CHAR 10 0
SST18 Area Status P10P_SSTAT CHAR 1 0
SHQ18 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG19 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN19 Area Effective End Date P10P_SENDD DATS 8 0
SCD19 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL19 Classification P10P_CLASS CHAR 4 0
SDN19 Area Document Number P10P_SDNUM CHAR 10 0
SST19 Area Status P10P_SSTAT CHAR 1 0
SHQ19 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No
SBG20 Area Effective Begin Date P10P_SBEGD DATS 8 0
SEN20 Area Effective End Date P10P_SENDD DATS 8 0
SCD20 Code (Classification, Area and Level) P10P_SCODE CHAR 6 0
SCL20 Classification P10P_CLASS CHAR 4 0
SDN20 Area Document Number P10P_SDNUM CHAR 10 0
SST20 Area Status P10P_SSTAT CHAR 1 0
SHQ20 Highly Qualified P10P_HQUAL CHAR 1 0
X Yes
NULL No

PA0795 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0795 CSTAT SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 CSTAT 'C' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 CSTAT PA0795 CSTAT T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 PERNR PA0795 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0795 PERNR SYST MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0795 PREAS SYST MANDT T530E Reasons for Changes MANDT
PA0795 PREAS PSKEY INFTY T530E Reasons for Changes INFTY
PA0795 PREAS PA0795 PREAS T530E Reasons for Changes PREAS
PA0795 RENCD PA0795 RENCD T5UPBSTC21 Certificate: Renewal Code Table RENCD
PA0795 RENCD SYST MANDT T5UPBSTC21 Certificate: Renewal Code Table MANDT
PA0795 SCD01 * T5UPBSTC16 Certificate: Classification, Area and Level ENDDA
PA0795 SCD01 PA0795 SCD01 T5UPBSTC16 Certificate: Classification, Area and Level SCODE
PA0795 SCD01 SYST MANDT T5UPBSTC16 Certificate: Classification, Area and Level MANDT
PA0795 SCD02 SYST MANDT T5UPBSTC16 Certificate: Classification, Area and Level MANDT
PA0795 SCD02 * T5UPBSTC16 Certificate: Classification, Area and Level ENDDA
PA0795 SCD02 PA0795 SCD02 T5UPBSTC16 Certificate: Classification, Area and Level SCODE
PA0795 SCD03 * T5UPBSTC16 Certificate: Classification, Area and Level ENDDA
PA0795 SCD03 PA0795 SCD03 T5UPBSTC16 Certificate: Classification, Area and Level SCODE
PA0795 SCD03 SYST MANDT T5UPBSTC16 Certificate: Classification, Area and Level MANDT
PA0795 SCD04 * T5UPBSTC16 Certificate: Classification, Area and Level ENDDA
PA0795 SCD04 PA0795 SCD04 T5UPBSTC16 Certificate: Classification, Area and Level SCODE
PA0795 SCD04 SYST MANDT T5UPBSTC16 Certificate: Classification, Area and Level MANDT
PA0795 SCD05 SYST MANDT T5UPBSTC16 Certificate: Classification, Area and Level MANDT
PA0795 SCD05 PA0795 SCD05 T5UPBSTC16 Certificate: Classification, Area and Level SCODE
PA0795 SCD05 * T5UPBSTC16 Certificate: Classification, Area and Level ENDDA
PA0795 SCL01 SYST MANDT T5UPBSTC03 Certificate: Classification MANDT
PA0795 SCL01 PA0795 SCL01 T5UPBSTC03 Certificate: Classification CLASS
PA0795 SCL02 SYST MANDT T5UPBSTC03 Certificate: Classification MANDT
PA0795 SCL02 PA0795 SCL02 T5UPBSTC03 Certificate: Classification CLASS
PA0795 SCL03 SYST MANDT T5UPBSTC03 Certificate: Classification MANDT
PA0795 SCL03 PA0795 SCL03 T5UPBSTC03 Certificate: Classification CLASS
PA0795 SCL04 SYST MANDT T5UPBSTC03 Certificate: Classification MANDT
PA0795 SCL04 PA0795 SCL04 T5UPBSTC03 Certificate: Classification CLASS
PA0795 SCL05 PA0795 SCL05 T5UPBSTC03 Certificate: Classification CLASS
PA0795 SCL05 SYST MANDT T5UPBSTC03 Certificate: Classification MANDT
PA0795 SST01 'A' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 SST01 SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 SST01 PA0795 SST01 T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 SST02 SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 SST02 'A' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 SST02 PA0795 SST02 T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 SST03 PA0795 SST03 T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 SST03 'A' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 SST03 SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 SST04 PA0795 SST04 T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 SST04 'A' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 SST04 SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 SST05 PA0795 SST05 T5UPBSTC30 Certificate: Certificate and Area Status CSTAT
PA0795 SST05 'A' T5UPBSTC30 Certificate: Certificate and Area Status SLVFL
PA0795 SST05 SYST MANDT T5UPBSTC30 Certificate: Certificate and Area Status MANDT
PA0795 TYPEC * T5UPBSTC11 Certificate: Category ENDDA
PA0795 TYPEC PA0795 TYPEC T5UPBSTC11 Certificate: Category TYPEC
PA0795 TYPEC SYST MANDT T5UPBSTC11 Certificate: Category MANDT