How to Get 'Network Activity Number' for a 'Project-ID'

[Former Member]

Hello All

Working on PS project and kindly expecting your expertise in How and Where to find the NETWORK ACTIVITY NUMBER for a PROJECT-ID. Would like to the table name and the relationship if possible. I tried debugging transation CN41 and couldnt able to get.Your help in this regard greatly appreciated.

Sincerely

Maddy Rangs

[Former Member]

PA0315-LSTNR

[raymond_giuseppi]

Convert project id (ext) to project number (int) via table PROJ

SELECT SINGLE pspnr INTO wa_pspnr FROM PROJ 
  WHERE pspid EQ wa_pspid.

Extract Network via view CAUFV

SELECT SINGLE AUFNR AUFPL INTO (wa_aufnr, wa_aupf) FROM CAUFV 
  WHERE AUTYP = '20' AND PRONR = wa_pspnr.

Then loop in operation to find activity

SELECT projn vornr INTO (wa_projn, wa_vornr) FROM afvc
  WHERE aufpl = wa_aufpl.

Read WBS to get ext id

  SELECT SINGLE posid INTO wa_posid FROM prps
    WHERE pspnr = wa_projn.

Let's try a demo

PARAMETER: pa_pspid LIKE proj-pspid.
DATA:      wa_pspnr LIKE proj-pspnr,
           wa_aufnr LIKE caufv-aufnr,
           wa_aufpl LIKE caufv-aufpl,
           wa_projn LIKE afvc-projn,
           wa_vornr LIKE afvc-vornr,
           wa_posid LIKE prps-posid.
SELECT SINGLE pspnr INTO wa_pspnr FROM proj WHERE pspid = pa_pspid.
SELECT SINGLE aufnr aufpl INTO (wa_aufnr, wa_aufpl) FROM caufv
  WHERE autyp = '20' AND pronr = wa_pspnr.
WRITE: / 'Project', wa_pspid, 'Network', wa_aufnr.
SELECT projn vornr INTO (wa_projn, wa_vornr) FROM afvc
  WHERE aufpl = wa_aufpl.
  SELECT SINGLE posid INTO wa_posid FROM prps
    WHERE pspnr = wa_projn.
  WRITE: / 'WBS', wa_posid, 'Activity', wa_aufnr, wa_vornr.
ENDSELECT.

Regards,

Raymond

[Former Member]

hi,

pass the project number to the Function Module 'BBP_PS_PROJECT_GET_LIST' , you will get every information about that project.

Regards

Geeta Gupta

[Former Member]

Would you like to mean current project no 'PSPHI'???????????????

[GauthamV]

Use these tables.

PROJ,PRPS.