Specifies which SAP ERP tables are displayed as views.

Possible Values

TransparentApplication, TransparentCustomer, TransparentSystem, Pooled, Cluster, InternalTable, View, AppendTable, All, None, Custom

データ型

string

デフォルト値

"TransparentApplication"

解説

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, and while the connector can list all tables in your installation as available views, the more tables you have access to, the longer the process of displaying this list takes.

This property allows you to only list the tables that are important to you. This both avoids the need to scroll through a massive list of tables and allows the connector to display the now-filtered list of tables more quickly.

The connector retrieves the list of tables from the DD02L system table. Set this property either to the name of one of the filter presets below, or write a custom filter for DD02L directly in this connection property's value.

Internal Filtering Behavior

In addition to the selected filter, the connector applies internal filtering logic to avoid displaying system-reserved or special-use tables. For example, by default, the connector excludes tables that contain a forward slash in the name. This can cause tables such as /Customer/Orders/ to be omitted from the table list, even if they would otherwise match your selected filter.

Using CustomTableFilter to Override Default Filters

To override the default filtering behavior, you can set the TableMode to Custom and define your own filter using the CustomTableFilter property.

Available values:

Setting	Filter	Description
TransparentApplication	TABCLASS = 'TRANSP' AND CONTFLAG = 'A'	Master and transaction data.
TransparentCustomer	TABCLASS = 'TRANSP' AND ( CONTFLAG = 'C' OR CONTFLAG = 'G' )	Data maintained by the customer only.
TransparentSystem	TABCLASS = 'TRANSP' AND ( CONTFLAG = 'E' OR CONTFLAG = 'S' OR CONTFLAG = 'W' )	Customer namespaces, program status changes, development environment tables, etc.
Pooled	TABCLASS = 'POOL'	All pooled tables.
Cluster	TABCLASS = 'CLUSTER'	All cluster tables such as BSEG and KONV.
InternalTable	TABCLASS = 'INTTAB'	All internal tables.
View	TABCLASS = 'VIEW'	All general view tables.
AppendTable	TABCLASS = 'APPEND'	All append tables.
All		All tables regardless of type. Warning: This will cause a massive amount of tables to be retrieved and may result in a noticeable delay in table listing.
None		No filter. No SAP tables are displayed. This may be useful if you intend to use schema files or SAP queries.
Custom		User-defined filter. Please set this filter in the CustomTableFilter property.