Collect statement

[Former Member]

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]

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...