Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

CDS views with ABAP : 'The Parameter is not bound' error while activating ABAP program .

0 Kudos
8,668

Hello Experts,

I am working on an optimization task for CDS views by parameterization. I just created a new parameter XX for a CDS view 'with parameter' statement and used it in the where clause. CDS view is successfully activated and trying to consume it in the ABAP program.

I am getting an error 'The Parameter XX is not bound' while activating ABAP program with CDS views , though I have added the new parameter in CDS view

Requesting your kind help on this.

Kind Regards, SP

1 ACCEPTED SOLUTION

retired_member
Product and Topic Expert
Product and Topic Expert
5,753

You must pass values for the parameters when using the CDS view in ABAP SQL with the following syntax:

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abenabap_sql_paramete...

BR

Horst

9 REPLIES 9

LaurensDeprost
Contributor
5,753

Can you share code snippets with (parts of) the CDS and the program you're trying to activate?

0 Kudos
5,753

Hello dep

Below is the snapshot of CDS view and the view consuming program am trying to activate. I have added a new parameter P_INVDOC and trying to consume it in a program. Ended up with an error while activating the program. Please help.

Kind Regards, SP

retired_member
Product and Topic Expert
Product and Topic Expert
5,754

You must pass values for the parameters when using the CDS view in ABAP SQL with the following syntax:

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abenabap_sql_paramete...

BR

Horst

0 Kudos
5,753

Thanks a ton!

0 Kudos
5,753

Thanks! But unfortunately this link is not available anymore. Could you help me with another one?

0 Kudos
5,753

The link is corrected.

0 Kudos
5,753

Dear Team,

How can i pass select options (S_INV) while consuming CDS views in abap progrms with new open sql statements.

Kind Regards,

Sharda

0 Kudos
5,753

select-options , For all Entries etc in abap progrms for CDS views

Sai_achyuth
Newcomer
0 Kudos
5,104

mines also a similar issue

i have created a cds view with parameter material , now i am using sap standard program to extract data from cds , i.e  RODPS_REPL_TEST(standard program name) , now when i am inserting the cds view name and executing it , i am getting the error saying 

error while accessing data:
the parser produced the error: the parameter "MATERIAL" was not bound.

 

any solution??