Using Exec SQL with parameters from production order

Respondida

Sarah Swettlen

• 31 de marzo de 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

• Comentario oficial

  

  Nadav Caridi

  • 1 de abril de 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

  • 31 de marzo de 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

  • 13 de mayo de 2020 19:29

  Hello Sarah,

   

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

  Sarah Swettlen

  • 13 de mayo de 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! :)

Iniciar sesión para dejar un comentario.