Skip to Content
Technical Articles
Author's profile photo Shanthi Bhaskar

S/4 HANA CDS View Search and related Fields Information

We used to spend lot of time in identifying the SAP delivered CDS view(s) or Existing CDS View(s) in the system before starting the development which is very important so that we don’t create duplicate objects and also we can utilize SAP delivered objects. Personally I felt the process was really painful and time taking.

As a Coding Savvy I could able to identify the tables which has all the Meta data information about the CDS view(s). So I had created a table function in S/4 HANA system which makes CDS search is easy. I am hoping that developers could able to leverage this code so that they could save lot of investigation time.

Below is the code for the table function and corresponding the AMDP Class. Only change which needs to done is to update the client number in the Class where I had mentioned as ‘000’ at line number 23.

 

Table Function Code

@EndUserText.label: 'table function for CDS Meta Data'
define table function ZT_CA_CDS_METADATA

returns
{
  Client      : mandt;
  SqlviewName : objectname;
  CDSView     : ddlname;
  CDSViewDesc : abap.char(60);
  FieldName   : fieldname;
  Position    : tabfdpos;
  DataElement : rollname;
  DataType    : datatype_d;
  Length      : ddleng;
  Decimals    : decimals;
}
implemented by method
  ZCL_CDS_META=>GET_CDS_META

Code for the Class

class zcl_cds_meta definition
  public
  final
  create public .

  public section.
    interfaces: if_amdp_marker_hdb.
    class-methods: GET_CDS_META for table function ZT_CA_CDS_METADATA.
  protected section.
  private section.
endclass.



class zcl_cds_meta implementation.
  method GET_CDS_META by database function
                       for hdb
                       language sqlscript
                       options read-only
                       using RSODPABAPCDSVIEW DD25T DD03L.

i_sqlview = SELECT
            '000' as CLIENT,
            RSODPABAPCDSVIEW.SQLVIEWNAME,
            RSODPABAPCDSVIEW.DDLNAME,
            DD25T.DDTEXT
            FROM RSODPABAPCDSVIEW
            INNER JOIN DD25T AS DD25T
            ON DD25T.VIEWNAME= RSODPABAPCDSVIEW.SQLVIEWNAME;

return      select
            sqlview.client,
            sqlview.SqlviewName,
            sqlview.DdlName as CdsView ,
            sqlview.ddtext  as CdsViewDesc,
            DD03L.Fieldname,
            DD03L.Position,
            DD03L.rollname as DataElement,
            DD03L.Datatype,
            DD03L.leng as Length,
            DD03L.Decimals
            from :i_sqlview as sqlview
            left outer join DD03L as DD03L
        on   DD03L.tabname = sqlview.sqlviewName;

  endmethod.

endclass.

Get the Data through Data Preview option or through writing SQL as displayed below

Open the image in a new window for clearer picture.

 

 

or you can modify the SQL query for getting the CDS views which has Billing in the CDS name

 

 

For Instance if you want to see all the CDS views which has name General Ledger

This Table Function can answer below questions

  1. Search for CDS view(s) by using the CDS View description.
  2. Get the Data Base View name of the CDS View(s).
  3. Get the Field names of the CDS view(s).
  4. Get the Data Type, Data Element and Length of Fields in the CDS View(s)

 

Hope this blog gives good sense and makes your development easy in order to identify the CDS views which was delivered by SAP and also you can reuse the CDS which were already built by other colleagues.

 

Please let me know if any suggestions and questions.

 

Regards,

Shanthi

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Syambabu Allu
      Syambabu Allu

      Hi Shanthi,

      Helpful blog and information.Thanks for sharing.

      Thank you,

      Syam

      Author's profile photo Nivardo Edwin Tahua Quijano
      Nivardo Edwin Tahua Quijano

      Hi Shanthi, very useful, thank for sharing!!!

      Regards,

      Edwin

      Author's profile photo Niranjana Vignesh
      Niranjana Vignesh

      Hi,

      The standard table that stores all the CDS views created in a system isĀ RSODPABAPCDSVIEW. Similarly, can you provide the table names that stores the BOPF and Odata services details that is created from the respective CDS view.

      Regards,

      Niranjana.

      Author's profile photo Mayank Jaiswal
      Mayank Jaiswal

      Hi Shanthi,

      Thanks for sharing this information.

      Here we are getting the data element information from the DD03L table, is there anyway by which we can get the exact field name of the table.

      Best Regards,

      Mayank