T5D1K

Branch Offices | #other | Component: Germany
Column Name Description
MANDT FK Client
KVSCH FK HI Fund Key for Compulsory Health Insurance Fund
KVGES HI Fund Branch Office
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
KVPSK Payee Fund for Reporting Show values
KVBFE HI Contribution Deduction Voluntarily Reduced Show values
KVBFR HI Contribution Deduction for Voluntarily Insured Person Show values
WOKNZ West/East Indicator Show values
PVBFR CI Contribution Deductions for Voluntarily Insured Person Show values
PVBFE CI Contrib. Deductions for Voluntarily Reduced Ins. Persons Show values
GSTYP Locked Branch Office Show values
Column Name Description Domain name
TXT01 Short text for branch office TEXT20
TXT02 Fund description TEXT25
TXT03 Fund description TEXT25
TXT04 Street and House Number TEXT30
PSTLZ Postal Code PSTLZ
ORT01 City TEXT25
TELNR Telephone number (Long form) CHAR30
BTRNR Company Number BTRNR
BLZZS Bank Number BANKL
KNRZS Account Number of Health Insurance Fund CHAR10
IBAN IBAN (International Bank Account Number) IBAN
Master Data Relations | to Other Relations ↓ Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • T5D1K.BANKS == T005.LAND1
  • T5D1K.MANDT == T005.MANDT
Client T5D1K.MANDT == T000.MANDT
Payment method
  • Payment method
  • ?
  • T5D1K.MANDT == T042Z.MANDT
  • T5D1K.ZLSCH == T042Z.ZLSCH
  • T5D1K.[column in domain "LAND1"] == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Health insurance fund
  • HI Fund Key for Compulsory Health Insurance Fund
  • ?
  • T5D1K.MANDT == T5D11.MANDT
  • T5D1K.KVSCH == T5D11.KVSCH
  • T5D1K.[column in domain "ENDDA"] == T5D11.ENDDA
Health Insurance Fund Category
  • Health Insurance Fund Category
  • Client
  • T5D1K.KZART == T515A.KKA
  • T5D1K.MANDT == T515A.MANDT
Account Data Key
  • Account Data Key
  • Client
  • HI Fund Key for Compulsory Health Insurance Fund