2007 Oct 31 11:45 AM
sir,
plz tell me the fields & tables name of ' value & total value ' of 'pending sales order'
2007 Oct 31 11:51 AM
<b>go se84
clieck on Abap dictionary - > fields -> Table fields -> specify your correspoding field names</b>
2007 Oct 31 6:26 PM
Hi
There is no direct field for the Values of the Pending Sales order
First pending Sales order means the Qty which is there in Sales order (VBAP-KWMENG) was not delivered completly
if VBAP-KWMENG for all items is not equal to LIPS-LFIMG then that order is called pending sales order
so first take the qty for the pending orders and take the NETWR/NETPR field from the Item table VBAP.
Then Pending Qty * Net Price
(VBAP-KWMENG - LIPS-LFIMG) * VBAP-NETWR.
If you sum up the all sales orders amount that will give the total value
Regards
Anji
Bluesky
