0BBP_SC Shopping Cart item/header status

[Former Member]

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

[norman]

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

[norman]

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

[norman]

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.

[Former Member]

Hi Norman,

I had to modify extractor logic in SRM system, making to put an 'X' in Deletion Indicator when Status is I1040.

I couldn't find any better solution.