T5P0P

HR-PT: Personnel Subarea Supplements | #other | Component: Portugal
Column Name Description
MANDT FK Client
WERKS FK Personnel Area
BTRTL Personnel Subarea
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SANPO Non-profit organization indicator Show values
Column Name Description Domain name
SANUM Personnel subarea no. NUMC04
SATXT Personnel subarea name TEXT60
SAADR Personnel subarea address TEXT40
SALOC Personnel subarea locality TEXT20
CODP Postal code PPT_CODP
TELPF Telephone/Fax prefix CHAR03
TELNO Telephone/Fax no. NUMC07
FAXPF Telephone/Fax prefix CHAR03
FAXNO Telephone/Fax no. NUMC07
SSCON Social security contributor no. NUMC6
TELNR Telephone no. NUMC09
FAXNR Fax no. NUMC09
EMAIL Mail address TEXT61
SSNSA Social security subarea code NUMC4
ESTID Establishment ID CHAR8
Master Data Relations | to Other Relations ↓ Join Conditions
Client T5P0P.MANDT == T000.MANDT
Other Relations Join Conditions
Council code
  • District code
  • Council code
  • T5P0P.DICOD == T5P6C.DICOD
  • T5P0P.COCOD == T5P6C.COCOD
District code T5P0P.DICOD == T5P6D.DICOD
Parish code
  • District code
  • Parish code
  • Council code
  • T5P0P.DICOD == T5P6P.DICOD
  • T5P0P.PACOD == T5P6P.PACOD
  • T5P0P.COCOD == T5P6P.COCOD
Economical Activity Code (CAE) T5P0P.SAACT == T5PEA.EACOD
Social security institution
  • Social security institution
  • Client
  • ?
  • T5P0P.SSINS == T5P2V.SSINS
  • T5P0P.MANDT == T5P2V.MANDT
  • T5P0P.[column in domain "ENDDA"] == T5P2V.ENDDA
Social security subregional service
  • Social security subregional service
  • Social security institution
  • T5P0P.SSSVC == T5P2J.SSSVC
  • T5P0P.SSINS == T5P2J.SSINS
Personnel Area
  • Personnel Subarea
  • Personnel Area
  • T5P0P.MANDT == T001P.MANDT
  • T5P0P.BTRTL == T001P.BTRTL
  • T5P0P.WERKS == T001P.WERKS