Query and retrieval of SAP table data

[Former Member]

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

[Former Member]

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.

[baskar_gopalakrishnan2]

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.

[Former Member]

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