Issues with CDS View Entity

[Vasu_Sac]

Hello, 

I am trying to create below CDS view entity, but getting error at lbkum field. This is due to reference information missing for unit of measure. 

Its allowing , If I create CDS view with same code but iF I want to create CDS View Entity, the code is failing. Please help how to fix the issue.

//@AbapCatalog.sqlViewName: 'ZTESTMBEW10'

//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Material DATA'

@VDM.viewType: #CONSUMPTION

define view entity ZTEST_MBEW_10

as select from Mbv_Mbew as A1

left outer join marc as A2

on A1.matnr = A2.matnr

and A1.bwkey = A2.werks

{

A1.matnr,

A1.bwkey,

A1.lbkum,

A2.prctr

}

Regards,

Vasu

[Vasu_Sac]

Hi @junwu,

Thank you. Now its working.

I thought LBKUMUNIT declaration belongs to A3.MEINS, so I am keeping the semantic statement above A3.MEINS and its not working.

[junwu]

if it is asking for uom, why not just give it?

[Vasu_Sac]

Hi @junwu

The uom field is not available in this CDS view tables, it is available in table (MARA-MEINS) and tried to join and getting same issue.

define view entity ZTEST_MBEW_10
as select from Mbv_Mbew as A1
left outer join marc as A2
on A1.matnr = A2.matnr
and A1.bwkey = A2.werks

inner join mara as A3 //Unit of Measure > Meins
on A3.matnr = A1.matnr

{
A1.matnr,
A1.bwkey,
//@Semantics.unitOfMeasure: true
@Semantics.quantity.unitOfMeasure: 'LBKUMUnit'
@DefaultAggregation: #SUM
A3.meins as LBKUMUnit,
A1.lbkum,
A2.prctr
}

[junwu]

@Semantics.quantity.unitOfMeasure: 'LBKUMUnit' A1.lbkum,