topic Dynamic Query in Application Development and Automation Discussions

Dynamic Query

Former Member — Tue, 30 Sep 2014 16:14:52 GMT

Hello, I have a query about internal tables. I have an internal tables as follows.

ZROW CHARAC       CHARVAL
1           MATERIAL      100
1           CALYEAR       2013
1           CALMONTH      12
1           AMOUNT       200
2           MATERIAL      200
2           CALYEAR       2013
2           CALMONTH      10
2           AMOUNT       200

I have another internal table which is like this:
Material CalYear CalMonth Amount

What I want to do is use Row number as my key and insert material, calyear, calmonth and amount data in material, calyear, calmonth, amount columns in the second internal table which is possible but the problem i have is to make my ZROW field dynamic. There is a possibility that I may have 1000 rows or 2000 or 2500 rows so i can't do some thing like this.

LOOP AT IT1 INTO WA1.
IF WA1-ZROW = '0000'.

MOVE: WA1-MATERIAL TO WA2-MATERIAL,
WA1-CALYEAR TO WA2-CALYEAR.

I am trying to see if there is a way i can make my zrow dynamic and keep counting up. once it reaches the end of internal table then it should stop.

Please let me know.

Re: Dynamic Query

RaymondGiuseppi — Wed, 01 Oct 2014 08:22:23 GMT

Try a dynamic code like

LOOP AT itab1 ASSIGNING <record1>.
   AT NEW zrow.
     APPEND INITIAL LINE TO itab2 ASSIGNING <record2>.
   ENDAT.
   TRY.
       ASSIGN COMPONENT <record1>-charac OF STRUCTURE <record2> TO <field>.
       <field> = <record1>-value.
     CATCH cx_sy_assign_cast_illegal_cast, cx_sy_assign_cast_unknown_type, cx_sy_assign_out_of_range.
       " ...
     CATCH cx_sy_conversion_no_number cx_sy_conversion_overflow cx_sy_move_cast_erro.
       " ...
   ENDTRY.
 ENDLOOP.

Where FIELD-SYMBOLS <record1> is typed with your actual itab1 structure and <record2> and <field> can be ANY TYPE.

Regards,

Raymond

Re: Dynamic Query

Former Member — Wed, 01 Oct 2014 11:33:35 GMT

Raymond, thank you sir. how do i declare these field symbols?

Please let me know.

Thanks.

Re: Dynamic Query

RaymondGiuseppi — Thu, 02 Oct 2014 05:40:43 GMT

For <record1> use a FIELD-SYMBOLS <record1> TYPE same type than itab1.

For <record2> and <field> use TYPE ANY.

Regards,
Raymond