3 Replies Latest reply: Feb 6, 2015 2:25 AM by Mika Lahti RSS

    SAP PS hierarchy

    Muhammad Irfan

      guys i need help in developing hierarchy between the wbs (work breakdown structure) and 2nd level wbs and then again 3rd level wbs/network(which is the order). now this is achieved in sap through a table called PRHI which has following fields.

       

      1. MANDT-Client(ignore this one)
      2. POSNR-WBS Element
      3. PSPHI-Current Internal project number
      4. Up-superior
      5. Down-1st sub. wbs element
      6. Left-left adjacent
      7. Right-Right adjacent.

       

      through ABAP coding i can achieve this hierarchy which is as following.

       

      SELECT * FROM PROJ

      SELECT * FROM PRPS Where PSPHI EQ PROJ-PSPNR SELECTSINGLE * FROM PRHI WHERE POSNR EQ PRPS-PSPNR.

      IF No Value Found

      MOVE PRHI-UP

      ENDIF.

      ENDSELECT.

      ENDSELECT.

       

      LOOP AT PRHI.

      SELECT SINGLE * FROM PRPS WHERE PSPNR EQ UP.

      IF PRPS-STUFE NE '2'.

      SELECT SINGLE * FROM PRHI WHERE POSNR EQ PRPS-PSPNR.

      IF SY-SUBRC EQ '0'.

      MOVE PRHI-UP TO ITAB_TEST-UP.

      ENDIF.

      MODIFY ITAB_TEST.

      ENDIF.

      ENDLOOP.

       

      can anyone help me in developing this hierarchy in qlikview 10