List report with filters and logic

[JJ09]

Hello all,

I have the following requirement:

I have a three databases named "Box", "Devices" and "Device type". Here is the relationship between them:

- A box consists of many devices and a device belongs to none or one box.

- A device always belongs to a device type and a device type always has one to many devices.

- The devices and device types are already created/existing before a new box can be created.

Now I have created an app in which I can display the boxes in a list report and the relationship to the devices exists. The relationship between the devices and the device types is also already there.

In the next step I would like to have the possibility to choose from the already existing devices when creating a new box. It would be ideal here if I could divide the devices into their device types. In addition, a check is desired in which it is checked that a device of each device type is present in a box.

My schema.cds:

My app currently:

- List report of boxes:

- When creating a new box with devices

I would be grateful for any help or tip.

Thanks

Jasmin

[gregorw]

Please check the annotations in https://github.com/SAP-samples/cap-sflight that allow to set the booking Status using a drop down:

[JJ09]

Hello Gregor,

thank you for the hint!

All the best

Jasmin