topic Re: Problem in InfoSet Query data in Application Development and Automation Discussions

Problem in InfoSet Query data

Former Member — Fri, 17 Jul 2009 09:48:00 GMT

Hello All,

I have a specification to develop an infoset query in HR.The problem i am facing is i need particular PERNR's listed in output of query which satisfy few condtions like p000-massn = 31 and p0000-massg = Ub or Uc. this is an example of one condition. I tried to wirte my code in record processing and end of selection( before listing) . but there is no data coming at all.

Please suggest how to go about this .

Thanks in advance

Nidhi.

Re: Problem in InfoSet Query data

former_member215917 — Fri, 17 Jul 2009 11:48:02 GMT

Hi Nidhi,

P0000 is a structure and not the table. Check whether you are using right tables e.g. PA0000, PA0001 etc.

Gouri.

Re: Problem in InfoSet Query data

Former Member — Fri, 17 Jul 2009 12:05:40 GMT

Hello gauri ,

I am writing my code like this in start of selection coding space in the infoset.

rp_provide_from_last p0000 space pnpbegda pnpbegda.

If P0000-MASSN = '31' AND ( P0000-MASSG = 'UB' or P0000-MASSG = 'UC' )

OR P0000-MASSN = '91' AND P0000-MASSG = 'UE'

OR P0000-MASSN = '10' AND P0000-MASSG = 'U2'.

ELSE.

reject.

endif.

Re: Problem in InfoSet Query data

Former Member — Fri, 17 Jul 2009 12:26:04 GMT

Hello,

I guess, you need to write the below code first before rp_provide_from_last

GET <Logical database table>

GET PERNR.

Cheers,

Balaji

Re: Problem in InfoSet Query data

Former Member — Fri, 17 Jul 2009 14:03:29 GMT

Hello Balaji ,

But the infoet is using the standard LDB .

Re: Problem in InfoSet Query data

Former Member — Fri, 17 Jul 2009 14:30:24 GMT

Hello Nidhi,

while creating the infoset in SQ02, are you giving the LDB PNPCE or PNP?

In normal SE38, programing, if you use LDB PNP, then you should write GET PERNR. This will retrieve all the data from infotypes 0000, 0001 and 0002.

Please try adding GET PERNR in the START OF SELECTION. Also try writing the code rp_provide_last in START OF SELECTION.

Cheers,

Balaji

Re: Problem in InfoSet Query data

Former Member — Mon, 20 Jul 2009 06:51:27 GMT

Hi,

As per my past work you need not write any code in 'end of selection' however you can put such conditions within field itself i.e., after designing the infoset right click to the field you want to set filter for, choose "Queries for field" option and write your filtering criteria. While execution infoset will process the records based on this condition(s).

Let me know if it suits to your requirement.

Rgds

Sudhanshu

Re: Problem in InfoSet Query data

Former Member — Mon, 20 Jul 2009 09:49:22 GMT

Hello Sudhanshu,

I am right clicking on the filed in the infoset and choosing queries of the field.Then it is taking me to the screen of directories of queries for field &p0000-massn . and it is an alv lis of 5 columns with infoset name , field name , user group , query name and query property. Here if i right click on the ifled name and choose set filter , even after i enter values like 31, 91 ,and 10 it is not working .Could you please guide me more on this . i need to finish this requeire ment as earliest as possible .

thanks in advance .

Re: Problem in InfoSet Query data

Former Member — Thu, 01 Oct 2009 11:41:24 GMT

Hi Nidhi,

Please write your code in Record Processing event of code section of Infoset . And instead of IF , use CHECK condition statement.

CHECK P0000-MASSN = '31' AND ( P0000-MASSG = 'UB' or P0000-MASSG = 'UC' )

OR P0000-MASSN = '91' AND P0000-MASSG = 'UE'

OR P0000-MASSN = '10' AND P0000-MASSG = 'U2'.

CHECK SY-SUBRC EQ 0.

Re: Problem in InfoSet Query data

Former Member — Thu, 01 Oct 2009 11:42:19 GMT

Hi Nidhi,

Please write your code in Record Processing event of code section of Infoset . And instead of IF , use CHECK condition statement.

CHECK P0000-MASSN = '31' AND ( P0000-MASSG = 'UB' or P0000-MASSG = 'UC' )
OR P0000-MASSN = '91' AND P0000-MASSG = 'UE'
OR P0000-MASSN = '10' AND P0000-MASSG = 'U2'.

CHECK SY-SUBRC EQ 0.

Edited by: Dinesh Tiwari on Oct 1, 2009 1:42 PM

Re: Problem in InfoSet Query data

Former Member — Tue, 27 Oct 2009 03:38:25 GMT

Hi Nidhi,

Please check if given logic solves your issue.

Regards.

Dinesh

Re: Problem in InfoSet Query data

Former Member — Thu, 12 Nov 2009 03:21:34 GMT

Hi Nidhi,

Did you try to implement the mentioned logic? Let me know if you need any more information.

Regards,

Dinesh