topic Re: Table with RAW Data type and Store the data in Application Development and Automation Discussions

Table with RAW Data type and Store the data

ipravir — Tue, 08 Oct 2013 07:21:17 GMT

Hi,

I have created a table using RAW DATA type or RAW STRING.

Table field would be

Client ID,

One Primary Key with 4 NUMC, and

one RAW Data type columns with 250 Size

Requirement:

I Want to Store the data into this table and Retrieve Back.

Kindly suggest any good documentation to bunch of code regarding RAW or RAWSTRING data process, that could be helpful for me.

Thanks.

Praveer.

Re: Table with RAW Data type and Store the data

Former Member — Tue, 08 Oct 2013 07:39:41 GMT

Hi Praveer,

Hope you are selecting those fields from database and keeping in same internal table/structure in the program. Just declare those fields X(n) in your program,they will be selected.

Hope this helps.

Regards,

Supratik

Re: Table with RAW Data type and Store the data

Former Member — Tue, 08 Oct 2013 08:08:30 GMT

Hi,

Declare a internal table having the same structure as database table .

( data: i_tab type TABLE OF Zraw )

Then i think we can fetch values from database table

Re: Table with RAW Data type and Store the data

ipravir — Tue, 08 Oct 2013 08:25:20 GMT

Hi Supratik,

In my program I declared the MATNR MAKTX, MTART,MATKL inside a structure.

and I want these information store in RAW field of the Z* table.

Can you provide some code information to store and retrieve back the same data.

Regards.

Praveer.

Re: Table with RAW Data type and Store the data

Former Member — Tue, 08 Oct 2013 08:38:38 GMT

Hi Praveer,

So you have created the Z table with some fields as type RAW?

If yes then just create a internal table(say itab1) of that type in your program. and populate that internal table from the values of MATNR MAKTX, MTART,MATKL(using MOVE statement). Then insert the values from your internal table(itab1) to DB table of yours which you have created.

Regards,

Supratik

Re: Table with RAW Data type and Store the data

RaymondGiuseppi — Tue, 08 Oct 2013 08:48:59 GMT

Why didn't you use a cluster INDX table type, managed with EXPORT TO/IMPORT FROM DATABASE ?

Regards,

Raymond

Re: Table with RAW Data type and Store the data

ipravir — Fri, 11 Oct 2013 06:52:21 GMT

Hi,

Kinldy find the below code and table and suggest how to insert the query information in DB table.

   REPORT ZPRV_RAW_TEST.
TABLES:   ZPRVRAW.

TYPES:    BEGIN OF S_MARA,
            MATNR TYPE MATNR,
            MAKTS TYPE MAKTX,
            MTART TYPE MARA-MTART,
            MATKL TYPE MARA-MATKL,
          END OF    S_MARA.

DATA:     GIT_MARA TYPE STANDARD TABLE OF S_MARA,
          GFL_MARA LIKE LINE OF GIT_MARA.

START-OF-SELECTION.
SELECT M~MATNR X~MAKTX M~MTART M~MATKL FROM MARA AS M
                                       INNER JOIN MAKT AS X
                                       ON M~MATNR EQ X~MATNR
                                       INTO TABLE GIT_MARA
                                       WHERE X~SPRAS EQ SY-LANGU.

END-OF-SELECTION.
IF LINES( GIT_MARA ) EQ 0.
EXIT.
ENDIF.

Regards.

Praveer