Qlik Community

QlikView Connectors

Partner
Partner

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
Highlighted
Partner
Partner

Re: Read SAP STXL

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

Re: Read SAP STXL

Hi Carlos,

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

Thank you

Norbert

Partner
Partner

Re: Read SAP STXL

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
Contributor

Re: Read SAP STXL

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
Contributor

Re: Read SAP STXL

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

Highlighted
Partner
Partner

Re: Read SAP STXL

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

suniljain
Honored Contributor

Re: Read SAP STXL

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