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

How can i get the value from Length,Width in Item Master Data to calculate?

Hi all experts,

My customer needs 1 columns in Item master data. To solve with his requirement, i create one UDF the store that information.

The UDF will calculate by width*length( Sales Tab). So when the user change or input the length or width, it will calculate and display in my UDF.

So does anybody know how i can get the value in Width and Length values from Sales Tab in Item Master Data?

Thanks

TONY

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 03, 2012 at 09:28 AM

    Hi Tony,

    Try something like

    select CONVERT(numeric(19,6),CONVERT(Numeric(19,6),Replace($[$-54.0.1] ,'m','')) * CONVERT(Numeric(19,6),Replace($[$-61.0.1] ,'m','')))

    And make sure your UDF is of type Rate/Total

    Regards

    Edy

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Edy,

      B1 allows mixed UOM, simply because SAP never deemed it necessary to enforce a single UOM policy. Using a single UOM policy, is more of a best-practices kind of thing. I can easily think up several scenarios that would benefit from a single UOM policy, and not a single one, that necessitates a multiple UOM policy. Also a multiple UOM policy makes automating processes that use measurements, unnecessarily complicated.

      You are right though, that the solution can be implemented with a query with string functions and/or case statements. However that only proves my point. A simple agreement to only use m as UOM, or a complicated query, each time you have a new requirement ? In other words, always use the K.I.S.S. method.

      Regards,

      Johan

      P.S. The UOM for each measurement is maintained in a separate own column. So for Height (SHeight1) the UOM can be found in SHght1Unit

  • Posted on Aug 03, 2012 at 09:24 AM

    Hi Tony,

    Apparently you already solved this question yourself ?

    Please see your own previous question.

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Johan,

      i confuse to use this query (select isnull(T0.sLength1,0)*isnull(T0.SWidth1,0) from oitm T0 where ItemCode=$[OITM.ItemCode])

      If i use this query, it will be wrong because when i change value at Length or Width, it doesn't change value at UDF.

      Do you know when i change values at Length or Width, it update values at UDF?

      Thanks

      TONY

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.