Skip to Content

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

Subquery in From clause @ universe level

hello Experts,

i want to implement subquery in From clause @ the universe level without creating derived table

Query:

SELECT DISTINCT

  'All_Discrepancies' Report,

  a.STUDY,

  b.DOC_INCREC_FLAG INCREC_FLAG,

  a.SITE,

  a.COUNTRY

From

(

Select

  C.STUDY,

  A.COMMENT_TEXT

from  --(ALL_DISCREPANCY)

rxc.discrepancy_management a,

rxa_des.clinical_studies c,

rxc.procedures p,

WHERE a.clinical_study_id = c.clinical_study_id

and a.clinical_study_id = r.clinical_study_id

and a.clinical_study_id = p.clinical_study_id

)a

Where

a.DOCUMENT_NUMBER = b.DOCUMENT_NUMBER

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