Using Exec SQL with parameters from production order

Answered

Sarah Swettlen

• March 31, 2020 18:10

Hi All!
I am trying to use a boyum button in order to execute a stored procedure in SAP.

I need it to pick up the stored procedure parameters from the production order ( Document number and Item code)

 

I have the following macro for the button however, I keep receiving the following error.

 

 

Button Macro:

ExecuteSQL(EXEC SAP_LabelFileCreator where itemcode = '$[$6.0.0]' AND docnum = '$[$18.0.0]' );

 

error

 

ExecuteSQL(EXEC SAP_LabelFileCreator where itemcode = '$[$6.0.0]' AND docnum = '$[$18.0.0]' );

Vote

0

• Official comment

  

  Nadav Caridi

  • April 01, 2020 06:51

  Hi , 

  Does that even work as an SQL ? 

  I always start off by running the command on SSMS to see that I'm using the proper SQL syntax with real values.

   
• 

  Sarah Swettlen

  • March 31, 2020 18:25

  Macro error in UF-081: System.Exception: Incorrect syntax near the keyword 'where'.
  [Macro Command: ExecuteSQL(EXEC SAP_LabelFileCreator where owor.itemcode = '$[$6.0.0]' AND owor.docnum = '$[$18.0.0]' )]

  Macro Enviroment parameters:
  [Cu
• 

  Yaremi Miranda Lopez

  • May 13, 2020 19:29

  Hello Sarah,

   

  As Nadav mentioned, please check the syntax and execute the SP in the query manager first.
• 

  Sarah Swettlen

  • May 13, 2020 20:08

  Hi Yaremi! 
  I was able to get it to work by having the entire stored procedure in the boyum button and then using the syntax there.

   

  It works great!
  
  Thank you all for your feedback! :)

Please sign in to leave a comment.