BAI flat file format?

[Former Member]

Hello All,

Can any one tell me, can we process the BAI falt file in PI7.1 system.

If any one done this requirement,Please let me know how to do this scenario.

Thanks and Regards,

Phani Kumar M

[Former Member]

Hi,

You need to convert it into XML format using some tools like conversion agent

http://help.sap.com/saphelp_nwpi711/helpdata/en/48/c1e7d95c284da5e10000000a421937/content.htm

Regards

Suraj

[Former Member]

Hi

Can you more it clearly? about your requeriment...

I guess you need to configure and IDOC -Flat Scenario?

[Former Member]

My requirement is like this.

i will receive Flat file(BAI) and i need to process the file through PI and send it to SAP system.

I cant buy any thrid party adapter and i need to do with PI7.1 only.

if any one done this type of requirement please let me know.

Thanks

[Former Member]

Hi Chinna,

This file is used for SAP financial purposes and this does interact mainly with the Banks. Banks have different format like bai, bai2 etc. BAI and BAI2 formats differ in their level of information detail. BAI does not separate out the incoming check line items by invoice subtotal reference. Conversely, BAI2 splits the check total into separate invoice references and associated payment amounts. As a result, your hit rate percentage of payment-invoice matching from each transmission is likely to be higher when using BAI2 rather than BAI formats.

Now coming to your question that you are getting a bai file and you need send to sap. Usually how we approach this is we will read the legacy file with file adapter and then will convert into the bai file format and drop the converted file on a shared drive. There are standard programs in sap which picks this file and loads the data in sap. If your client has different structure then the abaper may need to change the program accordingly.

The Bai file format you can take a look here:

https://businessonline.huntington.com/common/cms/help/BAI1Technical%20Ref%20Manual.pdf

Also please look into this help:

Note 86952 - El. bank statemt:BAI format (you can see the standard programs here)

http://help.sap.com/saphelp_45b/helpdata/en/0d/1a4b6e5733d1118b3f0060b03ca329/frameset.htm

The bottom line is the standard program in SAP expects this format and you using PI will make this file from your legacy file. How it loads into sap can be find from any of your FI consultant, he will be aware of all this.

Regards,

---Satish

[ravi_raman2]

you also might want to see if SAP can load the file directly into ECC as its a standard format and it can be loaded.

Regards

Ravi Raman