首页 > SAP > HANA > How to use JOINS in ABAP CDS Views on HANA
2019
08-27

How to use JOINS in ABAP CDS Views on HANA

Selects all entries which exists in both tables which meet ON condition. Below is the sample ABAP CDS views in which INNER JOIN is used among 3 tables to get the so_id, so_item_pos, product_id, amount and  currency_code. Copy and paste the below code into DDL source

Selects all records from the right table matching with the left table which meet ON condition. If no record found in left table those record fields are null.

最后编辑:
作者:yangsen
有需要可在文章留言或者邮件yan252@163.com给我。

留下一个回复

你的email不会被公开。

3 + 16 =