cds view with po parameters

@AbapCatalog.sqlViewName: 'ZMY_CDS_VIEW'

@AbapCatalog.compiler.compareFilter: true

@EndUserText.label: 'Rohini Kumar po'

define view ZMyCdsView with parameters p_erdat : aedat as select from ekko as h

inner join ekpo as i on h.ebeln = i.ebeln

inner join mara as m on i.matnr = m.matnr

inner join makt as t on m.matnr = t.matnr

left outer join adr6 as a on h.lifnr = a.addrnumber

{

h.ebeln,

h.aedat,

i.ebelp,

h.bukrs,

i.matnr,

i.menge,

i.netpr,

m.mtart,

t.maktx,

a.smtp_addr

}

where h.aedat = :p_erdat

********************************ROHINI KUMAR*********************************

Please support my work : sap.rohini988@gmail.com

LinkedIn Link : https://www.linkedin.com/in/rohini-kumar-14647a13a/

********************************************************************************

SAP ABAP