Master Data Inconsistency and RSRV Importance

由于X表缺失P表中的SID,导致在使用导航属性的时候,主数据缺失因此数据看不到。解决方法:用RSRV去检查,修复。给阿三哥点赞!


Master Data Inconsistency and RSRV Importance

发贴人 Vijay Chandra.R 在 SAP Business Warehouse 打开 2014-2-26 20:07:12

Hi Friends,


 

Here first I am providing problem which leads me to write this blog and explain details further how to analyse issue.

 

I have a issue with few Materials and there Navigational attributes, where I am unable to get transaction data(Sales Order Details) with respected to  Material and its navigational attr.

 

Although I have data for specific Material in my Infocube , still I am unable to view data at Query level.

 

Then I investigated the issue by doing reverse engineering as - checking whether I have any filters at global level of query or conditions or suppress 0 value records at Bex level.  Still no clue .


Then further checked the data at Multiprovider and Infocube level using Transaction LISTCUBE.

 

Here I find out that I am unable to get records if I see data by displaying/ enabling navigational attribute  (Material Group) of Material.


Here I took test data as 2 materials: A*01 AND J*01.

 

blog 1.PNG

 

 

If I cross check same data with only Material and without enabling Navigational attr at LICSTCUBE , I am able to see data.

 

blog 2.PNG

 

 

 

Then I came know that this issue belongs to Mater data inconsistency and this drives me to check Mater Data tables of 0MATERIAL.

 

I am able to see SIDs for both materials  A*01 AND J*01 in SID table  /BI0/SMATERIAL  & /BI0/PMATERIAL   and same SIDs are not available in /BI0/XMATERIAL (SID table for time independent Nav attr table) for Material  - J*01.

 

blog 3.PNG

 

blog 4.PNG

 

blog 5.PNG

 

This makes clear point that records are missing in  /BI0/XMATERIAL  - SID table for time independent Nav attr table.


Because of this Infocube is unable to pick master data value form X table and same leads to missing record in IC.


Lets me tell you why IC doesn’t have data for Material  J*01. 


In Dimension table of Material -  /BIC/DC_SD_C034  -  Dim ID 102 having SID 40 .

 

blog 6.PNG

If you are viewing data for just 0MATERIAL without Navigation attribute, then  system will pick value for SID 40 from P table  and you will able to see data in Infocube .

 

blog 7.PNG

If you are viewing data for 0MATERIAL along with Navigation attribute 0MATL_GROUP, then system will pick value for SID 40 from X table.  As X table doesn’t have SID 40 and system can’t pull data for Material A*01 and finally you will miss that record in Infocube.

 

blog 8.PNG

 

To rectify the issue I went to check the consistency of data between Master data tables (X table and Y table) with the help of Transaction RSRV.

 

RSRV is useful transaction in BW to validate inconsistencies in master data and Transaction Data tables and simultaneously we can Repair or correct those inconsistencies also.

 

Regarding discussing issue , as it is related to inconsistency in mater data tables- here I went to use Repair option called SID values in X and Y tables.

 

 

blog 9.PNG

 

After executing above function, system has given clear error messages and explained the reason for inconsistency.


This helps to conclude the unexpected behaviour of few master data records in X table and need to Repair those records.

 

blog 10.PNG

 

blog 11.PNG

 

To repair inconsistency use Correct Error option at Right Top of Screen.

 

blog 12.PNG

Continue with Yes option.

 

System provides details as – The following tables of 0MATERIAL must be reconstructed. Here X table is required to reconstruct.


Proceed with Yes option.

 

 

blog 13.PNG

 

 

Now I validated the data in master data tables which I repaired.


Here we are able to see values for materials A*01 AND J*01 in /BI0/XMATERIAL table.

 

 

blog 14.PNG

 

Finally, we are able to find desired data in Infocube.

 

blog 15.PNG

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值