Specifies which SAP ERP tables are displayed as views when the TableMode is set to 'Custom'.

Data Type

string

Default Value

""

Remarks

The connector lists SAP ERP tables as read-only views. If you need to write to SAP ERP tables, you can use BAPIs.

Most SAP ERP installations contain a very large number of tables. While the connector can list all tables as available views, this may result in long load times. This property allows you to define a custom filter against the DD02L system table to retrieve only the tables important to your use case.

To use this property, set the TableMode to Custom and define a valid SQL WHERE clause here (without the "WHERE" keyword). For example, to retrieve transparent tables used for application data:

CustomTableFilter = TABCLASS = 'TRANSP' AND CONTFLAG = 'A' AND AS4LOCAL = 'A'

Overriding Default Filtering Behavior

By default, the connector applies internal filters to exclude certain tables, such as those with names containing forward slashes. For example, Customer/Orders.

To override this behavior and explicitly include such tables, you can set a custom filter that matches your use case. For example, to retrieve only tables with slashes in their names:

CustomTableFilter = TABNAME LIKE '/%'

Note: Use custom filters with caution. Tables containing slashes are often system or namespace-reserved and may not be appropriate for general access.