topic Re: need logic in loop in Application Development and Automation Discussions

need logic in loop

Former Member — Thu, 02 Oct 2008 16:45:13 GMT

Hi Experts,

I need a logic in internal table loop.

Ex:

vbeln matnr werks quantity

1234 AAAA 0001 10.000

2345 AAAA 0001 20.000

2345 BBBB 0001 30.000

3456 AAAA 0001 35.000

I need a logic that for every new Material i need to know how many records are there in internal table for that material.

like...

sort itab ascending by matnr.

loop at itab.

at new matnr.

i need no: of records for that matnr ( AAAA) i.e. 3..

endloop.

i am confused where to use this at new...

can anyone provide the best logic in terns of performance?

Giri

Re: need logic in loop

Former Member — Thu, 02 Oct 2008 16:50:47 GMT

AT NEW won't help here.

Rob

Re: need logic in loop

former_member195698 — Thu, 02 Oct 2008 16:51:37 GMT

One method with MATNR as the first field in the internal table

matnr vbeln werks quantity

AAAA 1234 0001 10.000

AAAA 2345 0001 20.000

BBBB 2345 0001 30.000

AAAA 3456 0001 35.000

one internal table with fields

MATNR COUNT


Sort tb_data by matnr.

loop at tb_data.

  at new matnr.
     clear wf_count.
  endat.

  wf_count = wf_count +1 .

  at end of matnr.

     tb_summary-matnr = tb_data-matnr.
     tb_summary-count  = wf_count.
     append tb_summary.
  endat.


endloop.

Re: need logic in loop

naimesh_patel — Thu, 02 Oct 2008 16:54:39 GMT

Since you have to get the number of material in the AT NEW, you should fill the number of material in some temporary table and than you it inside in the LOOP to read the material number.

Like:


DATA: BEGIN OF ITC OCCURS 0,
      MATNR TYPE MATNR,
      COUNT TYPE I.
      END OF ITC.

LOOP AT ITAB.
  ITC-MATNR = ITAB-MATNR.
  ITC-COUNT = 1.
  COLLECT ITC.
ENDLOOP.

loop at itab.

at new matnr.
READ TABLE ITC WITH KEY MATNR = ITAB-MATNR.
* ITC-COUNT  WILL GIVE THE NUMBER OF MATERIAL
ENDAT.

endloop.

Regards,

Naimesh Patel

Re: need logic in loop

Former Member — Thu, 16 Oct 2008 15:25:53 GMT

Guys,

any help on this?

what is the best solution for this....

Giri

Re: need logic in loop

vamshi_mohan — Thu, 16 Oct 2008 16:06:52 GMT

Hi Giri,

I think Naimesh Patels logic would work fine. Let us know if you have tried it. If yes, do the performance analysis and let us know.

Regards.

Vamshi.