Show TOC

Version ADT 2.51Locate this document in the navigation structure

Here is an overview of the most significant changes in the context of CDS view building tools that relate to the:

  • Back end: SAP NetWeaver Release 7.50 SP00
  • Client: ABAP Development Tools (ADT) 2.51
Editor Support for TABLE FUNCTIONS in DDL Editor

Example:

Sample Code 
@ClientDependent: true
 
define table function GET_SCARR_SPFLI 
  with parameters @Environment.systemField: #CLIENT 
                  clnt:abap.clnt, 
                  carrid:s_carr_id 
  returns { client:s_mandt;   
            carrname:s_carrname; 
            connid:s_conn_id; 
            cityfrom:s_from_cit; 
            cityto:s_to_city; } 
  implemented by method 
    CL_DEMO_AMDP_FUNCTIONS=>GET_SCARR_SPFLI_FOR_CDS;

Tool Support

The DDL editor provides support for:

  • Opening an object ( CTRL + SHIFT + A) for table functions
  • Defininig table functions with parameters by the help of a creation template
  • Code completion for
    • Keywords
    • Annotations
    • Data types in parameter definitions and in field definitions (both built-in and DDIC types)
    • Name of the implementing class/implementing method
  • Navigation to (F3)
    • Implementing class
    • Implementing method
    • DDIC types used in field/parameter definitions
  • Navigation from implementing class (definition part to table function)
  • Element info for
    • Table functions (triggered with F2 in the DDL source itself, not in the ABAP class)
    • DDIC types used in field/parameter definitions

  • Integration in the Outline view.
Editor support for enhanced EXTEND VIEW features

Starting with SAP NetWeaver 7.50, you have the option to extend views in ABAP CDS.

Example:

Sample Code 
 @AbapCatalog.sqlViewAppendName: 'DEMO_CDS_EXTENS' 
extend view demo_cds_original_view with demo_cds_view_extension 
  { spfli.distance, 
    spfli.distid as unit };

Tool Support

The DDL editor provides support for:

  • EXTEND VIEW with the help of a creation template
  • Code completion for
    • Associations defined in the base view (public and private associations)
    • Associations defined in EXTEND VIEV
  • Including associations of the base view when triggering Insert all elements in the code completion in the EXTEND VIEW
  • Navigation from the usage of the association in the EXTEND VIEW to its definition in the base view (CTRL + click) or its target (CTRL + click )
  • Displaying the associations that have been added in the EXTEND VIEW in the element info of the base view.

Viewing SQL Statements

For each CDS entity that is defined in the DDL editor, you now have the option to view the SQL CREATE statement generated at database level.

For more information, look here:

Defining ON Conditions

You can now apply a wizard for defining ON conditions in JOIN clauses and ASSOCIATION definitions of your CDS view definition.

For more information, look here:

Dependency Analyzer

When implementing the view on view pattern, the relations between the resulting data sources can become very complex. The Dependency Analyzer aims to give the CDS developer a better overview of the complexity of the SQL behavior so that this complexity might be reduced and/or superfluous JOINs might be found.

For more information, look here: