1. SAP Tutorial
  2. HR Module

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

    • T5B1U related tables

    • T5B25 : Special Rules Pension
    • T5B29 : Kind of Calculation Pension
    • T5B26 : Origin of Advantage
    • T5B9G : Employee Groups/Subgroups (B)
    • T5BP8 : Absence category attributes
    • T5B1B : Text Table Spouse’s Professions (B)
    • T5B1V : Correspondence of customer entries in TSADV
    • T5B12 : Spouse’s Professions (B)
    • T5B14 : Marital Status (B)
    • T5BD5T : Inherently dangerous activities description
    • T5B5A : Fusion Postal Codes
    • PA0108 : HR Master Record: Infotype 0108 (Personal Data B)
    • T5BDRM : Grouping of deductions for DMFA
    • T5B9A : Institutions (B)
    • T5BDRY : Job Card Codes – Relationship with Deductions and Allowances
    • T5BP7 : Internal absence code definition table
    • T5B5D : Match Belgium Postal codes to region
    • T5B27 : Code Sickness and Invalidity Insurance
    • T5BHAT : Text Table Flow Types
    • PA0504 : Pensioner’s Advantage B

    T5B1U related transaction codes under SAP package PB12

    • PC00_M12_DMN_MG : DIMONA – Manage TemSe file
    • PC00_M12_DMN_DIM : Dimona: Display Reference Data
    • PC00_M12_R : Reimbursement declar. educ. leave
    • PC00_M12_P : Personnel Register
    • PC00_M12_DMN_PR : DIMONA – Prepare Declaration
    • PC00_M12_N : Notification in advance educ. leave
    • PC00_M12_DMN_GE : DIMONA – Generate TemSe file
    • PC00_M12_DMN_DIU : Dimona: Prepare Reference Data

    Related References

    Related Tutorials

    T5B1R SAP table for – Relationships Betw. Pers. Subareas and Institutions

    T5B1R table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Relationships...

    T5B1H SAP table for – Relationships Betw. Companies and Institutions

    T5B1H table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Relationships...

    T5B1T SAP table for – Relationships Betw. Companies and Institutions

    T5B1T table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Relationships...

    T5E01 SAP table for – Personnel areas and subareas

    T5E01 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Personnel...

    T5B1P SAP table for – Personnel subareas

    T5B1P table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Personnel...

    T5L0P SAP table for – Personnel Areas/Subareas for Malaysia

    T5L0P table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Personnel...

    T7RU50 SAP table for – Personnel areas/subareas region assignment

    T7RU50 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Personnel...

    «
    »