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.
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;