How this cenario can be achieved..

[Former Member]

Hi Experts,

FILE - SAP - scenarios

I will receive a flat file from SFTP which consists of Customer details with a delimiter(C/D).

The process will check and convert the customer number and partner number if required and also the existence of partner information in SAP tables. The sales area information for that customer will also be extracted.

next we havr to create a output file with some predefined format.

Then we have to load sap program(RFBIDE00) which will execute in a job and execute the session

Regards

Kiran Kumar

[Former Member]

Question answered

[Former Member]

Kiran,

I will receive a flat file from SFTP which consists of Customer details with a delimiter(C/D).

Will you be using a 3rd party adapter for SFTP? If yes, the Public Key will be exchanged between the PI system and the 3rd party System.

If you are not using the 3rd party adapter, then I believe you are SFTPing the file to a folder in the PI landscape using UNIX script with secured protocol. In this case, you will be using File adapter (NFS mode) to pick the file from File System.

Let us know if you have more questions.

Regards,

Neetesh

[Former Member]

What Raj says sounds good.

Also, these resources may help you:

File to IDOC step by step (you can very easily change this to BAPI to call your function rather than IDOC)

[http://wiki.sdn.sap.com/wiki/display/XI/FileToIDOC]

RFC Lookup UDF function example

http://wiki.sdn.sap.com/wiki/display/Snippets/User-definedMappingFunctionforRFC+Lookup

File to RFC to File scenario without using ccBPM

http://wiki.sdn.sap.com/wiki/display/XI/File-RFC-File%28Without+BPM%29

[rajasekhar_reddy14]

Hi ,

Your scenarios looks simple only

1) Use sender File Adapter to read the data from SFTP Server,use file content conversion in sender side to convert to XML data.

2)then you need to perform RFCLookup,Why RFC Lookup here to retrieve the data from SAP Tables,

3)Then send the data to receiver with predefined format,that mean use graphical mapping to perform the same.

4)if you want to send the data to SAP use IDoc/RFC Adapters.

Regards,

Raj