Skip to Content
0

Issue in the calculation of Backorder

Nov 29, 2016 at 01:46 PM

35

avatar image
Former Member

Hi All,

I am facing an issue in the calculation of open sales order quantity in BI. I am using 2lis_11_v_ssl data source.

Scenario:

One particular sales order is open i.e. it has order qty = 200, confirmed qty = 200 and deliver qty = 200 but there is no goods issued against the delivery so we should have 200 open quantity.

2 lines are appearing in 2lis_11_v_ssl data source,

I am removing all the closed items from the data source i.e. code is written in start routine to pass Reverse image ('R') to all those records which have Lowest GI status = 'C'.

So, in this case as Lowest GI status is blank or 'A', record mode is not changed here.

In my target DSO, required and confirmed qty is getting to 400 rather as per function rule it should be 200 only. Please help me here, how to get the correct quantities.

capture.png (4.0 kB)
capture.png (2.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 30, 2016 at 05:04 AM
0

Hi Sameer,

As per the DSO property it should return the value 200. Could you please debug this and check the value coming in the source package.

Also kindly check the aggregation property in the transformation level for the keyfigures it should be summation.

Regards

Vivek

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 30, 2016 at 05:39 AM
0

Hi Vivek,

Yes, the key figure at transformation level is summation. As per the technicalities, it is working fine i.e. summation of 2 records will return (200+200) = 400.

However, from functional point of view it should return 200 only. I have followed standard BW content for backorder functionality. I thought, SAP must have taken care of this scenario.

In this case, I don't know if I am doing something wrong or do I need to take care of this scenario.

Because in other scenarios, schedule line confirmed quantity is split into 2 lines. first line will have 200 qty and second line will have 0 quantities. So, summing 2 line will give correct 200 quantities.

In this special case, both schedule line have same 200 quantities. So, please help in treating this kind of scenario.

Share
10 |10000 characters needed characters left characters exceeded