topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Wed, 26 Sep 2007 08:31:38 GMT

Hello,

what I am trying to do is copy the contents of Internal Table A to Internal Table B,

which do have corresponding components, but , I want to select the a date field from table A , not to be between a start and end date in table B.

Is there a quick way of doing this , without a loop within a loop?

Thanks

Re: Internal Table

amit_khare — Wed, 26 Sep 2007 08:34:16 GMT

loop at itab2 into wa2.

Read table itab1 into wa1 <condition.

if sy-subrc = 0.

endif.

endloop.

Regards,

Amit

Reward all helpful replies.

Re: Internal Table

Former Member — Wed, 26 Sep 2007 08:36:42 GMT

Hi,

You can 1st copy the entire contents from table A to table B and use the DELETE Internal table command to delete the records given in the date range.

regards,

Mahesh

Re: Internal Table

Former Member — Wed, 26 Sep 2007 08:37:08 GMT

loop at b.

read table a with key date >= b-startdate

date <= b-enddate.

move corresponding a to b.

append b.

endloop.

reward points if useful.

Re: Internal Table

Former Member — Wed, 26 Sep 2007 08:38:09 GMT

loop at itabA.

read table itabB with key ... = itaba-... BINARY SEARCH.

if sy-subrc eq 0.

if itaba-start LT itabB-start and

itaba-end GT itabb-end.

....

endif.

endloop.

Re: Internal Table

Former Member — Wed, 26 Sep 2007 08:39:35 GMT

no need of second table you can do the same in first table.

you can use this

SORT ITAB BY DATE.

DELETE ITAB WHERE DATE LT S_DATE-LOW and DATE GT S_DATE-HIGH.

reward if useful.

Amit Singla

Re: Internal Table

Former Member — Wed, 26 Sep 2007 08:41:47 GMT

you can use this way if u need second table as well.

ITAB1[] = ITAB[].

SORT ITAB1 BY DATE.

DELETE ITAB1 WHERE DATE LT S_DATE-LOW and DATE GT S_DATE-HIGH.

reward if useful.

Amit Singla

Re: Internal Table

varma_narayana — Wed, 26 Sep 2007 08:42:02 GMT

Hi..

It is must to use the LOOP in this case.

Eg: Assume F1 Is the Common field (Key) in both internal tables

SORT TAB2 BY F1.

LOOP AT TAB1 .

READ TABLE TAB2 WITH KEY F1 = TAB1-F1 BINARY SEARCH.

IF SY-SUBRC = 0.

IF TAB1-DATE NOT BETWEEN TAB2-STARTDATE AND TAB2-ENDDATE.

MOVE-CORRESPONDING TAB1 TO TAB3.

APPEND TAB3.

ENDIF.

ENDLOOP.

reward if Helpful.

Re: Internal Table

hymavathi_oruganti — Wed, 26 Sep 2007 08:42:56 GMT

loop at tableb.

read tableA where date > tableb-start_date and tableb-end_date.

if sy-subrc <> 0.

read tableA.

if sy-subrc = 0.

delete tableA.

endif.

TABLEA-DATE is what u needed now

endif.

endloop.

Message was edited by:

Hymavathi Oruganti