topic Re: PA70 Payroll Identifier Modification in Application Development and Automation Discussions

PA70 Payroll Identifier Modification

Former Member — Sun, 20 Oct 2013 17:39:04 GMT

Dear Experts,

I want to use userexit EXIT_SAPFP50M_002 to assign default value to payroll identifier field.

All i want is when i press next screen the payroll identifier field is automatically filled according to the following query:

SELECT MAX(PAYID) from PA0267 into max_pay where BEGDA = Payment Date.

and assign max_pay + 1 to payroll identifier.

Here are the steps.

1- Run transaction PA70:

2- check Additional off-cycle Payments and Preselect using report, the with proposal

3- choose multiple personnel numbers

4- check with proposal

5- Here i change the payment date and add the wage type then press next screen,

all what i need is to automatically fill payroll identifier according to this query:

SELECT MAX(PAYID) from PA0267 into max_pay where BEGDA = Payment Date.

and assign max_pay + 1 to payroll identifier.

So for all these employee the payroll identifier will be assigned.

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 05:13:39 GMT

Hi Ahmed,

As discussed earlier to your previous thread

http://scn.sap.com/message/14423654#14423654

Write the same logic inside the USER EXIT.

EXIT_SAPFP50M_001

DATA : lx_0267 TYPE p0267.

Constant : lc_0267 type infty value '0267'.

* Check the Infotypes...
CLEAR lx_0267.
IF sy-tcode NE 'PA20' AND ( ipsyst-ioper EQ 'INS' OR ipsyst-ioper EQ 'MOD' ).
   CASE innnn-infty.
     WHEN lc_0267.
*** Importing data from innnn to the structure lx_0267
       CALL METHOD cl_hr_pnnnn_type_cast=>prelp_to_pnnnn
         EXPORTING
           prelp = innnn
         IMPORTING
           pnnnn = lx_0267.

Here you can write the logic... Like... Validations or pass default values to the screen elements..

           CALL METHOD cl_hr_pnnnn_type_cast=>pnnnn_to_prelp
             EXPORTING
               pnnnn = lx_0267
             IMPORTING
               prelp = innnn.
         WHEN OTHERS.
       ENDCASE.
     WHEN OTHERS.
   ENDCASE.
ENDIF.

http://www.slideshare.net/RingelJen/user-exit-training

With regards,

SuDEESH

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 09:14:24 GMT

Dear Sudeesh,

I have here a different case, In PA30 it was a single employee only.

My logic is to search for the max payroll identifier in table PA0267 and increment this value and assign it to the employee.

as follows:

CASE innnn-infty.

WHEN lc_0267.

CALL METHOD cl_hr_pnnnn_type_cast=>prelp_to_pnnnn

EXPORTING

prelp = innnn

IMPORTING

pnnnn = lx_0267.

SELECT max( PAYID ) FROM PA0267 INTO SERIAL WHERE BEGDA = IPSYST-DDATE.

lx_0267-PAYID = SERIAL + '1'.

CALL METHOD cl_hr_pnnnn_type_cast=>pnnnn_to_prelp

EXPORTING

pnnnn = lx_0267

IMPORTING

prelp = innnn.

WHEN OTHERS.

ENDCASE.

For transaction PA70, i have multiple employees.

If i use the same logic for multiple employees, every employee will be incremented by one.

I want to increment the payid only once.

In other words:

I want to change the value of payid of all the employees at the same time

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 09:24:33 GMT

For this purpose why you want to write logic in EXIT.

Better try to create a custom program using the FM HR_INFOTYPE_OPERATION.

And update the same in the infotype 0267.

With regards.

SuDEESH

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 11:44:54 GMT

Can i create global variable that is incremented every time the exit is called?

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 11:53:48 GMT

Is this an one time job?

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 11:59:00 GMT

CASE innnn-infty.

WHEN lc_0267.

CALL METHOD cl_hr_pnnnn_type_cast=>prelp_to_pnnnn

EXPORTING

prelp = innnn

IMPORTING

pnnnn = lx_0267.

GLOBVAR = GLOBVAR + 1.

CALL METHOD cl_hr_pnnnn_type_cast=>pnnnn_to_prelp

EXPORTING

pnnnn = lx_0267

IMPORTING

prelp = innnn.

WHEN OTHERS.

ENDCASE.

I want to get number of employees in the table and store it in global variable.

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:05:10 GMT

Dear Ahmed,

You can use memory id as well.

import from memory id 'ZZPAYID'.

lx_0267-PAYID = SERIAL + '1'.

export to memory id 'ZZPAYID'.

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:06:49 GMT

But where will you declare that global variable?

in user exit? if it so, whether it won't get be initial? when control passes for every employees?

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:07:23 GMT

This case doesnt work out like pa30 because they are multiple employees.

for example:

Higher payid in pa0267 is 4.

then personnal number 00999201 will have payid = 5.

and post it in pa0267.

for the next personnal number,

Higher payid in pa0267 will be 5.

then personnal number 00999203 will have payid = 6.

and post it in pa0267.

Higher payid in pa0267 will be 6.

then personnal number 00999333 will have payid = 7.

and post it in pa0267.

what i actually want is:

I want to look for the higher payid in pa0267.

and increment it and assign it to all the employees.

for example:

Higher payid in pa0267 is 4.

then personnal number 00999201 will have payid = 5.

for the next personnal number,

Higher payid in pa0267 will be 4.

then personnal number 00999203 will have payid = 5.

Higher payid in pa0267 will be 4.

then personnal number 00999333 will have payid = 5.

Then post post it in pa0267.

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:11:44 GMT

Try to create a custom program and update the same using the HR_INFOTYPE_OPERATION.

This will really help you!!

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:17:23 GMT

But i want this to be executed when the user create additional offcyle in pa70

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:26:06 GMT

Then for all employees, Get payid and increment it by 1.

l_payid = payid + 1.

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:30:55 GMT

how to access all the employees at the same time?!

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 12:35:15 GMT

Check this link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0d9b96c-7f89-2c10-0194-8854c0ef2001?overridelayout=true&45221710864545

http://www.saptraininghub.com/sap-fast-entry-tutorial/

Re: PA70 Payroll Identifier Modification

Former Member — Mon, 21 Oct 2013 14:16:06 GMT

it cannot be done by userexit EXIT_SAPFP50M_002 ??

Re: PA70 Payroll Identifier Modification

Former Member — Tue, 22 Oct 2013 04:46:09 GMT

You can write logic in EXIT_SAPFP50M_002. But Compare with your requirement.