Material & Quantity of all open orders

[Former Member]

Hi,

Can any one tell me the name of the table which will have the material number, quantity, plant, storage location and unit of measurement of all open sales orders ...?

Thanks in Advance.

Best Regards

Venki

[former_member217082 · Accepted solution]

Hi venkatesh

Go to SE16 and use VBBE table which is used for passing the planned requirements.

There you can search for the following feilds

MATNR - material

WERKS - plant

You will get it in VBBE table those feilds and other feilds in the open orders

Regards

Srinath

[Former Member]

Dear venki,

Goto table VEPVG , and enter sales order number in ' VBELN ' field and execute , you will get all the data , you want.

Just explore.

saravanan

[Former Member]

VBUP is the table for sales order status

[former_member184555]

Hi

You can check the table VBAP.

Thanks,

Ravi

[Former Member]

Hi

In SE16 Check table VBBE

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VA05 list of Open and all sales orders.

Regards