Common fields between AUFM and sales tables to fetch the order Quantity

[Former Member]

Dears,

I need an immediate solution to overcome the problem, as my technical concerned is working for the report development. I have used the table AUFM for fetching the production quantity for the specific material. From this table i need to find the common field to fetch the two customers order quantity based on a yearly basis.

Is there any common fields to link from AUFM to any of the sales tables to get the customer number and the order Quantity. or either.

Regards

Noufal.

Message was edited by: G Lakshmipathi

Please make use of the subject effectively and don't type the entire text there

[Former Member]

Ok. Noted. I will do the same.

[Lakshmipathi]

I need an immediate solution to overcome the problem

Don't ever use such commanding texts in your post in SCN as you can only request the members to assist you but cannot dictate them to respond immediately.   Everybody has their own priority.   Coming to your query,  have you not come across SQVI Table Join?  If not, search in Google and table join AUFM with VBAP

G. Lakshmipathi