S4HC | EBS | BAI2 Bank Key and Account Number | Australia

[SunnyZ]

Hello experts,

Hope you are well.

We have recently encountered an issue with Electronic Bank Statement (EBS) upload using S/4HANA Cloud, Public version, and we have not enabled the Multi-Bank Connectivity scope item.

The file format for download from our designated bank is BAI2, recognised by the S4HC system. However, we have issues with the Bank Key and Account Numbers.

For example, we have configured the ACTUAL bank details as follow:

- Actual Bank Key: 061-111 (6-digit, 06 represents Australia, also called BSB number)

- Actual Bank Account: 22334455 (8-digit)

However, the BAI2 export file from the bank displays the following:

- Bank Key: AAA (abbreviation of the Bank, 3-digit)

- Account Number: 111122334455 (last 4 digits from the actual bank key or the BSB, and 8 digits of actual bank account numbers)

In this case, we were thinking about routing the reading of BAI2 format just like using other formats, BUT! our system only allows us to copy and configure formats of MT940 (Structured or Non-Structured) and CAMT053_001_02.

We have tried searching, browsing and attempting on most of the other answers and blogs, but given T-codes are not available and/or some of the config activities are being locked in the S4HC world, so we are sort of stuck.

It would be much appreciated if you could:

1. Provide the BAI2 config file, which we could then upload to the format mappings, and then change the routing rules, or

2. Suggest how we can map and convert the exported file to match the bank key and account number with the actual ones?

Please do not hesitate to reach out if you need any further information. Any assistance would be greatly appreciated.

Thanks,

Sunny

[JulianoRomanato]

Dear sunnyzhu.

How are you? I have excluded the Tags "SAP S/4HANA Cloud" and "SAP S/4HANA Cloud for Professional Services" and included the Tags "SAP S/4HANA Cloud for Finance" and "SAP S/4HANA Cloud Localization" for this question due to the nature of the terms.

Regards.

Juliano Romanato.

[SunnyZ · Accepted solution]

Hello All,

Just posting an update and a resolution for future reference, please find below for the details of how we solved the issue.

In order to compensate for the Bank Key (CBA or any other bank keys that differ from BSB or not meeting the restriction) and Bank Account Number (BSB + Bank Account, or any other account numbers not meeting the restricted characters), we need to populate these details extracted from BAI2 to Alternative Bank ID and Alternative Bank Account Number.

- Populate Bank Key (e.g. CBA) as an alternative bank key from Manage Bank Accounts > House Bank Account Connectivity - Manage House Bank > House Banks > Edit > Alternative Bank ID

- Populate Bank Account Number from Manage Bank Accounts > House Bank Account Connectivity - Details > Edit > Altern. Bank Acct No.

By doing so, the bank statements can be processed by the system.

Hope the above helps by chance anyone is having an issue with the Australian BAI2 (Bank Administration Institute, or Bank Administration Institute AU specific) file import.

Thank you.

Kind regards,

Sunny

[Neeraj_Jain]

Hello Sunny Zhu,

Please refer below SAP Note, thread and Blog, if you already gone through to those then ignore else hope it's helps to you.

https://userapps.support.sap.com/sap/support/knowledge/en/2437617

2437617 - How to interpret a BAI2 file

https://answers.sap.com/questions/9275491/electronic-bank-statement---bai-2-format.html

Above SAP thread accepted.

https://blogs.sap.com/2015/10/20/ebs-how-to-interpret-a-bai2-file/

Please confirm it's helps to you or not.

Regards,

Neeraj Jain