How To Process SAP Table Data with Katalon Recorder

Hello community,
the new option to use JSON data files with Katalon Automation Recorder is fantastic. I want to know if it is possible to process SAP table data on the same way. So I programmed a tiny ABAP report which delivers via the JSON serializer table data, in my case I use standard training table SFLIGHT.

"-Begin------------------------------------------------------------REPORT z_json_for_katalon_recorder.DATA:  lt_sflight      TYPE STANDARD TABLE OF sflight,  lv_sflight_json TYPE string  .SELECT * INTO CORRESPONDING FIELDS OF TABLE lt_sflight FROM SFLIGHT.lv_sflight_json = /ui2/cl_json=>serialize( data = lt_sflight ).BREAK-POINT."-End--------------------------------------------------------------

I stopped the execution and copied the data from the variable lv_sflight_json from the debugger, not elegant but pratically for my experiment.

Now I create an HTML side with the fields of the table.

<!DOCTYPE html><html>  <head>    <title>SFLIGHT</title>  </head>  <body>    <form>      <table>        <tr><td>CARRID:</td><td><input type="text" name="carrid" id="carrid"></td></tr>        <tr><td>CONNID:</td><td><input type="text" name="connid" id="connid"></td></tr>        <tr><td>FLDATE:</td><td><input type="text" name="fldate" id="fldate"></td></tr>        <tr><td>PRICE:</td><td><input type="number" name="price" id="price"></td></tr>        <tr><td>CURRENCY:</td><td><input type="text" name="currency" id="currency"></td></tr>        <tr><td>PLANETYPE:</td><td><input type="text" name="planetype" id="planetype"></td></tr>        <tr><td>SEATSMAX:</td><td><input type="number" name="seatsmax" id="seatsmax"></td></tr>        <tr><td>SEATSOCC:</td><td><input type="number" name="seatsocc" id="seatsocc"></td></tr>        <tr><td>PAYMENTSUM:</td><td><input type="number" name="paymentsum" id="paymentsum"></td></tr>        <tr><td>SEATSMAX_B:</td><td><input type="number" name="seatsmax_b" id="seatsmax_b"></td></tr>        <tr><td>SEATSOCC_B:</td><td><input type="number" name="seatsocc_b" id="seatsocc_b"></td></tr>        <tr><td>SEATSMAX_F:</td><td><input type="number" name="seatsmax_f" id="seatsmax_f"></td></tr>        <tr><td>SEATSOCC_F:</td><td><input type="number" name="seatsocc_f" id="seatsocc_f"></td></tr>        <tr><td></td><td></td></tr>      </table>    </form>  </body></html>

And in the last step I create my Katalon Recorder test case and executes it.

It runs without any problems. :slight_smile: I processed 405 records.

On this way we have the possibility to export any data table with any SELECT possibility from OpenSQL in SAP you like and to process them in a WebUI with Katalon Automation Recorder.

Thanks to the Katalon Team for this tool and this possibility.





Hello Community,

for additional information please look here.

Best regards

Awesome. Thanks Stefan for sharing this. :slight_smile:

1 Like

Great work stephan

1 Like