Can we create a custom screen wherein user changes/controls the output displayed for a table?

[subhashinipt]

We want to create a table in Manage data with 5 to 6 fields. Practice Unit (PU) field combined with other fields such as location will give a different output.

For example, PU1 and USA --> Output1; PU1 and Australia --> Output2; PU2 and USA --> Output3.

We would like to refer all other fields based on Practice Unit and make changes to the output on table level in a single page/screen and allow user to change the output based on this requirement.

For instance, if I select practice1, I should able to see all the combinations associated with this PU as displayed below.

[FredericGirod]

You could do this using CDS, maybe also using simple view

[nlgro023]

Wouldn't a custom mdf object (with a child and parent object that is) with 4 fields suffice for this, or does your requirement or is there something we are missing?

[subhashinipt]

Could you give elaborate explanation as to how this child and parent object works or how to create this?

Out of 5 fields, four is already given. Last one is a Primary identifier, which can be a string or a numeric value.

[nlgro023]

In a blog that's quite challenging as it's basically an entire training.
There's however a blog and video, which is a more detailed combo than anyone can provide here in a comment:
- Create a custom MDF Object with multiple records | SAP Blogs
- https://www.google.nl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwiwtZ6D7sCDAx...

[subhashinipt]

Thanks for the KBAs, we have referred to the given KBA prior, but it did not suit our requirement as the external code data type is mapped to user. We require the external code to be a string/number as we would like to make changes on the object level. This screen will not be from the employee perspective. i.e, the data stored is not as per employee.

[nlgro023]

In essence that makes it easier, just ensure you skip the config UI part then and ensure the external code is not set as user but just as autogenerated code instead. You could take an object like department as an example on how that looks like on object level.