topic ALV report problem in Application Development and Automation Discussions

ALV report problem

former_member185116 — Thu, 24 Oct 2013 14:45:30 GMT

hello all,

i have an alv report with 4 columns say(order number,material,actual cost,planned cost ...)

for a partcular order say

order item material actual cost planned cost

90000720 i010 m------- 1000 2000

90000720 i020 sab101 1000 2000

90000720 i030 abc122 1000 2000.

now my question is i want to display actual cost and planned cost only once not all the times for the order,

is it possible if so please suggest me some solution...

thanking u.....

Re: ALV report problem

venkat_aileni — Thu, 24 Oct 2013 14:50:25 GMT

Hi-

I hope sort option with those two fields will work for you.

-Venkat

Re: ALV report problem

Former Member — Thu, 24 Oct 2013 15:02:19 GMT

Hi Vinay,

As Venkat suggested you can pass these two fields in the sorting parameter, and it will not show repeated rows.

Thanks,

Ajay Bose

Re: ALV report problem

venkat_aileni — Thu, 24 Oct 2013 15:48:17 GMT

Hi-

If you don't want to use sort option, loop over the final internal table(I hope you are already doing this) and make use of control break statement AT NEW with order number, so that you can pass those two fields only for the first time(first line item) and during the next iterations for the same order you can clear those two fields.

Hope this solves your problem.

-Venkat

Re: ALV report problem

Former Member — Thu, 24 Oct 2013 17:18:57 GMT

First you should Sort the table by orderno, actualcost, planned cost

Then delete duplicate adjacent comparing orderno, actualcost, planned cost

Reward if this is helpful

Regards,

Borland

Re: ALV report problem

Former Member — Fri, 25 Oct 2013 05:01:55 GMT

Hi,

In order to sort the fields in ALV, we may have two ways.

1. Sorting the Internal table---The advantage of this methid is, u can sort and can delete the irrelevant line items......

ex: SORT ITAB BY <FIELD NAME> [ASCENDING|DESCENDING]

The above statment will give us the sorted internal with the fields mentioned in Field Name.....

And with the help of the following statment u can reduce the repeated/unwanted line items..

DELETE ADJACENT DUPLICATES FROM ITAB

This method will allow u to filter the datas before displaying it.....

2. Sort Using sort structure----- This is can be used while displaying the data using "REUSE_ALV_GRID_DISPLAY" or " REUSE_ALV_GRID_DISPLAY_LVC" .

it_sort TYPE TABLE OF slis_sortinfo_alv "Internal Table

wa_sort TYPE slis_sortinfo_alv, "Work area

IT_SORT-FIELDNAME = 'Give you field name'.

IT_SORT-UP = 'X'.

APPEND IT_SORT

When calling the function REUSE_ALV_GRID_DISPALY_LVC , U must have to specify the sorting structure

it_sort_lvc = it_sort

Re: ALV report problem

former_member185116 — Sat, 26 Oct 2013 14:04:28 GMT

hai rajan,

thanks for u r helpful answer...

Re: ALV report problem

former_member185116 — Sat, 26 Oct 2013 14:05:37 GMT

hai venkat,

AT NEW with order number ,worked fine...

thanks a lot...

bye....