Sample Data cleansing for SAP Master data(Customer, Material and Vendor)

[former_member598107]

Hi Team,

Kindly let me know few sample data cleansing scenarios(business oriented) for SAP Master Data. We would like to extract data from SAP ECC and load it to S/4 HANA. Before data is migrated to S/4 HANA 1709 On Premise edition, we need to make sure that the data is clean.

Although the SAP ERP data is cleansed but still need to make sure that data loaded into S/4 HANA will not have quality issues. We cannot use SAP Information Steward to profile the data and cleanse.

We also dont have DQM License for Data services. Master data count is also not too high(Material maximum 14K records)

Regards

Arun Sasi

[former_member559864]

You can use profiler repository in BODS Designer to profile your data:

https://blogs.sap.com/2015/04/07/data-profiling-with-sap-business-objects-data-services/

Also, try TDP dictionaries/rules and built-in functions to cleanse data using BODS Designer.