? ?

Company Code，一個簡單的infoobject，我們發現里面有垃圾數據，想要做這個操作，點下去，后果是什么呢？

? ?

? ?

? ?

首先會詢問你是否和SID一起刪除。

? ?

? ?

When deleting master data, you can select whether entries in the

SID-table for the characteristic should be kept or deleted.

? ?

Effects If you delete the entry in the SID table for a specific

characteristic value, the SID value assigned to the characteristic value

is lost. If you load attributes for this characteristic value later, a

new SID value has to be generated for the characteristic value. This has

a general negative effect on the runtime required for loading. In rare

cases, deleting entries from the SID table can also lead to severe data

inconsistencies if the list of used SID values determined by the

where-used list is incomplete.

? ?

Use Note that deletion of entries from the SID table is only useful or

necessary in specific cases. For example, if you want to ensure that

individual values of the characteristic that are no longer deleted

before loading master data attributes or texts, deleting master data and

keeping the entries in the SID table is sufficient.

? ?

Deleting from the SID Table is useful, for example, when the composition

of the characteristic key has changed considerably and a larger set of

values is to be swapped for another record with new key values.

? ?

? ?

但是呢，如果你要刪的話，首先系統會自己定義一個后臺作業，類似于下圖：

命名規則是：BTCH_*

? ?

問題就出在這里：

? ?

第一：這個作業會先檢索所有用到0COMP_CODE的模型，確認該主數據是否還在使用。這個過程相當漫長。

第二：在這個作業運行期間，所有用到0COMP_CODE的模型數據加載都是不允許的。

?

需要注意：如果是因為主數據冗余的問題，要做刪除，可以不刪除SID，這樣可以節省時間

?

轉載于:https://www.cnblogs.com/hanmos/archive/2012/07/11/2586806.html

總結

以上是生活随笔為你收集整理的Delete Master Data时的注意事项的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。