Modeling Navigation Properties

The driver models Navigation Properties as separate views. The views are named in the format ParentTable_NavigationProperty.

Querying Navigation Properties

For an example of working with a navigation property as a view, see AccountCollection_AccountAddress. In SAP Cloud for Customer, the AccountCollection entity set has an AccountAddress navigation property. The CData ODBC Driver for SAP Cloud for Customer will display a view called AccountCollection_AccountAddress. Retrieving data from AccountCollection_AccountAddress will display all of the AccountAddresses associated with a given Account. The AccountCollection_AccountAddress view has a primary key made up of the Id of the parent entity and the Id of the related entity.