欢迎访问 生活随笔!

生活随笔

当前位置: 首页 > 编程资源 > 编程问答 >内容正文

编程问答

Delete Master Data时的注意事项

发布时间:2025/3/21 编程问答 39 豆豆
生活随笔 收集整理的这篇文章主要介绍了 Delete Master Data时的注意事项 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

   

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时的注意事项的全部内容,希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错,欢迎将生活随笔推荐给好友。