topic Collect statement in Application Development and Automation Discussions

Collect statement

Former Member — Fri, 13 Jun 2008 02:38:48 GMT

hi ,

i have to take these details from tabel bseg

in bseg i have bukrs belnr gjahr buzei shkzg hkont Dmbtr wrbtr from here i have to take data into final o/p tabel.it_final

in it_final has fields bukrs hkont debitAmt CreditAmt

now i need to collect for each gl debit amount and credit amount.

how can i do

thanks ,

satish

aris_hidalgo — Fri, 13 Jun 2008 02:54:50 GMT

Hi Satish,

What you can do is to loop through your table that holds the records from bseg then collect those records into another table(gt_final). For example:


LOOP AT gt_bseg INTO wa_bseg.
  MOVE-CORRESPONDING wa_bseg to wa_final.
  COLLECT wa_final INTO GT_FINAL.
  CLEAR wa_final.
ENDLOOP.

Hope it helps...

P.S. Please award points if it helps...