merge 2 records to use in Transfer or Set

Answered

Alain Seys

• June 05, 2019 14:28

in my sap i want $[OQUT.CntctCode] & $[OQUT.NumAtCard] to be merged as one field.

if i test this with some dummy data this merges well if i replace hello world with $[OQUT.CntctCode] & $[OQUT.NumAtCard]  this gives me an error.

bellow the code used , any idees to solve?

 

Activate(5904); Set($[$67.0.0]|T);

Set($[$68.0.NUMBER]|-1);
SET($[$35.0.NUMBER]|1);
Click($[$123.0.0]);
Click($[$85.0.0]);
//GOOD UNTIL HERE 

//ISSUE HERE 

SET($[$53.0.0]| SQL: SELECT CONCAT('hello','world'));

 

Vote

0

• Official comment

  

  Thomas

  • June 06, 2019 12:03
  • Edited

  Hi,

  Please contact your SAP partner to solve the issue, this forum is not intended for technical troubleshooting.

  Best regards,

  Thomas
• 

  Kenneth Sanderson

  • June 07, 2019 08:03

  Have you tried the CAST and +  instruction instead?

  This is part of something I used recently to generate a Serial number based on SO and Production order number

  Cast(T0.[DocNum] as nvarchar(10)) + '_' + CAST(T0.[OriginNum] as nvarchar(10)) as 'Serial'
• 

  Alain Seys

  • June 07, 2019 11:43

  Hy Kenneth , 

   

  thanks for the help that worked for me :) 

Please sign in to leave a comment.