topic Sales Open Orders in Application Development and Automation Discussions

Sales Open Orders

Former Member — Mon, 04 Aug 2008 13:24:03 GMT

Hi Experts,

I am trying to create an infoset query which allows the user to see the items, quantities and amounts still pending in every sales open order.

Could someone of you tell me what are the tables in which I should look together with the logic? I don't want to use TC VA05 because users don't want to provide all the filters that this transaction requires. They just want to provide a range of sales organizations and a limit date.

Thanks for your help.

Luis.

Re: Sales Open Orders

Former Member — Mon, 04 Aug 2008 14:15:52 GMT

Using the Table VBUK you will find the status(open or not).

and other tables are VBAK,VBAP, VBUK,VBUP.

Re: Sales Open Orders

Former Member — Fri, 22 Aug 2008 13:07:26 GMT

Hello,

Try the Table S066.

Thanks and Regards,

Venkat Phani Prasad Konduri

Re: Sales Open Orders

Former Member — Fri, 22 Aug 2008 13:11:30 GMT

Luis,

Tx V.02 would be enough?

Amit.

Re: Sales Open Orders

Former Member — Tue, 26 Aug 2008 10:08:55 GMT

HI,

Using the Table VBUK you will find the status(open or not).

and other tables are VBAK,VBAP, VBUK,VBUP.

Try the Table S066.

Tx V.02 would be enough?

and if u don't get then let me Know.