Applies to:

SAP BI NetWeaver 2004s and SAP CRM 5.0

Summary

This white paper is meant for SAP BW CRM delta understanding and will help to troubleshoot the delta flow of CRM standard datasources. Also it will help to analyze the changes moving from CRM to BW system.

Author(s):    Rahul Desai

Company:    Tata Consultancy Services Ltd

Created on:  20th Feb 2014

Author Bio:

/wp-content/uploads/2014/02/scn1_392287.jpg

Rahul Desai works as a SAP BW/BI consultant in Tata Consultancy Services Ltd and having 7 years of experience in SAP BW/BI Implementations and Production support environment.


Introduction

This document will allow you to understand the role of BDoc messages in BW/BI system, to monitor their flow, and to react effectively to error situations.

Also it will help to troubleshoot the missing or incorrect delta records which is coming from CRM to BW/BI system.

CRM to BW/BI delta flow


The below diagram will help you to understand the data from CRM system to BW system and also you can understand the role of Bdoc and IDoc.

BWAdapter.jpg

Also in this document we will see the step by step how CRM changes will be flowed to BW system.

Below are the basic transaction used for troubleshoot CRM datasources.

SPRO Configuration Related Settings

SMOEAC Administration console – CRM Middleware

SBDM BDoc Modeler

SMW01 Transaction for Monitoring BDocs

SMW02 Display BDoc Message Summary

SMQ1 Queue RFC Monitor for Outbound queue

SMQ2 Queue RFC Monitor for Inbound queue

BWA1 BW Adapter

BWA5 BW Adapter DataSources


Here in this document we have taken standard datasource 0CRM_SALES_CONTR_I to understand the actual Delta flow.

In each CRM item level data creation or any change will create ITEM_GUID in the system and also it will assign the HEADER_GUID for all header related information.

In this document we will change some item level information of CRM sales contract and we will see how those changes will be captured in Bdoc.

Step by Step CRM contract changes:


First login to the CRM source system and run the transaction CRMD_ORDER. This is the main transaction where you can create CRM order and change any existing CRM order. Here we have taken example of CRM contract “5000002”

/wp-content/uploads/2014/02/1_392304.png

After continue you can see on the screen the CRM contract with their respective line items:

/wp-content/uploads/2014/02/2_392305.png

After this to create the Delta records for BW we need to change any of the pricing details of the Contract line item. Here we will pick the line item 100 and will make the changes in the price details:

Currently the Price is 500 USD for line item 100 for contract 5000002.

/wp-content/uploads/2014/02/3_392324.png

Now go to the condition and change the price of contract to 700 USD and then click on SAVE.

/wp-content/uploads/2014/02/4_392325.png

Now before SAVE this transaction if will check the BW delta Queue for datasource “0CRM_SALES_CONTR_I” it will show you ZERO entry.

/wp-content/uploads/2014/02/5_392326.png

After SAVE the contract in CRM source system we will check the RSA7 delta queue and Bdoc (SMW01) in the system.

Now RSA7 will display the Delta Entry which we have changed in CRM:

/wp-content/uploads/2014/02/6_392327.png


Now we will check the same changes reflected in the BDoc (SMW01). Whenever any changes happened to CRM contract it will create a Bdoc and it will store the data in structural manner in BDoc queue.

During the production support thre are 100 of queue used to be created due to changes and it is difficult to find the Queue for single transaction.

so to make easier we will find the BDoc queue with the help of CRM contract number “5000002”.

See the below screen of SMW01 and also go for “Expand Additional select option”

/wp-content/uploads/2014/02/7_392328.png

Once exapand the selection check the Additional select options and you can see the “QUEUE NAME”. Now Queue name consist of CRM order number with some prefix and post fix. so you can search the queue like “*5000002*” so that it will give all the Queue name which consist of change to this CRM contract. and then click on execute.

/wp-content/uploads/2014/02/8_392329.png

In below screen you can see the BDoc Queue where your change records exist:

/wp-content/uploads/2014/02/9_392336.png

Once select the latest Queue according to Date and time of changes you have made and then click on the button

/wp-content/uploads/2014/02/10_392337.png

Now you can see the ITEM changes you have made in this Queue, we will check the PRICING changes which we have made in CRM order ITEM 10.

/wp-content/uploads/2014/02/11_392338.png

Also you can check the price changes in this particular contract in that pricing structure:

/wp-content/uploads/2014/02/12_392348.png


Now once you verify the change you have made then you can go and start the BW delta load for the datasource “0CRM_SALES_CONTR_I”

/wp-content/uploads/2014/02/13_392349.png

Now after running the Delta load you can check the data in PSA if you changes moved correctly or not.

In below scrrenshot of PSA it shows the changes we have made to pricing of contract (700 USD).

/wp-content/uploads/2014/02/14_392350.png


After this you can move your changes to BW data target.



Related content


www.scn.sap.com

help.sap.com

www.sapww.com/wp-content/uploads/…/BestPractice-BDoc-Analysis-V2.pdf







To report this post you need to login first.

8 Comments

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

  1. CH Raman

    Hi Rahul,

    Good presentation and sue ful stuff. Thanks for sharing with us.

    To send delta/changed records to RSA7,is there any settings at CRM system or those will be happen automatically as per CRM-BW Adapter settings.

    Actually some times BDocs will be hanged and not sending to RSA7. in this cases how we will move bdocs to rsa7.

    Thanks

    (0) 
    1. rahul desai Post author

      Hi Raman,

      May be you can chck the Queues in below transaction:

      SMQ1 Queue RFC Monitor for Outbound queue

      SMQ2 Queue RFC Monitor for Inbound queue


      and also you need to check the BW CRM services UP and working properly.


      May be your CRM technical person can help you to check CRM services.


      Thanks,

      Rahul

      (0) 

Leave a Reply