get customer details from material and serial number

[meenakshi_raina]

Hi All,

I want to fetch data from a standard table where I can give material number and serial number and get customer number.

I tried using AFIH table, but the customer details only come if the order exists for a particular material and serial number combination,

Is there any other table which can help me in this case ?

Regards

Meenakshi

[Former Member · Accepted solution]

Hi Meenakshi,

Can you try table ITOB.

I think if MTO order exists then only we can see the customer stock.(after production).

Regards,

Sreekanth.V

[meenakshi_raina · Accepted solution]

Thanks. This worked

[meenakshi_raina · Accepted solution]

Hi Srikanth,

How can we differentiate between sold to party and ship to party from this table ?

Do you have any idea on this.

Regards

Meenakshi

[Former Member · Accepted solution]

Hi Meenakshi,

If you have order number you can pass to KNVP table to find the SP, SH.

or if you want to know the that customer is sold or ship to party just pass the customer into KNVP table.

Regards,

Sreekanth.V

[meenakshi_raina · Accepted solution]

Ok. actually i want a table which gives material nim serial num and ship to party. I am creating a search help . hence i need only one table to get these details. In itob, both sold to party and ship to party sre coming in one field. Hence its creating confusion.