SAP ABAP Table T5B9A (Institutions (B))

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	T5B9A	Table Relationship Diagram
Short Description	Institutions (B)

Delivery and Maintenance

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

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	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
3	SOORT	☑	BESRT	BESRT	NUMC	4	0	Institutional group	T5B92
4	INSTL	☑	INSTL	P12_BVMUT	CHAR	4	0	Institution code
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	NAAM1	☐	NAAMA	TEXT25	CHAR	25	0	Name
8	ADRES	☐	STRAS	TEXT30	CHAR	30	0	House number and street
9	POSTK	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
10	GEMEE	☐	ORT01	TEXT25	CHAR	25	0	City
11	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
12	PERS1	☐	PERS1	NACHN	CHAR	25	0	Person to be contacted 1
13	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
14	BTWNR	☐	BTWNR	NUMC15	NUMC	15	0	Tax number
15	HFDNR	☐	HFDNR	CHAR4	CHAR	4	0	Key main address institution
16	RSZBL	☐	RSZBL	RSZLD	CHAR	4	0	Obsolete: SI/Belcotax country	T5B0F
17	POSTA	☐	POSTA	TEXT6	CHAR	6	0	Identification of an Apartment in a Building
18	HSNMR	☐	HSNMR	NUMC6	NUMC	6	0	House Number
19	PERSF	☐	PERSF	TEXT25	CHAR	25	0	Person to be contacted
20	BDHST	☐	BDHST	BDHST	CHAR	1	0	Recognition of Difficulty or Reorganization (00952)
21	BDFAL	☐	BDFAL	XFELD	CHAR	1	0	Company insolvent
22	ADRCO	☐	ADRCO	CHAR4	CHAR	4	0	Mailing address code
23	FAXNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
24	SPRSL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	PERNO	☐	P12_PERNR	PERSNO	NUMC	8	0	Appointed person personnel number	*
26	MOBNR	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
27	EMAIL	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
28	TELNK	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
29	FAXNK	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
30	DINNP	☐	P12_DINNP	NUMC10	NUMC	10	0	SI no. of the interim employee user
31	DIPBX	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
32	TRUST	☐	P12_TRUSTEESHIP	P12_TRUSTEESHIP	NUMC	1	0	Trusteeship (00012)
33	BEVAC	☐	P12_BEVAC	DATUM	DATS	8	0	Start date of vacation period (00017)
34	COMID	☐	P12_COMID	NUMC10	NUMC	10	0	Company ID (00014)
35	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
36	BIC	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5B9A	MANDT	T000	MANDT	KEY	1	CN
2	T5B9A	RSZBL	T5B0F	BELDK	KEY	1	CN
3	T5B9A	SOORT	T5B92	BESRT	KEY	1	CN
4	T5B9A	SPRAS	T002	SPRAS	KEY	1	CN
5	T5B9A	SPRSL	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in