topic Re: Logical database in Application Development and Automation Discussions

Logical database

Former Member — Wed, 18 May 2005 13:32:48 GMT

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

Re: Logical database

sergey_korolev — Wed, 18 May 2005 14:22:00 GMT

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.

Re: Logical database

Former Member — Thu, 19 May 2005 07:38:05 GMT

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

Re: Logical database

Former Member — Thu, 19 May 2005 11:51:44 GMT

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