Sales Open Orders

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

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

[Former Member]

Hello,

Try the Table S066.

Thanks and Regards,

Venkat Phani Prasad Konduri

[Former Member]

Luis,

Tx V.02 would be enough?

Amit.

[Former Member]

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.