Creating Variables in CDS Views and input parameter types

[IM_TSL]

I was trying to create a CDS View to use it in Analysis for Office. Here are a few problems that I'm facing:

1. I need to declare a dynamic variable that changes based on the input and that has to be used in a joining condition. I could not find a way to define a variable to I used the concat function directly to pass the value. But this approach is not working and the column data in the excel is replaced with asterisks. Could you suggest me a way?

2. I need to have parameters that will take interval input or multiple lines of input (like in SE38 Reports) and pass a range of input in parameters. Any leads on how to get that done?

Thank you in advance!

#ABAP #CDSViews #CDS #ABAPCDS 

[IM_TSL]

I was trying to create a CDS View to use it in Analysis for Office. Here are a few problems that I'm facing:

1. I need to declare a dynamic variable that changes based on the input and that has to be used in a joining condition. I could not find a way to define a variable to I used the concat function directly to pass the value. But this approach is not working and the column data in the excel is replaced with asterisks. Could you suggest me a way?

2. I need to have parameters that will take interval input or multiple lines of input (like in SE38 Reports) and pass a range of input in parameters. Any leads on how to get that done?

Thank you in advance!

#ABAP #CDSViews #CDS #ABAPCDS