0SD_O01 Vs 0SD_O02

[Former Member]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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