Lists

The driver uses the SAP Concur APIs to view your configured lists within SAP Concur products.

Table Specific Information

Select

This API is only available to partners who have been granted access by the SAP Concur team.

The 本製品 uses the SAP Concur APIs to retrieve configured lists within SAP Concur products.

For example:

-- Retrieves all available lists
SELECT * FROM Lists;

-- Retrieves a specific list by Id
SELECT * FROM Lists WHERE Id = '665E58E7E1226346BC424861DEC93F30';

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Unique identifier of a list.
Value	String	False		Name of the list.
LevelCount	Int	False		Number of levels in the list.
SearchCriteria	String	False		What attribute to search by {TEXT, CODE}.
DisplayFormat	String	False		Whether the code or value is displayed first {(CODE) TEXT, TEXT (CODE)}
CategoryId	String	False		The category of the list.
CategoryType	String	False		The category of the list.
IsReadOnly	Boolean	False		If true, the list is read-only.
IsDeleted	Boolean	False		If true, the list has been deleted. デフォルト値はfalseです。

ODBC Driver for SAP Concur

Lists

Table Specific Information

Select

Columns