Problem filtering a list

[Former Member]

Hi.

I have a problem filtering a list

I have a list with materials and the previous period stock and previous year stock

I only want to print the materials that have either a pp stock greather than zero or py stock greateher than zero.

I can't find a way to do it either in the select statement or the loop at.

I think I could use an if in the loop at to filter the results that have a sum of (pp stock and py stock) gt 0. I'll do it this way, but I want to know if there is a way to do it in the select statement

[former_member191735]

try this.

select * from abc

where (pp > 0 or PS > 0).

[Former Member]

Well the actual problem is that I cant filter it in the select statement because I gather all the information from mbew and then pass it to FM MBEW_EXTEND to get the pp stock and py stock. I forgot that.

But I don`t know if I can filter it some way in the FM or the loop.

[Former Member]

Thank you, everything was ok. I just messed up really bad

[Former Member]

I forgot that I was using FM MBEW_EXTEND after the query, it was impossible to filter the results in the first place.

Did it with a nested if inside a loop.

Thanks