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