T5P0E

Establishment | #other | Component: Portugal
Column Name Description
MANDT FK Client
WERKS FK Personnel Area
BTRTL FK Personnel Subarea
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
SANPO Non-profit organization indicator Show values
STATUS Establishment status 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
SSCON Social security contributor no. NUMC6
TELNR Telephone Number TELNR
FAXNR Telephone Number TELNR
EMAIL Mail address TEXT61
SSNSA Social security subarea code NUMC4
ESTID Establishment ID CHAR8
Master Data Relations | to Other Relations ↓ Join Conditions
Client T5P0E.MANDT == T000.MANDT
Other Relations Join Conditions
Personnel Subarea
  • Personnel Subarea
  • Personnel Area
  • T5P0E.MANDT == T001P.MANDT
  • T5P0E.BTRTL == T001P.BTRTL
  • T5P0E.WERKS == T001P.WERKS
Council code
  • District code
  • Council code
  • ?
  • T5P0E.MANDT == T5P6NC.MANDT
  • T5P0E.DICOD == T5P6NC.DICOD
  • T5P0E.COCOD == T5P6NC.COCOD
  • T5P0E.[column in domain "ENDDA"] == T5P6NC.ENDDA
Postal code T5P0E.CODP == T5PCP.CODP
District code
  • District code
  • ?
  • T5P0E.MANDT == T5P6ND.MANDT
  • T5P0E.DICOD == T5P6ND.DICOD
  • T5P0E.[column in domain "ENDDA"] == T5P6ND.ENDDA
Parish code
  • District code
  • Council code
  • Parish code
  • Client
  • ?
  • T5P0E.DICOD == T5P6NP.DICOD
  • T5P0E.COCOD == T5P6NP.COCOD
  • T5P0E.PACOD == T5P6NP.PACOD
  • T5P0E.MANDT == T5P6NP.MANDT
  • T5P0E.[column in domain "ENDDA"] == T5P6NP.ENDDA
Economical Activity Code (CAE) T5P0E.SAACT == T5PEA.EACOD
Social security institution
  • Social security institution
  • Client
  • ?
  • T5P0E.SSINS == T5P2V.SSINS
  • T5P0E.MANDT == T5P2V.MANDT
  • T5P0E.[column in domain "ENDDA"] == T5P2V.ENDDA
Social security subregional service
  • Social security subregional service
  • Social security institution
  • T5P0E.SSSVC == T5P2J.SSSVC
  • T5P0E.SSINS == T5P2J.SSINS
Personnel Area
  • T5P0E.MANDT == T500P.MANDT
  • T5P0E.WERKS == T500P.PERSA