Skip to Content
avatar image
Former Member

Help Needed: SAP MDG Duplicate Check while doing Mass Load using SAP HANA database

Hi MDG Experts,

Can anybody help me in providing the inputs for the below SAP MDG requirement:

We are using SAP MDG 7.0 SP02 co-deployed on SAP ECC6.0.

While doing mass upload using .CSV file format or using IDOC-XML format into SAP MDG ,Is there any way for SAP MDG to analyze the records contained in the uploaded file on a field-by-field basis to make sure there are no similar/duplicates records already existing in SAP ECC.

OR Is there any way to conduct a duplicate check for the records present in the file  with the records present in active area/ECC and we are using SAP HANA as the primary database?

Can we anyhow integrate the HANA based duplicate check while doing the mass load activity?

Please let me know if anyone has any idea on this or had worked on this type of scenario previously.

Regards,

Satyam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 07, 2014 at 10:55 AM

    Hi Satyam

    In Co-deployment (Add on) scnarion MDG sits on top of operational ECC.Here reuse data models like MM,BP uses ECC tableslike MARA,LFA1,BUT000,KNA1 etc. to stores their active data.Only in case of MDG F active area remains in MDG tables uptill data replication.

    For MDG S there are two options

    1. you can directly store your legacy data into ECC tanle without governing them (and explclity checking duplicate check in third party tool like BODS of Crystal reports).
    2. Otherwise you can upload in MDG table may be using file upload method.You can activate duplicate check in MDG under IMD node Search and Duplicate Check under Data Quality and Search. For every duplicate check it shows you pop up for your decesion.
    Add comment
    10|10000 characters needed characters exceeded