Graphical calculation views in SAP HANA are designed to model data flows based on tabular data sets. A data source node in a graphical calculation view must provide a structured, tabular result.

- Table Function: A table function is a user-defined function that returns its result as a table. This makes it a valid and powerful data source, allowing complex procedural logic to be encapsulated and used within a graphical model.

- Row Table: SAP HANA supports both row-store and column-store tables. Both types can be used as fundamental data sources in a calculation view. The graphical modeler allows the inclusion of any table from the catalog, irrespective of its underlying storage type.

B. Procedure: A procedure is a unit of procedural logic that is called for execution and does not return a table directly in a way that can be consumed as a data source node in a graphical flow.

D. Scalar function: A scalar function returns a single value, not a table. While it can be used within expressions (e.g., for a calculated column), it cannot serve as a primary data source node.

1. SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Business Application Studio:

Section: "Add Data Sources to the Calculation View"

Content: This section explicitly lists the objects that can be used as data sources. It states

"You can add data sources such as tables

views

calculation views

and table functions to the calculation view editor." This directly supports options A (Table function) and C (Row table

as it is a type of table).

Reference: SAP Help Portal

SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Business Application Studio

"Calculation Views" -> "Model Data" -> "Add Data Sources to the Calculation View".

2. SAP HANA SQLScript Reference:

Section: "User-Defined Functions"

Content: This guide differentiates between table functions and scalar functions. It defines a table function as returning a value of type table (RETURNS TABLE (...)) and a scalar function as returning a single scalar value (RETURNS ). This distinction clarifies why a table function is a valid data source (it provides a table) while a scalar function is not.

Reference: SAP Help Portal

SAP HANA SQLScript Reference

"User-Defined Functions".