SAP SAC- ACDOCA Delta load

[v_sridhar9]

Dear Experts,

We are importing data from S/4 HANA to SAC from ACDOCA table using a custom CDS view. How to implement delta load from ACDOCA to SAC ? Is Delta possible or full load is the only option?

We are using a New model (measure) which doesn't support incremental load.

For Classic model (Account) ,incremental load is sufficient for delta capture?

Thanks

SV

[MKreitlein]

Hello SV,

regarding CDS Delta I would recomment these two blogs:

https://blogs.sap.com/2019/12/13/cds-based-data-extraction-part-i-overview/

https://blogs.sap.com/2019/12/16/cds-based-data-extraction-part-ii-delta-handling/

Regarding the SAC model question I'm not familiar with the new model, since I'm still using the old model.

There I would use a "pseudo-delta" and change the filter selection on the Fiscalyear/Period.

Since there is period closing in FI/CO there should be no more postings at a certain point in time.

BR, Martin

[v_sridhar9]

Hi Martin,

Thanks for the reply. The links you shared for delta mechanism only works for SAP BW. Let me know if I am missing something.

Regrding the "pseudo-delta" ,can we apply it on a day level instead of period since our users want to see the data up-to-date.

Thanks

SV

[MKreitlein]

Hello SV,

Hm... to be honest, I don't know but since CDS delta extraction e.g. into SAP datasphere can be observerd via "DHCDCMON - CDS-View-Replication monitor" in S4, I had assumed that this is also true for SAC... but, you definitely should test it.

I can only speak for the classic model, where you have the "update" mode... there you could always load the current period into the model, and new data is added, available data is overwritten. Again, I don't know if the new model works the same. In that way you don't need a selection on the day.

BR, Martin

[v_sridhar9]

Hi Martin,

New model doesn't support Incremental load. Only master data and classic model has this option.

Thanks

SV