11-29-2016 1:46 PM - edited 02-03-2024 7:36 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.