Extract Data from SAP Tables

[#1]

Hey All,

Can someone please let me know what would be the best option to extract Data from SAP ECC tables and get in PI without writing any custom ABAP code.

I am aware that we can write RFC, ABAP Proxy etc to extract data from ECC and then send to PI but we often get requests to send data from SAP tables to other systems and developing custom ABAP code is becoming tedious.

One option i have found so far is FM RFC_READ_TABLE, this can be called from Message mapping via RFC lookup but it gives the complete table dump and could cause performance issue if table is big.

We are on PI 7.4

Thanks,

[vicky20691]

Hi Saif,

1. RFC lookup - In case you need only few things out of a table, of course atleast a small RFC code must be written

2. Proxy- It is good in performance compared to RFC for synch calls but again in ECC coding has to be done.

3. As praveen said, your requirement can save you from coding if it involves only standard BAPI or IDOCs.

Regards,

Vikas

[Former Member]

Hi Saif,

For most of the requirement there is standard IDOC, BAPI or Enterprise Services available, for example sales order, purchase order etc, check first for your requirement is there any standard IDOC, BAPI or Enterprise service then use it standard solution rather than creating custom development.

Regards,

Praveen.

[Former Member]

Hello Saif,

RFC and proxy are the only ways.

I would suggest Proxy because you can customize and get the required table fields.

Or If by chance Hana is ur backend you can make a JDBC call.

There are no other ways apart from this to get sap table values.