CDS - Filter List Reports by Child Entity Fields

-

👋 Hello Everyone!

Filter List Reports by Child Entity Fields

Have you ever wanted to filter a list report based on a field from a child entity? For example, filtering travel records by the AirlineID from the associated _Booking entity?

You can achieve this by adding the following annotation to the root CDS view metadata extension (e.g., Travel): 

@UI.selectionField: [{ element: '_Booking.AirlineID', position: 50 }]
_Booking;

🎥 Demo: Filtering by Child Entity Field (OData V4)

I tested this in the BTP ABAP Environment, and it works perfectly — but only with OData V4.

Comments

  1. Rate2 December 2025 at 20:54

    My problem is that I need two fields from the same child entity, but you can’t reference the entity twice. How would you handle that?

    ReplyDelete
    Replies
    1. Bharathi Sakthivel3 December 2025 at 21:47

      Hi, You can define your fields like this.
      @UI.selectionField: [{ element: '_entity.field1', position: 10 },
      { element: '_entity.field2', position: 20 }]
      _entity;

      Delete

Post a Comment

Popular posts from this blog

Fiori URL Generation and Navigation Using CL_LSAPI_MANAGER

-
Hello Everyone!👋 Fiori URL Generation and Navigation Using CL_LSAPI_MANAGER CL_LSAPI_MANAGER - This class allows you to easily generate SAP Fiori Launchpad URLs or trigger intent-based navigation. You’ll find it useful when you need to: Launch Fiori apps from the SAP GUI Generate dynamic Fiori URLs using semantic objects, actions, and parameters Share specific Fiori app links via email Navigate directly to transactions, and more DATA(lo_lsapi) = cl_lsapi_manager=>get_instance( ). " Generate URL to launch a Fiori app DATA(lv_flp_app_url) = cl_lsapi_manager=>create_flp_url( object = 'MaintenanceObject' " Semantic Object action = 'listFunctionalLocStructure' " Action system_alias = 'LOCAL' " SM59 Alias for FES parameters = VALUE #( name = 'DY_TPLNR' value = '0001' ) ). " Generate URL to launch a tran...
Read more

RAP - Real Time UI Updates Using Event-Driven Side Effects

-
Hello Everyone! 👋 Real-Time UI Updates in RAP Using Event-Driven Side Effects We've all come across situations where something changes in the backend, and we want those updates to automatically reflect in the UI without manually refreshing the page. In traditional setups, we used ABAP Channels for this but how can we achieve the same in RAP? Here's a simple example: I'm updating the travel status in one class/report, while the app is open in parallel. As soon as the status is updated in the backend, it automatically reflects in the UI no refresh needed! This is made possible through Event-Driven Side Effects . This is useful when: Background jobs update data We want to notify users with messages in real time Multiple users are working on the same data simultaneously Step 1 – Add the event-driven side effects in the BDEF managed with additional save .... .. define behavior for YR_YABS_TRAVEL...
Read more

ABAP - Create CSV Files Easily Using CL_CSV_FACTORY

-
Hello Everyone! 👋 Create CSV Files Easily in ABAP Using CL_CSV_FACTORY In many scenarios, we need to download internal table data in CSV format. Often, the requirements vary for example, using different field separators such as semicolon (;), comma (,). Additionally, we may need to include a header row and format fields like date, time, or timestamp. All of this can be handled very easily using the CL_CSV_FACTORY class. The best part is that this class is also available in the SAP Public Cloud. Step 1 – Select the Data SELECT FROM vbak FIELDS vbeln, vbtyp, erdat INTO TABLE @DATA(lt_test) UP TO 10 ROWS. Step 2 – Create a Simple CSV with Header This example generates a CSV using a semicolon as the delimiter and includes the header row automatically. DATA(lv_xstring_v1) = cl_csv_factory=>new_writer( )->set_delimiter( ';' )->set_write_header( abap_tr...
Read more