CDS-Based BW Extractors for Service and Solution Business in SAP S/4HANA and SAP S/4HANA Cloud
In a heterogeneous system landscape, a data warehouse enables you to integrate and harmonize data from various sources. In particular, this is done for reporting, analysis, and interpretation of business data, which is crucial for optimizing business processes and thus preserving and increasing the competitive edge of companies.
In the past, customers using the SAP CRM solution had a possibility to extract and transfer data from their source systems to SAP BW – a highly optimized data warehouse solution for the SAP HANA platform. They could do so by using a number of data extractors specifically designed for SAP CRM. However, in SAP S/4HANA and SAP S/4HANA Cloud, these old CRM extractors cannot be used anymore.
Why It’s Not Possible to Use Old BW Extractors for CRM in SAP S/4HANA
There’re several reasons why it’s not possible to use old extractors in S/4HANA systems.
- First, the basic tool for synchronization and distribution of data between different components of an SAP CRM solution, CRM Middleware, is not available in SAP S/4HANA and SAP S/4HANA Cloud. That’s why business documents that have been used for data exchange and data processing within a CRM system environment (Bdocs) can’t be used anymore either.
- The data models in SAP CRM and SAP S/4HANA Service are different, SAP CRM data structures don’t follow a 1:1 mapping in SAP S/4HANA. Also, not all CRM features are supported in the business processes covered by the new Service applications.
- Furthermore, some attributes available in SAP CRM data models have been replaced by Sales attributes re-used in SAP S/4HANA Service. As a result, new extractors from Sales need to be used for extracting these Sales attributes.
- Likewise, the CRM master data, such as business partner, product, and IBase, has been replaced by SAP S/4HANA’s master data, therefore requiring extraction to utilize SAP S/4HANA’s master data extractors.
- Finally: Data extraction in SAP S/4HANA is only possible using the new ABAP Core Data Services (CDS) technology.
This means that if you want to continue using the data extraction functionality in SAP S/4HANA and SAP S/4HANA Cloud, you need to switch to the new CDS-based extractors that are currently being developed in the Service area.
New: CDS-Based Extractors for Service and Solution Business Data
Since recently, new CDS-based BW extractors in SAP S/4HANA Service have been made available for extraction of transactional data, in particular for service order, service confirmation, service contract, and solution order data. Besides, the extraction of preceding transaction data and related reference object data is also possible. The extractor for service orders, preceding transactions, and reference object data has been available as of SAP S/4HANA Cloud 2005, the extractor for service confirmations – as of SAP S/4HANA Cloud 2008, the extractor for service contracts – as of SAP S/4HANA Cloud 2011, and the extractor for solution orders – as of SAP S/4HANA Cloud 2208.
The extractors are implemented in such a way that they extract data from the header and item level for each business object. Both levels must be considered due to the bottom-up analysis logic that covers item dimensions, such as product, functional location, equipment, etc. Another guiding principle in the current approach is that each extractor should be valid for SAP S/4HANA and SAP S/4HANA Cloud systems, covering the intersection of functionalities from both editions. The new extractors are called from a BW system in pull mode, meaning that your source data simply waits for your data warehouse to extract it.
Apart from SAP BW systems, any external system can be used to extract data. As a prerequisite for this, you need to establish communication between your SAP S/4HANA system and the corresponding external system (i.e. create an OData service, communication arrangement, etc.)
The CDS views that are used for supplying service order, service confirmation, service contract, and solution order data from SAP S/4HANA Cloud and SAP S/4HANA are:
- Data Extraction for Service Order (C_SERVICEORDERITEMDEX)
- Data Extraction for Service Confirmation (C_SERVICECONFIRMATIONITEMDEX)
- Data Extraction for Service Contract (C_SERVICECONTRACTITEMDEX)
- Data Extraction for Solution Order (C_BUSINESSSOLUTIONORDERITEMDEX)
In addition, several text views have been developed for the extraction of various master data.
These CDS views can be used both in full mode (for example, for master data because it changes rarely) and in delta mode based on the Change Data Capture (CDC) logic. You can use the delta mode if you want to extract new and changed data since the last extraction (for example, to extract transactional data due to its frequent changes). If there are multiple changes, only the latest changes are replicated across all attributes. The CDC feature also ensures that with every change in the source system, a respective change pointer is written.
The transactional data views are also enabled for extensibility, meaning that you can use them to extract your own custom fields. Using Information Lifecycle Management (ILM) notifications, the extractors that are based on these views also inform external systems about service orders, service confirmations, and service contracts that have been archived or destroyed in an SAP S/4HANA system.
Predefined Data Models
SAP BW/4HANA Content
With SAP BW/4HANA Content Add-On, SAP delivers SAP HANA-optimized Business Content for Service that you can use to analyze service order, service contract, and service confirmation data at header and item level. This content provides predefined data models following LSA++ (Layered Scalable Architecture) architecture for the CDS views Data Extraction for Service Order, Data Extraction for Service Confirmation, and Data Extraction for Service Contract. Some important measures that you can analyze using these data models are:
- Open service orders
- Completion rate of service orders
- Overdue service orders by requested end date
- Average net value of service order
- Net value and average net value of service confirmations
- Unplanned services
- Number of service orders and confirmations
- Expiring service contracts
- Top-selling products
The content for service orders is delivered with SAP BW/4HANA Content 1.0 SP15 and SAP BW/4HANA Content 2.0 SP04, for service confirmations – with SAP BW/4HANA Content 1.0 SP15 and SAP BW/4HANA Content 2.0 SP05, and for service contracts – with SAP BW/4HANA Content 1.0 SP16 and SAP BW/4HANA Content 2.0 SP06.
SAP Data Warehouse Cloud Content Including SAP Analytics Cloud Content
SAP also provides SAP Data Warehouse Cloud Content packages, including SAP Analytics Cloud stories for Service, to help you analyze service order, service contract, service confirmation, and solution order data at header and item level. This content provides predefined data models in SAP Data Warehouse Cloud for the CDS views Data Extraction for Service Order, Data Extraction for Service Confirmation, Data Extraction for Service Contract, and Data Extraction for Solution Order. Also, it provides a story for SAP Analytics Cloud for solution order analysis including solution order profitability and a story for service contracts.
The content for the solution order analysis has been available since Q3 2022 and for service order, service contracts, and service confirmations since Q4 2022.
Options for Extracting Data from Additional Fields
If you need to extract additional data, for example, those CRM fields that are not covered by the new extractors by default, you have the following options. If you are a cloud customer, you need to request additional fields that will then be considered in the next cloud release. If you are using an on-premise system, you can either request new fields for a next Feature Pack Stack (FPS) or you can use the provided CDS views as a template to build your own CDS-based extractors.
If you have any questions, please contact the topic owner Maschhur Smid.
- Extracting Data Through CDS Views to SAP BW/4HANA
- SAP HANA-Optimized Business Content for Service
- SAP BW Content: Rollout Presentation
- CDS-Based Data Extraction: Technical Overview, Delta Handling, FAQs
- CDS View: Data Extraction for Service Order
- CDS View: Data Extraction for Service Confirmation
- CDS View: Data Extraction for Service Contract
- CDS View: Data Extraction for Solution Order