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

Syntax

Connect-SAPERP -CustomTableFilter string

Data Type

cstr

Default Value

""

Remarks

The 本製品 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 本製品 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 本製品 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.