Skip to Content
0

Delta in BI for PGI status

Jul 11, 2017 at 09:44 AM

62

avatar image
Former Member

Hi Everyone,

Currently we are developing a report in BI which shows the Order qty and delivered qty(delivered qty is considered only when it has been goods issued), for this we have taken the Good Mvt Status of the Delivery. The base table are VBAK and VBAP as it is a Order booking report.

The problem is if the good are being delivered after few days of Delivery creation the delta is not taking up the updated order because the delta is set up on the order creation and order change date.

Is there any other field or way in which we can set up the delta so that it fetches the correct data.

Thanks,

Ashutosh Dubey

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jelena Perfiljeva
Jul 11, 2017 at 08:56 PM
0

Well, of course "delta is not taking" because the order is not updated by PGI. PGI applies to the delivery, so that's where you will see an update and that's what you need to track. There is GI status in VBUP.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks, i understand that Delivery status will not be there in order status. Even the GI status in VBUP will always be blank for Orders. I am looking for solutions what else can be done.

0

Not sure what else could be expected in this case... Is there any problem to sending delivery data to BI? You asked for "any field".

0
Former Member

Thanks Jelena , trying to modify the Delta data using enhancement , hope it works.

0