Beas: How to add OITM UDF in order recommendation screen

I'm going to show you how to add UDF value into your MRP result.

 

Like this

 

 

How to do that:

  1. Open order recommendation screen and activate those UDF in widows settings (right click in the top part)





  2. Open customization window either:
    • Ctrl + N +U or
    • SAP - Tools - Customisation tools - beas windows customising script




  3. Insert this script below

    • Replace "YourUD1-3" with your UDF name

      // ******* Event form_loaded ********
      // Created 2018/12/10 by Patrik
      global function form_loaded

      for=cl_loop=1=<dw_2.rowcount>

      sql=select "YourUDF1" into :var1 from "OITM" where "ItemCode"=<dw_2.item.oitm_itemcode:[cl_loop].value,dbstring>
      dw_2.item.beas_mrp_user1:[cl_loop].value=<var1>

      sql=select "YourUDF2" into :var2 from "OITM" where "ItemCode"=<dw_2.item.oitm_itemcode:[cl_loop].value,dbstring>
      dw_2.item.beas_mrp_user2:[cl_loop].value=<var2>

      sql=select "YourUDF3" into :var3 from "OITM" where "ItemCode"=<dw_2.item.oitm_itemcode:[cl_loop].value,dbstring>
      dw_2.item.beas_mrp_user3:[cl_loop].value=<var3>

      next

      end global

Was this article helpful?

1 out of 2 found this helpful

Comments

1 comment

Date Votes
  • Comment author
    Zuzana Benčeková

    Hi, we can see the information in the UDF field, but we cannot use for sorting, filtering. Any update in the screen (for example the recalculation of the MRP detail) will cause, that all the information disappears and you need to close and reopen the MRP window to see it again. Is there any way how to fix this info?

    0

Please sign in to leave a comment.