topic Re: Serial No. issue in Application Development and Automation Discussions

Serial No. issue

Former Member — Thu, 19 Jun 2008 18:19:11 GMT

Hi Friends,

I am new to SAP, I have a requirement where i need to add a count of serial no. to a report of Order creation.

How can i do it, can any one help me with a sample code.

Your feed back will be appreciated...........and rewarded.

Re: Serial No. issue

Former Member — Thu, 19 Jun 2008 18:25:41 GMT

Hi Murali,

Welcome to SDN Community...

Try to put the counter while printing the text in the report output.. This will solve your problem

EX: Data: counter type i value 1.

Loop at itab.

write:/10 counter , 30 itab-order.

counter = counter + 1.

Endloop.

Re: Serial No. issue

Former Member — Thu, 19 Jun 2008 18:25:56 GMT

Hi,

Use the collect stmt. or loop through the internal table and add the values.

or use the SUM aggregate function in the select query to give you the total of the field.

select sum(xxx) into ws from table tbl order by f`1 f2 group by .....

regards,

Subramanian

Re: Serial No. issue

Former Member — Thu, 19 Jun 2008 18:26:42 GMT

Hi Murali,

You have to use Number Ranges concept

use FM NUMBER_GET_NEXT and give the object as AUFTRAG for orders

and give the number range from table NRIV

Re: Serial No. issue

former_member156446 — Thu, 19 Jun 2008 18:53:23 GMT

Change ur deceleration of it_output to add counter..

loop at it_output into wa_output.
move sy-tabix to wa_output-counter.

modify it_output form wa_output transporting counter.
clear: wa_output.
endloop.