P_HRPADKZ_EHR_SELFLT_EMPLEE

Employees selection for KZ E-HR Filter | view: PHRPADKZEHRFLTEE | Extraction: Not supported | Component: Kazakhstan
Tables used: PA0000, PA0001, PA0002, PA0016
Column Name Description
pernr FK Personnel Number
begda Start Date
endda End Date
abkrs FK Payroll Area
werks FK Personnel Area
btrtl FK Personnel Subarea
persg FK Employee Group
persk FK Employee Subgroup
ansvh FK Work Contract
bukrs FK Company Code
ename Formatted Name of Employee or Applicant
gsber FK Business Area
juper Legal Person
kokrs FK Controlling Area
orgeh FK Organizational Unit
plans FK Position
sachp FK Administrator for HR Master Data
stell FK Job
vdsk1 FK Organizational Key
sbmod Administrator Group
stat1 FK Customer-Specific Status
stat2 FK Employment Status
stat3 FK Special Payment Status
gbdat Date of Birth
natio FK Nationality
perid Personnel ID Number
cttyp FK Contract Type
nbtgk Sideline Job
Column Name Description
Column Name Description
Column Name Description
begda Start Date
endda End Date
gbdat Date of Birth
Column Name Description
Column Name Description Domain name
Master Data Relations | to Other Relations ↓ Join Conditions
Payroll Area
  • Payroll Area
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.ABKRS == T549A.ABKRS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T549A.MANDT
Work Contract
  • Work Contract
  • Client
  • ?
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.ANSVH == T542A.ANSVH
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T542A.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "MOLGA"] == T542A.MOLGA
Company Code
  • Company Code
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.BUKRS == T001.BUKRS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T001.MANDT
Contract Type
  • Client
  • Contract Type
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T547V.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.CTTYP == T547V.CTTYP
Business Area
  • Client
  • Business Area
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == TGSB.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.GSBER == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.KOKRS == TKA01.KOKRS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == TKA01.MANDT
Nationality
  • Client
  • Nationality
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T005.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.NATIO == T005.LAND1
Personnel Number
  • Client
  • Personnel Number
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == PA0003.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.PERNR == PA0003.PERNR
Employee Group
  • Client
  • Employee Group
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T501.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.PERSG == T501.PERSG
Employee Subgroup
  • Employee Subgroup
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.PERSK == T503K.PERSK
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T503K.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Client
  • Personnel Area
  • Personnel Subarea
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T001P.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.WERKS == T001P.WERKS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.BTRTL == T001P.BTRTL
Organizational Unit
  • ?
  • ?
  • Client
  • Organizational Unit
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "ENDDA"] == T527X.ENDDA
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "SPRAS"] == T527X.SPRSL
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T527X.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.ORGEH == T527X.ORGEH
Position
  • Position
  • ?
  • Client
  • ?
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.PLANS == T528B.PLANS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "ENDDA"] == T528B.ENDDA
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T528B.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "OTYPE"] == T528B.OTYPE
Administrator for HR Master Data
  • Administrator Group
  • Client
  • Administrator for HR Master Data
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.SBMOD == T526.WERKS
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T526.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.SACHP == T526.SACHX
Customer-Specific Status
  • Customer-Specific Status
  • ?
  • ?
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.STAT1 == T529U.STATV
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "STATN"] == T529U.STATN
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "SPRAS"] == T529U.SPRSL
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T529U.MANDT
Employment Status
  • ?
  • ?
  • Client
  • Employment Status
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "STATN"] == T529U.STATN
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "SPRAS"] == T529U.SPRSL
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T529U.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.STAT2 == T529U.STATV
Special Payment Status
  • Special Payment Status
  • ?
  • ?
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.STAT3 == T529U.STATV
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "STATN"] == T529U.STATN
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "SPRAS"] == T529U.SPRSL
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T529U.MANDT
Job
  • Job
  • ?
  • Client
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.STELL == T513.STELL
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "ENDDA"] == T513.ENDDA
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T513.MANDT
Organizational Key
  • ?
  • Client
  • Organizational Key
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.[column in domain "HIRAR"] == T527O.HIRAR
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T527O.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.VDSK1 == T527O.ORGKY
Personnel Area
  • Client
  • Personnel Area
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.MANDT == T500P.MANDT
  • P_HRPADKZ_EHR_SELFLT_EMPLEE.WERKS == T500P.PERSA