Storing HTML data into SAP using BLOB methodology

[Former Member]

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

[matt]

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.

[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