Hi Neda! If I understand your requirement, this PQL query will be useful:

SELECT "Material Number", "Purch. Doc. Number", "Purch. Doc. Type", "Purch. Doc. Status"

FROM "nameoftable"

WHERE "Purch. Doc. Type"='SA' AND "Purch. Doc. Status"='Open'

ORDER BY "Material Number" ASC

Hi Neda, if I understood your query, Please try as below.

CASE WHEN "Purch.Doc.Type" LIKE 'SA'

AND

"Purch.Doc.Status" LIKE ''Open'

THEN "Material NUMBER"

ELSE 'other'

END

Thank you Rahul,

Your proposed PQL query will return Material Numbers that are ordered on active SAs. And my intention is to identify Material Numbers that are ordered on both active SAs and open POs at the same time. The use case behind is that we are not duplicating demand to supplier and ordering extra product.

BR

Neda