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.
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.
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
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?
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
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..
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 …
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 ?
🤟 Thank you for sharing information in simple & easy to understand way
Good luck!
Sir your video are very good learning material. I read them and get confidence to crack interview on SAP HANA.thank you very much
All the best
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.
Thank you
Welcome
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.
Can you please help as I need values from two different domains but the AND condition is not working
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
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?
you have to call cds in your select and apply where condition in CDS not possible to add select option
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
Yes you can't that is restriction when we are using cds . SAP not given this option
Hi, is there a way we can get the field values from sales order (va01) tcode and use it inside cds view ?
Sales order tcode fields will be available in vbak,vbap or other related table you can fetch from that table
Hi Ram.Is there any way to pass multiple selection values in CDS Views?
Not possible like we use in ABAP SQL
@SAPTECHNOMANIAC Thanks for the information..
Is there any way where i could write an query to an custom table or standard table using the table name received in parameters.
Never tried. As per dynamic thing not possible in CDS
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..
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 …
@@SAPTECHNOMANIAC 👍👍 got it sir
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
Did you creates DCL, put Where condition ?
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
You are working with CDS entity or DDDIC CDS view
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 ?
Ideally it should come .I didn't tried with BEX query..
suppose I don't want to make vbeln as mandatory in that case what shall we do ?
This is the limitation when we are using parameter. it's not possible non mandatory parameter apart from some system fields ...
Can we pass the default value for CDS View based OData service ?
Check out :- C_SalesAnalyticsQry_1
Hi bro, Can you explain regarding about AMDP's
Sure I will explain it in the upcoming video.
AMDP in detail you can watch video series got completed :- ua-cam.com/video/fkU-H6iUQXI/v-deo.html
Thank you
Welcome!
Thank you
👍