UDF value from OITM to workorder UDF1

Answered

Timo Skottki

• February 21, 2018 15:14

I have got an UDF in Item Master Data (table OITM) which I need in workorder UDF1.

Does anyone know the code for doing so?

Vote

1

• 

  Martin Heigl

  • February 22, 2018 06:50

  Click in any beas window Crtl + N + G

  Choose workordermanagement.src button edit

   

  

  Insert follow script

  

  function postcreateworkorderpos
  update "BEAS_FTPOS" set "UDF1"= &
  (select "OITM"."U_ZNR" from "OITM" where "OITM"."ItemCode"="BEAS_FTPOS"."ItemCode") &
   where "BEAS_FTPOS"."BELNR_ID"=<e_belnr_id,#0>
  end

  This HANA example copy the drawing number from OITM in the UDF1 field from work order pos

  Replace the "U_ZNR" in this command with your own UDF Field from OITM Table

   

  More information see Project folder in our documetation and beas script documentation

  in beas 9.3 PL 0 with beas B1UP integration we've a very simple soultion for this 

   
• 

  Timo Skottki

  • February 27, 2018 13:24

  First of all thanks for the answer, it worked out quite well. Right now I have a similar issue you might be able to help with.

  

  The red marked fields are template field and currently filled by copy + pasting the content of the previous field (which are UDFs filled from OITM). Is there a way to have that done automatically by some script?
• 

  Martin Heigl

  • March 01, 2018 14:59

  Yes, you can do the same in same function

  function postcreateworkorderpos
  
  ...
  
  update "BEAS_FTSTL" set "UDF1"= &
  (select "OITM"."U_ZNR" from "OITM" where "OITM"."ItemCode"="BEAS_FTSTL"."ART1_ID") &
   where "BEAS_FTSTL"."BELNR_ID"=<e_belnr_id,#0>
  end

Please sign in to leave a comment.