BW Extractor to CDS View Migration Guide
Complete guide to migrating SAP BW extractors to CDS View-based extraction in S/4HANA, including extractor-to-CDS mappings by module and key SAP Notes.
Why Replace BW Extractors with CDS Views?
Classic BW extractors (DataSources like 2LIS_*, 0FI_*, 0CO_*) rely on extraction structures, function modules, and delta queues that were designed for the ECC data model. With S/4HANA's simplified tables (ACDOCA, MATDOC, etc.), many of these extractors either no longer work correctly or produce incomplete data.
SAP's strategic direction is CDS-based extraction: CDS Views annotated with @Analytics.dataExtraction.enabled: true serve as modern DataSources for BW/4HANA and SAP Datasphere.
How CDS-Based Extraction Works
A CDS View becomes a BW-compatible DataSource when it carries these annotations:
@Analytics.dataCategory: #FACT
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.automatic: true
define view I_JournalEntryItemCube as select from acdoca {
...
}@Analytics.dataExtraction.enabled: true— Registers the view as an extractable DataSource@Analytics.dataExtraction.delta.changeDataCapture— Enables delta extraction (change logs)@Analytics.dataCategory: #FACT— Marks the view as a fact table for analytical processing
In BW/4HANA, you connect to the S/4HANA system and can directly browse CDS extraction views as DataSources.
Extractor-to-CDS Mapping by Module
Finance (FI)
| Classic Extractor | Description | CDS Replacement View |
|---|---|---|
| 0FI_GL_14 | G/L Line Items | I_JournalEntryItemCube |
| 0FI_AP_4 | Vendor Line Items | I_JournalEntryItemCube |
| 0FI_AR_4 | Customer Line Items | I_JournalEntryItemCube |
| 0FI_AA_004 | Asset Transactions | I_JournalEntryItemCube |
Controlling (CO)
| Classic Extractor | Description | CDS Replacement View |
|---|---|---|
| 0CO_OM_CCA_9 | Cost Center Costs | I_JournalEntryItemCube |
| 0CO_OM_OPA_6 | Internal Order Costs | I_JournalEntryItemCube |
| 0CO_PC_ACT_05 | Product Cost Actuals | I_JournalEntryItemCube |
Materials Management / Inventory (MM)
| Classic Extractor | Description | CDS Replacement View |
|---|---|---|
| 2LIS_03_BF | Goods Movements | I_MaterialDocumentItemCube |
| 2LIS_03_BX | Stock Initialization | I_StockInitialLoadCube |
| 2LIS_03_UM | Revaluations | I_StockRevaluationCube |
Sales (SD)
| Classic Extractor | Description | CDS Replacement View |
|---|---|---|
| 2LIS_11_VAITM | Sales Order Items | I_SalesDocumentItemCube |
| 2LIS_11_VAHDR | Sales Order Header | I_SalesDocumentCube |
| 2LIS_12_VCITM | Billing Items | I_BillingDocumentItemCube |
| 2LIS_13_VDITM | Delivery Items | I_DeliveryDocumentItemCube |
Purchasing
| Classic Extractor | Description | CDS Replacement View |
|---|---|---|
| 2LIS_02_ITM | Purchase Order Items | I_PurchaseOrderItemCube |
| 2LIS_02_HDR | Purchase Order Header | I_PurchaseOrderCube |
Key SAP Notes
- SAP Note 2521196 — Overview of CDS-based extraction in S/4HANA (master note)
- SAP Note 2367672 — CDS views for finance (FI/CO) extraction
- SAP Note 2521328 — CDS views for logistics (MM/SD) extraction
- SAP Note 2550084 — Enabling CDS extraction for BW/4HANA
- SAP Note 2574543 — Delta extraction setup for CDS views
Migration Steps
- Identify active extractors — List all DataSources used in your BW system (transaction RSA5/RSA6)
- Find CDS replacements — Use the mapping tables above or browse the Extractor Map on CDSee
- Test extraction — In BW/4HANA, create a DataSource from the CDS View and run a test extraction
- Delta validation — Verify that delta extraction captures all changes correctly
- Cutover — Switch from classic extractors to CDS DataSources in production