T5D5Z

Supplementary Pension Public Sector: SPI Data | #other | Component: Public Sector
Column Name Description
MANDT Client
ZVEID SPI ID (Obsolete with ZVMP)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
TAGGE Indicator: Absences must be reported for exact days Show values
ANZUB Indicator: Correction of Group Registrations Summarized Show values
ANMEL Indicator: Registrations on Data Medium Show values
ANBER Indicator: Correction of Registrations on Data Medium Show values
ANSTO Indicator: Reversal of Registrations on Data Medium Show values
ABMEL Indicator: Deregistrations on Data Medium Show values
ABBER Indicator: Correction of Deregistration on Data Medium Show values
ABSTO Indicator: Reversal of Deregistrations on Data Medium Show values
JAMEL Indicator: Whether Annual Reports are on Data Medium Show values
JABER Indic.: Correction of Annual Reports on Data Medium Show values
JASTO Indicator: Reversal of Annual Reports on Data Medium Show values
DABNA File Name Show values
PFZUW Supplementary Pension Liability for Special Payment Show values
PZVER Type of Check Digit Procedure Show values
VBLID Indicator: Supplementary Pension Institute Show values
WOKNZ West/East Indicator Show values
Column Name Description Domain name
KTEXT Designation of Supplementary Pension Institute TXT25
STIDA Day and Month of Key Date for Notification of Differences STIDA
ZULNR Registration Number for VBL NRZLG
DASNA Name of File on the Data Carrier DASNA
LFDNR Sequential File Number for Data Carrier Notifications DNRLF
FOPOS Output Format of Positive Amounts on Data Medium CHAR9
FONEG Output Format of Negative Amounts on Data Medium CHAR9
UELID AKA Number of SPI (Forwarding Number) PDEP_ZV_UELID
Other Relations Join Conditions
Layout rule for address type
  • Layout rule for address type
  • Client
  • ?
  • ?
  • T5D5Z.ADRDV == T536A.VARGU
  • T5D5Z.MANDT == T536A.MANDT
  • T5D5Z.[column in domain "P00_SEQNA"] == T536A.SEQNU
  • T5D5Z.[column in domain "ANART"] == T536A.ANART
Layout rule for address type
  • Layout rule for address type
  • Client
  • ?
  • ?
  • T5D5Z.ADRZV == T536A.VARGU
  • T5D5Z.MANDT == T536A.MANDT
  • T5D5Z.[column in domain "P00_SEQNA"] == T536A.SEQNU
  • T5D5Z.[column in domain "ANART"] == T536A.ANART
Key for Investment Institution
  • ?
  • ?
  • Key for Investment Institution
  • T5D5Z.MANDT == T5DRB.MANDT
  • T5D5Z.[column in domain "P01_ANLAR"] == T5DRB.ANLAR
  • T5D5Z.[column in domain "ENDDA"] == T5DRB.ENDDA
  • T5D5Z.AINSL == T5DRB.AINSL
Payroll Key
  • Payroll Key
  • Client
  • ?
  • T5D5Z.CAKEY == T5D5C.CAKEY
  • T5D5Z.MANDT == T5D5C.MANDT
  • T5D5Z.[column in domain "ENDDA"] == T5D5C.ENDDA
Combination Key
  • Combination Key
  • Client
  • ?
  • ?
  • T5D5Z.KOKEY == T5D5G.KOKEY
  • T5D5Z.MANDT == T5D5G.MANDT
  • T5D5Z.[column in domain "VESAR"] == T5D5G.VSART
  • T5D5Z.[column in domain "SEQNR"] == T5D5G.LFDNR
Notification Key
  • Notification Key
  • Client
  • ?
  • ?
  • T5D5Z.MEKEY == T5D5D.MEKEY
  • T5D5Z.MANDT == T5D5D.MANDT
  • T5D5Z.[column in domain "MELAR"] == T5D5D.MELAR
  • T5D5Z.[column in domain "TABFD"] == T5D5D.TABFD
Notification Reason Key
  • ?
  • Notification Reason Key
  • T5D5Z.MANDT == T5D5E.MANDT
  • T5D5Z.[column in domain "MELGR"] == T5D5E.MELGR
  • T5D5Z.MGKEY == T5D5E.MGKEY
Supplementary SI
  • Supplementary SI
  • ?
  • ?
  • T5D5Z.MANDT == T5D1H.MANDT
  • T5D5Z.SVVER == T5D1H.SVVER
  • T5D5Z.[column in domain "SVZSP"] == T5D1H.SVSPA
  • T5D5Z.[column in domain "ENDDA"] == T5D1H.ENDDA