topic SAP PS hierarchy in QlikView

SAP PS hierarchy

Anonymous — Wed, 30 Nov 2011 05:40:10 GMT

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.

MANDT-Client(ignore this one)
POSNR-WBS Element
PSPHI-Current Internal project number
Up-superior
Down-1st sub. wbs element
Left-left adjacent
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.

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

SAP PS hierarchy

Wed, 30 Nov 2011 09:29:46 GMT

Hey Irfan,

hierarchy and hierarchybelongsto can certainly solve your issue

SAP PS hierarchy

Anonymous — Wed, 30 Nov 2011 09:55:26 GMT

hey saad,

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

Re: SAP PS hierarchy

Fri, 06 Feb 2015 07:25:23 GMT

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.