Skip to Content
0
Dec 03, 2008 at 04:31 PM

Storing/retrieving binary data in/from a database table

126 Views

I've defined my table as:

MANDT	        MANDT	                        CLNT	3
/BIC/GLPLANT	/BIC/OIGLPLANT	                CHAR	4
/BIC/GLMATPLNT	/BIC/OIGLMATPLNT	        CHAR	18
HEXVALUE	SXIVERI_BINARY	RAWSTRING	0

I've defined my structure in my program, and read from my table

DATA: BEGIN OF ls_in_data,
        /bic/glplant   TYPE /bic/oiglplant,
        /bic/glmatplnt TYPE	/bic/oiglmatplnt,
        hexvalue       TYPE xstring,
      END OF ls_in_data.
...
* Populating ls_in_data
...
SELECT SINGLE * INTO ls_in_data FROM z_mytable...

and I get the messages:

The types for the database table and work area (or internal table) "LS_IN_DATA" are not compatible.

As far as my program goes, the hexvalue MUST be xstring. What type should I use in my database table?

thanks

matt