KB 029 – Configuration Table Filter

Configuration Table Filter

View Fields and Description of Field

Go to transaction SE16 and enter table name

Select Table Content button

Select fields to run query

Go to Settings -> “Fields for Selection” to view the fields in table

This pop shows the field name and a description of the field.

Select the following button to clear all selections

Then select the fields you would like to run the query.

Confirm screen

You will now see the fields you would like to search.

Carry out the same selection in Settings -> Format List -> Choose Fields. This will reduce the output of the results to just the selected fields.

Clear entries

Then select the fields you want to view in the output.

Confirm screen

Once confirmed execute the transaction and select one of the rows from the output.

Use the display button to change the view of the row

You can then select the fields you wish to use in your query to see possible values.

Return to the initial screen

Test the query you with to make

Check the number entries

Execute to see the output of your query

Configure PowerConnect Table Reader

In transaction /n/bnwvs/main go to Administrator -> Setup Metric -> Table reader filter

Select “New Entries

Enter Table name and a unique description and select “Active”

Save

Highlight the new entry and double-click “Select Conditions”

Select “New Entries”

Enter Field Names you wish to use in your query.

Select I or E to state if the excluding or including the values. Use “F1” for detailed information about “Options” Values.

If you are using a date or time field you can use the following vales

DATE: $today, if you wish to select a different day you can use the “-“ followed by a numeric value. e.g. $today-1 is yesterday, $today-2 is two days ago

TIME: $now, if you wish to select a different time you can use the “-“ followed by a numeric value. e.g. $now-1 is the last hour, $today-2 is two hours ago

You can use the option BT (between) to select a date or time range

In the example above I have set to include BADAT = today, include WERKS where values are between 9000 and 9999, exclude KNTTP when the value is between A to Z.

Save