Views
Get all view templates for a realm.
View-Specific Information
Select
The provider uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The provider processes other filters client-side within the provider.
- ViewTemplateName supports the '=' comparison operator.
- Status supports the '=' comparison operator.
- DocumentType supports the '=' comparison operator.
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. |