------------------------------------------------------------
CDS VIEW:
------------------------------------------------------------
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS - Inner Join'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity ZI_CDS_INNER_JOIN 
as select from LIKP               //Left
inner join LIPS                   //Right
on LIKP.VBELN = LIPS.VBELN        //Join Condition
{
    key likp.vbeln,
    key lips.posnr,
    likp.erdat,
    likp.lfart,
    lips.lfimg,
    @Semantics.amount.currencyCode: 'meins'
    lip.meins}
where likp.lfart = 'LF'