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