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

Storing HTML data into SAP using BLOB methodology

Hi All,

I need to store the HTML data from 3rd party system (come in file attachment) into SAP data base and retrive the same,

I heared that BLOB is one of methodology which may useful, if yes, then how can we write the code at ABAP environment

for storing to data base and retrive the same.

If there any otehr methods by which we can store and retrive the HTML data otehr than AL11...?

Thanks in advance.

Regards,

VjmHyd

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 13, 2012 at 08:03 AM

    Define a database table with a field of type string. Then store the HTML in that field, using normal open SQL. Strings (and xstrings if you want to store binary data) are stored in the db as blobs.

    An alternative is to use data type raw - but this requires a fixed length and additional processing if the source data is longer than the fixed length.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Team,

      we used the BASE 64 encoding at 3rd party system for converting HTML to BASE 64 then once received to SAP then Decoded the Base 64 to Binary then stored to data base in RAWSTRING format using string to Xstring ice versa for display.

      Thanks,

      Vij

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.