The CData Excel Add-In for SAP Business One connects to SAP Business One Service Layer, an OData service, to model entities in relational Tables and Views. The table definitions are dynamically obtained from the SAP Business One Service Layer. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.

Tables

The add-in models the writable entity sets and singletons described in the service metadata document as bidirectional Tables.

Views

Some OData entities can only be accessed through Navigation Properties. By default, the add-in models navigation properties as separate views. You can disable this behavior with NavigationPropertiesAsViews. See Views for more information on querying navigation properties.