Filter on a View

[Former Member]

Hello firends,

I have created a View based on AFPO table.I would like to exclude 2 order types out of the view.Is there a way i can achieve this by going into 'Selection Condition Tab' and excluding just 2 Order Types. If someone can please show me the exact parameters in the Selection Condition Tab.Points will be assigned.

Thanks.

[Former Member]

Follow the below steps.

1. In the Selction Conditon Tab, On the first row SELECT the Table Name as AFPO, 2. Field Name as DAUAT Select Operator as NE.

3. Provide the value to be excluded in the Comp Value field within quotes.

4. In the AND/OR field ENter AND if you want to exclude one more value.

5. In the next entry follow the above steps.

Hope this helps.

Thanks,

Balaji

[Former Member]

Hi,

In the Select Conditions, you can give the table name as "T003O" and field name as AUART operator is NE and value NMO for order type NMO.

Let me know if it works.

Thanks,

Anil.

[Former Member]

Follow the below steps.

1. In the Selction Conditon Tab, On the first row SELECT the Table Name as AFPO, 2. Field Name as DAUAT Select Operator as NE.

3. Provide the value to be excluded in the Comp Value field within quotes.

4. In the AND/OR field ENter AND if you want to exclude one more value.

5. In the next entry follow the above steps.

Hope this helps.

Thanks,

Balaji