topic Re: dynamic internal table in Application Development and Automation Discussions

dynamic internal table

Former Member — Wed, 25 Jul 2007 20:50:36 GMT

How to apply condition to the dynamic internal table.

how to sort a dynamic internal table based on fields.

i m having some records in internal table.How to apply condition to tht dynamically & append to another table.

loop at IT assigning <l> (here i have to give where condition).

endloop.

thanks in advance.

Re: dynamic internal table

former_member194669 — Wed, 25 Jul 2007 20:55:27 GMT

Hi,

You cannot give a where condition in the loop for <fs>.

Check this


        loop at i_fcat assigning <fcat>.
          assign component <fcat>-col_id of structure <xtab> to <l_f3>.
          read table i_final_cat3 assigning <final_cat3> with key
                                        tabname = p_table
                                        fieldname = <fcat>-fieldname.
          if sy-subrc eq 0.
            assign component <final_cat3>-col_id of
                                      structure <final_wa3> to <l_f4>.
            write : <l_f3> to <l_f4>.
          endif.
        endloop.

aRs

Re: dynamic internal table

Former Member — Wed, 25 Jul 2007 21:06:36 GMT

thanks.

but how to filter the data without where condition.

In read statement also i cant give where condition.

i want to fetch the record with condition where total < 60 & append it in another table.

can u give an example

Message was edited by:

Maya Vinothini

Re: dynamic internal table

marcelo_ramos1 — Wed, 25 Jul 2007 21:36:43 GMT

Hi,

Try this, maybe it's usefull for you.

DATA: t_mara TYPE TABLE OF mara WITH HEADER LINE.

FIELD-SYMBOLS <line> TYPE ANY.

FIELD-SYMBOLS <field> TYPE ANY.

FIELD-SYMBOLS <table> TYPE table.

START-OF-SELECTION.

SELECT *

FROM mara

UP TO 20 ROWS

INTO TABLE t_mara.

ASSIGN t_mara-matnr TO <field>.

SORT t_mara BY <field>.

LOOP AT t_mara ASSIGNING <line>

WHERE ERSDA le sy-datum.

write: / <line>.

ENDLOOP.

______________________________________________

Else, you can try this.

ASSIGN t_mara[] TO <table>.

ASSIGN t_mara TO <line>.

ASSIGN t_mara-ersda TO <field>.

LOOP AT <table> INTO <line>.

IF <field> LE sy-datum.

...

ELSE.

CONTINUE.

ENDIF.

ENDLOOP.

Regards.

Marcelo Ramos

Re: dynamic internal table

former_member194669 — Thu, 26 Jul 2007 02:49:48 GMT

Hi,

For example if your TOTAL field is in 4 th position then


loop at i_fcat assigning <fcat>.
     assign component 4 of structure <xtab> to <l_f3>.
         write : <l_f3> to <l_f4>.
         if <l_f4> ge 60
             <<<<< move value to internal table
         endif.
endloop.

aRs