topic Re: HANA ABAP CDS input parameter in Application Development and Automation Discussions

HANA ABAP CDS input parameter

Former Member — Wed, 25 Jan 2017 07:27:11 GMT

When Trying to use CDS Views InputParameter

define view zinput_pa as select from zha400_cds_sb1 (carrid: 'AA')

{

carrid, customid

}

Error Message :Type Parameter carrid is not defined for entity

But In zha400_cds_sb1 CDS View field in availabe ,Could you please help me.

retired_member — Wed, 25 Jan 2017 07:52:03 GMT

"But In zha400_cds_sb1 CDS View field in availabe"

I don't understand this sentence.

Former Member — Wed, 25 Jan 2017 08:26:45 GMT

Yes Field is available

Fetching values from View zha400_cds_sb1 as a input Parameter carrid = 'AA'

retired_member — Wed, 25 Jan 2017 08:43:36 GMT

Is also a parameter available?

Former Member — Wed, 25 Jan 2017 10:34:31 GMT

Yes Available

retired_member — Wed, 25 Jan 2017 14:17:37 GMT

Can you show its definition?

Matt_Fraser — Wed, 25 Jan 2017 22:53:42 GMT

I've removed the "NetWeaver Application Server for ABAP" secondary tag, as that is for Basis/platform questions, not development.

Former Member — Fri, 21 Apr 2017 11:51:34 GMT

Can you share the view definition for zha400_cds_sb1?

It seem to me that you are mapping value to the column directly not input parameter.

Try the below code:

define view zha400_cds_sb1 with parameters ip_carrid:abap.char(3) { * }

define view zinput_pa as select from zha400_cds_sb1 (ip_carrid: 'AA')

{

carrid, customid

}

Sathya_Gunasekaran — Fri, 21 Apr 2017 13:19:21 GMT

Hi Raghavendra,

Does the view zha400_cds_sb1 have an input parameter with the name carrid?

It seems to me that the parameter carrid is missing in the other view.

It should have define view zha400_cds_sb1 with parameters carrid:datatype

Sathya