Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
clisboa_noesis
Partner - Creator
Partner - Creator

Read SAP STXL

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

1 Solution

Accepted Solutions
clisboa_noesis
Partner - Creator
Partner - Creator
Author

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.

View solution in original post

6 Replies
Not applicable

Hi Carlos,

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

Thank you

Norbert

clisboa_noesis
Partner - Creator
Partner - Creator
Author

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.

yevgeniy
Creator
Creator

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

yevgeniy
Creator
Creator

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

clisboa_noesis
Partner - Creator
Partner - Creator
Author

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.

suniljain
Master
Master

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