Solution Manager Documnt Management related tables

[wojtekr1]

Dear Experts,

Do you know how in DB level is done connection between document, that is attached to ChaRM change ticket and SolDoc related tables, that stores phisicaly word documents describing particular solution?

General idea, is, that we use Power BI to build reporting over QA in ACM process, one of the problema is to validate whenver all charm tickets has document attached to it, but at this point im not able to veryfie, what are tables behind this relation and soldoc in general.

Thanks for help!

Wojtek

[former_member190969]

Hi Wojtek,
there is no chance to do this with some selects on our tables. This will deliver wrong results. But you can use this API

https://wiki.scn.sap.com/wiki/display/SM/ABAP+classed+based+API

IF_SMUDE_SBOM_READ delivers the Solution Documentation element/node IDs for a change document. The application Type for change documents is CD. For these element IDs you can read the element headers with

IF_SMUDE_NODE_READ~READ_NODE_BY_ID_BULK

The documents have type KWOBJ. To get the document ID from this element you can use

READ_NODE_ATTRIBUTES_BULK

Regards

Andreas

[wojtekr1]

Tommy, thanks, but it is empty in my DB.

[TammyPowlas]

In Solution Manager, there is a table SRGBTBREL that contains information on relationship with attachments. In our other ABAP systems we have written code to check for these things. I haven't tried it yet in SolMan but I may try it.