Skip to Content
avatar image
Former Member

Query and retrieval of SAP table data

Hi,

Within PI Is it possible to use a select query on an ECC table and retrieve the relevant data. The data will then need to be mapped to the output.

Can this be achieved through an RFC call?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 12, 2012 at 05:42 PM

    Hi,

    You can use RFC lookup and map the output to target field.

    view this article for step by step process...

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40b64ca6-b1e3-2b10-4c9b-c48234ccea35

    Hope this helps....

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2012 at 05:56 PM

    You can access SAP ECC backend table using IDOC, RFC and ABAP Proxy. You can use graphica RFC lookup during mapping and retrieve the data from the backend and use them for mapping to the target data structure.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2012 at 06:02 PM

    Thanks for your responses so far.

    Should of mentioned before I am using PI 7.0 EhP 14, not sure if this poses additional issues.

    Add comment
    10|10000 characters needed characters exceeded