Solution manager - Tables
I'm developing a few custom reports in solution manager, on the Change & Release management part.
I found that the change documents are stored in table crmd_orderadm_h. Installation Base is stored in table IBIN.
However, I'm not able to find back the link between change document and installation base. Where's this stored in the database? I only found the function module CRM_REFOBJ_READ_OW to get the IBase for a change document, but I would need it the other way around, as IBase will be a selection screen parameter.
Also, I'm looking at the link between Maintenance cycle and change document. Both are stored in table crmd_orderadm_h, but with a different process type. These are linked on some way however, but I don't find it back in the tables.
I already spent quite some time debugging existing reports to find this information, but I have not found it all. Maybe one of you already knows this information, and can share it?
Many thanks for the help!
PS: I will award points for every helpfull answer.