QlikView Connectivity

[atsushi_saijo]

Hi Gurus, Is it possible to process an array of record set via BAPI? The BAPI is slow. It takes approx. 1 second per record (in case of Forex rate).

Current loading code for BAPI (BAPI_EXCHANGERATE_GETDETAIL)  is printed as below. It would be very nice if I could process multiple values in "EUR" part, by inserting "EUR","JPY","USD" .... and so on. I have attempted, but resulted in error. It may be that it is because output table expects single record only. I should appreciate for your valuable input in advance.

LOAD *;

SQL {

  "function":"BAPI_EXCHANGERATE_GETDETAIL",

  "output":"EXCH_RATE",

  "parameters":

  [

    { "direction":"out", "name":"RETURN", "optional":false },

    { "direction":"out", "name":"RETURN", "optional":false },

    { "direction":"in", "length":8, "name":"DATE", "optional":false, "type":"DATE", "value":"$(i)" },

    { "direction":"in", "length":5, "name":"FROM_CURR", "optional":false, "type":"CHAR", "value":"GBP" },

    { "direction":"in", "length":4, "name":"RATE_TYPE", "optional":false, "type":"CHAR", "value":"$(vExcType)" },

    { "direction":"in", "length":5, "name":"TO_CURRNCY", "optional":false, "type":"CHAR", "value":"EUR" }

  ]

};

//*****

[atsushi_saijo · Accepted solution]

It was verified from an ABAP programmer that it is one-by-one conversion. In general it sepends on BAPI. Some BAPI allows multiple tuples to be processed. I will turn the question down.