2019
08-27

How to use JOINS in ABAP CDS Views on HANA HOT

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 [crayon-68bef15c4e73879768781....Read More >
2019
08-27

Date Functions in ABAP CDS Views HOT

Date Functions in ABAP CDS Views 说明 本文介绍在CDS视图中使用日期相关功能的一些方法。CDS视图是功能强大的视图。如果您使用的是SAP S / 4HANA系统,那么CDS对于技术支持非常重要,日期的处理与在ABAP中一有定差异,以下作为一些参考。 DATE_IS_VALID 日期函数,DATE_IS_VALID,用于验证包含有效SAP日期格式“ YYYYMMDD ”的日期。如果日期采用有效的日期格式,则返回“ 1 ”,否则返回“ 0 ”。如....Read More >
2019
08-27

How to create SAP HANA SQL Synonym HOT

How to create SAP HANA SQL Synonym Hello everyone in this blog you will learn to create SAP HANA SQL synonym in SAP HANA. Lets get started. What is SAP HANA SQL Synonym SAP HANA SQL Synonym is an alternative name created for a table, view, procedure and sequence in SAP HANA. There ....Read More >