topic Re: information about fields in Application Development and Automation Discussions

information about fields

Former Member — Wed, 31 Oct 2007 11:45:14 GMT

sir,

plz tell me the fields & tables name of ' value & total value ' of 'pending sales order'

Former Member — Wed, 31 Oct 2007 11:51:36 GMT

<b>go se84

clieck on Abap dictionary - > fields -> Table fields -> specify your correspoding field names</b>

Former Member — Wed, 31 Oct 2007 18:26:01 GMT

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