RITM variables in database view?

[LikeARabbit]

This is the first database view I've attempted to build so I'm hoping this is something obvious that I'm missing.

Desired end result:

Database view that shows approvals of RITMs along with a specific RITM variable and attachments from the RITM. Something like this:

Approver Name | RITM # | Item Name | Short Description | State | Attachment file names | Total Cost (RITM variable)

What I have so far:

Everything listed above EXCEPT for the RITM variable (total_amount_requested, in PO Variables 2 variable set) and value.

I know the variable values are stored in Variable Ownership (sc_item_option_mtom) but I'm not seeing how I can attach that table and only show one specific variable (question) from a RITM with several variables.

Any ideas?

[LikeARabbit]

Actually, would the correct table be sc_item_option (Options)? That appears to hold all of the variable questions & answers. I'm not seeing a way to tie a sc_item_option record back to the RITM it originated from though.

[LouisG]

Hey Rabbit,

Any luck with this? Currently looking to do something similar and haven't had any luck finding anything out in the community besides this post. 

Thanks,

Louis

[anaghas]

was anyone able to solve this? I have a similar requirement where I need the RITM variables in the header. The RITM/item-option/item-option-mtom db view links all put the variables and values as 2 columns in the list. Thanks in advance for any inputs.