Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query Parameter against a UDT

Hello All:

Normally when you do paramter like

/*select from OINV t0*/ 
declare @docdate as datetime
/* where */ 
set @docdate = /* t0.docdate */ '[%0]' 
select @docdate

But I have tried to use a parameter against UDT instead of SBO native table.. I am not sure if this is doable...Has anyone done something like this before?

/*select from dbo.[@JP_WHSPSR] t0*/ 
declare @wareperson as nvarchar(50)
/* where */ 
set @wareperson = /* t0.Name */ N'[%0]' 
select @wareperson

Anyone can help I greatly appreciate it!

replied

Hi, many thanks for responding. I want to do something like this

/* Select from .[owht] T0 */

declare @code as nvarchar(15)

/* where T0.U_TGV_CODE_JURIS ='902'*/

set @code= /* T0.wtname */ '[%0]'

select @code

But the 'where' clause doesn´t filter the query I only want to select the name where de code is like '902' and not the rest. This brings me all what i have in the table

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question