Best approach to get data from ECC/s4hana and merge with CAPm

[enric101]

Dear experts,

I have an API that gets a list of data in local ECC and merges this data with some tables in the cloud using CAPm in Java (foundry).

Both data (ECC and cloud) must apply filters from the sapui5 application.

As you can imagine, this approach is underperforming. We decided to create batch operations to get data from 100 to 100.

Could someone explain a better approach?

I think the data replication service exists in SCP, but in this case it is not possible to activate it 😞

Thanks in advance

Enric

[gregorw]

How many entities does the service from ECC return? How up-to-date does this entries have to be?

[enric101]

Hi Gregor,

In this case 1 entity from ECC. I need to get data from EKKO (using some filters) and then merge it with extra fields located in SCP (with some filters), this table in the SCP is considered as an extension of table in ECC. The key is the same in the both tables (ECC and SCP > EBELN) .

So, the UI5 application send some filters (selected by user). Then, we need to get a list of EBELN from the ECC (according with these filters for ECC fields) and the list of EBELN (according with filters from SCP fields). If this EBELN exist in both "list" the ui5 table show this row.

I hope I have explained it better now.

Thanks in advance.

Regards

Enric

[gregorw · Accepted solution]

Maybe srv/customer-material-service.js#L25 can be a starting point for you. Here I read data from the S/4HANA backend. Before I've enriced the filter to always restrict by customer. With the result you could read from the local table and then provide the merged result.