topic Query - PNP Database in Application Development and Automation Discussions

Query - PNP Database

Former Member — Tue, 11 Mar 2008 08:48:57 GMT

Hi All,

I have a question regarding use of PNP database.

in the PNP selection screen entered values

date - 01.02.2008 - 31.12.1999

cost center - X.

Personal Area - Q

in the database p0001 for pernr P1 there are two records for cost center history

1) 01.01.2002 - 01.01.2008 - X ( Cost Center)

2) 15.01.2008 - 31.12.9999 - Y( Cost Center)

As my input screen suggests pernr with only cost center X should be selected... why is it that P1 is being selected via GET Pernr ?

I can manually put a logic .. but PNP database selection screen is dynamic and user can select any field as filter paramter .. Have I to check and each and every selection field. I dont think thats how PNP would work.

Could you please explain where am I going wrong?

Thanks

Neelima

Re: Query - PNP Database

Former Member — Tue, 11 Mar 2008 08:52:09 GMT

Using PNP will not filter the records based on the values entered on the

selection screen .. except for the Pernr ..

U have to explicitly write the filter criteria after GET PERNR event.

Re: Query - PNP Database

Former Member — Tue, 11 Mar 2008 09:18:51 GMT

Thanks for the reply.

does that mean for all the fields in pnp selection screen .. logic has to be explicitly written to handle data ?

Re: Query - PNP Database

Former Member — Tue, 11 Mar 2008 09:28:28 GMT

not all the fields need to be handled.. but some fields such as

begda endda ... needs to be handled .. even though U give the

date condition in selection screen .. U get all the records in the structure

Pnnnn.

Re: Query - PNP Database

Former Member — Tue, 11 Mar 2008 13:30:42 GMT

Thanks for the reply.

Checking for begda and endda is fine .. but i was refering to other fields which are visible in the pnp selection screen ..e.g cost center , payroll area, emp. status

if user puts selection criteria in any of these fields .. shouldnt the returned personal nos. from GET pernr be filtered ?