topic Replacing SAP Views? in Application Development and Automation Discussions

Replacing SAP Views?

Former Member — Wed, 09 Aug 2006 10:59:55 GMT

Hi,

We have a requirement where in the business is accessing SAP data via SAP Views which is directly accessing SAP Database. SAP Views were implemented long back considering the

-performance

-the volume of data

-and the number of tables that needs to be accessed

Considering, this is not a good approach of reteriving data. Is there any better design approaches that can be replaced for this SAP views.

We evaluated using RFC, but since RFC talks to databases and retrives the data..it took much longer time to perform the transaction than the current SAP View mechanism..

Please let me know incase you have any suggestions to overcome this design limitation,

Regards,

Vinayak Kamath

Re: Replacing SAP Views?

Former Member — Wed, 09 Aug 2006 11:02:40 GMT

Write efficient report programs to fetch the required data.

Users directly access the views? Or is there programs which fetch data from views?

Re: Replacing SAP Views?

Former Member — Wed, 09 Aug 2006 11:02:46 GMT

Hi,

I hope , they are using these views somewhere in programs.

How about using Inner joins , instead of views in programs.

regards.

santosh.

Re: Replacing SAP Views?

Former Member — Wed, 09 Aug 2006 11:14:19 GMT

Ok..Let me put some more light on this..

We have a VB Application which invokes this SAP views and executes the query.

We are finding a way 2 replace this setup with a better design approach.

Re: Replacing SAP Views?

Former Member — Wed, 09 Aug 2006 11:17:06 GMT

Create RFC FM;s which can be called from VB.

check the FM RFC_READ_TABLE.

Cheers