Cannot delete 0MATERIAL Master Data

[Former Member]

Hi all,

I am clearing down our SAP BW DSiM system ready for go-live. All DSOs and InfoObjects have had data removed, and all that's let is 0MATERIAL. But 0MATERIAL won't fully delete its data.

I checked all objects in the "where used list" and all are empty. The "Where used" list on the 0MATERIAL deletion log is referencing itself, rather than data in other providers.

f

I executed SLG1 and again it only references data in itself.

Does anyone have any ideas on what's causing this issue?

Cheers

Martyn

[FCI · Accepted solution]

Hi Martin,

You sould have an attribute of 0MATERIAL which is referencing 0MATERIAL. You will have to set this attribute to blank before being able to remove the entries in the SID table.

Regards,

Frederic

[Former Member]

Thanks to all for your suggestion. It took a while but this issue is resolved, the solution is two fold...

• In a DSiM platform, a job runs which updates the master data objects periodically. So soon after clearing the DSOs and InfoObjects with 0MATERIAL data was filled again in these objects a few hours later. So disabling this job helped.
• But the biggest issue is that InfoObjects referencing 0MATERIAL are also in 0MATERIAL, so it would never clear down. The 'Where-Used' says 0MATERIAL rather than the actual objects. I created a transformation to clear each field that uses 0MATERIAL and ran the DTP. Then I could delete the contents from 0MATERIAL. So basically what Frederic said.

[former_member182970]

Hi,

Please, clear data of 0material wherever is being used as an attribute and all attributes of 0material like below. And keep results posted.

-

regards,

Mgande

[kohesco]

Hi,

make sure that you deleted all indexes in cubes etc as well. if that doesn't work you can delete table content via SE14, but try it first via the clean way.

grtz

Koen