SAP Table lookups in mappings
In a mapping, you can configure a Lookup transformation to look up data from SAP Table objects.
If you configure an uncached lookup, you can use only the = logical operator in the lookup condition.
When you configure an uncached lookup, ensure that the data does not contain the pipe (|) character, otherwise data corruption occurs.
When you use an SAP Table object as a lookup, you do not need to configure specific SAP Table properties.