Logical database

[Former Member]

I'm using the logical database PNP...

In my office some times this logical database takes to much time. Due to authority check etc

Do you know if it exists logical db like PNP that does not check... just a way to search personal number on criteria.

Or, and I almost know the answer is NO, is there a way to run the Logical db with authority check...

Thank you In advance

[sergey_korolev]

There is an special-aided authority check object 'P_ABAP' in class 'HR'. To turn off all the authority checks in PNP and PNPCE logical databases you have to add to a particular user authority to object P_ABAP with values REPID = 'SAPDBPNP' and COARS = '2'.

Caution!! Keep in mind that it will affect absolutely all PNP/PNPCE reports.

[Former Member]

Thanks Sergei for this wonderfull answer.

You have added a caution but let me know if I'm correct.

If I do this for a user X It does affect this username! So If I want to create maybe a special user I could be good...

Regards,

Message was edited by: STEPHAN KAMINSKI

[Former Member]

Hi STEPHAN KAMINSKI ,

If your running the report for all the emp # , assign the smallest and greatest per # in the selection-screen (i.e) PNPPERNR-LOW = smallest and PNPPERNR-HIGH = greatest. This will help LDB to select the index in the table.

USE THIS BEFORE GET PERNR EVENT

E.G

PNPPERNR-LOW = '34001' .

PNPPERNR-high = '34004'.

PNPPERNR-sign = 'I'.

PNPPERNR-option = 'BT'.

append pnppernr.

Hope this will work.

Thanks

Senthil