SetValidValues Query

Answered

Rob

• October 30, 2018 04:30

I'm having some issues with the "Set Valid values" function with the B1UP.

I have watched the help videos and i have replicated the functionality, but mine will only work when in Debug mode. Below is the code used

SetValidValues($[$BOYX_3.0.0]|SQL:select T1.Name, T0.U_FreightAccNum from dbo.[@DASCO_FREIGHT] T0 Inner Join dbo.[@DASCO_FREIGHTOPTION] T1 on T0.U_FreightType = T1.Code where T0.U_CardCode =$[$5.0.0]);

This is to View some Freight options for the Business Partner. When in Debug mode, it works perfectly. When not in Debug mode it does not load any values.

Is there something that i am missing for this to not work? 

 

Vote

0

• Official comment

  

  Thomas

  • October 31, 2018 08:12

  Hi Rob,

  I cannot see anything wrong in the functionality based on your message. Please contact your SAP partner with all necessary details on this issue so they can have a look at it.

  Best regards,

  Thomas

Please sign in to leave a comment.