SAP CAP how to reuse existing tables rather creating new

[rajeshkumar_rajeshkumar]

HI All,

Can some one help me how can I use my existing SAP tables rather than creating new tables and loading data.

I would like build a REST service to fetch data from existing tables using CAP Node.JS.

Any examples are really appriciated

Thanks

[rajeshkumar_rajeshkumar]

I mean lets say I have custom existing table "ZCUSTOMERS"(or a BUT000) I would like to use these tables and build REST services in CAP .

Thanks in advance

[former_member631165 · Accepted solution]

Hi,

please check this page for help on modelling with existing databases:
https://cap.cloud.sap/docs/advanced/hana

You can also find more information in that documentation and samples of CDS projects.

BR

Samuel

[rajeshkumar_rajeshkumar · Accepted solution]

Thanks, thats a perfect for me to move on.

Thanks

Rajesh

[geert-janklaps]

Hi,

Assuming you're going to be working with an S/4 backend, you basically have two options.

• Use an Odata API to read the data (custom or standard odata api)
• Setup replication to a HANA Cloud DB and reuse the replicated data for displaying (e.g. using the replicate CDS views in S/4HANA Cloud)

Best regards,

Geert-Jan Klaps