CDS View with input parameters Part 7 ABAP on HANA Course

ABAP CDS View with input parameters
Define a Parameterized view.
Call a parameterized view with open SQL.
ABAP CDS Views: Default values in parameters
@Environment parameter in sap
Code :-
saptechnomania...

[@CutieSaanvi2017]

Hi Ram, Could you please provide vendor who is providing Eclipse with Hana DB Server access. I do have one contact but they are not proving eclipse, instead they are proving Hana studio.

[@Sanobar-j4v]

Hello, Can you please help me with how I can write AND in where condition for Select Query for the example you are writing in where condition empid = 1 but I want it as empid = 1 and empid = 2 in where condition of select.. Thank you

[@Sanobar-j4v]

Can you please help as I need values from two different domains but the AND condition is not working

[@sree8652]

i created a simple CDS view entity ..i can see lot of entries in SE11 for the same table..in view only one entry is coming..what could be the reason

[@SAPTECHNOMANIAC]

Did you creates DCL, put Where condition ?

[@ansumanbehera8150]

Excellent knowledge share and information. Truly enlighten! A suggestion request for consideration: A video on Hierarchies creation would help a lot. Preferably say Cost Center or GL Account for example or any simple master data Hierarchy.

[@venu..8786]

Hi, Why cant we pass parameters to associated CDS view ex : cds a assication cds b(parameter) .. for cds b we cannot pass paraemters..could you please let us know why

[@SAPTECHNOMANIAC]

Yes you can't that is restriction when we are using cds . SAP not given this option

[@monojs_vlog]

Sir your video are very good learning material. I read them and get confidence to crack interview on SAP HANA.thank you very much

[@SAPTECHNOMANIAC]

All the best

[@CutieSaanvi2017]

Hi! Is it possible to use select options in CDS views? With parameter we can give only single value, if we want to get multiple values, how it can be handled?

[@SAPTECHNOMANIAC]

you have to call cds in your select and apply where condition in CDS not possible to add select option

[@im_shrey]

Hi brother, when I use @Environment.systemField : #USER_DATE in consumption view, the bex query with this consumption view doesn't show any date. Requirement is to get user timezone date not the system date as default value. Any suggestions on how to achieve this ?

[@SAPTECHNOMANIAC]

Ideally it should come .I didn't tried with BEX query..

[@Utubeuser16]

Hi bro, why I'm not able to use semantic.amount.currencycode in define view entity getting error as can't be used in filed list

[@SAPTECHNOMANIAC]

You are working with CDS entity or DDDIC CDS view

[@sandeshatram2158]

In above we are using vbap and vbak table field "MATNR" as parameters. but if client requirement is for two parameters such as MATNR and POSNR but the client condition is that they want to fetch data by any one of the parameter even they use MATNR or POSNR any one of the field,, then how it will occure as we required both parameters as non manditory then how it will be done..

[@SAPTECHNOMANIAC]

Where are you consuming your CDS ? If you are consuming in SQL then you can pass there where condition. It is not possible to pass non mandatory parameter apart of environment annotation parameter …

[@sandeshatram2158]

@@SAPTECHNOMANIAC 👍👍 got it sir

[@akshayakumar823]

Hi, is there a way we can get the field values from sales order (va01) tcode and use it inside cds view ?

[@SAPTECHNOMANIAC]

Sales order tcode fields will be available in vbak,vbap or other related table you can fetch from that table

[@abaper347]

🤟 Thank you for sharing information in simple & easy to understand way

[@SAPTECHNOMANIAC]

Good luck!

[@guptarahul97480]

Is there any way where i could write an query to an custom table or standard table using the table name received in parameters.

[@SAPTECHNOMANIAC]

Never tried. As per dynamic thing not possible in CDS

[@sundarpasayat8069]

suppose I don't want to make vbeln as mandatory in that case what shall we do ?

[@SAPTECHNOMANIAC]

This is the limitation when we are using parameter. it's not possible non mandatory parameter apart from some system fields ...

[@gururajanraghu5989]

Can we pass the default value for CDS View based OData service ?

[@SAPTECHNOMANIAC]

Check out :- C_SalesAnalyticsQry_1

[@bharathreddyk30]

Thank you

[@SAPTECHNOMANIAC]

Welcome

[@sandeepreddy2319]

Hi bro, Can you explain regarding about AMDP's

[@SAPTECHNOMANIAC]

Sure I will explain it in the upcoming video.

[@SAPTECHNOMANIAC]

AMDP in detail you can watch video series got completed :- kzbin.info/www/bejne/nJy4XntsnrqEjqs

[@bharathreddyk30]

Thank you

[@SAPTECHNOMANIAC]

Welcome!