Get Example source ABAP code based on a different SAP table
VERSION 5 IN • DEFINE TABLE FUNCTION ABAP_CDS_DDL_STATEMENT • IMPLEMENTED BY METHOD ABAP_CDS_DEFINE_TABFNC
ABAP_CDS_DDL - DEFINE TABLE FUNCTION
ABAP_SYNTAX $[@entity_annot1$] $[@entity_annot2$] ... $[@function_annot1$] $[@function_annot2$] ... $[DEFINE$] TABLE FUNCTION table_function $[parameter_list$] element_list IMPLEMENTED BY METHOD amdp_function $[;$]
What does it do? Defines a CDS entity table_function as a CDS table function in the CDS DDL. In platform-dependent SQL, the CDS table function is implemented in an AMDP method amdp_function, which is created using the AMDP framework in the database system as an AMDP table function. The name table_function must comply with the naming conventions for dictionary types and can have a maximum of 30 characters.
@entity_annot and @function_annot are used to specify optional annotations for the CDS table function.
parameter_list is used to declare a list of optional input parameters for the CDS table function. These also define the input parameters of the AMDP table function.
element_list is used to declare the elements of the CDS table function. These also define the columns of the tabular return value of the AMDP table function.
When amdp_function is used, an AMDP function implementation must be specified for an AMDP table function in the form amdp_class=>amdp_method. Here amdp_class is an AMDP class and amdp_method is an AMDP function implementation contained in this class. When this function implementation is declared, the current CDS table function is specified after the addition FOR TABLE FUNCTION. The AMDP function implementation must not exist when the CDS table function is created and activated. The name of an AMDP function implementation amdp_function can be specified in a single CDS table function only. A CDS table function returns a tabular result set. Like any CDS entity, it can be used as a data source in other CDS entities or AB-SQL read statements. The prerequisite for use is that the specified AMDP function implementation exists and is active. The name of a CDS table function is located in the namespace of all global types of an AS ABAP.
Latest notes:
If a CDS role is defined for a CDS entity using the CDS-DCL statement DEFINE ROLE, implicit access control applies by default when the CDS entity is accessed using AB-SQL . CDS access control can be switched off using the value #NOT_ALLOWED for the annotation @AccessControl.authorizationCheck and using the addition WITH PRIVILEGED ACCESS in the FROM clause of an AB-SQL query.
