Help HR query with logical db

[Former Member]

Hi,

I've created a query from a infoset based on logical db PNP.

The infoset is setted to read also 2001 infotype (absences).

The user that run the query has a role that can't read some 2001 subtypes, for example it can read subty YYYY but not subty XXXX.

When the user execute the query and select in selection screen only subtype YYYY for a defined period, if this period contains a least one 2001 record with XXXX subtype, however the user can not see the records with YYYY subtypes in that period.

I think it's very strange behaviour, indeed if I select a period that not contains XXXX subtypes record the user can view YYYY correctly.

It's a normal SAP behaviour?

Thanks for answers.

[Former Member]

Hi,

I've created a query from a infoset based on logical db PNP.

The infoset is setted to read also 2001 infotype (absences).

The user that run the query has a role that can't read some 2001 subtypes, for example it can read subty YYYY but not subty XXXX.

When the user execute the query and select in selection screen only subtype YYYY for a defined period, if this period contains a least one 2001 record with XXXX subtype, however the user can not see the records with YYYY subtypes in that period.

I think it's very strange behaviour, indeed if I select a period that not contains XXXX subtypes record the user can view YYYY correctly.

It's a normal SAP behaviour?

Thanks for answers.

[Puneet_Gupta]

This is normal SAP behavior. In case of missing partial authorizations, the logical database skips the PERNR completely and does not display any data for the PERNR.

You can bypass this check but adding a line of code in the the infoset.

From the menu path Goto -> Code -> Initialization.

In that block add the code.

PNP_SW_SKIP_PERNR = 'N'.

This will prevent the LDB from skipping the pernr but the unauthorized fields will be blank.

- Puneet

[Former Member]

Thanks,

tomorrow I'll try your solution, I let you know if this will'be ok for my customer.

Obviously I will update the status of your answer 😉

Update: It works for my purpose, thanks again.