T5CD4

Pension Fund Data for WEF File | #other | Component: Pension Fund Switzerland
Column Name Description
MANDT FK Client
KASSE FK Pension fund
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
Column Name Description Domain name
PLACE Location of Pension Fund TEXT32
CPK_NAME Contact Person for Pension Fund TEXT40
CPK_EMAIL E-Mail of Contact Person for Pension Fund TEXT40
CPK_TELNR Telephone Number of Contact Person for Pension Fund TEXT14
DOSSIERNR Dossier Number of Pension Fund P02F_WEF_DOSSIERNR
CRE_NAME First and Last Name of Issuer TEXT32
PF_ADDRESS_1 First Address Line of Issuer TEXT40
PF_ADDRESS_2 Second Address Line of Issuer TEXT40
PF_POSTCODE Postal Code of Issuer TEXT9
PF_PLACE Location of Issuer TEXT40
PF_COUNTRY Country/Region of Issuer INTCA
PF_NAME Name of Pension Fund TEXT40
Master Data Relations Join Conditions
Pension fund
  • T5CD4.MANDT == T5CP0.MANDT
  • T5CD4.KASSE == T5CP0.KASSE
Client T5CD4.MANDT == T000.MANDT
Canton of Pension Fund
  • ?
  • Canton of Pension Fund
  • T5CD4.MANDT == T005S.MANDT
  • T5CD4.[column in domain "LAND1"] == T005S.LAND1
  • T5CD4.REGIO == T005S.BLAND