How to handle deleted records?

[Former Member]

Hi!

I would like to delete (permanently) a record in created repository and syndicate this action to remote systems (so, it should also delete this record in remote systems). Please, can anyone share docs, ideas, etc.?

Thanks All for all the help,

Pawel

[Former Member · Accepted solution]

Hi,

when a record is deleted in MDM the deletion occurs only in the MDM repository level. In case this information is to be passed on to a backend system for eg:R/3 - then the field for deletion in that system has to be set. Eg : in the customer scenario the customer deletion flag is to be set in MDM & the value passed to R/3 -after the record can be deleted in the MDM repository. Therefore in R/3 the custoemr record will be marked for deletion.

Similarly the same logic can be used for any backend system.Some more information in this regard can be obtained in the following thread

Hope this helps !

Regards,

Anita

[Former Member · Accepted solution]

Hi Anita,

Where can I set flag in MDM for the deleted records. Kindly tell the full path.

Thanks in advance

Dilmit Chadha

[Former Member · Accepted solution]

> Where can I set flag in MDM for the deleted records.

> Kindly tell the full path.

Hi,

As far as I know, you need to define a new, separate field in a table.

Regards,

Pawel

[Former Member · Accepted solution]

Thanks Anita!

I've seen these threads earlier. I wonder if "to-be-deleted" flag is the only way to do this?

Regards,

Pawel

[Former Member · Accepted solution]

Hi Pawel,

The decision on the process to be followed to delete records -depends on the dependant system, please check if there is a field in that system whose value you can can enter from MDM.This is the process explained earlier with R/3 as an example.

In cases where the dependant system has no explicit deletion field - you could create a dummy field in MDM to indicate that the record is to be deleted pass the value to the dependant system & then you would check how this action can be reflected in that system maybe a program to deleted all records which have the deletion field value set/a flag that pops up saying that the record is deleted and so on.

Currently by deleting a record in MDM this alone does not ensure that the record is deleted in the downstream system.

Regards ,

Anita

[Former Member · Accepted solution]

Ho Pawel,

I also guess this is oly way to handle this.

However you can automise deletion of source records by modifications in R/3 system (user-exit and workflow) .

hope it helps,

+ An

[Former Member]

Hi, Pawel

As it has been said possible decision is not to delete records physically in MDM but to transfer into 'deleted' status using special field. There also can be other statuses in your repository e.g.'blocked', 'draft' and others according to status model in use. And later you can process this status in remote systems accordingly.

Also you could want to keep information about deletion statuses of your MDM record in remote systems (e.g. 'deleted in ERP' and 'exists in CRM'). In this case you can use qualified table with remote system identifiers as non-qualifier field and deletion status (Yes/No) as qualifier field.

Regards,

Vadim Kalabin