Skip to Content
0

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

Mar 28, 2017 at 04:25 AM

501

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 21, 2017 at 07:53 PM
0

Hi Deep,

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

Thanks,

Gokul

Share
10 |10000 characters needed characters left characters exceeded
Anurag Bajaj
Feb 09 at 01:48 PM
0

Hello Gokul,

You need to type cast the output to decimal instead of 1 as int.

cast(cast( 1 as abap.dec ) as <domain name here which is of decimal type>)

Regards,

Anurag.

Share
10 |10000 characters needed characters left characters exceeded