Hello Experts,
We have a decision table (as shown below) which returns Status Profile based on the Vendor No, Location and Country as inputs.
VENDOR_NO LOCATION COUNTRY STATUS_PROFILE 10000665 1202 DE STAT_PROFILE_1 10000665 1202 US STAT_PROFILE_2 10000665 1202 US STAT_PROFILE_1Now in certain cases, the LOCATION field may not have any value and would be passed as blank. In such cases we would like the Status Profile to be selected based on Vendor No and Country.
I am unable to find a place where we could specify LOCATION as an optional column.
In the Decision table design screen, I could find "Mandatory input" column which is not checked in the our case. I believe this indicates that LOCATION field is an optional column, but still the decision table doesn't return any result when LOCATION field is passed blank.
Appreciate any help/ideas in this case.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
As per standard SAP help -
We can modify the behavior for each condition column individually in the following way:
With this indicator set, the system skips the evaluation of a condition at runtime if the input data does not contain a value for that column. The processing then continues with the evaluation of the next condition. With this indicator not set, the evaluation of an empty input to a defined condition value would yield false, and processing of the row would be stopped.
With this indicator set, the system forces you to provide a condition value at design time for the respective column in each row that you enter in the table definition. Such a condition can therefore not be used for providing an unspecific empty condition that would be evaluated as true regardless of the input data.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Best Regards,
Prasanna