Create CDS Entity in system 2 based on table in system 1

[nagaraosunkara]

Hello All,

We are looking to create a CDS entity in system 2 based on data present in system 1. This entity in system 2 will be used by PaPM tool in system 1 for further processing, based on the following requirement:

In system 1, PaPM team are trying to build a solution, but the source data is present in system 2. Source data is too huge, and filters applied via PaPM in system 1 aren't working effectively. We are looking to create CDS entity in system 2, based on the filters maintained in system 1 (which is an ABAP table), so that PaPM can use the CDS created in system 2 as a source with less number of fields. 

We tried the following options, but they don't fit our requirement:

1. Custom entity and ABAP interface (Custom entity can't be used for data fetch and can be used for RAP framework only, so couldn't go further)

2. Entity with Virtual data elements (Entity doesn't reflect the values calculated via Virtual data elements, unless used in Odata/RAP, which doesn't meet our requirement.)

Is there any way to achieve this? 

I see one way is to create the filter table in system 2, and create CDS in system, but this requires efforts in building an Fiori app based on RAP framework (for user input), Odata (for excel upload) and UI5 coding.

Thanks & Regards,

Naga

[Marian_Zeis · Accepted solution]

A way would be using external views
https://community.sap.com/t5/technology-blogs-by-sap/cds-view-accessing-external-system-remotely-in-...

Another way Unmanaged RAP with Custom Views
https://software-heroes.com/en/blog/abap-rap-custom-entity-en

[nagaraosunkara · Accepted solution]

Hey Marian,

Thanks. We are looking at external views through virtual tables.

Regards,

Naga

[Oleg_Vokh]

Hi @nagaraosunkara 

You can try to solve your problem by creating a custom table(Database Table) in system 2, where the data will be populated by a job scheduling  (how to create you can find here) in system 2, that will perform the following logic:

1 Read data from system 1;
2 Populate the custom table(Database Table) in system 2;

Set the job to trigger at an interval, for example, every 1 minute.

After that, create an CDS based on the Database Table.

I hope this helps.

BR,
Oleg

[nagaraosunkara]

Hello @Oleg_Vokh,

I thought of this an option, but felt scheduling a job every min is something of an overkill.

As mentioned by other we are looking at using Virtual tables, which is bit easier.

Regards,

Naga