Link SRM and back-end in a query

[Former Member]

hi experts,

i'm doing a query in SRM 4.0 with a back-end ECC 6.0.

This query includes some TABLES/VIEWS of SRM and others of ECC 6.0 (MM module). Pay attention: i know how is possible to link the views between them, i need to know how to connect two system (SRM and ECC6.0 - MM module) in the same query.

thanks a lot

ab

[Former Member]

Hi,

As Atul suggested,best way to fetch the data from R/3 backend in SRM would be to use RFC enabled FM's/BAPI's rather then writing SELECT statements.Also it would be nice if you can elaborate your query for further suggestions.

BR,

Disha.

<b>Pls reward points for useful answers.</b>

[Former Member]

Hi,

thank you for your response. This query is developed with tool SQ01, and his scope is to get data from R/3 tables (Eban,Ekko,Ekpo,Lfa1) and SRM tables (BBP_PDView_IAP,BBP_PDView_ACC,...), for view shopping cart state on SRM, and its relative Purchase Order on MM.

Can you make me an example for RFC-enabled function modules (Business APIs) ?

thanks a lot

ab

[Former Member]

Hi

I have not tried this.. but try using RFC-enabled function modules (Business APIs) - BAPI Function modules to get this done.. This can be done easily using BAPIs.

Regards

- Atul