Odata service with a deep structure

[TimMuchena]

I want to expose an OData service with a deep structure as shown below. any ideas on how to go about it

Thank you

[former_member184867 · Accepted solution]

Looking at your structure i think a complex type would be an option .

Look for 'Details' complex type in

[Former Member]

For ContactPersons, if you are going to have a single contact person, you can create a 'complex type' structure and include that in main entity as contact persons. While creating entity, just F4-> select the new created complex type in 'Complex Type' column.

However, this cannot be applicable if you have multiple contact persons for single entity records.

In this case, if you have a key like ADRNR or CUSTOMER joining the two structures(entities), then create associations.

If you do not have a key linking these 2 entities, then you can do the following, create a blank key in each of the entities  and map it as key. This isn't the best and recommended approach as in 2nd entity you have to make sure that it's always filled dynamically with selected customer. (For example, you have 2 customer and in CONTACTPERSONS entity, you need to make sure only the selected customer data is filled). Through associations and navigations you can link then entire dependencies.

Thanks,

VS