如何用ABAP读取CDS view association的数据

AG3, view name Zorder_Sys_Status.
This view has an association named _statushelp:

Requirement

I would like to read the guid from host view Zorder_Sys_Status together with its associated data via association _statushelp.

(1) Since there is no existing data type which holds both host view field and associated view fields, you have to create one on your own:

(2) Use the following syntax in ABAP code:

DATA: lt_data TYPE tt_Data.

SELECT
   guid,
   \_STATUSHELP-STATUS_KEY AS STATUS_KEY ,
   \_STATUSHELP-STATUS_TEXT AS STATUS_TEXT
 FROM
  ZORDER_SYS_STATUS
 WHERE
  ZORDER_SYS_STATUS~GUID = 'FA163E8EAB031EE6A99F824537D112A4' AND ZORDER_SYS_STATUS~STAT = 'I1002' AND \_STATUSHELP-STATUS_KEY IS NOT NULL

  INTO TABLE @lt_data.

By the way, when the association defined in CDS view is consumed via OPEN SQL, it will be converted to LEFT OUTER JOIN, as could be observed in SQL trace:


In ST05, select your trace record, and click this button in toolbar:

要获取更多Jerry的原创文章,请关注公众号"汪子熙":

展开阅读全文
©️2020 CSDN 皮肤主题: 深蓝海洋 设计师: CSDN官方博客 返回首页
实付0元
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值