Reg Logical database

[Former Member]

Hi,

While customizing the LDB (<i>PNP)</i>) selection screen (<i>SPRO</i>), what is the importance of checking and unchecking the Radio Button

<i>Data selection period = Person selection period</i>?

How this affects the selection criteria?

Thx

Albert.

[ferry_lianto]

Hi Albert,

Period is standard selection of database PNP.

You will get, when you specify PNP as logical database in report attributes.

<b>Data Selection Period</b>

The data selection period enables you to specify the period in which employee data records are read. Only records which overlap with the specified period by at least one day are selected. To define an interval, enter the start date in the left column and the end date in the right column

<b>Person Selection Period</b>

When you enter a person selection period, the system selects only those employees who are members of the enterprise on at least one day in the specified period. These are persons with a valid Organizational Assignment (0001) record. Entries in the standard selection options fields limit the personnel numbers that are selected. You can specify an interval by entering the start and end dates in the left and right columns respectively.

Selection criteria in PNP are just used to determine the pernrs which meet them. For these pernrs then all wanted data is selected. This data then is not checked against this criterias.

An Example:

Pernr 4711 has benn assigned to costcenter 10 from 01.01.2004 until 31.12.2004. On 01.01.2005 costcenter changes to 20.

If you now select all employees with costcenter 10 and list their costcenters, you will get both costcenters 10 and 20.

Most reports which use PNP have to sets of date-ranges:

- Person selection period that controls selection of pernr.

- Other period that controls selection of data.

If you set person selection period in above example to 01.01.2004 and other period to 01.01.2005 and select costcenter 10 you will in fact get employee 4711 with costcenter 20 shown.

Same effect with org-unit or any other selection criteria.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

[Former Member]

Hi Ferry,

Thanks for your time.

Plz tell me incase to get active employee Info of a particular period,

Data selection must be equal to person selection (or)pa0001-stat2 eq 3.

Is it Correct?