topic Re: Internal Table related query in Application Development and Automation Discussions

Internal Table related query

Former Member — Sat, 28 Feb 2009 20:16:19 GMT

Hi Guys,

I have a 1st Internal Table with all shipments details.

I have 2nd internal table shipments details along with pallets details.

My 2nd Internal table looks like below.

PN TKNUM

1 1144

2 1144 and many more than this

3 1145

4 1145

I need to calculate that TKNUM 1144 has total 2 PN's and TKNUM 1145 has total 2 PN's

Thanks,

Prasad.

Re: Internal Table related query

former_member156446 — Sat, 28 Feb 2009 21:11:23 GMT

see the help on at statement....

loop at itab into wa_itab.

at new tknum / at last tknum....etc...

count.....and move...

enddat.

Re: Internal Table related query

Former Member — Sat, 28 Feb 2009 21:17:06 GMT

Hi Jay,

Thanks for your reply.

Can you give me any example.

Thanks,

Prasad.

Re: Internal Table related query

former_member156446 — Sat, 28 Feb 2009 21:20:47 GMT

>[Click Here|https://forums.sdn.sap.com/search.jspa?q=at%20endat&dateRange=last90days&searchID=22926323&rankBy=10001&start=0]<

alternative:


loop at itab into wa_itab.
itab1[] = itab[].

delete itab1 where tknum NE wa_itab-tknum.
describe table itab1 lines lv_lines.
write: 'No. of records:', wa_itab-tknum , lv_lines.

endloop.

Re: Internal Table related query

Former Member — Sun, 01 Mar 2009 02:35:34 GMT

HI,

Check this Code..

SORT itab by  TKNUM.
LOOP AT itab.

  COUNT = COUNT + 1.

AT END OF TKNUM.
"  Move total PN count to another internal table
  ITAB2-PN = COUNT.
  ITAB2-TKNUM = ITAB1-TKNUM.
  APPEND ITAB2.
  CLEAR COUNT.
ENDAT.

ENDLOOP.

Re: Internal Table related query

Former Member — Sun, 01 Mar 2009 08:31:38 GMT

Hi Avinash,

Its not working.

Let me give my internal table details once again.

PN TKNUM

8 |0000001144

7 |0000001144

I need to get count as 2 for TKNUM .

Plz can you let me know.

Thanks,

Prasad.

Re: Internal Table related query

Former Member — Sun, 01 Mar 2009 08:47:02 GMT

Hello,

You can do this way.

Loop at 2nd internal table.

At new TKNUM.

if flag is initial. " at 1st loop also AT new control break event occurs.

" 1st loop pass count should not be displayed

write:/ count, tknum.

endif.

flag = 'X'.

endat.

count = count + 1.

endllop.

Regards,

Sameer

Re: Internal Table related query

Former Member — Sun, 01 Mar 2009 10:08:22 GMT

Thanks for ur answer sameer.

Prasad.

Re: Internal Table related query

Former Member — Sun, 01 Mar 2009 10:08:51 GMT

Thanks to all....