Quey for sales odrers

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