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

internal table issue

Former Member — Thu, 14 Dec 2006 15:11:56 GMT

hi All,

I am having three itabs. itab1 and itab2 have common field prctr. And prctr can be same for many records in both itab1 and itab2. i want to check that if records for a particular prctr are not in itab1 but are in itab2 then those records be moved to itab3. can anyone give me some suggestion?

thanks and regards,

Reena

Re: internal table issue

Former Member — Thu, 14 Dec 2006 15:15:38 GMT

HI,

Loop at itab2.

read table itab1 with key prctr = itab2-prctr.

if sy-subrc NE 0.

move-correspondings itab2 to itab3.

endif.

endloop.

Regs

Manas

Re: internal table issue

ferry_lianto — Thu, 14 Dec 2006 15:18:12 GMT

Hi,

Please try this.


LOOP AT ITAB2.
  READ TABLE ITAB1 WITH KEY PRCTR = ITAB2-PRCTR
                   BINARY SEARCH.
  
  IF SY-SUBRC <> 0.
    MOVE-CORRESPONDING ITAB2 TO ITAB3.
    APPEND ITAB3.
  ENDIF.

ENDLOOP.

Regards,

Ferry Lianto

Re: internal table issue

Former Member — Thu, 14 Dec 2006 15:20:24 GMT

Hi Reena,

SORT ITAB1 BY PRCTR.

SORT ITAB2 BY PRCTR.

LOOP AT ITAB1.

READ TABLE ITAB2 WITH KEY PRCTR = ITAB1-PRCTR BINARY SEARCH.

IF SY-SUBRC <> 0.

MOVE-CORRESPONDING ITAB1 TO ITAB3.

APPEND ITAB3.

CLEAR ITAB3.

ENDIF.

CLEAR ITAB1.

ENDLOOP.

Thanks,

Vinay

Re: internal table issue

Former Member — Thu, 14 Dec 2006 15:21:25 GMT

loop at itab1.

read table itab2 with key

prctr = itab1-prctr.

if sy-subrc ne 0.

move itab2 to itab3.

enif.

endloop.

Warren.

Re: internal table issue

Former Member — Thu, 14 Dec 2006 15:25:39 GMT

Hi Reena,

If you want to append itab3 based on internal table is ITAB2.

Use this:

LOOP AT ITAB2.

READ TABLE ITAB1 WITH KEY PRCTR = ITAB2-PRCTR.

IF SY-SUBRC <> 0.

MOVE CORRESPONDING ITAB2 TO ITAB3.

APPEND ITAB3.

CLEAR ITAB2.

ENDIF.

ENDLOOP.

else If you want to append itab3 based on internal table is ITAB1

Use this:

LOOP AT ITAB1.

READ TABLE ITAB2 WITH KEY PRCTR = ITAB1-PRCTR.

IF SY-SUBRC <> 0.

MOVE CORRESPONDING ITAB1 TO ITAB3.

APPEND ITAB3.

CLEAR ITAB1.

ENDIF.

ENDLOOP.

Regards,

Vinod.

Re: internal table issue

ferry_lianto — Thu, 14 Dec 2006 15:27:47 GMT

Hi Reena,

How could it work without APPEND ITAB3?

Your ITAB3 will be empty.

Let me know ...

Regards,

Ferry Lianto

Re: internal table issue

Former Member — Thu, 14 Dec 2006 15:36:30 GMT

i have used append statement. thanks for ur answer. Actually everyone suggested the same answer so i figured out more or less a mixed solution.