Macro SQL Set Row Values with Store Function

Carla van Zyl

• August 17, 2023 07:43

Good day!

On My Sales Order, I want the Minimum price (from Item Master Data) to reflect per row on an open sales order. 


I have written this,but its not working - casuing my SAP to just load. Do you maybe know what the issue is or what I can do to fix. 

@store1=SQL

(Declare @ItemCode as nvarchar(12);

SET @ItemCode=$[$38.1.0]

SELECT Distinct T0.U_Min_Price

FROM OITM T0  INNER JOIN RDR1 T1 ON T0.[ItemCode] = T1.[ItemCode]);

Set($[$38.U_Min_Price.0]|@Store1);

 

Vote

0

• 

  Geoff Booth

  • August 17, 2023 13:49

  Validation:

  Set the Before Action to False

  Set the ActionSuccess to True

   

  UF:

  @STORE1 = SQL(Select T0.U_Min_Price FROM OITM T0  Where T0.ItemCode = $[$38.1.0]);

  Set($[$38.U_Min_Price.0]|@Store1);
• 

  Carla van Zyl

  • August 18, 2023 08:04

  Hi Geoff, 
  
  Thanks so much for your quick assistance! It is working now. 

Please sign in to leave a comment.