topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 29 May 2008 06:22:12 GMT

Hi All,

my requirement is like this:

order no item no

5000 01

5000 02

5000 03

i want to eliminate the repetition of order no for each item no. i want it to be like this:

5000 01

helpful answers will be rewarded.

Regards

prashanth

Re: report

Former Member — Thu, 29 May 2008 06:27:28 GMT

Hi,

You can try like this :


loop at it_ordrs.
  at new order.
  move it_ordrs-order to lv_order.
  lv_flag = 'X'.
endat.

if lv_flag = '' and lv_order = it_ordrs-order.
 clear it_ordrs-order.
modify it_ordrs transporting order.
endif.
clear lv_flag.
endloop.

Regards,

Himanshu Verma

Re: report

Former Member — Thu, 29 May 2008 06:28:14 GMT

1. if the Problem is while displaying the data in classical report then,

use the Event - AT NEW <itab-var>.

ENDAT.

2. if the report is of ALV use AT NEW event and move the data according to the needed output to another itab.

Reward me if its useful.

Regards,

Nagulan

Re: report

Former Member — Thu, 29 May 2008 06:28:15 GMT

Hi,

Create an another internal table of same type as previous one and then sort the previous internal table on the basis of order no and item no.

Now loop into prvious internal table and and move the desired content into the new internal table .

Thanks

Re: report

Former Member — Thu, 29 May 2008 06:28:41 GMT

Hi prashanth,

r u displaying ur output in alv OR

is it normal output?

if it is alv.........sort the fields which ever u want into a table and then pass that table to table display FM.

if ur not clear let me know.......i will send u code.

Regards,

kk.

Re: report

Former Member — Thu, 29 May 2008 06:28:45 GMT

Hi Prasanth,

According to me, i guess 5000 is one field and 01, 02 ,03 are the line items, if this is the case you can make use of AT NEW statement and fill 5000 value alone under AT NEW statement and the line items u can fill it outside AT NEW.

Reward points if helpful.

Regards,

Asha

Re: report

Former Member — Thu, 29 May 2008 06:28:58 GMT

HI do this

loop at itab.

l_orderno = itab-orderno.

if old_ordno = l_orderno.

itab-oredrno = ' '.

modify iatb index sy-tabix.

else.

old_ordno = l_orderno.

endif.

endloop.

Regards

Aditya

Re: report

GauthamV — Thu, 29 May 2008 06:29:37 GMT

hi,

if u r using alv then use u can achive using sort statement.

sort ur internal table by order then it will giv according to ur requirement.

Re: report

Former Member — Thu, 29 May 2008 06:34:03 GMT

Hi,

Code like......

LOOP AT ITAB.

AT NEW ORDERNO.

NEWPAGE.

WRITE..............

ENDAT.

WRITE................

ENDLOOP.

Dont forget to to SORT the ITAB before LOOP. Its the requirement if U r using CONTROL BREAK events.

Reward all Helpful Answers,

Thanks.

Re: report

prasanth_kasturi — Thu, 29 May 2008 06:38:30 GMT

check the following code

data : begin of itab occurs 0,

f1(5),

f2(5),

end of itab.

itab-f1 = 5000.

itab-f2 = 01.

append itab.

itab-f1 = 5000.

itab-f2 = 02.

append itab.

itab-f1 = 5000.

itab-f2 = 03.

append itab.

sort itab by f1.

loop at itab.

on change of itab-f1.

write 😕 itab-f1,

itab-f2.

else.

clear itab-f1.

write 😕 itab-f1,

itab-f2.

endon.

endloop.

reward if helpful

prasanth

Re: report

Former Member — Thu, 29 May 2008 06:42:48 GMT

Use 'AT NEW' event... Use the write statement with the required offset.