Skip to Content

Fetching data from Table cluster e.g. RFBLG

Hi Gurus

I want to write a ABAP program to:

1. read data from Table cluster RFBLG,

2. filter data concerning BSEG,

3. decompress data from column Vardata and

4. fill transparent z table.

How this can be done. How do decompress data from Vardata column?

Is there a better way to achieve the above i.e. select enteries from table cluster and populate uncompressed data to transperant table?

Rgds

Sunny

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2011 at 11:54 AM

    Hi,

    1. Fetch the data into a internal table for RFBLG.

    2. Now for decompressing use a FM 'RRXWS_RAW_TO_CHAR'. Now here get the char data ( converted data ) into another field of itab.

    3. finally ur internal table will be filled with the req value.

    4. Filtering wrt BSEG can be done based on the converted value.

    5. Upload the data in Transparent Ztable.

    TYPES: BEGIN OF ty_itab.

    INCLUDE type RFBLG.

    types: conv_data type string.

    Types: end OF ty_itab.

    data: itab type TABLE OF ty_itab,

    wa_itab type ty_itab,

    rawitab type TABLE OF bapiconten,

    wa_rawitab type bapiconten,

    it_conv type TABLE OF w3html,

    wa_conv type w3html.

    select * from RFBLG into CORRESPONDING FIELDS OF TABLE itab UP TO 10 ROWS.

    loop at itab INTO wa_itab.

    wa_rawitab-line = wa_itab-vardata .

    append wa_rawitab to rawitab.

    CALL FUNCTION 'RRXWS_RAW_TO_CHAR'

    EXPORTING

    I_T_RAW_DATA = rawitab

    IMPORTING

    E_T_HTML = it_conv

    .

    loop at it_conv INTO wa_conv.

    CONCATENATE wa_itab-conv_data wa_conv-line INTO wa_itab-conv_data.

    endloop.

    MODIFY itab from wa_itab TRANSPORTING conv_data.

    ENDLOOP.

    insert ztable from TABLE itab.

    Note create ztable with same fields as in the internal table ITAB.

    Hope this will surely help you !!

    Thanks & Regards,

    Punit.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.