Hello Experts, I created cds view with union of two tables. Here my problem is i am able to aggregate the data(sum) for individual selects but not for entire CDS view. Is it possible to aggregate the data after u...
Hello Experts, I have used both EXPORT/IMPORT to data buffer string and database with ID. I understand and clear about Export to database will store the compression string in database. But i am not clear about the concept EXPOR...
Hello Guys, From SAP NW Rel. 750 supports CDS table functions which are similar to SAP ABAP AMDP. Is this feature is supported in all underlying databases? or supported in HANA only?Thanks,Venkatesh
Hi All, I have requirement of converting table data into json or xml format using SQL Script. If it is possible please paste the sample code.Thanks,Venkatesh
Hi, I am trying to execute the stored procedure dynamically using EXEC command inside another procedure. Here my doubt is how to retrieve the result after dynamic call of procedure. Please help me on how to retrieve the result of stored procedure....
Thanks for your response. You are correct but my requirement is to achieve in one CDS View. I achieved it by union of left outer join of table1 and table 2 and unmatched rows from table 2. Thanks,Venkatesh
Hello, I think the problem is converting date field (FKDAT) from db to abap type. You need to convert date field using TO_DATS( ) function to convert date into abap type.In your case mismatch error due to FKDAT field. Now try this in select que...
Hi, I achieved this with below code.Here "SYSTEM"."ZPERIOD_TEST" is temporary global table.CREATE PROCEDURE test_procedure(out lt_data1 tt_data ) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER DEFAULT SCHEMA SYSTEM AS BEGIN/**************************...
Hello Florian, Yes, we can convert using XSJS or ODATA but in my scenario, i have different procedures which will be return different types of data. I would create one wrapper procedure and call the procedure dynamically. The wrapper procedu...
