1 Reply Latest reply: Jan 30, 2017 9:08 AM by Atsushi Saijo RSS

    SAP BAPI: processing array of input data possibility?

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

        ]

      };

      //*****