首页 > 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
本站为个人博客网站,全由我个人维护,我从事SAP开发13年,其它ERP开发7年,基本都是零售行业。本站记录工作学习的过程, 有SAP相关询问专、兼职工作可随时联系我。 有网站相关的问题可直接在文章下方留言,或者联系我。 邮件:yan252@163.com给我。 QQ:415402519

留下一个回复

你的email不会被公开。

6 + eight =