topic Re: SUM, per material? in Application Development and Automation Discussions

SUM, per material?

Former Member — Mon, 15 Jun 2009 07:53:45 GMT

Hi,

I have an internal table:

material price

111111 10,00

111111 15,00

222111 12,00

222111 18,00

How to use SUM to get total price PER material? Which statement tu use?

ON CHANGE of material doesnt work..I get total price of all materials..

111111 25,00

222111 30,00

thanks..

Re: SUM, per material?

former_member188829 — Mon, 15 Jun 2009 07:55:16 GMT

Use AT NEW matnr

ENDAT. Statements

Re: SUM, per material?

Sandeep_Panghal — Mon, 15 Jun 2009 07:56:59 GMT

either use at new or on change of.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:01:06 GMT

U can also use at end statement to get the sum per material.

Re: SUM, per material?

suredarreddy_pulimamidi — Mon, 15 Jun 2009 08:05:21 GMT

Hi,

Use AT NEW.

ON CHNAGE of is obsolute in ECC.

Regards,

Surendar Reddy.

Re: SUM, per material?

kesavadas_thekkillath — Mon, 15 Jun 2009 08:12:56 GMT

check this

loop at itab.

at new matnr.

sum.

write itab-price.

skip1.

endat.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:21:50 GMT

Hi,

You can also use LOOP AT with COLLECT statement.

Regards

Karthik D

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:24:04 GMT

Hi,

Thanks all!

AT NEW won't work if MATERIAL isn't the first kolumn??

pos material price

Is there other solution?

tnx!

Re: SUM, per material?

kesavadas_thekkillath — Mon, 15 Jun 2009 08:29:35 GMT

u can make it in the first column and try if your not using any control break statement else where.

or.

loop at itab.

it1-matnr = itab-matnr.

it1-price = itab-price.

collect it1.

endloop.

Re: SUM, per material?

former_member188829 — Mon, 15 Jun 2009 08:44:46 GMT

Did you sort the internal table before using Control break statement?

Sort itab by matnr. -

> Add this statement

Loop at itab.

At new matnr.

Sum.

Endat.

Endloop.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:46:25 GMT

Yes I have.. but no result..

Re: SUM, per material?

Sandeep_Panghal — Mon, 15 Jun 2009 08:50:44 GMT

AT NEW won't work if MATERIAL isn't the first kolumn??

Have you tried using at new itab-matnr.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:57:05 GMT

Yes, getting error: no component exists with the name itab-matnr

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 08:59:09 GMT

Example:


REPORT  zz_test_aa1.


TYPES: BEGIN OF ls_itab,
  p(3),
  matnr TYPE matnr,
  price TYPE kbetr,
  END OF ls_itab.

DATA: itab TYPE STANDARD TABLE OF ls_itab,
      wtab TYPE ls_itab.

wtab-p     = '10'.
wtab-matnr = '1111111111'.
wtab-price = '10.00'.
APPEND wtab TO itab.

wtab-p     = '20'.
wtab-matnr = '1111111111'.
wtab-price = '12.00'.
APPEND wtab TO itab.

wtab-p     = '30'.
wtab-matnr = '2211111111'.
wtab-price = '13.00'.
APPEND wtab TO itab.

wtab-p     = '40'.
wtab-matnr = '2211111111'.
wtab-price = '14.00'.
APPEND wtab TO itab.


SORT itab by matnr.
LOOP AT itab INTO wtab.

  ON CHANGE OF wtab-matnr.
    SUM.
    WRITE: wtab-matnr, wtab-price.
    SKIP 1.
  ENDON.


ENDLOOP.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 09:00:09 GMT

Use Collect Statement,

This is the most suited alternative .

Re: SUM, per material?

former_member188829 — Mon, 15 Jun 2009 09:02:08 GMT

Try this.

DATA:BEGIN OF itab OCCURS 0,
     matnr TYPE matnr,
     price TYPE wrbtr,
     END OF itab.

START-OF-SELECTION.
  CLEAR itab.
  itab-matnr = '111111'.
  itab-price = '10'.
  APPEND itab.

  CLEAR itab.
  itab-matnr = '111111'.
  itab-price = '15'.
  APPEND itab.

  CLEAR itab.
  itab-matnr = '222111'.
  itab-price = '12'.
  APPEND itab.

  CLEAR itab.
  itab-matnr = '222111'.
  itab-price = '18'.
  APPEND itab.

  SORT itab BY matnr.

  LOOP AT itab.
    AT NEW matnr.
      SUM.
      WRITE:/ itab-matnr,itab-price.
    ENDAT.
  ENDLOOP.

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 09:03:35 GMT

@Vishnu,

I can't change the kolumns..

Re: SUM, per material?

Former Member — Mon, 15 Jun 2009 09:07:43 GMT

Info to all:

I'm printing invoice sapscript so i'm using internal table tvbdpr type vbdpr so I can't change kolumns here.

Re: SUM, per material?

former_member188829 — Mon, 15 Jun 2009 09:09:04 GMT

TYPES: BEGIN OF ls_itab,
  matnr TYPE matnr,
  price TYPE kbetr,
  p(3),                        "Change it to third column from first column
  END OF ls_itab.

DATA: itab TYPE STANDARD TABLE OF ls_itab,
      wtab TYPE ls_itab.

wtab-p     = '10'.
wtab-matnr = '1111111111'.
wtab-price = '10.00'.
APPEND wtab TO itab.

wtab-p     = '20'.
wtab-matnr = '1111111111'.
wtab-price = '12.00'.
APPEND wtab TO itab.

wtab-p     = '30'.
wtab-matnr = '2211111111'.
wtab-price = '13.00'.
APPEND wtab TO itab.

wtab-p     = '40'.
wtab-matnr = '2211111111'.
wtab-price = '14.00'.
APPEND wtab TO itab.


SORT itab BY matnr.
LOOP AT itab INTO wtab.
  AT NEW matnr.                   "Change it it At new
    SUM.
    WRITE: wtab-matnr, wtab-price.
    SKIP 1.
  ENDAT.
ENDLOOP.

If we use At new material, if the left side columns change before material the control break statement wil be triggered.

Re: SUM, per material?

former_member188829 — Mon, 15 Jun 2009 09:10:05 GMT

i changed column position in my previous post. Okay i will try it with out changing the column position.