Excel Add-In for SAP ERP

Build 25.0.9434

Pagesize

The maximum number of records per page the provider returns when requesting data from SAP ERP. Only used for SAP tables.

データ型

string

デフォルト値

""

解説

When processing a query, instead of requesting all of the queried data at once from SAP ERP, the 本製品 can request the queried data in pieces called pages.

This connection property determines the maximum number of results that the 本製品 requests per page.

The RFC_READ_TABLE function module uses the rowcount and rowskips parameters for paging. This can cause unusual behavior if you are paging through data while it is being interacted with.

For instance, if a new row is inserted to a table while you are paging through data, you may see a duplicate entry show up.

Also, if a row is deleted from a table, the results you get back may be missing a row.

This can be avoided by increasing the page size to such a degree that the 本製品 only needs one page to return all data requested in the problematic query.

Note that, while setting large page sizes can resolve this issue and may improve overall query execution time, doing so also causes the 本製品 to use more memory when executing queries and risks triggering a timeout.

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