JDBC Driver for SAP Ariba Procurement

Build 23.0.8839


Get all view templates for a realm.

View-Specific Information


The driver uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • ViewTemplateName supports the '=' comparison operator.
  • Status supports the '=' comparison operator.
  • DocumentType supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM Views WHERE ViewTemplateName='Contract_SAP_createdRange_v1'
SELECT * FROM Views WHERE Status='published'
SELECT * FROM Views WHERE DocumentType='DirectOrder'


You can create views by executing INSERT statements and specifying the ViewTemplateName, Status, DocumentType, SelectAttributes and FilterExpressions. For example:

INSERT INTO Views (ViewTemplateName, Status, DocumentType, SelectAttributes, FilterExpressions) VALUES ('TestView','published','DirectOrder', '["SubmitDate"]','[{"name":"ExampleFilter","field":"UniqueName","op":"IN","defaultValue":["P011"]}]')


You can update the status of views by executing UPDATE statements and specifying the ViewTemplateName and Status. For example:

UPDATE Views SET Status='published' WHERE ViewTemplateName='TestView'


Name Type ReadOnly References Description
ViewTemplateName [KEY] String False

The name of the view.

Type String False

The type of view template.

Status String False

Status of the view template.

DocumentType String False

The type of transaction data this view template queries.

SelectAttributes String False

The fields that will be included in the response to queries using this view template.

FilterExpressions String False

A collection of objects that defines filters for the view template.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839