T5B9A SAP (Institutions (B)) Table details

Dictionary Type: Table
Description: Institutions (B)




ABAP Code to SELECT data from T5B9A
Related tables to T5B9A
Access table T5B9A




Table field list including key, data, relationships and ABAP select examples

T5B9A is a standard SAP Table which is used to store Institutions (B) data and is available within R/3 SAP systems depending on the version and release level.

The T5B9A table consists of various fields, each holding specific information or linking keys about Institutions (B) data available in SAP. These include SPRAS (Language Key), SOORT (Institutional group), INSTL (Institution code), ENDDA (End Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP T5B9A table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
SOORTInstitutional group BESRTNUMC4T5B92BESRT
INSTLInstitution code INSTLCHAR4P12_BVMUT
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
NAAM1Name NAAMACHAR25TEXT25
ADRESHouse number and street STRASCHAR30TEXT30
POSTKPostal Code PSTLZCHAR10PSTLZ
GEMEECity ORT01CHAR25TEXT25
TELNRTelephone Number TELNRCHAR14TELNR
PERS1Person to be contacted 1 PERS1CHAR25NACHN
BANKNBank account number BANKNCHAR18BANKN
BTWNRTax number BTWNRNUMC15NUMC15
HFDNRKey main address institution HFDNRCHAR4CHAR4
RSZBLObsolete: SI/Belcotax country RSZBLCHAR4T5B0FRSZLD
POSTAIdentification of an Apartment in a Building POSTACHAR6TEXT6
HSNMRHouse Number HSNMRNUMC6NUMC6
PERSFPerson to be contacted PERSFCHAR25TEXT25
BDHSTRecognition of Difficulty or Reorganization (00952) BDHSTCHAR1BDHST
BDFALCompany insolvent BDFALCHAR1XFELD
ADRCOMailing address code ADRCOCHAR4CHAR4
FAXNRTelephone Number TELNRCHAR14TELNR
SPRSLLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
PERNOAppointed person personnel number P12_PERNRNUMC8Assigned to domainPERSNO
MOBNRMobile Phone Number of Contact Person P12_MOBNRCHAR20CHAR20
EMAILEmail Address of Contact Person (00637) P12_EMAILCHAR60CHAR60
TELNKPhone Number of Contact Person P12_TELNKCHAR20CHAR20
FAXNKFax Number of Contact Person (00678) P12_FAXNKCHAR20CHAR20
DINNPSI no. of the interim employee user P12_DINNPNUMC10NUMC10
DIPBXP.O. Box Number P12_DIPBXCHAR3CHAR3
TRUSTTrusteeship (00012) P12_TRUSTEESHIPNUMC1P12_TRUSTEESHIP
BEVACStart Date of Vacation Period (00017) P12_BEVACDATS8DATUM
COMIDCompany ID (00014) P12_COMIDNUMC10NUMC10
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
BICSWIFT/BIC for International Payments SWIFTCHAR11SWIFT

Key field Non-key field



How do I retrieve data from SAP table T5B9A using ABAP code

The following ABAP code Example will allow you to do a basic selection on T5B9A to SELECT all data from the table
DATA: WA_T5B9A TYPE T5B9A.

SELECT SINGLE *
FROM T5B9A
INTO CORRESPONDING FIELDS OF WA_T5B9A
WHERE...

How to access SAP table T5B9A

Within an ECC or HANA version of SAP you can also view further information about T5B9A and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!