Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 ?

Former Member
Not what you were looking for? View more on this topic or Ask a question