Limit file Bank Statment FF.5

[MariaSouza]

Hello Experts,

Please!!!
I have a scenario where I will get a file with more than 1 million records every day of bank statement to be processed by FF.5 transaction in an S4 Hana environment with Linux and Hana database. I need to know if there is a processing limit for this bank statement file on S/4 version 2022 or can I process any value, 100.000 lines... 200.000 etc?
What best practices for processing bank statement files over 100,000 line items?
Is splitting the bank statement file into files of 50,000 line items on the Value Added Network the best solution processing these files in parallel jobs?

Thanks in advance,

Maria

[Edrilan_Berisha · Accepted solution]

Hi,

so we have some logic in place if you upload the bank statement file as MT940. That we create those bank statements and we have multiple pages. So the limit for a bank statement is 99999 items. That is the technical limit of the database. If this is reached we basically create a second page for that bank statement (FEBKO-AZPGNO). Here we add again up to 99999 items. And this goes on until all items are mapped.

This does not exist though for other file formats. Unless you talk about camt file formats. Then this should also work with release OP2023 and higher.

My personal advice is: ask your bank to split these bank statements themselves into multiple pages, once they reach 99999 items. This is more performant for the import and processing than doing it in the system.

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development