Skip to Content

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

How to achieve a sub query having Prompt in webi

Hi Experts,

I have a requirement where a column value(Vendor.Setid) of a main query is populating from a sub query (containing prompt).


Vendor.Setid =(Select Control.Setid from Control

Where Control.Setcntrlvalue =Prompt

And Control.Recname='Vendor')

Or Vendor.Setid IS NULL

Can anyone please help me with the solution.

Thanks in advance!!


Ravi Shankar

Helpful Answer

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