What is table function in cds. Practical example when it was used

Question

Accepted Answer

Table function in CDS is a reusable database function that can be used to define complex logic and calculations.

Table function is defined in CDS (Core Data Services) using the @EndUserFunction annotation.
It allows you to define complex logic and calculations that can be used in CDS views or ABAP programs.
Table functions can have input parameters and return a table of data as the result.
They can be used to perform data transformations, aggregations, filtering, and more.
A practical example of using a table function is to calculate the total sales amount for each customer based on their sales orders.

Accepted Answer

In the context of SAP's Core Data Services (CDS), a table function is a type of CDS artifact that allows you to define a reusable table-valued function in your database. It provides a way to encapsulate a query logic into a function that can be called from other CDS artifacts, such as views or other table functions.

A table function takes input parameters and produces a table as output. The input parameters can be simple scalar values or structured types, such as table types or table types with a single row. The output table can have any number of columns, and the column types can be any data type that is supported by CDS.

Here's a simple example of a table function in CDS:

define table function get_employee_data

with parameters

p_employee_id : integer

returns {

employee_id : integer;

first_name : string(50);

last_name : string(50);

salary : decimal(10,2);

}

as select from employees

where employee_id = :p_employee_id;

In this example, the get_employee_data table function takes an input parameter p_employee_id and returns a table with four columns: employee_id, first_name, last_name, and salary. The function queries the employees table to retrieve the data for a specific employee, based on the input parameter.

Table functions can be used in a variety of scenarios, such as:

As a building block for more complex views or table functions.
To encapsulate common query logic and promote reuse across different CDS artifacts.
To provide a convenient way to return data from a CDS service to a client application.

What is table function in cds. Practical example when it was used

Top TCS SAP Abap Technical Consultant interview questions & answers

Popular interview questions of SAP Abap Technical Consultant

Top HR questions asked in TCS SAP Abap Technical Consultant