Question
PQL filter - different filtering based on an attribute
Hi everyone,
I am trying to write a load script that would incorporate the below logic, and I am confused with the syntax. Will appreciate any advise.
Analyzing SAP O2C process.
Logic:
If SO Item is for defined materials then this SO Items should be included without any additional filter.
If SO Item is for any other materials (not from that defined set), then for those SO Items additional filter should apply.
Materials that should go without filter: EDIDUMMY, ILODUMMY
For every other material I want to exclude those where there is a reason for rejection: ISNULL(VBAP.ABGRU) = 1;
I tried to write something like this, but after I try to save the script analysis keeps loading forever, so I guess something is not working with the filter:
CASE WHEN VBAP.MATNR IN (EDIDUMMY, ILODUMMY) THEN FILTER 1=1 ELSE
FILTER ISNULL(VBAP.ABGRU) = 1;
thanks
Masha
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.