ACH File transfer via PI to ECC

[Former Member]

requirement is some bank sends ACH Nacha file and this need to be transmitted to ECC via SAP PI.

If anybody has done this please provide inputs OR if there is any standard program available in ECC to read this file, please let me know

Iam looking at the file format.

It has

1) File Header Record

with in this it has 2) Batch Header Record

With in this 3) First Entry Detail Record (unbounded)

At the same level as 3) another one 4) Second entry detail record...(optional and unbounded)

At the level as 2) Batch Control Record

At the level of 1) file control Record.

If you can google it you can get ACH NACHA format.

http://www.regaltek.com/docs/NACHA%20Format.pdf

[Former Member · Accepted solution]

Hi Vamsi,

You use File content parameters but that is very difficult job, if your fields are more than level 3 then we can go for XSLT or java mapping.

<REMOVED BY MODERATOR LINKS CAN BE SEARCHED>

Regards,

Venkata Ramesh

Edited by: Prateek Raj Srivastava on Dec 9, 2011 10:21 PM

[Former Member]

Hi Vamsi,

It is very much executable at PI end only.

It has been done earlier of similar kind FCC but in retail.

If you have standard content for Retail STORE_CONNECTIVITY, you will get an exact match and parameters they have used to convert the POS files (similar to your ACH file)

Regards

Ramesh

[rajasekhar_reddy14]

Hi Vamsi,

It is very difficult write File content conversion for ACH file .

i had done Bank system and ECC integration using PI, but we connected to Bank system and pulled the ACH file and placed in to FTP(Just dumping no conversion) and standard ABAP Function module/Program processed it.

in you case first check with ABAP Team ,i think they use standard one only, so dump the file.

challening here is connecting to bank system, most of the times they use FTPS/SFTP.

Regards,

Raj

[Former Member]

Hi,

Usually for these kind of requirement you dont need to anything in PI since SAP standard program will take care of file reading with Industry specific format...check with yout functional team or you can get it from SAP Help also...unless otherwise there is lot of custom requirement inside PI before it hits ECC.

[baskar_gopalakrishnan2]

Basically you need to do file content conversion at the sender side to convert the data structure to xml. Receiver end you can use as per need like idoc or proxy.

Since your data structure has hierarchy, you might want to see these links for the sender side for starting. FCC does not support higher level of hierarchy more than two. Also search sdn on handling complex fcc structure.