How to Use the ODP_CDS Source System in SAP BW/4HANA

SAP BW/4HANA is the next-generation data warehouse solution that can leverage the power of SAP HANA to provide fast and flexible data analysis and reporting. But how can you extract data from your SAP S/4HANA system or other SAP systems to your SAP BW/4HANA system? One of the options is to use the ODP_CDS source system, a technology that allows you to extract data from ABAP Core Data Services views (ABAP CDS views) using the Operational Data Provisioning (ODP) framework.

In this blog post, we will explain what ODP_CDS source system is, how it works, and how you can use it in your SAP BW/4HANA system. We will also share some tips and best practices for optimizing your ODP_CDS source system performance and data quality.

What is ODP_CDS Source System?

ODP_CDS source system is a type of source system that enables data extraction from SAP systems using ABAP CDS views. ABAP CDS views are a core technology for data modeling in SAP systems. They define a logical view on one or more tables in the SAP HANA database using SQL syntax and annotations. Annotations are additional metadata that provide information about the semantics, behavior, and consumption of the ABAP CDS views.

ODP_CDS source system uses the ODP framework to expose the data from the ABAP CDS views to the SAP BW/4HANA system. ODP is a generic framework that supports various types of source systems, such as SAP systems (S/4HANA, ECC, BW, etc.), non-SAP systems (Oracle, SQL Server, etc.), or file systems (CSV, XML, etc.). ODP also supports various types of extraction methods, such as full load, delta load, real-time load, or scheduled load.

ODP_CDS source system has several benefits, such as:

It supports various types of data, such as transactional data, master data, text data, or hierarchy data.
It supports various types of scenarios, such as virtual access for small data volumes or low latency requirements, physical integration for large data volumes or complex transformations, or hybrid scenarios for mixed requirements.
It is based on the same data models that are used for operational analytics and transactions in SAP systems, ensuring consistency and alignment of the data.
It is easy to create and maintain using Eclipse IDE or ABAP Development Tools (ADT), without requiring additional tools or coding.

How to Use ODP_CDS Source System in SAP BW/4HANA?

To use ODP_CDS source system in SAP BW/4HANA, you need to have access to an SAP system as the source system via Eclipse IDE or ADT and the authorization to view and create ABAP development objects. You also need to have access to an SAP BW/4HANA system as the target system via Eclipse IDE or ADT and the authorization to view and create BW development objects.

To use ODP_CDS source system in SAP BW/4HANA, follow these steps:

Create an ABAP CDS view in your source system. In Eclipse IDE or ADT, open the Project Explorer view and right-click on your package. Select New > Other > Core Data Services > Data Definition. Enter a name and a description for your ABAP CDS view and click on Next. In the Template Selection screen, select Define View as Extraction Enabled View from the list of templates and click on Finish. In the editor window, you will see a template code for your ABAP CDS view with some predefined annotations and SQL statements. You can modify the code according to your requirements. For example:

@AbapCatalog.sqlViewName: 'ZCUST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customer Extractor'
@Analytics.dataExtraction.enabled: true
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.delta.changeDataCapture.annotationVersion: 1

define view Z_Customer as select from kna1 as c
association [0..1] to I_Country as _Country on $projection.country_code = _Country.Country
{
  key c.mandt as client,
  key c.kunnr as customer,
  c.name1 as name,
  c.land1 as country_code,
  _Country.CountryName as country_name,
  c.region as region_code,
  c.ktokd as account_group,
  @Analytics.dataExtraction.delta.changeDataCapture: true
  cast(c.timestamp as abap.timestampl) as last_change_timestamp
}

@AbapCatalog.sqlViewName: 'ZCUST'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Customer Extractor'

@Analytics.dataExtraction.enabled: true

@Analytics.dataCategory: #DIMENSION

@Analytics.dataExtraction.delta.changeDataCapture.annotationVersion: 1

define view Z_Customer as select from kna1 as c

association [0..1] to I_Country as _Country on $projection.country_code = _Country.Country

{

key c.mandt as client,

key c.kunnr as customer,

c.name1 as name,

c.land1 as country_code,

_Country.CountryName as country_name,

c.region as region_code,

c.ktokd as account_group,

@Analytics.dataExtraction.delta.changeDataCapture: true

cast(c.timestamp as abap.timestampl) as last_change_timestamp

}

Save and activate your ABAP CDS view in your source system. In Eclipse IDE or ADT, right-click on your ABAP CDS view and select Activate. You can also use the keyboard shortcut Ctrl+F3 to activate your ABAP CDS view.
Create an ODP_CDS source system in your target system. In Eclipse IDE or ADT, open the BW Modeling perspective and expand the Data Sources folder. Right-click on the ODP_CDS folder and select New > ODP_CDS Source System. Enter a name and a description for your ODP_CDS source system and click on Next. In the Connection Settings screen, enter the connection details of your source system, such as host name, system number, client, user name, and password. Click on Test Connection to verify that the connection is successful and click on Finish.
Create a DataSource in your target system based on your ABAP CDS view. In Eclipse IDE or ADT, open the BW Modeling perspective and expand the Data Sources folder. Right-click on your ODP_CDS source system and select New > DataSource. Enter a name and a description for your DataSource and click on Next. In the Proposal from Operational Data Provider screen, select your ABAP CDS view from the list of available views and click on Finish.
Activate and test your DataSource in your target system. In Eclipse IDE or ADT, right-click on your DataSource and select Activate. You can also use the keyboard shortcut Ctrl+F3 to activate your DataSource. To test your DataSource, right-click on it and select Data Preview. You will see the data from your ABAP CDS view in a table format.
Create an InfoProvider in your target system based on your DataSource. In Eclipse IDE or ADT, open the BW Modeling perspective and expand the InfoProviders folder. Right-click on your InfoArea and select New > InfoProvider. Enter a name and a description for your InfoProvider and click on Next. In the Template Selection screen, select the type of InfoProvider that you want to create, such as Advanced DSO, CompositeProvider, or Open ODS View. Click on Finish.
Map and transfer the fields from your DataSource to your InfoProvider. In Eclipse IDE or ADT, open the editor window for your InfoProvider and switch to the Data Flow tab. Drag and drop your DataSource from the Data Sources folder to the data flow area of your InfoProvider. A transformation will be automatically created between your DataSource and your InfoProvider. Double-click on the transformation to open it in a new editor window. Switch to the Mapping tab and map the fields from your DataSource to your InfoProvider according to your requirements.
Save and activate your InfoProvider in your target system. In Eclipse IDE or ADT, right-click on your InfoProvider and select Activate. You can also use the keyboard shortcut Ctrl+F3 to activate your InfoProvider.
Create an InfoPackage in your target system to load data from your DataSource to your InfoProvider. In Eclipse IDE or ADT, open the BW Modeling perspective and expand the Data Flows folder. Right-click on your InfoProvider and select New > Data Transfer Process (DTP). Enter a name and a description for your DTP and click on Next. In the Extraction Settings screen, select Full Load or Delta Load as the extraction mode according to your requirements and click on Finish.
Execute and monitor your DTP in your target system to load data from your DataSource to your InfoProvider. In Eclipse IDE or ADT, right-click on your DTP and select Execute. You can also use the keyboard shortcut F8 to execute your DTP. To monitor your DTP, right-click on it and select Monitor. You will see the status and details of your data load in a new window.
You have now used ODP_CDS source system in SAP BW/4HANA to extract data from your ABAP CDS view in your source system to your InfoProvider in your target system.

Tips and Best Practices for ODP_CDS Source System

Here are some tips and best practices for using ODP_CDS source system in SAP BW/4HANA:

Before creating an ODP_CDS source system, check if there is already an ABAP CDS view available for your data source in your source system. You can use transaction SE16 in your source system and table name IXTRCTNENBLDVW to see a list of all ABAP CDS views that are enabled for data extraction. You can also use the SAP help documentation to find the ABAP CDS views for specific applications or scenarios.
To improve the performance of your ODP_CDS source system, you can use indexes, partitions, or compression techniques on your source tables or views. You can also use filters, parameters, or associations to reduce the data volume and complexity of your ABAP CDS view.
To ensure the data quality and integrity of your ODP_CDS source system, you can use transaction RSDRI_ODP_REPAIR in your target system to repair any inconsistencies or errors in the data extraction. You can also use transaction RSDRI_ODP_COMPARE in your target system to compare the data between source and target systems.
To avoid unnecessary replication of data, you can use filters, parameters, or associations to only extract the data that you need for your target system. You can also use transaction RSDRI_ODP_DELETE in your target system to delete the data that you no longer need from target system.

Conclusion

We hope this blog post has helped you understand how to use ODP_CDS source system in SAP BW/4HANA. If you have any questions or feedback, please feel free to leave a comment below.

This content is generated by AI.