Hello,
I look everywhere and seem that theres no way to perform a negative like in a statement.
Im trying to create a save formula by doing something like the following example:
CASE
WHEN VBAK.VKORG = E100
AND VBAK.VTWEG = 11
AND (ISNULL(VBAP.ABGRU) = 1 OR VBAP.ABGRU IN (, 50, 99, Y8))
AND VBAK.AUART IN (YOPA, YOPB, YOPD, YVPE)
AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%
THEN Product
WHEN VBAP.BUKRS_LAND1 = US
AND VBAP.ABGRU =
AND VBAP.DIVISION = SSI
AND VBAK.VKBUR IN (BIL4,BNJ4)
AND VBAP.PSTYV NOT IN (YFP4,YOP4)
AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%
THEN Product
WHEN VBAP.BUKRS_LAND1 = US
AND VBAP.BS_UNIT_TEXT LIKE %CS%
THEN Service
ELSE Unclassified
END
Is there any workaround that let me use this type of approach?
Thanks in advance.
BR,
Joo Bu