Incoming orders - functional question

[Former Member]

Dear experts,

I am trying to report on the orders. I am currently using the datasource 2lis_11_vaitm and the netvalue of the item.

However, in a scenario where the Item quantity or value is changed the report reports on the item creation date.

For eg.

If Order is created in Jan with Net value $500

If an item is added in Feb for the same order in Feb of $200

If the netvalue of the item is changed to $300 in march

All the result would show up in the item or order creation date. But I would expect $500 for the same order in Jan and $200 in Feb and $ 300 in March.

Is there a way we can create such a report. Basically this is to report on the same period where the order actually has come but not the actual order was created.

I believe this is very common problem lot of companies have. I would like to know how this is worked.

Any thoughts or datasources which provide this info. Please let me know.

Best regards,

KK

[Former Member]

Hi,

I am using the DataSources of 2LIS_11_* too...

For reporting I don't use the item creation date (ERDAT). Instead of that I use the field VDATU which is used for statistical update.

So, I guess that VDATU has either a date of an item creation or a date of statistics updating. In case of order posting it is going to be a current date.

Regards

Andreas

[Former Member]

Dear Andreas,

Thank you for the reply. Would this date VDATU also include any change in the item quantity.

My client would also want the change to the item quantity. If an item had qty 100 in January and if its reduced to 50 in Feb. We would want the report to show 100 in Jan and -50 in Feb.

Is this possible with VDATU?

Regards,

KK

[Former Member]

Hi,

sorry I understand you not correctly...

This is an other business logic as we use. We use the Delta mode for updating our reported incomming orders.

For statistical date in our reports we use the VDATU field.

I suppose in your case if you want to report changes you have to implement your own solution. You can use VDATU to do it.

If the order is created VDATU is the creation date. After that it includes the date of statistics updating. This logic is also necessary for you.

Now you can build your DSO depending on your reporting logic. I think in your case a solution could be to use time dependent key field in your DSO.

An other solution could be to implement a start routine in transformation for your business logic. This routine have to look in your DSO and set your key figures.

Regards

Andreas