5 Replies Latest reply: Aug 20, 2015 6:10 AM by Максим Рыбалко RSS

    SAP Report Connector 5.9 set several values to variable

    Максим Рыбалко

      I use QlikView SAP Connector 5.9IR.

       

      I want transaction to return data for several materials. The materials list changes every day. So I cannot use variants but "Select Options". How can I set several values to variable? 

       

      For example my query to SAP:

      Select SAPREPORT (REPORT (ZLO_ASSORT), ROWS_PER_RECORD (1), SKIP (T (2), T (1), T (3), T (4), T (6), T (7), T (8), T (9)), 

      OPTIONS (

        (SELNAME P_BUDAT, KIND P, SIGN I, OPTION EQ, LOW 20150727), // report date

        (SELNAME S_MATNR, KIND S, SIGN I, OPTION EQ, LOW 59),  // material

        (SELNAME S_WERKS, KIND S, SIGN I, OPTION EQ, LOW 5569) // plant

      ));

      Now I want to get information for materials 59, 77, 123.

      I tried

      Select SAPREPORT (REPORT (ZLO_ASSORT), ROWS_PER_RECORD (1), SKIP (T (2), T (1), T (3), T (4), T (6), T (7), T (8), T (9)), 

      OPTIONS (

        (SELNAME P_BUDAT, KIND P, SIGN I, OPTION EQ, LOW 20150727),

        (SELNAME S_MATNR, KIND S, SIGN I, OPTION EQ, LOW 59),

        (SELNAME S_MATNR, KIND S, SIGN I, OPTION EQ, LOW 77),

        (SELNAME S_MATNR, KIND S, SIGN I, OPTION EQ, LOW 123),

        (SELNAME S_WERKS, KIND S, SIGN I, OPTION EQ, LOW 5569)

      ));

      Connector returns 1 string: the first material (59) only. In SAP there is information about each material. Any ideas?