Quey for sales odrers

[Former Member]

Hi all,

1- I want to create a query to display the turnover for each item in the orders. In the table VBAP, the field name NETWR shows the net price of the order not by item.

2- I need to display the status of delivery of each order. I found the table VBUK and field name LFSTK displays only the letters A, B or C and I need to display the description for each of these letters

Can any one have suggestions

Best regards

[Former Member · Accepted solution]

hello, friend.

other than NETWR, please also consider KZWI1 KZWI6.

regards.

[Former Member]

To get the value of cond type line item wise, take doc. cond (VBAK-KNUMV) and put it in KONV-KNUMV, you can find line item wise every cond type value.

[former_member188076]

Hi

If you want to know from where you can take the description of LFSTK field value like A, B etc. then use the table DD07T in SE16 and fill STATV in the field DOMNAME and execute. STATV is domain name where SAP maintain these values and its description.

Regards

AA