SQL > SELECT PNLNAME, RECNAME, FIELDNAME from PSPNLFIELD WHERE RECNAME = 'ZZ_CUST_TBL';
ZZ_CUST was the page I was interested in. So, I go on to find out the component that holds this page.
SELECT PNLGRPNAME FROM PSPNLGROUP WHERE PNLNAME = 'ZZ_CUST';
And the grand finale! The entire portal navigation tree is stored in PSPRSMDEFN table. Specifically, PORTAL_URI_SEG2 is the column that stores the component that corresponds to a navigation link.
SELECT PORTAL_URI_TEXT FROM PSPRSMDEFN WHERE PORTAL_URI_SEG2 = 'ZZ_CUST_TBL'
The PORTAL_URLTEXT returned by the query reads “/c/ADMINISTER_WORKFORCE_(GBL).ZZ_CUST_TBL.GBL”, which is nothing but the menu and the component stringed together.
On a PIA screen, the url format is
http:/server:port/psp/domain/EMPLOYEE/HRMS/c/………………………..
Now, I would snap the PORTAL_URLTEXT on the URL,
http:/server:port/psp/domain/EMPLOYEE/HRMS/
c/ADMINISTER_WORKFORCE_(GBL).ZZ_CUST_TBL.GBL
…and go, page that holds ZZ_CUST_TBL.
