Table for Sales Order Pending Qty.

[Former Member]

Hi All,

I need a Table from which I can extract the pending qty (Qty

Still to be delivered)with material code of all open sales

order. I need this for Reporting purpose. This report is for

pending qty so by refering this report I can forward my

requirement to production.

Thanks in Advance.

Regards

Mahendra

[Manoj_Mahajan78]

Mahendra,

make use of VBBE,LIKP,LIPS,VBKD Table..

In se16 see a;ll above and see which one satisfies ur need.

REWARD if this helps..

Regds

MM

[Former Member]

Hi

You have to use simple query report by joining VBAK,VBAP,LIKP AND LIPS

select the fields as per need.

Regards,

Veeresh babu

Forum points if helpful

[Former Member]

hi,

you can use VA05 std transaction but it may limit your search as you can have onyl one one cust or mat as input, so u can create an ABAP query in sq01 which will link the tables vbuk, vbap,vbak.

saurabh

[Former Member]

Mahendra,

As I understand from your post - you are looking for a table, not the Tcode, right?

The table is VBBE. open quantity is OMENG.

Ashutosh

[Former Member]

Hi,

You can use Transaction VA05 and input the from date and To date and click on radio button for open orders you will get the list of all open orders with material details.

Reward if helps

Manoj

[Former Member]

Hi:

I think you are looking for a back order report - we developed a custom report. I think on the production side, there should be a list of parts to be make. On the sales side, you could try VA05 and select open orders

Or even try Logistics > Production > MRP > Environment....there are options there

Try Tcode CO24

Let me know how this turned out