information about fields

[Former Member]

sir,

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

[Former Member]

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

[Former Member]

<b>go se84

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

[Former Member]

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