Hello Experts,I have table where one of the columns is called COL1.Suppose this table has just one record where the column COL1 has the value 56006*.I want to select the above record even when I look up this table for records with COL1 value = 560068...
Hi All,I already searched through the threads but did not find an answer to my problem so I am raising it here. Is there a function module or class-method using which I can find the allowed values for a domain. I only know the name of the domain and ...
Hello,Is there a function module or class/method which will give me the list of all locks of a user in the current session and not across all sessions (like transaction SM12). Function modules like ENQUE_READ and ENQUE_READ2 provides the lock list fo...
Hello Colleagues,Is there a function module or class/method which will give me the list of all locks of a user in the current session and not across all sessions (like transaction SM12). Function modules like ENQUE_READ and ENQUE_READ2 provides the l...
Hi All,I have created an implicit code enhancement spot at the end of a function module. In this enhancement I am unable to access the local variables and the import/export variables of the function module. Is this the expected behavior or I am doing...
Hi Andreas,Thanks a lot for the quick reply. So with the current CDS capabilities I will have to use the view on view construct. I will try this out.Also sorry for using the wrong terminology (joins vs. sub select)!!Regards,Saurabh
Hi Andreas,Thanks for the reply. I used aliases for joins in HANA SQL script. Basically I am trying to port a HANA SQL script based AMDP to a CDS view.Here is the working code that I used:- METHODS hana_ld IMPORTING VALUE(mandt) TY...
Hi Chris,I have to do multiple nested inner joins so I need to have aliases for the intermediate joins because some of the field names are same across tables used in the joins and also in the resultant intermediate joins. So my question is that in yo...
Hi Chris,Some more questions:-1) Are selects from multiple tables allowed for CDS view definition, for example something like SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1;2) Are nested joins allowed ...
