SELECT WHERE field IN (*, x)
Ok let’s go slowly on this one.
Picture a scenario in which you have a customizing table with several levels of detail which may or may not be defined:
-
BUKRS (empresa)
-
WERKS (plant)
-
LGORT (depósito)
When one of the fields is empty, we treat it as a wildcard, meaning all values are valid.