Sales Order Query

[amit_jha1]

Hi All,

I need to write a query, that gives me the Open sales order for a financial calendar year, which is easy enough because I can write a query for the sales order with open line status, but the problem I need to find out if any of those open orders or closed or cancelled have deliveries or Invoice attached to it.

It will be really helpful if some one can help me with this.

Kind regards,

[rob_ariaans]

Table VBFA contains the document flow for SD documents. Alternatively, tables LIPS and VBRP contain fields VGBEL and VGPOS where reference documents are stored for delivery / invoice line item.

[amit_jha1]

Hi Rob,

Thank you very much for your reply.

I forgot to mention this is for SAP B1, not sure it I can see those tables there.

Kind Regards,