Skip to Content
author's profile photo Former Member
Former Member

Import Longtext from a SAP System into HANA

Hey folks,

I'm trying to import longtexts out of a SAP System (e.g. table "QMEL") into my Monsoon HANA. I know that I need the tables "STXL" and "STXH", but the most challenging thing is to get the right longtext for the object. Does anyone know how to do this?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 15, 2014 at 08:40 PM

    Hi Tim,

    So you have two informations missing. First is the key that this thread can help you:

    The other is the dificult to read that binary inside HANA, as we don't have all functions in hand there, we usually convert it on SLT.

    On this wiki Justin Molenaur's convert this on SLT:

    How To...Load and Convert SAP Long Text into HANA using SLT

    Regards, Fernando Da Rós

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Tim,

      I've just pointed the wiki as there have a lot of discussion and suggestions around the theme. You can also create a Z table on source system and with a Z program to fill this in an converted way. Then copy this one and not source....

      About your suggestion you plan to read on demand or just user NW WebService + xsjs to fill the new table?

      Both options works, the "best" I think depends on the resources you have in hands and also if you need on demand or not.

      Regards, Fernando Da Rós

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.