How BEAS's MRP list uses the UDF field?

Answered

WuPingHsien

• April 23, 2022 04:04

Hi

I want to display the lot size data of the master file data in the MRP list data

I also made the settings as shown in the figure below, but there is no response after calculating the MRP

How should I set it up?

In addition, I also need the same information in Sales Order to Production Order, and also encountered a similar problem, I made a template but it shows an error

Thanks!

 

Vote

0

• 

  Martin Heigl

  • April 23, 2022 05:57
  • Edited

  MRP: Templatefields current not supported in MRP - item list view

  What can you do? 
  After calculation of the mrp you can write a small script in userevent mrp.end
  which fill in field BEAS_MRP.USER1 the Lotsize from OITM

   

  Filter:
  You must define
  Only with Lotsize#"OITM"."U_beas_losgr">='0'
  
  Sales order to Production order - Template
  if you work with select command, then the system insert this as sub select command. In this case correct is
  (select "U_beas_losgr" from "OITM" o where o."ItemCode"=line."ItemCode")
  
  But it's more simple. You see that the SQL from this window use "OITM"
  It's enough to write
  "OITM"."U_beas_losgr"
  
  Note:
  This list use an union all
  It's not allowed to use ORDR or RDR1 because in second part it's using OINV, INV1
  In this window use header or line, example:  header."CardCode". Then this is working for sales order and pre invoice.

   

   
• 

  WuPingHsien

  • April 23, 2022 06:30

  Hi Martin

  MRP -- I made settings and calculations didn't work

  

  Sales Order to Production Order -- I set it up and it doesn't work and shows SQL error

  

  

  Does this have something to do with me using HANA database?
• 

  Martin Heigl

  • April 25, 2022 06:41

  MRP Filter
  title#SQL command
  Lotsize is a number, not string > '0' is wrong. use > ß
  
  

  Sales order to work order:
  Sub select commands must be in brackets. 
  The second variant is correct.
  If you've an SQL error, check the debug log. Here you can see a red line with the SQL error. And you can check the created SQL Command.
• 

  WuPingHsien

  • April 25, 2022 10:08

  Hi Martin

  The MRP results don't show up on the UDF, which is not what I want, but it taught me how to set.

  The previous discussion mentioned "userevent mrp.end" which seems to fix this, can you tell me where to open it?

  Thanks!
• 

  Martin Heigl

  • April 25, 2022 14:28

  

Please sign in to leave a comment.