Skip to Content
0

Dynamic read of data in ODATA

Feb 13, 2017 at 01:40 AM

44

avatar image
Former Member

Hi All

I have a particular requirement ..

I need to read data from different tables and display in detail section based on the selection of the table on master sheet .. The columns may differ from table to table so my detail layout have to be dynamic ..I think i can handle that ..

I was thinking of doing this odata ..

I would create 2 hdb views One with the list of the tables and use this as master

and second need to be a dynamic hdbview with an input paramter and finally create a single odata and estabilish a link between 2hdbview's with parameter

My problem is to create a dynamic second hdbview with an input parameter

1 hdview ) select distinct table from sys.tables where schema = hana

2 hdbview ) select * from table from 1 hdbview ( this is suppose to be dynamic select * from :inparam

then my odata will be something like this

service {
   "sap.test::table" as "Tab" navigates ("avp" as "ViewNav");
   "sap.test::calcview" as "View" key ("theKeyColumns") parameters via key and entity;
 
   association via parameters "avp"
     principal "Tab"("paramValue") multiplicity "*"
     dependent "View"("parameter") multiplicity "*";
}


unfortunately i cannot use calc view (may be graphical cal view ) because my out structure varies from table to table and the table name is passed by input paramter

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers