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

Query for FMS in Order Recommendation page

Hi

I have created a UDF in the MRP order recommendation page in which I want to show the quantity on order (ordered but not yet received) from the inventory tab in the item master data.

I am not having success so far in writing the correct query , can someone please help

We are running SAP B1 v8.81

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2012 at 12:42 PM

    Hi,

    Try:

    Select T0.onorder from oitm

    where T0.itemcode= $[orcm.itemcode]

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2012 at 04:41 PM

    The query you wrote is not a FMS query. A FMS query cannot be run under query manager. You have to define FMS first.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gordon

      you are right, I did not know it doesnt need to work in the query manager

      I have tried the query suggested by Rahul (see below) and it did work and solved the issue,

      Thank you Rahul, Gordon and everybody

      Select T0.OnOrder From OITM T0 Where T0.ItemCode=$[$3.7.0]

  • Posted on Jul 24, 2012 at 11:04 AM

    HI Sham,

    I think its not possible but am not sure.

    check with this tread

    http://scn.sap.com/thread/2040177

    Regards

    Kennedy

    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.