Beas: How to add OITM UDF in order recommendation screen

Patrik Kludsky

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

Like this

How to do that:

Open order recommendation screen and activate those UDF in widows settings (right click in the top part)
Open customization window either:
- Ctrl + N +U or
- SAP - Tools - Customisation tools - beas windows customising script
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

Comments

1 comment

Zuzana Benčeková

October 21, 2024 09:43
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.

Related articles