How to get invoice via material document

[Former Member]

HI,

How to get invoice via material document is there any table or any inderect way?

thanks

pandu

[Lakshmipathi · Accepted solution]

First of all, through standard reports, this is not possible. Also I dont know why you want a material document to fetch a billing document which will affect the system performance and it is not recommended.

May be you can try in VBFA where you maintain the Preceding Document Category as R and Subsequent Document Category as M with the Creation Date maintained. Not sure on this but once you tried, update here.

G. Lakshmipathi

[Former Member · Accepted solution]

Hi Lakshimipathi,

thanks for your reply.

i have checked in vbfa but it's not showing anything.

my client is providing below information and asking that invoice number.

material,

plat,

material doc,

movement type,

posting date.

i have ran the mb59 by giving material , plant , movement type and Archive info struct as Z_MM_MATBE. here i got the material doc and same doc i have checked at table levle but it's showing.

and how can i get invoice number by using this information..

please letme know if you have any idea.

thanks in advance.

pandu.

[Lakshmipathi · Accepted solution]

With the material document reference, if you execute MB51, you will get the corresponding delivery reference. From delivery reference, you can very well take the invoice reference from VBFA.

G. Lakshmipathi