Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

m_irfan360
Contributor

SAP PS hierarchy

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

3 Replies
Not applicable

SAP PS hierarchy

Hey Irfan,

hierarchy and hierarchybelongsto can certainly solve your issue

m_irfan360
Contributor

SAP PS hierarchy

hey saad,

thanks for the heads up i have tried both of these i guess i need to try more ..

Not applicable

Re: SAP PS hierarchy

Hi, old issue, but I'm looking at the same problem now.

Did you manage to get this resolved? Hierarchy seems to be possible on QlikView Listbox, but I'm wondering if there are any possibilities to implement PS type of hierarchy on a tree in order to display some key figures on various PS levels.

Community Browser