Skip to Content
avatar image
Former Member

Select r/3 kna1 from CRM

Hi Gurus,

I have to look at R/3 tabla kna1 and knvp. I'm in CRM but I don't know how to search in the r/3 system.

Please help.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 01:09 AM

    Hi,

    There's an RFC-enabled function module which allows you to select data in a remote R3 system - I think it's called RFC_TABLE_READ (or something similar). Basically, you just supply your selection criteria in one table and a list of fields you'e looking for (along with the table name, of course) and then you get a list of matching records back.

    Hope this helps, Andy

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2010 at 12:17 AM

    Howdy,

    Create a remote enabled function module in ECC (if one doesn't already exist that will meet your requirement) and call it from CRM.

    Cheers

    Alex

    Add comment
    10|10000 characters needed characters exceeded

    • But only do that (RFC FM) keeping in mind the volume of data selection and the frequency of data request.

      If you need large volume of data and/or data is requested from source system at frequent time intervals, the best way to approach would be to do it using Proxies via PI/XI (if your customer is using PI that is).

      Cheers,

      Sougata.

  • avatar image
    Former Member
    Sep 20, 2010 at 09:21 PM

    What exactly is the problem? Are you in the CRM system, trying to return data from R/3 to CRM? Or are you in R/3 and don't know how to read the table data?

    Rob

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 11:26 PM

    I'm in CRM, and I need to search in R3.

    Basicly the function process is:

    CRM----


    > go to r/3 to search data. -


    > give data back to CRM.

    Add comment
    10|10000 characters needed characters exceeded