0EMPLOYEE_0022_ATTR

Employee - Education and Training | #ATTR | Extraction method: V | No Delta | Component: Personnel Administration Master Data
Tables used: PA0022 → show details
Column Name Description
PERNR FK Personnel Number
DATETO End Date
DATEFROM Start Date
SLART FK Educational establishment
INSTI Institute/location of training
SLAND FK Country/Region Key
AUSBI FK Education/training
SLABS FK Certificate
ANZKL Duration of training course
ANZEH FK External Unit of Measurement in Commercial Format (3-Char.)
SLTP1 FK Branch of study
SLTP2 FK Branch of study
JBEZ1 Course fees
WAERS FK Currency Key
SLRZG Repayment obligation Show values
KSBEZ Course name
TX122 Course appraisal
DPTMT Department
EMARK Final Grade
Column Name Description
💲 Currency Key (WAERS):
JBEZ1 Course fees
Column Name Description
Column Name Description
DATETO End Date
DATEFROM Start Date
Column Name Description
SLRZG Repayment obligation Show values
Column Name Description Domain name
Master Data Relations | to Other Relations ↓ Join Conditions
External Unit of Measurement in Commercial Format (3-Char.)
  • Client
  • External Unit of Measurement in Commercial Format (3-Char.)
  • 0EMPLOYEE_0022_ATTR.MANDT == T538A.MANDT
  • 0EMPLOYEE_0022_ATTR.ANZEH == T538A.ZEINH
Education/training
  • Education/training
  • Client
  • 0EMPLOYEE_0022_ATTR.AUSBI == T518A.AUSBI
  • 0EMPLOYEE_0022_ATTR.MANDT == T518A.MANDT
Personnel Number
  • Client
  • Personnel Number
  • 0EMPLOYEE_0022_ATTR.MANDT == PA0003.MANDT
  • 0EMPLOYEE_0022_ATTR.PERNR == PA0003.PERNR
Country/Region Key
  • Client
  • Country/Region Key
  • 0EMPLOYEE_0022_ATTR.MANDT == T005.MANDT
  • 0EMPLOYEE_0022_ATTR.SLAND == T005.LAND1
Branch of study
  • Branch of study
  • Client
  • 0EMPLOYEE_0022_ATTR.SLTP1 == T517Y.FACHR
  • 0EMPLOYEE_0022_ATTR.MANDT == T517Y.MANDT
Branch of study
  • Branch of study
  • Client
  • 0EMPLOYEE_0022_ATTR.SLTP2 == T517Y.FACHR
  • 0EMPLOYEE_0022_ATTR.MANDT == T517Y.MANDT
Currency Key
  • Currency Key
  • Client
  • 0EMPLOYEE_0022_ATTR.WAERS == TCURC.WAERS
  • 0EMPLOYEE_0022_ATTR.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Certificate
  • Certificate
  • Client
  • 0EMPLOYEE_0022_ATTR.SLABS == T519T.SLABS
  • 0EMPLOYEE_0022_ATTR.MANDT == T519T.MANDT
Educational establishment
  • Client
  • Educational establishment
  • 0EMPLOYEE_0022_ATTR.MANDT == T517T.MANDT
  • 0EMPLOYEE_0022_ATTR.SLART == T517T.SLART