Currently we are implementing SAP (ERP software) across the company and we have a requirement to send the EFT’s (payments) file by building an integrated interface with some bank. Initially, SAP FI generates the file and is placed in a predefined directory in client ERP on outbound side and PI needs to encrypt the file using PGP by AES 128/256 algorithm & need to post the xls files to SFTP/FTP folder on inbound side from where a server at Bank’s end will pick the file on a scheduled basis.... I have some initial queries mentioned below to build this interface:
1. Since they need only xls files to be posted to FTP/SFTP folders, is it possible by standard option in PI other than custom module/mappings to convert xml to xls ? or Can I ask them that PI converts only to csv & post them to the inbound folders from where bank people can convert .csv to .xls by any batch script themselves?
2. What all information should I gather from Bank people[inbound] side for above scenario to be implemented ?
Also please suggest me better design options other than customization for xls conversion in this scenario.