topic Re: Program flow skipping get pernr statement in Application Development and Automation Discussions

Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 05:35:04 GMT

Hello all,

I am new to HR abap coding and had to see a program written for dubai and now i have to make changes to india.

in the code it is as

START-OF-SELECTION.

REFRESH : it_zhr_tbl_006[].

SELECT * FROM zhr_tbl_006 INTO TABLE it_zhr_tbl_006.

IF NOT it_zhr_tbl_006[] IS INITIAL.

SELECT * FROM t512t INTO TABLE it_t512t

FOR ALL ENTRIES IN it_zhr_tbl_006[]

WHERE sprsl EQ sy-langu AND

molga EQ 40 AND

lgart EQ it_zhr_tbl_006-lgart.

ENDIF.

DATA : s_period TYPE char10.

SELECT * FROM zhr_tbl_002 INTO TABLE it_para.

GET pernr.

rp_provide_from_last p0008 space sy-datum sy-datum.

the program flow is coming till the select above get pernr and skipping all other and going to end of selection.

Can you tell me what changes i have to make??

I changes molga and and user group paramaters in user profiles as 40 also.

Please help.

Ujwal

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 05:48:57 GMT

hi Ujwal,

For GET, there is no syntax that matches - GET pernr.

In order to get the value that you want, we first create a node for the table and then access its fields as shown in the example below.

REPORT demo_get.

NODES: spfli, sflight, sbook.

DATA: weight       TYPE p LENGTH 8 DECIMALS 4,
      total_weight TYPE p LENGTH 8 DECIMALS 4.

INITIALIZATION.
carrid-sign = 'I'.
carrid-option = 'EQ'.
carrid-low = 'AA'.
carrid-high = 'LH'.
APPEND carrid TO carrid.

START-OF-SELECTION.
WRITE 'Luggage weight of flights'.

GET spfli FIELDS carrid connid cityfrom cityto.
SKIP.
ULINE.
WRITE: / 'Carrid:', spfli-carrid,
           'Connid:', spfli-connid,
         / 'From: ', spfli-cityfrom,
           'To:    ', spfli-cityto.

Let me know if this helps.

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 06:01:44 GMT

Hi Ujwal,

do you want to enhance an existing program or do you write a new program?

GET penrnr needs a logical database like PNP in the programs attributes.

Please check the attributes of your program.

You can display the Logical Database in SE36.

Regards,

Klaus

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 06:09:56 GMT

hi klaus,

There is an existing program for molga 99(Dubai) and now in need to copy the program and change according to India Molga = 40.

Yes i have used PNP in the attributes. I know all those but dont know why the program flow is not going till get pernr and jumping directly to end of selection.

Ujwal.

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 06:14:43 GMT

Hi Ujwal,

this normally always will happen, if no data matching the Logical Database select options on your selection screen will be found.

Regards,

Klaus

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 06:19:36 GMT

Try writing this way:

REPORT zreport.

INFOTYPES: 0001.

TABLES: pernr.

START-OF-SELECTION.

GET PERNR.

PROVIDE * FROM P0001 BETWEEN PN-BEGDA AND PN-ENDDA.

WRITE:/ P0001-PERNR,

P0001-STELL,

P0001-BEGDA.

ENDPROVIDE.

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 06:22:39 GMT

Hi Ujwal,

I created a short test program with logical database PNP in the attributes:

REPORT ztestpnp.

NODES: pernr.

START-OF-SELECTION.

GET pernr.

BREAK-POINT.

END-OF-SELECTION.

It works fine without any input on the selection screen. Please check it in your system.

Regards,

Klaus

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 06:25:52 GMT

hi klaus.

\thanks for your reply.

Can you tell me how can i cross check this??

i am using following infotypes in my program. is it anything related to this.

INFOTYPES : 0000, 0001, 0002, 0008, 0041, 2006,0014,0009.

Ujwal

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 06:26:24 GMT

Hi Ujwal,

I think the issue might also be caused using macro rp_provide_from_last p0008.

Maybe this doesn't work okay for India. Try the macrö's code without using the macro, for macros can't be processed in debugging mode.

Regards,

Klaus

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 06:46:53 GMT

hi klaus,

the

rp_provide_from_last p0008. statement is after get pernr right? but the flow is not going till get pernr also.

and aslo i checked the data for infotype 0008 and its available.

Thanks

Re: Program flow skipping get pernr statement

RaymondGiuseppi — Fri, 06 Sep 2013 06:55:34 GMT

If you don't trigger the GET there may be no record you are allowed to see So logical database program SAPDBPNP does not execute any PUT pernr.

(no record or records you are not allowed, HR loves authorization-checks)

Some hints :

Look via SU53 for authorization-check failed.
Check (development system ?) via SE16/SE16N if there are records if there is no authorization failure.
Also, you could also test your selection via SE36 on logical database, the test option allows this. (if SE36 give same result than you report, there is no problem, else...)

Regards,

Raymond

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 07:19:27 GMT

hi raymond,

i check su53 after running my program it says "The last authorization check was successful".

Ujwal

Re: Program flow skipping get pernr statement

RaymondGiuseppi — Fri, 06 Sep 2013 07:31:58 GMT

And do you see some data when testing the LDB with SE36 ?

Regards,

Raymond

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 07:39:13 GMT

yes i am getting a record for the employee given.

hover i modified the pnp selection screen with Z report category.

My screen looks like below. its program for settlement form for resigned or terminated employees.

Re: Program flow skipping get pernr statement

RaymondGiuseppi — Fri, 06 Sep 2013 08:15:46 GMT

Can you try to put a break point in the PUT PERNR (end of include DBPNPF03 of SAPDBPNP)

Regards,

Raymond

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 10:07:25 GMT

hi raymond,

i put break at the point you mentioned but its not triggering.

Ujwal

Re: Program flow skipping get pernr statement

Former Member — Fri, 06 Sep 2013 10:20:15 GMT

Hi,

you should give the user id executing this logic correct user parameters like molga.

Kind regards, Rob Dielemans

Re: Program flow skipping get pernr statement

former_member420959 — Fri, 06 Sep 2013 10:49:28 GMT

hi rob,

the molga value is given correctly as 40 in the user parameters

Re: Program flow skipping get pernr statement

Sudhakargadde — Fri, 06 Sep 2013 11:33:02 GMT

hi ujwal,

for every LDB program their is start-of-selection and End-of-selection in between GET PERNR is their right. your statements are below

GET pernr.

rp_provide_from_last p0008 space sy-datum sy-datum.

put a break point in macro above mentioned and check. put in macro don't forget OK.

Thanks and Regards

Sudhakar

Re: Program flow skipping get pernr statement

RaymondGiuseppi — Fri, 06 Sep 2013 11:37:27 GMT

break-point in a macro, how did you perform ?