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

0BBP_SC Shopping Cart item/header status

Hi lads,

Again a 0BBP_SC / 0BBP_TD_SC_1 problem. I know that a lot has been written and discussed about this extractor and DSO, and that discussions have been posted in different forums (Extractors, SRM), but I consider this one as the most generic and probably where most experts I can find.

Here my issue.

Let's say that in an INIT LOAD I have the following data in PSA, and then in DSO

SC No Item Head Status Deletion ind.

101 I105

101 1 I105

102 I140 X

102 1 I140 X

102 2 I140 X

Later, 101 is deleted from SRM, and in DELTA extraction I got this:

SC No Item Head Status Deletion ind.

101 I140

When loading DSO I have got this final result:

SC No Item Head Status Deletion ind.

101 I140

101 1 I105

102 I140 X

102 1 I140 X

102 2 I140 X

Line item is not loaded when a SC is deleted from SRM, so register still has an open Status, so when my report reads DSO data, it considers SC=101 is not deleted.

I've seen in other posts that there are two OSS Notes, but I'm not sure if it applies to me.

1863334 - Shopping cart line items are omitted during delta extration

2058180 - 0BBP_TD_SC_1 - During delta extraction item level data is not being captured


I've thought of modifying item registers with an start or end routine.


Has this happened to you?

Do you know if that Delta behaviour is normal?


Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 13, 2016 at 12:11 AM

    Does anyone have an answer to this issue? We are experiencing the same problem.

    When loading to Shopping Cart DSO, I get this final result:

    SC No Item Head Status Deletion ind.

    101 I1040

    101 1 I1009

    101 2 I1009

    102 I1040 X

    102 1 I1040 X

    102 2 I1040 X

    Line item is not loaded when a SC is deleted from SRM, so item still has an saved Status, so when my report reads DSO data, it considers SC=101 is not deleted.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2016 at 04:29 PM

    Hi Alberto,

    Thanks for your response and suggestion!

    Did you mark the deletion indicator for line items of the Shopping Cart that have Header Status equal to I1040 as well?

    The reason I ask this is because my issue is that when someone runs a line item query, it looks as though the SC is still in SAVED (I1009) status and not deleted.

    Thanks,

    -Norm

    Add a comment
    10|10000 characters needed characters exceeded

    • All,

      This issue has been solved by creating a new transformation from the 0BBP_SC DSO back to itself and marking the deletion indication for the line items of the Shopping Cart that have a Header Status equal to I1040 after the nightly delta load is complete.

      This needs to be done this way because when the Shopping Cart is marked for deletion it only marks and sends the header record to BW in the delta load.

      Thanks for you input Alberto!

      Regards,

      -Norm

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.