6 Replies Latest reply: Sep 19, 2013 2:51 AM by s j RSS

    Read SAP STXL

    Carlos Lisboa

      Hi all,

       

      I need to obtain the long text for each fin. document.

      AFAIK it's stored in the STXL table, but i can't access it's data, it's encoded, and the only way to get the information is with the help of an ABAP function: READ_TEXT.

      Has anyone ever needed to get this information? How did you get it?

       

      Regards,

      Carlos

        • Re: Read SAP STXL
          Norbert Lidauer

          Hi Carlos,

           

          I have the same problem, did you find a reason to show the encoded long text in Qlikview?

           

          Thank you

          Norbert

            • Re: Read SAP STXL
              Carlos Lisboa

              Hi Norbert,

               

              Since then the issue has become somewhat dormant.

              I've talked to my SAP guy and he's going to create a table that will be populated with an SAP Report every night for each document that has the encoded long text.

              It's still in the works so i don't really know if this is going to work but it should

              The table is only half million records long, so it shouldnt be a big deal.

            • Re: Read SAP STXL
              Yevgeniy Popov

              Hi,

              Sap connector is work on function

              You need know input, output parameters function

              If you have SAPConnector, you need input Database : QvSAPBAPIConnector.

               

              Be write row connect

               

              Sample Kod my function:

              Test:

              Load

                num(MATNR) ,

                  LIFNR ,

                  text(WERKS) ,

                  DMBTR ,

                  BUDAT ',

                  BLART ;

              SQL You Abap kod;

              Sample:

              SQL {

                "function":"You function",

                "output":"You Data",

                "parameters":

                [

                  {

                    "direction":".......",

                    "name":"...........",

                    "optional":.........,

                    "table":

                    [

                      { "field":"BUKRS", "length":4, "type":"CHAR", "values":[] },

                      { "field":"GJAHR", "length":4, "type":"NUM", "values":[] },

                      { "field":"MONAT", "length":2, "type":"NUM", "values":[] },

                      { "field":"LIFNR", "length":10, "type":"CHAR", "values":[] },

                      { "field":"MATNR", "length":18, "type":"CHAR", "values":[] },

                      { "field":"WERKS", "length":4, "type":"CHAR", "values":[] },

                      { "field":"DMBTR", "length":7, "type":"BCD", "values":[] },

                      { "field":"WAERS", "length":5, "type":"CHAR", "values":[] },

                      { "field":"BLART", "length":2, "type":"CHAR", "values":[] },

                      { "field":"BUDAT", "length":8, "type":"DATE", "values":[] }

                    ]

                  },

                  { "direction":"in", "length":4, "name":"I_GJAHR", "optional":false, "type":"NUM", "value":"$(i_gjahr)" },

                  { "direction":"in", "length":2, "name":"I_MONTH", "optional":false, "type":"NUM", "value":"$(i_month)" }

                ]

              };

              $(i_gjahr) and $(i_month) - QlikView variable

              • Re: Read SAP STXL
                Yevgeniy Popov

                ABAP function: READ_TEXT

                Long names are stored in the YYY within a few tables at once. In theory, you need to pass parameters to specify key, and get ready table, where a great name will be written in a few lines.
                But I have not tested

                  • Re: Read SAP STXL
                    Carlos Lisboa

                    I know how to use the READ_TEXT function, my question and problem was not how to use it.

                    I wanted to know a way to read the table without the combersome of the ABAP function.

                     

                    In the end we solved it by scheduling daily a report that translates the table to another one table that QlikView is able to read.

                  • Re: Read SAP STXL
                    s j

                    There is no option other than to Use ABAP function "READ_TEXT".