list of open sales orders

[Former Member]

Hi,

I created orders for which sold to party & payer is different. I want to check all open orders which has particular "X" payer.

For payer "X" some amount of orders is blocked (credit block), so want to to check for payer "x" which sales orders are open.

Thanks.

SHASHANK.

[former_member188027]

hi,

Use VA05/VA05N to see all list of sale order for perticular "X" customer. you also can findout from thae table VBAK / VBAP.

in this case u can make a simple query from list viewer SQVI.

Regards,

anand

[Former Member]

here I have no of sold to parties for payer "x",

with va05/va05n we can get data for SP, not for PY.

i WANT LIST OF OPEN SALES ORDERS WHICH HAVE PAYER "X".

i don't have authorization for SQVI

[Former Member]

Please suggest me tables to make report via SQVI.

Thanks

[andrea_brusarestelletti]

Hello,

you can use VBAK (Header sales document data), VBAP (item data), VBPA (partner roles),  VBUK + VBUP (sales document status at header and item level).

Hope to be useful.

Best regards,

Andrea

[former_member217082]

Hi Shashank

If you want to go through SQVI, then use VBPA Table.You can also use KNVP Table to know the relation from customer master record

The above two tables should solve your problem

Regards

Srinath