Skip to Content
0
May 01, 2018 at 06:33 PM

view data that contains foreign keys

69 Views

I am in varsity currently working on a project, however l was thrown under the bus and l have to figure out how to use SAP tools for development. Now l've been relatively successful, however I'm struggling to display the data that contains foreign keys.

So far I've gotten to the stage where l can view my metadata and the relative addresses, but l do not know how to provide the address on initialization for it to populate my views.

So the context is: l have three tables, namely consultant, project and assignments. My assignments table is dependent on two foreign keys from project and consultant namely, consultantID and projectID.

So now my question is, how do l populate the view with the data from assignments, such that l can simply extract my consultant's information as well as my project information.

Any help would be greatly appreciated.