Items
Lists list items based on the search criteria.
Table Specific Information
Select
The 本製品 uses the SAP Concur APIs to get list items based on the search criteria.
By default the provider will return only the first level of items for each list. Only unique items will be returned. If the item is present in multiple lists it will show only once.
In the following queries, the 本製品 offloads the processing to the SAP Concur APIs:
SELECT * FROM Items where ListId = '665E58E7E1226346BC424861DEC93F30' SELECT * FROM Items where ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c')
INSERT
In order to create an Item see ListItems
Update
UPDATE Items SET value = 'updatedListItem', ShortCode='VFAL1' WHERE ID = '54f19bfa-aef0-2645-b3a4-3b2f15749858'
DELETE
DELETE FROM Items WHERE Id = '54f19bfa-aef0-2645-b3a4-3b2f15749858'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier of the list item. |
Code | String | False |
List item long code. |
ShortCode | String | False |
List item short code. |
Value | String | False |
List item value. |
ParentId | String | False |
The unique identifier of the parent list item. |
Level | Int | False |
Level of the list item within the list. |
HasChildren | Boolean | False |
If true, the list item has children in this particular list. |
Lists | String | False |
The unique identifiers of the lists that contains the list item. The list item may exist under one or more lists. |
IsDeleted | Boolean | False |
Indicates the deleted state of the item in a particular list. If false, the list item is not deleted from one or more lists. The lists field will include only the lists that contain the list item in a not-deleted state. isDeleted will only be true when the list item is deleted from all lists. The lists field will include all lists that contain the list item. デフォルト値はfalseです。 |
ListId | String | False |
The unique identifier of the list that contains the list item. |