How to Write a Code to Create a Delta CDS Extractor in SAP S/4HANA

SAP S/4HANA is a next-generation ERP solution that can leverage the power of SAP HANA to provide fast and flexible business processes and analytics. But how can you extract data from your SAP S/4HANA system to your data warehouse or other target systems? One of the options is to use CDS (Core Data Services) extractors, a technology that allows you to define and expose data models using CDS views and annotations.

In this blog post, we will explain what CDS extractors are, how they work, and how you can write a code to create a delta CDS extractor in SAP S/4HANA. We will also share some tips and best practices for optimizing your CDS extractor performance and data quality.

What are CDS Extractors?

CDS extractors are a type of DataSources that enable data extraction from SAP S/4HANA using CDS views. CDS views are a core technology for data modeling in SAP S/4HANA. 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 CDS views.

CDS extractors use the Operational Data Provisioning (ODP) framework to expose the data from the CDS views to the target systems. 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.

CDS extractors have several benefits, such as:

They support various types of data, such as transactional data, master data, text data, or hierarchy data.
They support 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.
They are based on the same data models that are used for operational analytics and transactions in SAP S/4HANA, ensuring consistency and alignment of the data.
They are easy to create and maintain using Eclipse IDE or ABAP Development Tools (ADT), without requiring additional tools or coding.

How to Write a Code to Create a Delta CDS Extractor in SAP S/4HANA?

To write a code to create a delta CDS extractor in SAP S/4HANA, you need to have access to an SAP S/4HANA system via Eclipse IDE or ADT and the authorization to view and create ABAP development objects. You also need to have a basic knowledge of SQL syntax and CDS annotations.

To write a code to create a delta CDS extractor in SAP S/4HANA, follow these steps:

Open Eclipse IDE or ADT and connect to your SAP S/4HANA system.
In the Project Explorer view, right-click on your package and select New > Other > Core Data Services > Data Definition.
Enter a name and a description for your 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 CDS view with some predefined annotations and SQL statements. You can modify the code according to your requirements.
In the @AbapCatalog.sqlViewName annotation, enter a name for the ABAP DDIC view that will be generated from your CDS view. This is the name that will be used for data extraction.
In the @Analytics.dataExtraction.enabled annotation, enter true to enable your CDS view for data extraction.
In the @Analytics.dataCategory annotation, enter #FACT if your CDS view contains transactional data or #DIMENSION if your CDS view contains master data.
In the @Analytics.dataExtraction.delta.changeDataCapture.annotationVersion annotation, enter 1 if your CDS view supports delta extraction using change data capture (CDC) mechanism or 0 if your CDS view only supports full extraction.
In the define view statement, enter the name of your CDS view and specify the fields that you want to include in your CDS view. You can use aliases, expressions, aggregations, joins, unions, filters, parameters, or associations to define your fields.

The following is an example code for creating a delta CDS extractor for sales order item data:

@AbapCatalog.sqlViewName: 'ZSOITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order Item Extractor'
@Analytics.dataExtraction.enabled: true
@Analytics.dataCategory: #FACT
@Analytics.dataExtraction.delta.changeDataCapture.annotationVersion: 1

define view Z_Sales_Order_Item as select from vbap as soi
association [0..1] to I_Currency as _Currency on $projection.currency_code = _Currency.Currency
{
  key soi.mandt as client,
  key soi.vbeln as sales_order,
  key soi.posnr as sales_order_item,
  soi.matnr as material,
  soi.kwmeng as order_quantity,
  soi.vrkme as sales_unit,
  soi.netpr as net_price,
  soi.waerk as currency_code,
  _Currency.CurrencyName as currency_name,
  soi.netwr as net_value,
  soi.erdat as created_on,
  soi.ernam as created_by,
  @Analytics.dataExtraction.delta.changeDataCapture: true
  cast(soi.timestamp as abap.timestampl) as last_change_timestamp
}

@AbapCatalog.sqlViewName: 'ZSOITM'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Sales Order Item Extractor'

@Analytics.dataExtraction.enabled: true

@Analytics.dataCategory: #FACT

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

define view Z_Sales_Order_Item as select from vbap as soi

association [0..1] to I_Currency as _Currency on $projection.currency_code = _Currency.Currency

{

key soi.mandt as client,

key soi.vbeln as sales_order,

key soi.posnr as sales_order_item,

soi.matnr as material,

soi.kwmeng as order_quantity,

soi.vrkme as sales_unit,

soi.netpr as net_price,

soi.waerk as currency_code,

_Currency.CurrencyName as currency_name,

soi.netwr as net_value,

soi.erdat as created_on,

soi.ernam as created_by,

@Analytics.dataExtraction.delta.changeDataCapture: true

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

}

Save and activate your CDS view.

You have now written a code to create a delta CDS extractor in SAP S/4HANA. You can test your CDS extractor by using transaction RSDCUBE in your SAP S/4HANA system or by using the View Browser app in the SAP Fiori Launchpad. You can also use transaction RSDS in your SAP S/4HANA system to create or maintain a DataSource/ extractor based on your CDS view.

Tips and Best Practices for CDS Extractors

Here are some tips and best practices for creating and using CDS extractors in SAP S/4HANA:

Before creating a CDS extractor, check if there is already a standard CDS extractor available for your data source. You can use transaction SE16 in your SAP S/4HANA system and table name IXTRCTNENBLDVW to see a list of all CDS extractors that are enabled for data extraction. You can also use the SAP help documentation to find the CDS extractors for specific applications or scenarios.
To improve the performance of your CDS extractor, 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 CDS view.
To ensure the data quality and integrity of your CDS extractor, you can use transaction RSDRI_ODP_REPAIR in your SAP S/4HANA system to repair any inconsistencies or errors in the data extraction. You can also use transaction RSDRI_ODP_COMPARE in your SAP S/4HANA 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 SAP S/4HANA 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 write a code to create a delta CDS extractor in SAP S/4HANA. If you have any questions or feedback, please feel free to leave a comment below.

This content is generated by AI.