Create a table function without using AMDP

 In SAP ABAP, you can create a CDS (Core Data Services) table function without using AMDP (ABAP Managed Database Procedures) by following these steps:

1. Open the ABAP Development Tools (ADT) or the SAP GUI ABAP Editor (SE38).

2. Create a new or select an existing ABAP package where you want to create the CDS table function.

3. Inside the ABAP package, create a new CDS view.

4. Define the CDS view as a table function by adding the @AccessControl annotation with the value #CHECK to the CDS view.

5. Define the input parameters and output structure of the table function. These parameters will determine the structure of the table to be returned.

6. In the CDS view definition, write the logic to populate the table.

Here's an example of a simple CDS table function that returns a list of material numbers and their descriptions:

abap
@AbapCatalog.sqlViewName: 'Z_MATERIALS_DESC'
@AccessControl #CHECK
define table function z_get_material_list
  with parameters
  @Environment.systemField: #CLIENT
  client : abap.clnt,
  @Environment.systemField: #LANGUAGE
  language : abap.lang,
  @DefaultLanguage: 'EN'
  @Search.defaultSearchElement: true
  @Consumption.valueHelpDefinition: 'Material'
  material : matnr
as select from mara as m
join makt as t on m.matnr = t.matnr
where t.spras = :language;

In this example, we define a CDS table function z_get_material_list with input parameters client, language, and material. The output structure will be determined by the fields selected in the SELECT statement.

After creating and activating the CDS table function, you can use it in ABAP CDS views or other CDS table functions. The CDS table function will return the list of material numbers and their descriptions based on the provided input parameters.