Skip to Content
author's profile photo Former Member
Former Member

BW-SRM Delta Load brings too many records

I am using SRM datasources 0BBP_TD_SC_1 for loading shopping cart individual documents into BW.

When I do a delta load I am getting 100s of records for every shopping cart. If i re-initialize the datasource then for the same shopping cart I will just have 3-4 records (1 header level, 1 item level, 1 with account assignment details etc)

Either ways the data uploads correctly into the DSO.

Does the datasource behave the same way in your systems ?

I face the same issue with the datasource for Shopping cart approvals.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2007 at 01:39 PM

    Hello Guru's

    does anyone having an answer for this? We are facing the same problem.

    We have few millions of records waiting in SRM outbound queue for 0BBP_TD_SC_1 and 0BBP_TD_SC_Appr_1 but when i run the full load I could only see few thousands in BI. And the queue is not moving from SRM.

    we have SRM5.0 and BI7 enronment. much appriciated if anyone have any ideas on how to go about it.

    Thanks,

    Mahita

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2007 at 10:52 PM

    Hi,

    I have used this DS and not faced this issue on previous projects, I would first check on OSS that this isn't a bug that has just recently materialised. As I used SRM with BW 3.5 and SRM 7 and the delta mechanism worked correctly.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 01, 2007 at 02:17 PM

    SAP sent us the following notes but we have not applied them yet. We are following up to find out about some pre-requisites as we are still SRM_SERVER patch 6.

    Please check SAP note:-

    978637: Duplicated Entries in Shopping Cart Approval DSO

    Please implement and retest the scenario.

    In addition also go through the following notes, which will helps

    you further.

    481283

    380078

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2007 at 05:42 PM

    We are experiencing the same issue, I think, The above mentioned note is applicable to the Shopping Cart Approval Process DSO and does not fix the delta load issue for the Shopping Cart - Individual Documents DSO.

    Mahita / A.S, how did you resolve this? Any response is appreciated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.