T5B1H

Relationships Betw. Companies and Institutions | #other | Component: Belgium
Column Name Description
MANDT FK Client
BUKRS FK Company Code
INSTG FK Institution Group
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
REGNO Registration Number at Institution P12_REGNO
CONTACTINST Person to be contacted 1 NACHN
CONTACTFUNC Person to be contacted TEXT25
FAX_INST Fax Number of Contact Person (00678) CHAR20
TEL_INST Phone Number of Contact Person CHAR20
MOB_INST Mobile Phone Number of Contact Person CHAR20
EMAIL_INST Email Address of Contact Person (00637) CHAR60
DIPBX_INST P.O. Box Number CHAR3
CONTACT1 Personnel Number PERSNO
FAX1 Fax Number of Contact Person (00678) CHAR20
TEL1 Phone Number of Contact Person CHAR20
MOB1 Mobile Phone Number of Contact Person CHAR20
EMAIL1 Email Address of Contact Person (00637) CHAR60
DIPBX1 P.O. Box Number CHAR3
CONTACT2 Personnel Number PERSNO
FAX2 Fax Number of Contact Person (00678) CHAR20
TEL2 Phone Number of Contact Person CHAR20
MOB2 Mobile Phone Number of Contact Person CHAR20
EMAIL2 Email Address of Contact Person (00637) CHAR60
DIPBX2 P.O. Box Number CHAR3
Master Data Relations Join Conditions
Company Code
  • ?
  • Company Code
  • T5B1H.MANDT == T5B1S.MANDT
  • T5B1H.[column in domain "ENDDA"] == T5B1S.ENDDA
  • T5B1H.BUKRS == T5B1S.BUKRS
Institution Group
  • Institution Group
  • ?
  • Client
  • ?
  • T5B1H.INSTG == T5F99IG.INSTG
  • T5B1H.[column in domain "ENDDA"] == T5F99IG.ENDDA
  • T5B1H.MANDT == T5F99IG.MANDT
  • T5B1H.[column in domain "MOLGA"] == T5F99IG.MOLGA
Institution Code
  • Institution Code
  • ?
  • Institution Group
  • Client
  • ?
  • T5B1H.INSTL == T5F99IE.INSTL
  • T5B1H.[column in domain "ENDDA"] == T5F99IE.ENDDA
  • T5B1H.INSTG == T5F99IE.INSTG
  • T5B1H.MANDT == T5F99IE.MANDT
  • T5B1H.[column in domain "MOLGA"] == T5F99IE.MOLGA
Client T5B1H.MANDT == T000.MANDT