GuiXT (SAP R/3) - Koehn Consulting, Lyss

Reading a table

Reading any table from SAP ERP

SAP offers an RFC function module, RFC_READ_TABLE, enabling any table to be read through RFC.
The script below is an example of how you can read the MVKE table for a specific material by means of a call instruction.
It has been possible to transfer the values of the material grouping (KONDM) and the product hierarchy (PRODH) fields in their own variables.

// Example for reading any transparent table
// and transfer to GuiXT variables
// 10.05.2003 / Gérald Koehn / Koehn Consulting / www.guiXT.ch

// Initialising texts or tables 
copytext toText="M_Fields" fromString="M_Leer"
copytext toText="Daten" fromString="M_Leer"
copytext toText="Bedingung" fromString="M_Leer"
// Setting the Where condition obligatorily without a dot at the end, otherwise a dump occurs !
set V[M_Bedingung] "MATNR = '&V[Material]' and VKORG = '1000' and VTWEG = '10' "   
// Transfer string to condition table 
copytext toText="Bedingung" fromString="M_Bedingung"
// Definition of fields to be read
set V[M_Fields_01] "KONDM"
set V[M_Fields_02] "PRODH"
// Filling the table with the fields to be read  
copytext toText="M_Fields" fromString="M_Fields_01"
copytext toText="M_Fields" fromString="M_Fields_02" -appendline
// Calling RFC  module
call "RFC_READ_TABLE" in.QUERY_TABLE="MVKE" table.OPTIONS=Bedingung table.FIELDS=M_Fields table.DATA=Daten
// Transferring data that have been read from table to variable
copytext fromText="Daten" ToString="M_Daten"
// Filling the individual fields through allocation of partial string
set V[M_MVKE-KONDM] "&V[M_Daten](1-2)"
set V[M_MVKE-PRODH] "&V[M_Daten](3-20)"

Whereby in condition V[M_Bedingung] the part of the ABAP syntax of the WHERE condition is recorded.
In the M_Fields put those individual fields which you wish to get back by reading the table.
From the DATA table, the data are transferred to the "Data" text. The “Data” text is assigned to a variable [M_Daten].
By means of allocation, individual parts of M_Daten are assigned to the individual variables.

In this way the material grouping and the product hierarchy are now available for the material contained in the &V[Material] variable.