Skip to Content

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

No Join in Tables

Hi ,

I have two isolated tabels in my universe design like below as its business layer separately.

At report level, iam trying to have Fiscal Year/period (Selection Options) as common query filter by having same prompt text, where iam trying to search value, at any point of time only delhi conn prompt LOV is apearing. Basically i want LOV's as union of both.

Appreciate your help.

Thanks,

Dinya,

replied

Hi,

no impact on the data. assigning custom LOV's are only limited with the display of LOV's in the prompt.with the custom lov's you can see all the  values in the prompt list and the value you select in the prompt based on that you will get the data from two  queries.

let say if you select prompt value from LOV's 010.2015 then same value  pass in the Delhi and Mumbai queries.if values are not present in the Mumbai query for 010.2015 then you will not get the data.

Amit

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