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/

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