You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table to join Activity and resources

edited Aug 2, 2018 1:07PM in Learning 3 comments

Summary

Link between activity(WLF_LI_ACTIVITIES_F) and resources(WLF_RESOURCES_B) table

Content

We have defined an activity and attached resources(Room no, location) under the activity. Now I am unable to link the 2 tables which holds the data from activity(WLF_LI_ACTIVITIES_F) and resources(WLF_RESOURCES_B).

I know the bookings table(WLF_LI_BOOKINGS) but this sometimes doesnt have the complete data and more importantly it is only populated in case any employee is assigned to the offering/activity. Since the activity is always tagged to the resources irrespective of any bookings done, I need a connection between the activity and resource even if there are no bookings done.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!