Give technical steps to create a CDS view with an example

1. Prerequisites

• SAP S/4HANA System: Access to an SAP S/4HANA system with the necessary authorizations to create and activate CDS views.
• ABAP Development Tools (ADT): An Eclipse-based development environment with the ABAP Development Tools plugin installed.

2. Create a New CDS View

• Open ADT: Launch ADT and connect to your S/4HANA system.
• Create Package: If you don't have an existing package, create a new one to store your CDS view (e.g., Z_MY_CDS_VIEWS).
• New Data Definition: In your package, right-click and select "New" -> "Other ABAP Repository Object" -> Search for "Data Definition" -> "Next".
• Basic Properties:
  • SQL View Name: Provide a technical name for your view (e.g., Z_MY_SALES_DATA).
  • Data Source: Select the primary data source (table or view) that your CDS view will be based on (e.g., VBAK for sales order headers).

3. Define the CDS View

• SELECT Statement: Write the SQL SELECT statement to specify the fields you want to include in your view.
• Data Source: Reference the data source you selected in the previous step.
• Fields: List the fields you want to include from the data source.
• JOINs (Optional): If you need data from multiple tables, use JOIN clauses to combine them.
• WHERE Clause (Optional): Add a WHERE clause to filter the data.
• Calculated Fields (Optional): Create calculated fields using expressions.
• Annotations (Optional): Add annotations to define metadata, associations, or UI behavior.

4. Activate the CDS View

• Save: Save your CDS view.
• Activate: Activate the CDS view to make it available for use.

Example: CDS View for Sales Order Data

@AbapCatalog.sqlViewName: 'Z_MY_SALES_DATA'  @AbapCatalog.compiler.compareFilter: true  @AbapCatalog.preserveKey: true  @AccessControl.authorizationCheck: #CHECK  @EndUserText.label: 'My Sales Data'  define view Z_My_Sales_Data as select from vbak   {   key vbeln as SalesOrder,    erdat as CreatedDate,    auart as OrderType,    kunnr as CustomerNumber,    netwr as NetValue  } where auart = 'OR'; // Example filter  

Explanation:

• @AbapCatalog.sqlViewName: Defines the technical name of the view.
• @AccessControl.authorizationCheck: Specifies authorization checks.
• @EndUserText.label: Provides a user-friendly label.
• define view: Starts the view definition.
• select from vbak: Specifies the data source.
• key vbeln: Defines the primary key field.
• vbeln as SalesOrder: Renames the field for better readability.
• where auart = 'OR': Filters the data to include only standard orders.

Key Considerations:

• Naming Conventions: Use meaningful names for your CDS views and fields.
• Performance: Optimize your CDS view for performance by minimizing joins and aggregations.
• Annotations: Explore the various annotations available to enhance your CDS view's functionality and usability.
• Testing: Always test your CDS view thoroughly to ensure it returns the expected data.

By following these steps and adapting the example to your specific requirements, you can create CDS views to efficiently model and expose data from your SAP S/4HANA system.

• https://blogs.sap.com/2018/12/24/cdsfiorielementadventures-cds-extension-not-getting-activated/