Read from a Screen field

[Former Member]

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

[Former Member]

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

[Former Member]

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