T5B1U SAP table for – Relationships Betw. Personnel Subareas and Institutions

Here we would like to draw your attention to T5B1U table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). T5B1U is a SAP standard transp table used for storing Relationships Betw. Personnel Subareas and Institutions related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB12.

SAP T5B1U table

Table T5B1U technical data

TableT5B1U
Data storingRelationships Betw. Personnel Subareas and Institutions
ModulePA
Sub ModulePA-PA-BE
SAP PackagePB12
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCBE
Table CategoryTRANSP

SAP T5B1U Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T5B1U table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • WERKS : Personnel Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BTRTL : Personnel Subarea
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • INSTG : Institution Group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • EEGRM : Employee Grouping Modifier (Institution Tables)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTL : Institution Code
    Its data type is CHAR (Character String) with field length 4
  • REGNO : Registration Number at Institution
    Its data type is CHAR (Character String) with field length 20
  • CONTACTINST : Person to be contacted 1
    Its data type is CHAR (Character String) with field length 25
  • CONTACTFUNC : Person to be contacted
    Its data type is CHAR (Character String) with field length 25
  • FAX_INST : Fax Number of Contact Person (00678)
    Its data type is CHAR (Character String) with field length 20
  • TEL_INST : Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • MOB_INST : Mobile Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • EMAIL_INST : Email Address of Contact Person (00637)
    Its data type is CHAR (Character String) with field length 60
  • DIPBX_INST : P.O. Box Number
    Its data type is CHAR (Character String) with field length 3
  • CONTACT1 : Personnel number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • FAX1 : Fax Number of Contact Person (00678)
    Its data type is CHAR (Character String) with field length 20
  • TEL1 : Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • MOB1 : Mobile Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • EMAIL1 : Email Address of Contact Person (00637)
    Its data type is CHAR (Character String) with field length 60
  • DIPBX1 : P.O. Box Number
    Its data type is CHAR (Character String) with field length 3
  • CONTACT2 : Personnel number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • FAX2 : Fax Number of Contact Person (00678)
    Its data type is CHAR (Character String) with field length 20
  • TEL2 : Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • MOB2 : Mobile Phone Number of Contact Person
    Its data type is CHAR (Character String) with field length 20
  • EMAIL2 : Email Address of Contact Person (00637)
    Its data type is CHAR (Character String) with field length 60
  • DIPBX2 : P.O. Box Number
    Its data type is CHAR (Character String) with field length 3