Skip to Content
avatar image
Former Member

Data Services to cleanse and harmonize spend data to UNSPSC

Hi, I have a requirement to cleanse invoice and master data using data services then do analysis on it. For the cleansing part of master data, do i still need SAP MDM? Or would data services suffice.

I'm looked into the optimized supplier spend reporting and it is recommending a combination of DS and MDM. But then the article is created on 2009. There might be a better practice today.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 12, 2015 at 08:45 AM

    Hello Paulo,

    I never used SAP MDM, but in my opinion you could do every validation and cleanse with the DS.

    For example you could make pattern validations with the Validation Transform or cleanse addresses with the Data Quality Transforms.

    In addition you can create custom functions and custom validations to validate or cleanse special data.

    If this answer does not help, please give an example what you want to clean, because there are a lot of different kind of master data and invoice.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      UNSPSC is a widely used coding stardard. I need to map the materials to this coding standard which is comprised thousands of entries. I can't seem to find the exact functionality of DS to use for this.

  • avatar image
    Former Member
    Jan 12, 2015 at 05:20 PM

    I agree with Severin and I believe Data Services should suffice to cleanse both your invoice and master data. There are a lot of transforms in Data Services tailored for cleansing and analysis for both, transactional and master data.

    About the SAP MDM/MDG tool, although I am no expert, I believe it is used to maintain clean data in a live system than cleanse already existing/created data. For such existing data, using SAP Data Services would be a recommended approach.

    Add comment
    10|10000 characters needed characters exceeded