Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
atsushi_saijo
Creator II
Creator II

SAP BAPI: processing array of input data possibility?

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" }

  ]

};

//*****

1 Solution

Accepted Solutions
atsushi_saijo
Creator II
Creator II
Author

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.

View solution in original post

1 Reply
atsushi_saijo
Creator II
Creator II
Author

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.