Skip to Content

Mixed UOM in query

We are dealing with several base units of measure in our BW queries.

As an alternative to conversion to one common unit of measure for all materials in the BW query, is it possible to subtotal the query results according to similar units of measure?

Thanks for any assistance that you are able to provide.

Mark

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2005 at 06:30 PM

    Hi Mark,

    If you pull in the unit of measure as the last column ..

    You should be able to display the results by UOM.

    We used a similar appraoch to deal with multiple currencies..

    Ashish.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2005 at 06:37 PM

    Hi Mark,

    I think you will have different unit of measure for the same material in your data and usually people would sort their query by material and other characteristics. If you are okay with by material by unit and do not need a common unit total of all things for the material, you can do it by organizing the order of the fields in the query, first 0material then 0unit.

    Hope this helps and feel free to assign points if it is of use.

    Mary

    Message was edited by: Mary Huang

    Mark, it was nice getting your thank you e-mail when it help with your issue but you had trouble assigning points since this was not created as a question. 😊 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.