SAP ABAP Table T5B1H (Relationships Betw. Companies 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	T5B1H	Table Relationship Diagram
Short Description	Relationships Betw. Companies 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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T5B1S
3	INSTG	☑	P_99S_INSTGR	P_99S_INSTGR	CHAR	4	0	Institution Group	T5F99IG
4	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	INSTL	☐	P_99S_INST	P_99S_INST	CHAR	4	0	Institution Code	T5F99IE
7	REGNO	☐	P12_REGNO	P12_REGNO	CHAR	20	0	Registration Number at Institution
8	CONTACTINST	☐	PERS1	NACHN	CHAR	25	0	Person to be contacted 1
9	CONTACTFUNC	☐	PERSF	TEXT25	CHAR	25	0	Person to be contacted
10	FAX_INST	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
11	TEL_INST	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
12	MOB_INST	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
13	EMAIL_INST	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
14	DIPBX_INST	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
15	CONTACT1	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
16	FAX1	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
17	TEL1	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
18	MOB1	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
19	EMAIL1	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
20	DIPBX1	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
21	CONTACT2	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
22	FAX2	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
23	TEL2	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
24	MOB2	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
25	EMAIL2	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
26	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	T5B1H	BUKRS	T5B1S	BUKRS	KEY	1	CN
2	T5B1H	INSTG	T5F99IG	INSTG	KEY	1	CN
3	T5B1H	INSTL	T5F99IE	INSTL	KEY	1	CN
4	T5B1H	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in