Power BI Connector for SAP ERP

Build 25.0.9434

TableMode

Determines which SAP tables are displayed as views, if any.

Possible Values

TransparentApplication, TransparentCustomer, TransparentSystem, Pooled, Cluster, All, None

データ型

string

デフォルト値

"TransparentApplication"

解説

The 本製品 lists SAP tables as read-only views (you can use BAPIs to write to SAP tables if needed).

Most SAP installations contain a very large number of SAP tables, and while the 本製品 can list all SAP tables in your installation as available views, the more SAP tables you have access to, the longer the process of displaying this list of available SAP Tables (as views) takes.

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

The 本製品 retrieves the list of SAP tables from the DD02L system table. Set this connection 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.

SettingFilterDescription
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.
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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434