Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Replacing SAP Views?

Former Member

‎2006 Aug 09 11:59 AM

0 Likes
532

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

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

Reply
4 REPLIES 4
Read only

Former Member

‎2006 Aug 09 12:02 PM

0 Likes
506

Write efficient report programs to fetch the required data.

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

VJ

Read only

Former Member

‎2006 Aug 09 12:02 PM

0 Likes
506

Hi,

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

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

regards.

santosh.

Read only

Former Member
In response to Former Member

‎2006 Aug 09 12:14 PM

0 Likes
506

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.

Read only

Former Member
In response to Former Member

‎2006 Aug 09 12:17 PM

0 Likes
506

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

check the FM RFC_READ_TABLE.

Cheers

VJ