Skip to Content
0
Aug 29, 2023 at 12:15 PM

SAP Datasphere: I_CustSalesPartnerFunc CDC enabled but not working - Why?

181 Views Last edit Aug 29, 2023 at 12:16 PM 2 rev

Dear CDS View and SAP Datasphere experts,

I've got one more tricky question regarding to data extraction from S4 into SAP Datasphere.

I wanted to use CDS View: I_CustSalesPartnerFunc (ICUSTPARTNERFUNC), which is supposed to have delta extraction:

@AbapCatalog.sqlViewName: 'ICUSTPARTNERFUNC'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture: {
      automatic: true
    }
  }
}<br>

When trying to trigger it from SAP Datasphere, this message is displayed in SLG1:

tables-cannot-be-determined.png

I tried to find notes for this error message number, but without success.

When I tried to check that via the RODPS_REPL_TEST program from (DHCDCMON - CDS-View-Replikationsmonitor) this message is displayed:

source-does-not-support-delta.png

My developer colleague tried to debug it, and while comparing it with another CDS View, which can provide delta, she found out the following:

debug1.png

debug2.png

Here the last line is missing for CDS View: I_CustSalesPartnerFunc ... she gave up with that...

Who can explain the reason for that? Where are those entries stored? Why does CDC not work here?

Thanks, Martin

Attachments

debug1.png (31.6 kB)
debug2.png (30.8 kB)