topic Re: Read from a Screen field in Application Development and Automation Discussions

Read from a Screen field

Former Member — Mon, 05 May 2008 15:11:34 GMT

Hi,

I am attempting to read data from SAP screens rather than tables with an RFC connection (from VBA). I am able to fluently write data into SAP using this method. Can someone guide me on how to read the data? Thanks.

Regards,

Krishna Kumar

Re: Read from a Screen field

Former Member — Mon, 05 May 2008 15:21:32 GMT

Hi,

It is not possoble to read the data from the screen directly.

The data which is visible on the screens is fetched from some tables.

You can only write a RFC Function module which fetches the data from the datbase tables .

SO, find the tables in which the data is stored for the fields that you see on the screen and code to fetch the data from the corresponding tables in a RFC function module, which can be called from external applications like VBA.

Regards,

Ravi

Re: Read from a Screen field

Former Member — Tue, 06 May 2008 07:07:33 GMT

Hi Ravi,

I am already aware of the method to read data from tables using VBA. However, this means I will have to write multiple queries to read the data from the same transaction for e.g. for transaction VA43, I will need to read tables VBAK, VBAP, VEDA, FPLA etc.

What I am looking for is something similar to how TxShuttle reads data from SAP, using the screen fields.

Regards,

Krishna Kumar