Show only valid data based on characteristic relations in query

[Former Member]

Hello,

i want to show only valid data in a query based on charcteristic relations. In the actual scenario also data is displayed not input ready (eg actual reference or plan data), which is out of the char relations range.

Example:

Char rel:

1 --> A

Query:

Char 1----Char2-Actual (Ref)PlanInput ready

1--

---

A

---

100,

---

0,----yes

1--

---

B

---

200,

---

0,----no (achieve that this line will not be shown in query)

Is there any possibility, except from reposting or deleting the invalid combinations in transformation or planning function, like a parameter in the exit class or a frontend modification to hide the invalid combinations in the query?

Thanks in advance, appreciate your help. JR

Edited by: JR on Apr 22, 2009 1:42 PM

[Former Member]

No, this parameter in the query has no effect on the display of the data. If there is any data that matches the query filter, it is shown anyhow (not inputable), although it is out of the char relations range.

[Former Member]

Hi,

You can choose on the query front itself how the data has to be populated. Check on the properties of the charteristic on the right hand pane of Query.