cancel
Showing results for 
Search instead for 
Did you mean: 

0SD_O01 Vs 0SD_O02

Former Member
0 Kudos

Hello,

We are using the ODS 0SD_O01 for brining the SD order items. When we come to check the data we discovered that it doesn’t bring the returns orders. This ODS uses a start routine which delete all the records with document category not equal to C (=Order) or I (= Order w/o charge). I know that I can use the ODS 0SD_O02 for the returns Items but this ODS gets the data only from 2LIS_11_VAITM and not using 2LIS_11_V_SSL and I need data from the 2LIS_11_V_SSL as well… Did someone changed the start routine of 0SD_O01 to bring returns items as well? Why did SAP separate the orders into 2 ODSes?

Please Advice

David

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi David,

0SD_O02 - The DataStore object contains data on all returns items for a certain order item. This is ensured by the fact that only returns orders and credit memos are written to the DataStore object in the update. Delta update is not supported for this DataStore object.

http://help.sap.com/saphelp_nw2004s/helpdata/en/41/2b4f7b5f153014e10000000a114e5d/content.htm

0SD_O01- The DataStore object integrates data on orders and free-of-charge orders on the basis of the order items (2LIS_11_VAITM) and aggregated information on order delivery schedule lines (2LIS_11_V_SSL). The start routine for the updates ensures that only orders and free-of-charge orders are updated in the DataStore object.

The start routines for the updates also ensure that reverse images are converted to after images. No records are thus deleted in this DataStore object. Instead, an indicator (0ITEM_DEL) is set for deleted records.

http://help.sap.com/saphelp_nw2004s/helpdata/en/41/2b4f815f153014e10000000a114e5d/content.htm

Bye

Dinesh

Former Member
0 Kudos

Hi Dinesh,

0SD_O02 contains data on the return items but not supported delta (althought it uses the dataSource 2LIS_11_VAITM which <b>supports</b> delta) but how can i extract the return items with delta?

Former Member
0 Kudos

The documentation you sent is for version 2004S but according to the documentation of BW 3.5 the ODS 0SD_O02 supports delta update:

http://help.sap.com/saphelp_bw33/helpdata/en/12/bbc73c3d91995be10000000a114084/frameset.htm

I still dont understand why SAP split the data of the same DataSource into 2 ODSes

Answers (0)