T5B9A

Institutions (B) | #other | #language | Component: Belgium
Column Name Description
MANDT FK Client
SPRAS FK Language Key
SOORT FK Institutional group
INSTL Institution code
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
BEVAC Start Date of Vacation Period (00017)
Column Name Description
BDHST Recognition of Difficulty or Reorganization (00952) Show values
BDFAL Obsolete: Company insolvent Show values
TRUST Trusteeship (00012) Show values
Column Name Description Domain name
NAAM1 Name TEXT25
ADRES Street and House Number TEXT30
POSTK Postal Code PSTLZ
GEMEE City TEXT25
TELNR Telephone Number TELNR
PERS1 Person to be contacted 1 NACHN
BANKN Bank account number BANKN
BTWNR Tax number NUMC15
HFDNR Key main address institution CHAR4
POSTA Identification of an Apartment in a Building TEXT6
HSNMR House Number NUMC6
PERSF Person to be contacted TEXT25
ADRCO Mailing address code CHAR4
FAXNR Telephone Number TELNR
PERNO Appointed person personnel number PERSNO
MOBNR Mobile Phone Number of Contact Person CHAR20
EMAIL Email Address of Contact Person (00637) CHAR60
TELNK Phone Number of Contact Person CHAR20
FAXNK Fax Number of Contact Person (00678) CHAR20
DINNP SI no. of the interim employee user NUMC10
DIPBX P.O. Box Number CHAR3
COMID Company ID (00014) NUMC10
IBAN IBAN (International Bank Account Number) IBAN
BIC SWIFT/BIC for International Payments SWIFT
Master Data Relations Join Conditions
Client T5B9A.MANDT == T000.MANDT
Obsolete: SI/Belcotax country
  • T5B9A.MANDT == T5B0F.MANDT
  • T5B9A.RSZBL == T5B0F.BELDK
Institutional group
  • Institutional group
  • Client
  • T5B9A.SOORT == T5B92.BESRT
  • T5B9A.MANDT == T5B92.MANDT
Language Key T5B9A.SPRAS == T002.SPRAS
Language Key T5B9A.SPRSL == T002.SPRAS