Numeric overflow for parameter/column (1) source type DECIMAL, target type DECIMAL, value 'unknown'

[NidhiDeep]

Hi ,

I am trying to get schedule work hours from pa007 and then getting the total work hours from CATSDB using HANA CDS Interface view .

selectfrom catsdb

left outer join aufk as orderText on(catsdb.raufnr = orderText.aufnr)

inner join pa0002 as name on(catsdb.pernr = name.pernr)

inner join pa0105 as uname on(catsdb.pernr = uname.pernr)

left outer join pa0007 as schHrs on (catsdb.pernr = schHrs.pernr )

In my consumption view , I am just exposing Schedule hours as a Measure

@EndUserText.label:'Work Schedule Hours'

@DefaultAggregation:#SUM

ZNBI_PROJECTTYPE.mostd as ScheduleHours,

But this gives me errorNumeric overflow for parameter/column (1) source type DECIMAL, target type DECIMAL, value 'unknown' . During design time though i am getting the data.

Please let me know if any of experts have got this error.

Regards

Deep

[gokul_jayaraman2]

Hi Deep,

I am facing a simillar issue. Can you please let me know how you fixed it ?

Thanks,

Gokul