topic Storing HTML data into SAP using BLOB methodology in Application Development and Automation Discussions

Storing HTML data into SAP using BLOB methodology

Former Member — Tue, 12 Jun 2012 19:04:53 GMT

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

Re: Storing HTML data into SAP using BLOB methodology

matt — Wed, 13 Jun 2012 08:03:06 GMT

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.

Re: Storing HTML data into SAP using BLOB methodology

Former Member — Thu, 19 Nov 2015 22:09:43 GMT

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