Posts

Showing posts from July, 2025

Interactive ALV report using ALV IDA

Image
Scenario: Create an interactive ALV report which will display Customer data, Sales data data upon double clicking customer number in Customer data ALV report. Approach:      I have initially created simple CDS views of KNA1 and VBAK tables. @AbapCatalog.sqlViewName: 'ZCDSVRKNA1' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'demo view kna1' @Metadata.ignorePropagatedAnnotations: true define view ZCDS_VR_KNA1 as select from kna1 { key kunnr as CUSTOMER_NO, land1 as COUNTRY, name1 as NAME, ort01 as CITY, erdat as CREATED_ON, ernam as CREATED_BY, lifnr as SUPPLIER } @AbapCatalog.sqlViewName: 'ZCDSVRVBAK' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'demo view vbak' @Metadata.ignorePropagatedAnnotations: true define view ZCDS_VR_VBAK as select from vbak { key vbeln as SALES_DOC, erdat as CREAT...