deleting catalog item in /SRMNXP/CAT_ITM and staging tables

[Former Member]

Hi expert

How do we suppose to handle items in MDM that have been deleted there but are still in SRM ESH tables and staging tables?
The way it behaves now is whem an item is deleted in MDM, the corresponding item in srm tables is not deleted when extraction program is ran

and just remains there, causing data inconsistencies.

What's the ideal process handling this?
Appreciate any help.

Thanks!

[yu_feng2]

Hi Dex

Could you please check if the sample code in Note 2065273 could be any help?

Best Regards
Feng, Yu

[Former Member]

Hi.

I am facing the same problem. What is the proper way to keep MDM repostories and SRM staging tables in sync?

UI addon cookbook says not to use CTI indicator (see below). I cannot run initial load every time, because it does not remove existing entries.

Delta load on the other hand does not remove any entries and it does not set deletion indicator.

I had to implement BAdi /SRMNXP/MDM_FIELD_MAPPING to map the deletion indicator, but it is only called in initial load, not in delta load. Note 2270632 is implemented, but deletion indicator is set to 'X' only if value is 4. We only have values 1 and 2 coming in with the extraction.

Thanks in advance Gurus!

br,

Tomi