Skip to Content
-2
May 08, 2020 at 11:29 AM

CDS View on mutiple tables

395 Views

@AbapCatalog.sqlViewName: 'Z_ESSR_ESLL_CDS' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'BI CDS View on ESSR and ESLL' @Analytics.dataExtraction.enabled: true @Analytics.dataCategory: #FACT define view Z_ESSR_ESLL as select from ekpo as ekpo left outer to one join esll as esll1 on esll1.packno = ekpo.packno left outer to one join esll as esll on esll.packno = esll1.sub_packno left outer to one join essr as essr on essr.ebeln = ekpo.ebeln and essr.ebelp = ekpo.ebelp // left outer to one join eskl as eskl on eskl.hpackno = essr.packno // and essr.kzabn = 'X' // left outer to one join esll as esll2 on esll2.packno = essr.packno // left outer to one join esll as esll3 on esll3.packno = esll2.sub_packno // and esll3.introw = esll2.introw // and esll3.extrow = esll2.extrow // left outer join ekkn as ekkn on ekkn.ebeln = ekpo.ebeln // and ekkn.ebelp = ekpo.ebelp // left outer to one join afvc as afvc on afvc.aufpl = ekkn.aufpl // and afvc.aplzl = ekkn.aplzl // left outer to one join prps as prps on prps.pspnr = ekkn.ps_psp_pnr { key ekpo.ebeln as ebeln, key ekpo.ebelp as ebelp, key essr.lblni as LBLNI, key esll.packno as PACKNO_ESLL, key esll.introw as INTROW, key esll.extrow as EXTROW, ekpo.loekz as loekz, ekpo.pstyp as pstyp, essr.ernam as ERNAM, essr.erdat as ERDAT, essr.aedat as AEDAT, essr.aenam as AENAM, essr.lbldt as LBLDT, essr.lwert as LWERT, essr.uwert as UWERT, essr.unplv as UNPLV, essr.waers as WAERS, essr.packno as PACKNO_ESSR, essr.txz01 as TXZ01, essr.ebeln as EBELN_ESSR, essr.ebelp as EBELP_ESSR, essr.loekz as loekz_essr, essr.final as final, essr.bldat as BLDAT, essr.budat as BUDAT, essr.xblnr as XBLNR, essr.bktxt as BKTXT, essr.knttp as KNTPP, essr.netwr as NETWR_ESSR, esll.del as DEL, esll.srvpos as SRVPOS, esll.sub_packno as SUB_PACKNO, @DefaultAggregation: #NONE @Semantics.quantity.unitOfMeasure: 'MEINS' esll.menge as MENGE, esll.meins as MEINS, esll.peinh as PEINH, esll.brtwr as BRTWR, esll.netwr as NETWR_ESLL, esll.ktext1 as KTEXT1, esll.pln_packno as PLN_PACKNO, esll.pln_introw as PLN_INTROW, @DefaultAggregation: #NONE @Semantics.quantity.unitOfMeasure: 'MEINS' esll.act_menge as ACT_MENGE, esll.act_wert as ACT_WERT // esll3.menge as ENT_MENGE, // esll3.meins as ENT_MEINS, // eskl.menge as ACC_MENGE, // eskl.netwr as ACC_NETWR // ekkn.nplnr as nplnr // prps.posid as posid, // afvc.vornr as VORNR } where ( ekpo.pstyp = '9' and ekpo.loekz = '' )

I want to build CDS View for Service entry sheet, i see with below code, the records are getting multipied.

Can we do something like move cooresponding fields in CDS View .