topic Sorting in Classical report in Application Development and Automation Discussions

Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:07:47 GMT

Hi friends,

I am working with a Stasndard FI Report RFKOPR00,Right now In this report,data is not getting diplayed profitcenter wise.hence user wants me add profit center in selection-screen and sort the output, it is a simple classical report,by priftcenter by proving a Sort button in application tool bar.

Could you please let me know, How I can provide this option,and the proccedure.

Kindly, provide me sample code if available.

Follwoing is the code that Prints output data.

loop at it_item into wa_item.

format color col_normal.

write:/ sy-vline.

write : 2 wa_item-lifnr,

12 wa_item-name1,

30 wa_item-prctr,

41 wa_item-bukrs,

50 wa_item-belnr,

60 wa_item-buzei,

70 wa_item-netdt,

80 wa_item-zfbdt,

90 wa_item-budat,

100 wa_item-bldat,

110 wa_item-bschl,

115 wa_item-zlsch,

120 wa_item-WAERS,

150 wa_item-wrshb.

WRITE : 170 SY-VLINE.

format color off.

endloop.

Regards,

Xavier.P.

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:14:50 GMT

Hi,

Check this link

https://www.sdn.sap.com/irj/scn/forums

regards

pavan

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:15:33 GMT

Hi ,

On selection screen add

select-options: s_prctr for tablename-prctr . <--- add table name e.g mara-matnr

Then before displaying report sort using following syntax -

SORT it_item by prctr.... ( you can add the required fields here).

You may need to use control statement like AT END .... ENDAT

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:16:21 GMT

Hi,

There is an enhancement point in the subroutine : FORM raster_ausgabe_alv_grid

Just sort the output table before the ALV list display in the standard program,

SORT <tablename> by <profitcenter>

For addition of new field on selection screen its not possible as there is no enhancement point to add your custom code..

Hope you need to copy the report into a Z report and make changes

Regards

Shiva

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:19:54 GMT

Hi Narayan,

Is it Possible to provide Two buttons( Sort ascending, and srot descending) in application toolbar so that when the user clicks these two buttons output will be sorted Just like in ALV Grid display?

Regards,

Xavier.P

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:25:42 GMT

Hi Shiva,

as you said, I am copying the standard report to Z and making changes, but can we provide two buttons( Sort Ascend and descend ) in Application toolbar of the classical report?

Regards,

Xavier.P

Re: Sorting in Classical report

Former Member — Wed, 17 Jun 2009 11:26:13 GMT

yes you can add 2 buttons and code accordingly

SORT itab by field descending.

SORT itab by field ascending.

Regards

Mansi.