4 Replies Latest reply: Jun 14, 2017 1:02 AM by Benjamin Stähr RSS

    SAP Report Connector - How to choose list format option

    Benjamin Stähr

      Hey guys,

       

      I'm trying to read data from Cluster B2 where I'm interested in the SALDO table.

      I identified the SAP Report Connector as the best way to do that.

       

      So I first fired up transaction  SE38 to check out RPCLSTB2. I get the following Options:

       

       

      Please notice that I chose 'Detailed description of all table entries'. Now when I run this I get exactly the desired results.

       

      I then switched to the Qlik SAP Report connector, which presents me with the following options (please click to view entire image):

       

       

      The resulting query returns the same information that can be seen in the preview window, which is not what I was after. It is the same data I would get from the above SAP dialog would I choose "List of personnel numbers and periods" in the List format options.

       

      How can I specify the desired "Detailed description of all table entries" in my query?

       

      Thanks and cheers

      Benjamin

        • Re: SAP Report Connector - How to choose list format option
          Hakan Ronningberg

          Hi Benjamin,

           

          Try creating a variant in SE38  with 'Detailed description of all table entries' selected, under the Menu: Goto/Variants/Save As Variant...

           

          Then enter the name of the Report and the variant name in the Report connector before 'Get'.

           

          Regards,

          Hakan

            • Re: SAP Report Connector - How to choose list format option
              Benjamin Stähr

              Hi Hakan,

               

              thanks for your suggestion.

               

              However as you can see, I specify a period. This would mean that I would have to manually create a variant each month. So this isn't the solution I was looking for.

               

              I fear that what I'm going for isn't achievable via the report connector and I might have to write an ABAP program.

                • Re: SAP Report Connector - How to choose list format option
                  Hakan Ronningberg

                  Hi Benjamin,

                   

                  I think you can solve it by using the 'Select Options' button in the Report connector. I tried the following script and it worked:

                   

                  set zyear=2005;

                  set zperiod=200501;

                   

                  CUSTOM CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=99.88.777.66;SYSNR=06;CLIENT=800;XUserId=bZVNHUJOHLSB;XPassword=xxx;";

                   

                  [RPCLSTB2]:

                  Load [Field0_] AS 'Field name',

                  [Field1_] AS 'Field cont.',

                  [Field2_] AS 'Description';

                  Select SAPREPORT (REPORT (RPCLSTB2), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (6),

                  OPTIONS (

                    (SELNAME LIST1, KIND P, SIGN I, OPTION EQ, LOW  ),

                    (SELNAME LIST4, KIND P, SIGN I, OPTION EQ, LOW X),

                    (SELNAME SELCLTYP, KIND S, SIGN I, OPTION EQ, LOW 1),

                    (SELNAME SELPABRJ, KIND S, SIGN I, OPTION EQ, LOW $(zyear)),

                    (SELNAME SELPERIO, KIND S, SIGN I, OPTION EQ, LOW $(zperiod))

                  ));

                  //Store * from [RPCLSTB2] into RPCLSTB2_OPTIONS.QVD;

                  //Drop Table [RPCLSTB2];

                   

                  You have to calculate the variables in the script (like zperiod) you want to use, at each execution time.

                   

                  Regards,

                  Hakan