SAP CDS ANA SCALAR FUNCTION

Get Example source ABAP code based on a different SAP table

VERSION 5 IN

ABAP_CDS - Analytical Scalar Functions
Analytical scalar functions are scalar functions that are evaluated by an analytical runtime environment.
They can be specified in the element list of analytical projection views .
Analytical scalar functions are delivered by SAP. They can only be defined and implemented internally by SAP. They are available for internal and external use in CDS analytical queries.

SAP-Delivered Analytical Scalar Functions
The following analytical scalar functions are delivered by SAP. They are released under the C1 contract for system-internal use.
ANALYTICAL_SCALAR_FUNCTIONS

ABAP_EXAMPLE_VX5
The following example demonstrates the use of an analytical scalar function provided by SAP.

The projected entity DEMO_CDS_CUBE_VIEW is a cube view.

The provider contract is set to ANALYTICAL_QUERY.

The analytical scalar function RATIO_OF is used in the element list to calculate the ratio of the final value of the field amount_sum compared to the original value. The final value subtracts a discount from the original value and adds taxes.
DDLS DEMO_CDS_USE_ANA_SCALAR
ABAP_EXAMPLE_END