My client requirement is to caluculate the total open order value of some Sales document Type for each customer i.e
1)Open order value=order is created but no delivery created
2)Open delivery Value=Delivery without picking+delivery with Picking+delivery with PGI.
3)Open Invoice value=Billing is created but Accounting Document not generated(Posting Block)
Total Open order value+Open delivery Value+Open Invoice value.
My client credit control area updated group is 000015.So i will not get open order value in s066 table.
1)For this I went VBAK-->took all sales orders for a Customer and pass it to VBUK Table Overaall Delivery status#C.and the output of this i passed it to VBUP table DeliveryStatus for A(not yet Delivered) and B(Partially Delivered).
For Delivery Status=A sales orders i passed it to VBAP. From there i getting the open order value=X(variable)
For delivery Status=B sales order i am passing it to lips. From there i am getting the delivery quantity and from VBAP i am getting order quantity.
By Subtracting i am getting the open order quantity and open order value=Y
Open order value=X+Y
2)From Open delivery Value i can get it from s067 table.But s067 is giving wrong Open deliveryvalue.Even i tried with RVKRED88 report but it is showing different value.
Is there any way to calculate open delivery value and open invoice value through table.