Reg. Tables in Solman

[Former Member]

Hi all,

I have to prepare a report which accepts a Project ID as I/P and based on that I have to get all the business process under it. I would like to know what are the tables that contain the data. Is there any Function Module which gives this data. I want to generate a report which has some other columns too. So, all I need is a table that gives ProjectID & all the Business process that come under this project ID.I'm an ABAPer and any help will be useful.

Thanks & Regards,

Ramky.G

[Former Member]

Try below code,

donot know if it is completely correct, but this is what I was playing around with.

REPORT  ZTEST_JDV.
DATA wa_node_id LIKE TPR_INDEX-REFNODE_ID.
DATA wa_ref_object LIKE DFTNODE01R-REF_OBJECT.
DATA wa_text LIKE TTREET-TEXT.
DATA wa_type LIKE TTREE-TYPE.

SELECT REFNODE_ID
FROM TPR_INDEX
INTO wa_node_id
WHERE PROJECT_ID = 'ATLAS'.

    SELECT TTREET~TEXT TTREE~TYPE
    FROM TTREE JOIN TTREET ON TTREE~ID = TTREET~ID
    INTO (wa_text, wa_type)
    WHERE TTREE~ID = wa_node_id OR
          TTREE~NODE_ID = wa_node_id.

      DATA nodeType(25) TYPE C.

      IF wa_type = 'REFH0'.
        nodeType = 'PROJECT:  '.
      WRITE: / nodeType, 10 wa_text.
      ELSEIF wa_type = 'BMBS0'.
        nodeType = 'SCENARIO: '.
      WRITE: / nodeType, 15 wa_text.
      ELSEIF wa_type = 'BMPG1'.
        nodeType = 'PROCESS:  '.
      WRITE: / nodeType, 45 wa_text.
      ELSEIF wa_type = 'BMPS1'.
        nodeType = 'STEP:     '.
      WRITE: / nodeType, 85 wa_text.
      ELSE.
        nodeType = 'OTHER: '.
      ENDIF.

    ENDSELECT.


ENDSELECT.

[Former Member]

Hi Ramki,

As far as I know there is no relation between solman project and BP(Seniors please correct me if i m wrong).

BP are created and used for service desk functionality.

If u visit the BUPA_DEL tcode it is used to delete the BP no given as input.

Try ST05 here or go thru the Bupa_delete program code you will get the table names involved for BP.

OR Just create one BP from BP tcode and try St05 you get the dbase tables involved.

Hope it helps.

Please reward points.

[Former Member]

Are you just trying to get the document and links from solar01? if so i put the code on the blog. but it kind of big if it not.hehehe

[Former Member]

Try Function Modules from the package AI_SOLAR_PROJ, or try searching for SPROJECT* FMs.

Hope that helps.

Thanks,

Anil Santhapuri

PS: IF the reply is useful, reward points.