Compression of String in S/4HANA

[Pai_N]

Hello Gurus, 

   I want to Compress the string value  before storing in DB table to save disk space. Currently I am using cl_abap_gzip=compress_text  & cl_abap_gzip=compress_binary to compress string, but I don't see great results . Could any one please suggest , is there any other Compression mechanism available in S/4HANA ? Thanks.  

[matt]

I use EXPORT ... TO DATA BUFFER ... COMPRESSION ON

[Pai_N]

Thank you Matt. Will try this one. 

[matt]

IMPORT ... FROM DATA BUFFER...

Just read the documentation!

[Pai_N]

Hi  @matt  How to decompress  back to string . Can you please suggest. 

Thanks,

[RaymondGiuseppi]

In which kind of table (cluster/indx, transparent) and field (lchr, string, rawsting) do you save the data?

[Pai_N]

HI @RaymondGiuseppi . Its Transparent Table  and Field type string. 

[RaymondGiuseppi]

You should not be allowed to compress a string field, look for some binary type such as RAWSTRING, but handle the compress/uncompress at every read/write statement.

Using an export/import you can use the COMPRESS option, and uncompress will be automatic.

[Pai_N]

@RaymondGiuseppi  Currently I am using rawstring to store compressed format. I have doubt on uncompress. How to uncompress back to string.  

[RaymondGiuseppi]

If you used method COMPRESS_TEXT before write, then use DECOMPRESS_TEXT aftrer read (CSEQUENCE can be C or STRING, XSEQUENCE can be X or XSTRING. DDIC RAWSTRING is XSTRING)