topic Re: Logic in Application Development and Automation Discussions

Logic

Former Member — Fri, 04 Jul 2008 16:15:40 GMT

Hi,

I have a data in my Itab like this: -

ebeln ebelp Quantity

1000005 10 100

1000005 10 20

1000005 10 80

1000005 20 10

1000005 20 15

1000006 10 240

1000006 20 60

I need my output in my Itab like this: -

How could I do it?

ebeln ebelp Quantity

1000005 10 200

1000005 20 25

1000006 10 240

1000006 20 120

Let me know how can this be achieved?

Re: Logic

Former Member — Fri, 04 Jul 2008 16:19:41 GMT

make a second table with keys ebeln and ebelp.

Loop at the first table and use collect statement to add all the entries to the second table and you'll get what you want

Re: Logic

Former Member — Fri, 04 Jul 2008 16:21:43 GMT

U can use a new internal table for output structurated just as ITAB, where u collect the record of ITAB to T_OUTPUT.

LOOP AT ITAB INTO T_OUTPUT.
  COLLECT T_OUTPUT.
ENDLOOP.

Max

Re: Logic

Former Member — Fri, 04 Jul 2008 16:22:37 GMT

Hi,

Use control break statement,

AT NEW
 SUM,
END AT.

Regards

Adil

Edited by: Syed Abdul Adil on Jul 4, 2008 7:04 PM

Edited by: Syed Abdul Adil on Jul 4, 2008 7:12 PM

Re: Logic

Former Member — Fri, 04 Jul 2008 16:51:58 GMT

Hi Max,

Could you please tell How it works using SUM key word?

I m doing something like this: -

LOOP AT i_ekbe.

ON CHANGE OF EBELN OR

EBELP.

SUM ( MENGE ).

ENDON.

ENDLOOP.

Re: Logic

Former Member — Fri, 04 Jul 2008 16:57:54 GMT

Hi,

I think the COLLECT statement is the best, very performing too.

Regards

Re: Logic

Former Member — Fri, 04 Jul 2008 17:13:44 GMT

Hi,

Hope this will help you.

DATA: 
  BEGIN OF w_test,
    ebeln    TYPE ekpo-ebeln,
    ebelp    TYPE ekpo-ebelp,
    quantity TYPE ekpo-MENGE,
  END OF w_test,
  
  t_test LIKE TABLE OF w_test.

w_test-ebeln = '1000005'.
w_test-ebelp = '10'.
w_test-quantity = '100'.
APPEND w_test TO t_test.

w_test-ebeln = '1000005'.
w_test-ebelp = '10'.
w_test-quantity = '20'.
APPEND w_test TO t_test.

w_test-ebeln = '1000005'.
w_test-ebelp = '10'.
w_test-quantity = '80'.
APPEND w_test TO t_test.

w_test-ebeln = '1000005'.
w_test-ebelp = '20'.
w_test-quantity = '10'.
APPEND w_test TO t_test.

w_test-ebeln = '1000005'.
w_test-ebelp = '20'.
w_test-quantity = '15'.
APPEND w_test TO t_test.

w_test-ebeln = '1000006'.
w_test-ebelp = '10'.
w_test-quantity = '240'.
APPEND w_test TO t_test.

w_test-ebeln = '1000006'.
w_test-ebelp = '20'.
w_test-quantity = '60'.
APPEND w_test TO t_test.

w_test-ebeln = '1000006'.
w_test-ebelp = '20'.
w_test-quantity = '60'.
APPEND w_test TO t_test.

LOOP AT t_test INTO w_test.
  AT NEW ebelp.
    SUM.
  WRITE:/
  w_test-ebeln,
  w_test-ebelp,
  w_test-quantity.
  ENDAT.
ENDLOOP.

Regards

Adil