SAP ABAP Table T5B1R (Relationships Betw. Pers. Subareas and Institutions)

Hierarchy

☛ SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   ⤷ PA-PA-BE (Application Component) Belgium
     ⤷ PB12 (Package) HR Master Data: Belgium

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5B1R	Table Relationship Diagram
Short Description	Relationships Betw. Pers. Subareas and Institutions

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T5B1P
3	BTRTL	☑	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T5B1P
4	INSTG	☑	P_99S_INSTGR	P_99S_INSTGR	CHAR	4	0	Institution Group	T5F99IG
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	INSTL	☐	P_99S_INST	P_99S_INST	CHAR	4	0	Institution Code	T5F99IE
8	REGNO	☐	P12_REGNO	P12_REGNO	CHAR	20	0	Registration Number at Institution
9	CONTACTINST	☐	PERS1	NACHN	CHAR	25	0	Person to be contacted 1
10	CONTACTFUNC	☐	PERSF	TEXT25	CHAR	25	0	Person to be contacted
11	FAX_INST	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
12	TEL_INST	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
13	MOB_INST	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
14	EMAIL_INST	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
15	DIPBX_INST	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
16	CONTACT1	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
17	FAX1	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
18	TEL1	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
19	MOB1	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
20	EMAIL1	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
21	DIPBX1	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
22	CONTACT2	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
23	FAX2	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
24	TEL2	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
25	MOB2	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
26	EMAIL2	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
27	DIPBX2	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5B1R	BTRTL	T5B1P	BTRTL	KEY	1	CN
2	T5B1R	INSTG	T5F99IG	INSTG	KEY	1	CN
3	T5B1R	INSTL	T5F99IE	INSTL	KEY	1	CN
4	T5B1R	MANDT	T000	MANDT	KEY	1	CN
5	T5B1R	WERKS	T5B1P	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in