Determines how to handle the pagination query.

Possible Values

Data Type

string

Default Value

"Default"

Remarks

Allowed values are:

• Default: Performs LIMIT and OFFSET clauses to retrieve each page via the Remote Function Call (RFC) function.
• Key: Paginates the query by the primary key and LIMIT (page size). If the table does not support a server-side ORDER BY clause or lacks a primary key, the driver automatically falls back to Default.
• MaxRows: Retrieves the entire table in a single request rather than using pagination. While full ACID guarantees are not provided, this approach reduces the likelihood of inconsistent results caused by concurrent writes when querying small tables.

Note: When PaginationScheme is set to Default or Key, the driver orders results by the table's primary key(s) only when the table class supports a server-side ORDER BY clause. This behavior prevents duplicate records across paginated result sets.

If a table does not support server-side ORDER BY, the driver does not apply primary-key ordering by default. In this case, if an ORDER BY clause is explicitly specified in the query, it is not sent to SAP; instead, the driver applies the ordering client-side.