cancel
Showing results for 
Search instead for 
Did you mean: 

RFC lookup error when table in change mode

Former Member
0 Kudos

Hi,

I´m using an RFC lookup from XI to translate external to internal partner nr. Input to the FM in R/3 is the external partner nr och the FM should return the internal partner nr to XI. The problem is that when a user edits the table that my FM reads from a get an error.

- Isn´t it possible to read a r/3 table while it is in change mode? Is my only way around this to create a z version of this table?

/

Claes

Accepted Solutions (1)

Accepted Solutions (1)

stefan_grube
Active Contributor
0 Kudos

When your RFC is not able to read a table, when this is locked by a dialog, then you have to change the RFC.

Regards

Stefan

Answers (3)

Answers (3)

prateek
Active Contributor
0 Kudos

In my opinion, when the table is in change mode, then it creates a database lock. And according to the rules of database management, this connection to this table could not be opened by any other application.

Now when the code in RFC e.g. select query, tries to access the databse, it tries to opens a connection with the table. At that time it must be throwing an exception that should be handled at RFC.

Lets wait for more inputs by experts. It would be great if some1 could explain the mechanism.

Regards,

Prateek

Former Member
0 Kudos

The problem wasn´t the RFC call. We have a problem with our runtime environment but thank you all for the help.

BR

Claes

Former Member
0 Kudos

Hi Claes

have a look on these links ,

For your RFC lookup,

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

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

RFC lookups pdf https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-code-samples...

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

Michal's Blog on RFC Mapping Lookup:/people/michal.krawczyk2/blog/2005/09/15/xi-rfc-mapping-lookups-from-bc-to-xi

http://help.sap.com/saphelp_nw2004s/helpdata/en/17/d609b48ea5f748b47c0f32be265935/frameset.htm

Also check this useful link which also talk about Value Lookup:

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

Thanks !!