Applies to:

SAP NetWeaver Business Warehouse (formerly BI). This has been tested and working fine on SAP BI 7.0 version.

Applicable for other BW versions as well.

Summary :

This document will help to understand the steps one can take in order to fix the issue related with the datasource – 0CSM_CASE_ATTR (Case Management: Case (GUID) ). This is a necessary point to be performed if you have freshly installed the datasource in the BW system. The datasource is enabled to fetch delta records.

Author: Arpit Khandelwal.

Company: Accenture Services Pvt. Ltd.

Author Bio:

apk.PNG

Arpit Khandelwal is a SAP BI Consultant currently working with Accenture Services Private Limited. He has 2.7 years of experience in  BW/BI implementation and support projects. He has been particularly involved in SAP BW Archiving Activities. Major area of work involves with the extraction of R/3 data from LO and FI datasources.



Basic Scenario ::


Freshly installed datasource – 0CSM_CASE_ATTR (Case Management: Case (GUID) )is available in your BW system.

You have run the RSA3 extractor in R/3 side and tried to pull the data through repair full load on BW side but records are not matching.


Number in records in RSA3:: 70,936


/wp-content/uploads/2014/02/s1_378816.png


Number of records in Infoobject loaded on Repair Full ::  13,228


/wp-content/uploads/2014/02/s2_378817.png




Functional & Technical Aspect ::


The bug in the standard extractor program of this datasource does not allows the data to be loaded correctly through the Repair Full option. This needs to be fixed by instaling the support packages provided by the SAP OSS – 996360 – Case Extractor not able to pull more than 1 data package . If the BW version is not supported by this OSS, then we need to use the SAP OSS – 1159696 – Not able to get the data using case type from case extractor.

The 2nd OSS message also gives us an option to add one more field to the RSA3 extractor – CHANGE_Time field.


If user wants to extract the data using CHANGE_TIME, please do the below steps.

1. Execute rsa2 transaction

2. Input Data source(ex:0CSM_CASE_ATTR) and click on change button

3. Click on fields tab

4. Locate “CHANGE_TIME” field. Change the property value to “X”from “P”.

5. Save the changes.


s3.JPG


s1.JPG



You need to install the Note in your source system (R/3) development –> acceptance –> production to make this load work correctly.

After installing the correction note , the data was loaded correctly.


Number in records in RSA3:: 62,140


/wp-content/uploads/2014/02/s2_378817.png


Number of records in Infoobject loaded on Repair Full ::  62,140

/wp-content/uploads/2014/02/s4_378952.png

Reference Sources ::

Note 996360 – Case Extractor not able to pull more than 1 data package

Note 1159696 – Not able to get the data using case type from case extractor

Time desync of data loading from data source – 0CSM_CASE_ATTR

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply