Fetch the data at runtime from SAP

[Former Member]

Hi All,

There is a requiremnt that i need to implement?

I will get a file and then i will process that file in XI and at runtime i need to fetch the data from SAP and then generate the output.

Suppose for Ex:

I am geting a file containing a business partner and then i need to check in SAP whether the business partner exist or not and the other datils of that business partner from SAP and then i need to proceess the file with that details and thus generating the output.

So what all the things that i may need for this scenerio?

How can i achive this?

I hope i can achive this by BPM, if yes then can anyone let me know the steps that i need to follow for this?

I will be highly oblidge for your support...

Many Thanks,

JAY

[Former Member · Accepted solution]

Hi Jay,

R u using any RFC for this scenario.

If u r using RFc then u can achieve this using BPM or without BPM.

Just refer the below links for more detail which has the same requirement.

File-RFC-File without BPM:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file-rfc-file%28without+bpm%29&;

With BPM.

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

u can also do it with RFC lookup:

• RFC lookup using JCO (without communication channel)

/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

• RFC lookup with communication channel.

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

Thnx

Chirag

[Former Member]

.

[Former Member]

Thanks Chirag and Raj for your valuable time and quick responce.

I will definitely look at this and get back to you if i there occured any problme.

Point is assigned :::

Good job enjoy....:)

Thanks,

JAY.

[Former Member]

Thanks A lot Chirag & Raj for your quick reply.

The file scenerio will be FILE(XML)--XI---FILE(XML)

And while runtime and doing a processing in XI i need to get the data from SAP(EX: All the details for that business partner)

and then generate the output(XML FILE) with all that detials fetched from SAP.

Is it like in Mapping i will create a UDF and then do a lookof from SAP and then get the details from SAP and then generate the output or something else.

Please let me know.

Thanks,.

JAY

[Former Member]

Hi Jay,

Thats what my first question to you.

R u using Std RFC Function module to get the business partner detail.

If u r using the Std RFC FM then u can go with BPM or Without BPM. I suggest to try without BPM link is provided to you.

In above link: The scenario is similar which u r looking for.

Only difference is they are getting the company code from file and through RFC they get the company details and they send these details in output file.

If u go thorugh the weblog then u get more idea. I suggest u start replicating the weblog with respect to your scenario.

Thnx

Chirag

[prateek]

Is it like in Mapping i will create a UDF and then do a lookof from SAP

Exactly, yes.

Regards,

Prateek

[Former Member]

Which one will be the better option for this..

Thanks,

JAY

[Former Member]

Hi Jay,

U can try FILE-RFC-FILE without BPM.

In RFC lookup u need to write the UDF for calling the FM in SAP.

Thnx

Chirag

[prateek]

Ur scenario is File - XI - Output.

Now in between as u want to access data from SAP, u may perform RFC lookup to check whether business partner exist or not. No BPM would be required in this case.

Regards,

Prateek