sale orders for which invoice has been created

[Former Member]

is there any table in sd module from which we can find out the list of all sales order for which invoice has been created.

[former_member184703]

Hi

Kindly Table VBFA.It is sales document flow table containing data from the begining of sales order till the invoice.

VBTYP_N = 'M' invoice

Thanks

Subha

[P561888]

HI ,

Yes we need to refer the VBFA table which is Sales Document Flow . Check here we have different type of Document category

VBTYP_N = M is for the INVOICE.

M is capital case sensitive.

Regards,

Bharani

[Former Member]

you can also find in vbrp-vgebl ( delivery number ) and in lips-vgbel (sales order number )

this you can check