topic Re: CDS on 2 database table in Application Development and Automation Discussions

CDS on 2 database table

Former Member — Tue, 16 Jun 2020 03:03:37 GMT

Hi, I try to make project on abap development in eclipse that have 2 database table (A and B) that table A get foreign key from table B. When building CDS, i got confused because it is my first time not using /DMO/ and only based from database table.

This is my question:

1. On data defined as data model, what should i choose ? defined association or join?
2. On data defined as projection view, @Consumption.valueHelpDefinition: [{ entity: {} }], what should i define when i try to accessing the table B?
3. should i make entity for table B? i already defined the database table.

Thank you for your time and help.

Re: CDS on 2 database table

former_member1716 — Tue, 16 Jun 2020 05:24:33 GMT

pakpak,

Using Associations or Joins depends on the business scenario you are in, from what i see in your requirement it would suffice if you can use Joins in the CDS.

However understanding the CDS and types is very important before getting onto any coding, recommend you to go through the below links for better understanding and it should improve your knowledge base in CDS.

LINK1

LINK2

LINK3

Regards!

Re: CDS on 2 database table

Former Member — Tue, 16 Jun 2020 05:39:15 GMT

Thanks for your view ! i already find out the answer by myself. Create Entity with data definitions View.

Re: CDS on 2 database table

Former Member — Tue, 16 Jun 2020 05:40:34 GMT

Hi Satish Kumar !

Thank you for your answer. I really appreciate your link! I will study more ABAP development !