Retrieve details of locations that are used by Concur and that are valid at the company of the user.

Table Specific Information

Select

The driver uses the SAP Concur APIs to process filters that refer to Id or City_p. The driver processes other filters client-side within the driver. For example, the driver will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Locations WHERE Id = '123456'
SELECT * FROM Locations WHERE City_p = 'London'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns

Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
AdministrativeRegion	String		The administrative region of the location.
Country	String		The 2-letter ISO 3166-1 country code for the location.
CountrySubdivision	String		The ISO 3166-2:2007 country subdivision code for the location. Example: US-WA
IATACode	String		The International Air Transport Association (IATA) airport code of the location.
IsAirport	Bool		Indicates whether the location is an airport. Format: true or false
IsBookingTool	Bool		Indicates whether the location is used by the booking tool. Format: true or false
Latitude	Decimal		The latitude of the geocode for the location.
Longitude	Decimal		The longitude of the geocode for the location.
Name	String		The location name. Maximum length: 64 characters
URI	String		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
City_p	String		The city name of the location.