Source time field for 0CALDAY in SD Standard Cube 0SD_C03 - 0CREATEDON vs. 0ST_UP_DTE

[Former Member]

Hi experts,

we are using BW Standard SD Cube 0SD_C03 (Sales: Overview).

Are there any best practice proposals to use the Update Date Statistics (0ST_UP_DTE) as source for 0CALDAY?

ECC	BW
MCVAP-ERDAT	0CREATEDON
MCVAP-VDATU	0ST_UP_DTE

Example:

Sales order item was created on 15.01.2013 with a net value of 1,000.00 $. So we expect an Incoming Order value of 1,000.00 $ in periode 01.2013. One month later, e.g. on 25.02.2013 the sales order item was changed and the net value of the sales order item is 750.00 $.

Now we expect an incoming order value in periode 01.2013 of 1,000.00 $ and in the periode 02.2013 of -250.00 $. So in total (periode 01 + 02) that we have an Incoming Order value of 750,00 $ for this sales document item.

Everything works fine.

But the curiosity is, if we change only a time-irrelevant information (e.g. invoice date, payment conditions, etc. not quantity or price) in the sales document item, the Update Date Statistics is affected.

We want to use the Update Date Statistics (0ST_UP_DTE) as source for 0CALDAY, but only for specific changes (e.g. quantity, price, etc.) in the sales order item.

Should we implement any conclusion criteria in the transformation routine or what kind of prerequisites we have to check? 

Many thanks in advance!

Best regards,

Michael

[Former Member · Accepted solution]

Hi all,

we have solved our Issue!!!

The problem in our specific case was, that we have a incorrect key combination in the line item DSO.

We have used 0DOC_NUMBER (Doc. Number) and 0S_ORD_ITEM (Doc. Item Number) -> As the result of this DSO key combination we always got one single data record (see screen in above comments) from the DataSource 2LIS_11_VAITM.

For Details, please see http://scn.sap.com/thread/3432246 in the Place "SAP NetWeaver BusinessWarehouse".

Thanks and regards,

Michael

[Former Member]

Please find attached the help.sap.com source with the topic "Specific Definition Using Update Rules"

and the note of the two possible situations (A = MCVBAP-ERDAT vs. B = MCVBAP-VDATU)

Source: http://help.sap.com/saphelp_45b/helpdata/en/f9/6bec6eb435d1118b3f0060b03ca329/content.htm

As stated above we want to use MCVBAP-VDATU (situation B).

But how we should setup the settings, that the VDATU updates only for specific changes in the sales order item (e.g. change of the quantity and price).

Thanks in advance!

Regards,

Michael