ListItems

Create, update, delete, and query all list items based on the search criteria.

Table Specific Information

Select

The adapter uses the SAP Concur APIs to process filters on Id or on any combination of ListId, Name, ParentId, and Level1Code - Level10Code. The adapter processes other filters client-side within the adapter.

For example, the adapter will offload processing of the following queries to the SAP Concur APIs:

SELECT * FROM ListItems WHERE Id = 'ListItemId'
SELECT * FROM ListItems WHERE ListId = 'sampleListId' AND Name = 'sampleName' AND Level5Code = 'code5' AND Level10Code = 'code10'

Insert

To insert a list item the following columns are required: ListId, Name, and Level1Code.

INSERT INTO ListItems (ListId, Name, Level1Code) VALUES ('ListIdValue','ListItemName', 'Level1CodValue')

Update

Updates are not supported for list items.

Delete

Deletes are not supported for list items.

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
ListID	String	False		The unique identifier for the list this item is a member.
ParentID	String	True		The unique identifier of this item's parent. Is empty when there is no parent.
Level10Code	String	False		The item code for the tenth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level1Code	String	False		The item code for the first level of the list. All lists have at least a Level1Code. Text maximum 32 characters
Level2Code	String	False		The item code for the second level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level3Code	String	False		The item code for the third level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level4Code	String	False		The item code for the fourth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level5Code	String	False		The item code for the fifth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level6Code	String	False		The item code for the sixth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level7Code	String	False		The item code for the seventh level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level8Code	String	False		The item code for the eighth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level9Code	String	False		The item code for the ninth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Name	String	False		The name of item. Text maximum 64 characters
URI	String	True		The URI to the resource.