Get all view templates for a realm.

View-Specific Information

Select

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

• 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'

Insert

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"]}]')

Update

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'

Columns

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.