Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Open Sales Order quantity & value

Hi,

We have a requirement here of report to show open sales order quantity & value for any month (monthend). There is a datasource 2LIS_11_V_ITM which gives Open order quantity. I have created an ODS with 2LIS_11_VAITM & 2LIS_11_V_ITM which can give me desired qty & value, but only for date of last data upload and not for date in the past.(and to get that, I have to sumup all open orders quantity without using any date filter)

I am thinking of creating a Infocube over this ODS to update the Open Order qty & value at the monthend (Snapshot scenario). But to update this, I am not able to get the logic for date to be used in time dimension.

If anyone can think of the solution or any alternate way to develop this kind of report, your help/suggestions are most welcome.

Thanks,

Vikram.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question