CAPM - Performing CRUD operations on Views
Hi Experts.
Over the last few weeks I have been messing around with CAPM by building out a simple Doctor / Patient appointment booking scenario. Coming from a CRM background, my aim is to essentially test the Business Partner concept with CAPm whereby a person can take on multiple roles (i.e. a doctor can be a patient) and we need to normalise the data model do avoid replication of say Name, Surname etc.
In my scenario I have:
- a persons-model.cds file in the /db folder which i have normalised into {Business_Partner, Business_Role, Patient, Practitioner} where Patients have business role "02" and Practitioners have the role "01"
- a admin-service.cds file in the /srv folder which contains the Patient and Practitioner entities which are SELECTS across {Business_Partner, Business_Role, Patient} and {Business_ Partner, Business_Role, Practitioner} respectively
From what I understand (and what I observe from the database) is that the /srv Patient and Practitioner entities are generates as views. Consequently i am able to read Patients and Practitioners, but i am unable to perform Create, Updates or Delete operations.
What is the recommended approach form performing CRUD operations on entities that are views.
Any help will be appreciated