topic Regarding logic in manipulation of internal table in Application Development and Automation Discussions

Regarding logic in manipulation of internal table

Former Member — Mon, 20 Nov 2006 14:26:17 GMT

Hi All,

I have one internal table as below:

<b>I_TAB</b>.

<b>VBELN LIKE VBAP-VBELN,

POSNR LIKE VBAP-POSNR,

QTY LIKE VBAP-KWMENG,

SUM LIKE VBAP-KWMENG,

</b>

Now i have filled in this internal table from select statement

Data is:

100, 10, 100

100, 10, 200

100, 10, 300

100, 20, 50

100, 30, 100

100, 30, 200

etc.

Now what i want is i want t calculate SUM field in above internal table based on VBELN & POSNR

Finally data should come as

100, 10, QTY, 600

100, 20, QTY, 50

100, 30, QTY, 300

(or)

we can update QTY with SUM of all VBELN/POSNR.

Can anybody tell me what is the logiic!

Thanks,

Deep.

Re: Regarding logic in manipulation of internal table

Former Member — Mon, 20 Nov 2006 14:28:13 GMT

Hi,

Declare on more table as ITAB, say JTAB.

Loop at ITAB.

JTAB-VBELN = ITAB-VBELN.

JTAB-POSNR = ITAB-POSNR.

JTAB-SUM = ITAB-QTY.

COLLECT JTAB

endloop.

JTAB will have ur required output, But u cant put QTY in between since, the Qunattity is Integer field u cant place 'QTY', since it is a char.

Sreedhar

Message was edited by:

Sreedhar Kanchanapalli

Re: Regarding logic in manipulation of internal table

Former Member — Mon, 20 Nov 2006 14:30:12 GMT

loop at itab.

at end of posnr.

sum.

write: / itab-vbeln, itab-posnr, itab-qty.

endat.

endloop.

i dint understand why u would want to print QTY agn as the sum is what you need.

santhosh

mark if helps

Message was edited by:

Kaluvala Santhosh

Re: Regarding logic in manipulation of internal table

Former Member — Mon, 20 Nov 2006 14:30:59 GMT

loop at i_tab.

  at end of posnr.
    sum.
   i_tab-sum = i_tab-qty.
   modify i_tab index sy-tabix.
  endat.

endloop.

Re: Regarding logic in manipulation of internal table

Former Member — Mon, 20 Nov 2006 14:36:38 GMT

Hi,

loop at i_tab

at end of posnr.

sum.

i_final-vbeln = i_tab-vbeln.

i_final-posnr = i_tab-posnr.

i_final-qty = 'QTY'

i_final- sum = i_tab-qty.

append i_final.

clear i_final.

endat.

Regards,

Satya

endloop.