SAP TABLE

[Former Member]

Hi All,

We have one scanario in XI.We are going ti integrate WBI and SAP R3 using XI. we are getting input from WBI and post an IDOC to SAP.

But before posting the IDOC to SAP,we need some values from SAP TABLE.Based on those values,we need to populate IDOC fields and then post that IDOC to SAP.

Before fetching the values from SAP,we have to chck certain conditions.

Could you please suggest the possible and efficient way to do this?

[Former Member]

Hi Rajesh,

You have to use RFC lookup in this case. Please refer to following links.for all kinds of lookups.

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

DB lookup - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

SOAP Lookup - /people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0

Lookup’s in XI made simpler - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

Lookups - /people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

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

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

Lookups with XSLT - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e7daa90-0201-0010-9499-cd347ffb...

/people/sravya.talanki2/blog

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05a3d62e-0a01-0010-14bc-adc8efd4...

How we have to create the lookups?

Check this weblogs with some screenshots on how to achieve this:

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

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

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

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

Ranjeet Singh

[Former Member]

Hi,

I dont sugest u to go for Look ups ,sorry to say this but i dont find any use of it.

Doing BPM will be a performance issue and no one prefer for BPM.

Next u can do this for every IDOC u will have a standard funtion that will insert the data in to SAP,so find out for an User exit,Just try to check the flow of the data and after checking the flow u will get an idea were u have to take the data from the tables.

At that point check for user exit,u can find lot of them,there u can wrtie ur abap code,

i have done this type of senarios in my project.

Regards,

phani

Reward points if helpful

[Former Member]

Hi,

I would suggest BPM. Place a sync. Send step to retrieve the information you need via RFC. After that make a transformation step. You will need a multi-mapping to merge the information from different source messages into one target message.

Samples for multi-mapping can be found in your integration repository. They are delivered by SAP . Can be found in SWC: SAP BASIS --> patterns

Regards Mario

[nisarkhan_n]

Yes you can, try to use the RFC lookups in that RFC lookup pass the input and do the calculation and return the output from the RFC.

Search the forum for the details on the RFC Lookups