KB 029 – Configuration Table Filter

Configuration Table Filter

View Fields and Description of Field

Go to transaction SE16 and enter table name

Configuration Table Filter

Select Table Content button Configuration Table Filter

Select fields to run query

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

Configuration Table Filter

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

Configuration Table Filter

Select the following button to clear all selections Configuration Table Filter

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

Configuration Table Filter

Confirm screen Configuration Table Filter

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

Configuration Table Filter

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

Configuration Table Filter

Configuration Table Filter

Clear entries Configuration Table Filter

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

Configuration Table Filter

Confirm screen Configuration Table Filter

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

Configuration Table Filter

Configuration Table Filter

Use the display button Configuration Table Filter to change the view of the row

Configuration Table Filter

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

Configuration Table Filter

Configuration Table Filter

Configuration Table Filter

Configuration Table Filter

Return to the initial screen

Configuration Table Filter

Test the query you with to make

Configuration Table Filter

Check the number entries Configuration Table Filter

Configuration Table Filter

Execute to see the output of your query Configuration Table Filter

Configuration Table Filter

Configure PowerConnect Table Reader

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

Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Select “New Entries Configure PowerConnect Table Reader

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

Configure PowerConnect Table Reader

Save Configure PowerConnect Table Reader

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

Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Select “New Entries” Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Enter Field Names you wish to use in your query.

Configure PowerConnect Table Reader

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

Configure PowerConnect Table Reader

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

Configure PowerConnect Table Reader

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 Configure PowerConnect Table Reader

If you would like to extract values from specific fields, double-click

Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Configure PowerConnect Table Reader

Specify TREAD and TREAD_DYN definition

Go to Administrator -> Setup Group Def

Configure PowerConnect Table Reader

Scroll down to TREAD and TREAD_DYN. By default TREAD_DYN is active and is used when you are extracting values from fields.

TREAD can be used when you are not extracting values and will just send a DBCOUNT result of the number of entries that match your query.

Configure PowerConnect Table Reader

Download PDF version here