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

[former_member225191]

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

[Former Member]

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.

[former_member225191]

Hi Sanjay,

But I am asking this wrt to HANA database  if we can incorporate duplicate check of HANA while doing the activation of CR for File Upload.

Regards,

Satyam

[Former Member]

Hi Satyam

Try with option 2

[former_member225191]

Hi Sanjay,

With option 2, we need to create the rule set in SAP HANA studio and search view too which can be seen in the "included Search help" field .

Do you have any screenshot doc of this configuration?

It will really help me a lot.

Regards,

Satyam

[Former Member]

Unfortunately No screen shot doc is available with me