Skip to Content
0
Jun 03, 2020 at 04:18 PM

Multiple tables Insert with Primary-foreign key relation in single post

552 Views

Hi Experts,

We have a HANA database which has 2 tables with foreign key relationship between them (Like header and Item).
In another HANA XSA system we are developing an application using Cloud Application Programming model and using the same HANA database as a tenant database. In our cds file we are adding these two tables as entities with '@cds.persistence.exists'
In normal scenario we use association or composition in 2 tables and do multi table insert using deep insert.
but since these two tables does not have association/composition relation, is it possible to achieve deep insert. If yes, could you please guide us.


Thanks & Regards,
Soundarya