Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV Display Question - SQ01

Former Member
0 Kudos

Hello All,

I am displaying a query through SQ01, it is as any ALV report, there are a few controls on top of the list one of them is filter and thats where I have the question.

I have a list like this as output of the program:

Status Hours Name

True 0 John

True 1 Joe

False 0 Smith

True 1 Scott

False 1 Cindy

Now, do not want to show the records that have (Status = False and Hours = 0), Which will remove the 3rd record from the display.

How can this be accomplished through the FILTER icon?

Again, this is not a custom program so I cannot simply add this condition inside ABAP, I have to do something through toolbar icons.

I have tried different options in FILTER but it is not putting an "AND" logical condition between the two.

Thanks a lot!

1 ACCEPTED SOLUTION

naimesh_patel
Active Contributor
0 Kudos

You need to set two filters to achieve this functionality.

One for the Status and Second for the Hours.

Press the Filter Icon.

Select both fields from the right side and move it to left side by pressing the left arrow button. Press Enter

In the next screen, use the F4 for avaliable values and select FALSE for the status and 0 for the Hours.

You can save this setting in one Layout variant and use that for future use to avoid setting filter everytime you run the report.

Regards,

Naimesh Patel

3 REPLIES 3

naimesh_patel
Active Contributor
0 Kudos

You need to set two filters to achieve this functionality.

One for the Status and Second for the Hours.

Press the Filter Icon.

Select both fields from the right side and move it to left side by pressing the left arrow button. Press Enter

In the next screen, use the F4 for avaliable values and select FALSE for the status and 0 for the Hours.

You can save this setting in one Layout variant and use that for future use to avoid setting filter everytime you run the report.

Regards,

Naimesh Patel

0 Kudos

Thanks for your reply, but it does not put an "AND" condition between the two fields. It will suppress all fields that are False and all fields that are 0.

0 Kudos

Create a local field in SQ01, and build a formula to output 1 or 0 based on your condition then at the report output level you can suppress rows with 1s or 0s using filter.