SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Purpose of table TIBAN

Former Member

‎2015 Nov 23 9:09 AM

0 Kudos
8,276

Hi Experts,

According to what I think TIBAN table was only used for the migration to SEPA and  suspect it is now used by SAP as a kind of archive, to register false mandates or something like that. In the last 3 months, only 3 new records were added to this list.

Can you confirm if above conslusions are correct? If not correct, what the purpose is of this table?

Thanks in Advance. Looking forward to relevant replies.

3 REPLIES 3

Former Member

‎2015 Nov 23 1:30 PM

0 Kudos
3,009

This message was moderated.

AmlanBanerjee
Active Contributor

‎2015 Nov 23 9:59 PM

0 Kudos
3,009

Hi Charusmita,

As per my knowledge goes, some European countries, have a long bank account number, (See Note 1585003) containing country code (first 2 characters), bank number and bank account number.

SAP uses a special functionality for these IBAN's: it stores the old account number in master data (also called BBAN: Basic Bank Account Number), and stores the translation from BBAN to IBAN in the TIBAN table.

So table TIBAN can have the data from two tables in SAP FICA.

1. BUT0BK - where the combination of IBAN number with Business Partner.

2. T012K - where the combination of House bank Account with IBAN number.

Hope it helps..

Thanks,

Amlan

Former Member

‎2016 Jan 06 3:24 PM

0 Kudos
3,009

Hi Charusmita.

Amlan explained it quite nice. Id like to add that IBAN (International Bank Account Number) consists of two letters representing country, two check numbers, 7 digits for bank number and 10 digits for bank account number. So its like HR0029876541234567890.

IBAN can be entered,f or example, via BP transaction. Every time you add a new IBAN to a business partner, TIBAN table gets updated. Also, when you do migration (for example via EMIGALL), and youre migrating IBAN number, table TIBAN gets updated. Althought the field IBAN exists in BUT0BK table, it is not populated when you enter new IBAN in the business partner bank account data.

Almost all EU countries are obligated to use IBAN as a bank number, replacing the old number (which was only bank number + bank account number). This means, its used in all payment transactions.

Hope it helps.

Marko