Fetching purchase document header data and item data with CDS view with parameters

Below code help you to fething records with two table header and item data

@AbapCatalog.sqlViewName: 'zekko_ekpo1'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'CDS View with parameters'

define view ZEKKO_EKPO

    with parameters p_ebeln_low :ebeln,

                    p_ebeln_high:ebeln

as select from ekko

           join ekpo on ekko.ebeln = ekpo.ebeln {

          

           ekko.ebeln as purachsing_docu,

           ekko.ebeln,

           ekko.ernam,

           ekpo.ebelp,

           ekpo.aedat,

           ekpo.meins

           }

           where ekko.ebeln = :p_ebeln_low or ekko.ebeln between :p_ebeln_low

                                                       and :p_ebeln_high;