Navigation Attribute DrillDown Exception in Reports

1. The Scenario:

    InfoObject ZPRO_CTR is the Navigation Attribute of the MasterData(0Mat_Plant),and Exception occur when drilldown the Navigation Attribute ZPRO_CTR.

The following are the EP exception error messages:

“An Error has occurred during loading.Please look in the upper frame. for further information…

“System error in program CL_RSDM_READ_MASTER_DATA and form. _sidval_direct_read2…”

Use T_Code: RSRT Error Message:

“A system error in program SAPLRRKO and form. GET_FIELD_POSITION-01-… ”

2. The Solution:

Step 1:

    RSRV检查并修复ZPRO_CTR InfoObject 看MasterData是否存在异常情况,若无异常情况继续Step 2操作;

Step 2:

    测试在EP上显示0Mat_Plant的Attribute (ZPRO_CTR)可以正常显示,只是Navigation 显示异常;

    检查0Mat_Plant的SID Attribute Table中ZPRO_CTR的SID是否存在于 MasterData (ZPRO_CTR)的 SID Table中;

检查结果: [0Mat_Plant的SID Attribute Table中ZPRO_CTR的SID有部分不存在于 MasterData (ZPRO_CTR)的 SID Table中],这是导致报表不能DrillDown的原因所在.

Step 3:

    为了保持0Mat_Plant的SID Attribute Table中ZPRO_CTR的SID和 MasterData (ZPRO_CTR)的 SID Table中 SID保持一致,需要重新初始化0Mat_Plant的SID Attribute Table中ZPRO_CTR的SID.

具体操作方法:

将出现问题的MasterData的ZPRO_CTR字段置空并重新拉取原始数据,系统会根据目前MasterData (ZPRO_CTR)的 SID Table的自动更新0Mat_Plant的SID Attribute Table中ZPRO_CTR的SID.

3. The Summary:

  1. 以后维护MasterData建议还是尽量不要手工删除,很容易导致数据关联出问题的;

  2. 通过分析InfoObject 的MasterDataTable与Attribute SID Table字段对应关系,目前发现如下规律:

只有InfoObject设置了Navigation才会生成Attribute SID Table,并且Attribute SID Table的字段都是KeyFields+Navigation Attribute Fields;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9381143/viewspace-594761/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9381143/viewspace-594761/