Skip to Content
avatar image
Former Member

RFC lookup error when table in change mode

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Sep 18, 2007 at 01:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 01:56 PM

    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/xi%20mapping%20lookups%20rfc%20api.pdf

    /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

    RFC Lookup.

    RFC lookup return no values

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

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

    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 !!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 02:00 PM

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

    BR

    Claes

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2007 at 02:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded