T5B1U

Relationships Betw. Personnel Subareas and Institutions | #other | Component: Belgium
Column Name Description
MANDT FK Client
WERKS FK Personnel Area
BTRTL FK Personnel Subarea
INSTG FK Institution Group
EEGRM FK Employee Grouping Modifier (Institution Tables)
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 | to Other Relations ↓ Join Conditions
Employee Grouping Modifier (Institution Tables)
  • T5B1U.MANDT == T5B1E.MANDT
  • T5B1U.EEGRM == T5B1E.EEGRM
Institution Group
  • Institution Group
  • ?
  • Client
  • ?
  • T5B1U.INSTG == T5F99IG.INSTG
  • T5B1U.[column in domain "ENDDA"] == T5F99IG.ENDDA
  • T5B1U.MANDT == T5F99IG.MANDT
  • T5B1U.[column in domain "MOLGA"] == T5F99IG.MOLGA
Institution Code
  • Institution Code
  • ?
  • Institution Group
  • Client
  • ?
  • T5B1U.INSTL == T5F99IE.INSTL
  • T5B1U.[column in domain "ENDDA"] == T5F99IE.ENDDA
  • T5B1U.INSTG == T5F99IE.INSTG
  • T5B1U.MANDT == T5F99IE.MANDT
  • T5B1U.[column in domain "MOLGA"] == T5F99IE.MOLGA
Client T5B1U.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • Client
  • Personnel Area
  • ?
  • T5B1U.BTRTL == T5B1P.BTRTL
  • T5B1U.MANDT == T5B1P.MANDT
  • T5B1U.WERKS == T5B1P.WERKS
  • T5B1U.[column in domain "ENDDA"] == T5B1P.ENDDA
Personnel Area
  • Personnel Subarea
  • Client
  • Personnel Area
  • ?
  • T5B1U.BTRTL == T5B1P.BTRTL
  • T5B1U.MANDT == T5B1P.MANDT
  • T5B1U.WERKS == T5B1P.WERKS
  • T5B1U.[column in domain "ENDDA"] == T5B1P.ENDDA