Posts

Showing posts from May, 2023

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/ ********************************************************************************

CDS View from using table ekko ekpo mara and makt adr6

 @AbapCatalog.sqlViewName: 'ZMY_CDS_VIEW' @AbapCatalog.compiler.compareFilter: true @EndUserText.label: 'My CDS View' define view ZMyCdsView 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,   i.ebelp,   h.bukrs,   i.matnr,   i.menge,   i.netpr,   m.mtart,   t.maktx,   a.smtp_addr } ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ ********************************************************************************