Skip to Content
0
Former Member
Apr 21, 2009 at 06:57 AM

Result of the query is not filtered as value given in Select Option variabl

105 Views

Hello ,

A Select option Variable is created on Navigational Attribute( ZINV_PROG) of 0WBS_ELEMT.

The Compound Key for object ZINV_PROG(Investment program) is APPR_YEAR( Approval Year)

This ZINV_PROG object does not bear Master data.

The values in the field get populated as you load Master data of 0WBS_ELEMT.

The values for this objects is as shown below:

APPR_YEAR ZINVPROG

2005 ESCCCAPS

2007 ESCCCAPS

2008 FIRE

2006 CAPITAL

A select option variable is craeted on this Navigational attribute.

When you execute the query , On the selection screen of the query..

If you provide i/p for Investment programm field as 2007 ESCCCAPS, the data should ideally be filtered for this values only.

But the result of the query shows data for both values 2005 ESCCCAPS and as well as for 2007ESCCCAPS.

Let me know how to sort this issue.

Points will be assigned for the correct and helpfull answere.

Thanks,