I want the URL of the SOLDOC transaction for a particular document.

[Former Member]

I want the URL of the SOLDOC transaction(in SOLMON) for a particular document. Are there any tables that store the file path of the documents.

I have PHIO_ID for the document.

One more question, is the data stored for SOLDOC and SOLAR02 transaction the same except that one is webdypro and the other one is dynpro. If it is same, then I can get help from SOLAR02 transaction, I guess.

Please quick reply.

[s1252]

Refer below code, this is what i used for getting URL and soldoc Path for Documents attached to a CD/CR's GUID.

"PROP fields from smdphio table may change based on soldoc configuration.

    DATA: lv_branch TYPE smude_branch_id.
    DATA ls_smud_occ TYPE cl_ags_crm_1o_api=>ts_smud_occurrence.

    SELECT  phio~phio_id,
            phio~loio_id,
            phio~prop01,
            phio~prop02,
            phio~prop03,
            phio~prop04,
            phio~prop05, "Status
            phio~prop09, "Branch GUID
            attr~occ_id "Node GUID
      FROM smud_sbom_h AS sbom_h
      INNER JOIN smud_sbom AS sbom
      ON sbom~sbom_id  = sbom_h~sbom_id

      INNER JOIN smud_node_attr AS attr
      ON attr~occ_id = sbom~occ_id

      INNER JOIN smdphio AS phio
      ON phio~loio_id = attr~value

      WHERE "sbom_h~app_type = 'DOS' AND
            sbom_h~app_id = @i_cd_cr_guid
        AND sbom_h~deleted = @space
        AND attr~attr_type = 'KWOBJID'
      INTO  TABLE @DATA(lt_sdoc_prop).

    IF sy-subrc = 0 AND lt_sdoc_prop[] IS NOT INITIAL.
        LOOP AT lt_sdoc_prop ASSIGNING <fs_sdoc_prop>.
          MOVE-CORRESPONDING <fs_sdoc_prop> TO ls_soldoc.

          "Get URL
          lv_branch = <fs_sdoc_prop>-prop09.
          ls_soldoc-abs_url =  cl_ags_crm_smud_util=>get_smud_url( EXPORTING iv_branch_id        = lv_branch
                                                                             iv_node_id          = <fs_sdoc_prop>-occ_id
                                                                             iv_get_absolute_url = abap_true ).
          " Get Path
          ls_smud_occ-root_occ = lv_branch.
          ls_smud_occ-occ_id = <fs_sdoc_prop>-occ_id.
          ls_soldoc-path = cl_ags_crm_smud_util=>get_path_description( is_smud_occ = ls_smud_occ ).

          APPEND ls_soldoc TO v_soldoc.
          CLEAR ls_soldoc.
        ENDLOOP.

    ENDIF.

Accept the answer if this helps, so some others can also use this .

[ascnblog5]

is there any FM / BADI / BAPI for generation of new occ id ?

i did not found any such in solution manager system

[ascnblog5]

Thanks a lot Krishna ! i was in a need for exact solution since my problem statement was very much similar. i'm able to get exact URL which is required.

But now im stuck in another step . can you please suggest how does new occ id gets generated against newly uploaded / created solution manager document ? . System version is 7.2 which is being used.

[s1252]

Hi Nimesh,

I am looking for the same answer, And you have posted this few months back, did you able to get link. If yes please let me know how you did it.

- Krishna