Rule using 'Lookup' for Material characteristics duplicate check in SAP
We are using Information Steward 4.2 - Data Insight - Rules.
We have successfully tested Uniqueness / Duplicate checks in SAP for Customer Master and Vendor Master using
'lookup' function to lookup SAP table in Information Steward Rule.
Example of lookup function :
lookup('HR', 'dbo.Orders', 'customer_name', $name, 'order_type', 7, 'order_id', null)
Result: Returns the column order_id if there is a row with customer_name=$name and order_type=7 from table HR.dbo.Orders
Now we are trying to set up Uniqueness / Duplicate checks in SAP for Material Master & its characteristics.
i.e We want to check in SAP if another material with same characteristics exists
But since Material Characteristics data is not available in a single table and flat format like other tables, we are not able to use a table directly for the Lookup function in Information Steward.
Has anyone implemented such a lookup for duplicate check of Material Characteristics in Information Steward with SAP ?