KB 029 – Configuration Table Filter
Configuration Table Filter
View Fields and Description of Field
Go to transaction SE16 and enter table name
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.
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.
Then select the fields you want to view in the output.
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
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
Enter Table name and a unique description and select “Active”
Highlight the new entry and double-click “Select Conditions”
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.
If you would like to extract values from specific fields, double-click
Specify TREAD and TREAD_DYN definition
Go to Administrator -> Setup Group Def
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.