Sales Order # and Despatch Advice # from Invoice #

[Former Member]

Hi all,

If I know the invoice no, from which tables I can get Sales order # and Despatch Advice #?

Please respond.

Regards,

Aisha Ishrat

ICI Pakistan Ltd.

[Former Member · Accepted solution]

HI,

Try VBFA.

Thanks,

Pramod

[Former Member]

I have used table "VBRP"

Best Regards,

Aisha Ishrat

ICI Pakistan Ltd.

[Former Member]

hi,

the document flow is stored in VBFA table where you can find out either subsequent documents or preceding doucments.

And if you specifically want to find for example a sales order for an invoice you can even mention the previous doc category(VBTYP).

so in your case, go to se16 > give VBFA table > give invoice # in the succeding document field and you will see the order as well the delivery number.

regards

sadhu kishore

[ranjeetrajendra_jain]

You will find the entry in VBFA.

The documents with preceding document category C are Sales orders and those with J are deliveries.

Hope this helps