Skip to Content

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

Need help with a query

I'm trying to create a query to copy information from an invoice to a user field.

We have 2 locations, each one uses its own series for most documents. A new add-on we'll use requires a user field series, which I basically want to make the same as the document's series; since I couldn't find a simple way to assign that field to specific users (like the invoice series), I'm trying to create a query that copies the document's series to the user field series.

The last query I tried was:

select b.name

from dbo.user_series d

inner join oinv o

on b.name = (select seriesname from nnm1 where series = o.series)

I'm not sure if its possible to do something like

MAKE b.series

from dbo.user_series b

inner join oinv o

where b.series = o.series

Thanks in advance

Hugo

Former Member
Not what you were looking for? View more on this topic or Ask a question