Skip to Content
author's profile photo Former Member
Former Member

FMS for purchase request

Hi Experts ,

i have writte the following query for the alternative item list of the particular item in purchase request i had created the udf U_Alteternative item in the row level field of the purchase request ,please find the following query

SELECT Distinct T0.[ItemCode], T0.[ItemName], T).[Desription],T1.[AltItem], T2.[WhsCode] FROM OITM T0 INNER JOIN OALI T1 ON T0.[ItemCode] = T1.[OrigItem]INNER JOIN POR1 T3 ON T0.[ItemCode] = T3.[ItemCode], OWHS T2 WHERE T3.[ItemCode] = T0.[ItemCode]



i getting the alternative item list of all the items ,i want the alternative item list of particular item only






Thanks and Regards,

Nagendra Prasad

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 14, 2015 at 01:46 PM

    Hi,

    Have you tried with standard alternative item function? If you define alternative item under item management, you can easily display alternative items by pressing ctrl + tab at item no.

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2015 at 12:20 PM

    Hi,

    I think the problem is the OWHS.

    Do you need this table?

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2015 at 01:13 PM

    Try this Nagendra

    SELECT T1.[AltItem], T3.[WhsCode] FROM OITM T0 INNER JOIN OALI T1 ON T0.ItemCode = T1.OrigItem INNER JOIN OITW T2 ON T0.ItemCode = T2.ItemCode INNER JOIN OWHS T3 ON T2.WhsCode = T3.WhsCode WHERE T0.[ItemCode] = $[prq1.itemcode]

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.