Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Skip to end of metadata
Go to start of metadata

After reading article of SAP HR report https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3180,I write a report that using the  PNP ldb PY_FIVAC hr report category, and under normal conditions, it runs well,but there are two problems:1). when muttiple organizations are selected by clicking the Organization Unit button, it will throw a sql excption.     SQL error "-101" occurred when accessing table "HRPY_RGDIR ".              Termination occurred in the ABAP program "SAPDBPNP" - in "PYBUILD_INDEX_TABS".
                The main program was "YXHRR008 ".
                 In the source code you have the termination point in line 329
                of the (Include) program "PAY_GETDATA".
                The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
                procedure "PYBUILD_INDEX_TABS" "(FORM)", but it was neither handled locally nor
                 declared
                in the RAISING clause of its signature.
                 The procedure is in program "SAPDBPNP "; its source code begins in line
                291 of the (Include program "PAY_GETDATA ".2). when using the pnp ldb,how to check whether the logon user has the authroity to view the person payroll result data?

  • No labels