The semantic layer in SAP Business One is an abstraction layer above the underlying data models that enables structured data access for reporting, analyses and OData services - especially in conjunction with the SAP HANA database.
Clear and understandable language style:
A semantic layer serves as a "translator" between the technical database structure and the real business world. Instead of accessing tables and fields directly, reporting tools utilise user-friendly views that are already enriched with business logic - for example "Sales Analysis by Rows" or "Customer Balances".
Relevant context and area of application:
In SAP Business One, the semantic layer is primarily used for analyses, dashboards, KPI visualisations (e.g. with Pervasive Analytics, SAP Analytics Cloud or Crystal Reports) and the connection of external systems via OData used. The web client also accesses these layers directly when configuring maps in the "General Overview" dashboard.
Differentiation from similar or related terms:
In contrast to classic database queries or simple reporting views, the semantic layer contains business objects with a defined semantic meaning - this makes it easier to analyse and reduces misinterpretations. In contrast to the service layer, the semantic layer is explicitly designed for analytical purposes, although it can also be technically addressed via OData.
Examples or illustrative comparisons:
Imagine the semantic layer as a well-labelled menu: Instead of having to find the ingredients yourself in the kitchen, you can see pre-defined dishes - including all relevant details. This means that reporting tools can rely on these prepared structures without having to reassemble every data relationship.
Special technical features (SAP Business One, SAP HANA):
- Only available in the SAP HANA version of SAP Business One.
- Views predefined by the system often end with "Query" (e.g. "Sales Analysis by Document Query").
- Views can be provided specifically for the service layers via SAP HANA Model Management.
- Data is provided via OData (standard endpoint:
/b1s/v1/sml.svc). - Virtual keys ("id__") are used for unique identification.
- Authorisation management ensures secure access by authorised users.
Related terms in the glossary:
- Service Layer - REST-based API interface for transactional access in SAP Business One.
- Pervasive analytics - Analysis tool for KPIs and dashboards based on the Semantic Layer.
- SAPHANA - In-memory database platform, basis for the use of the Semantic Layer.
Shopware 6 for SAP Business One
SAP Business One and DATEV - Synchronised
DATEV and SAP Business One Export & Import
SAP BTP for SAP Business One
Group-wide consolidation of ERP systems
