topic Get PERNR in Application Development and Automation Discussions

Get PERNR

Former Member — Wed, 25 Jul 2007 06:41:36 GMT

Hi,

Can anyone explain in detail, on how get pernr works?

Thanks,

Sriram.

Re: Get PERNR

Former Member — Wed, 25 Jul 2007 06:44:25 GMT

Hi Sriram,

For this you need to be familiar with the logical database concept. Just search for logical database or do F1 on GET and you will get an idea. Still you are not clear let us know, we will try to explain.

Regards,

Atish

Re: Get PERNR

RaymondGiuseppi — Wed, 25 Jul 2007 06:47:18 GMT

<b>GET pernr.</b>

This is related to logiical database LDB, usually logical database PNP.

Look at <a href="http://help.sap.com/saphelp_46c/helpdata/en/4f/d527ba575e11d189270000e8322f96/frameset.htm">Report Structure (PA-PAD)</a>

Regards

Re: Get PERNR

Former Member — Wed, 25 Jul 2007 06:52:45 GMT

GET is the command used in Logical database concept for fetching the data

GET PERNR will fetch all the Pernr's one by one in a Loop like thing

and for each pernr the data records in other infotypes have been processed

and it goes on till all the pernr's are completed.

see the sample code

start-of-selection.

Get PERNR from LDB

get pernr.

Get data from Respective Infotypes

rp_provide_from_last p0001 space pnpbegda pnpendda.

if p0001-kostl in pnpkostl.

rep_tab-kostl = p0001-kostl.

rep_tab-pernr = p0001-pernr.

rep_tab-ename = p0001-ename.

Get the Position Text

clear t528t-plstx.

select single plstx into t528t-plstx from t528t

where plans = p0001-plans and

otype = c_type and

sprsl = sy-langu.

if sy-subrc = 0.

rep_tab-ptext = t528t-plstx.

endif.

Get the Cost Center Text

clear cskt-ltext.

select single ltext into cskt-ltext from cskt

where spras = sy-langu and

kokrs = c_kokrs and

kostl = p0001-kostl.

if sy-subrc = 0.

rep_tab-ctext = cskt-ltext.

endif.

append rep_tab.

clear rep_tab.

endif.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Get PERNR

Former Member — Wed, 25 Jul 2007 06:55:30 GMT

Hi,

www.planetsap.com/HR_ABAP_LDB.htm

/people/alvaro.tejadagalindo/blog/2006/02/19/how-to-deal-with-hr-payroll-reports

www.sapdevelopment.co.uk/programs/custom/zp_postcode.htm

www.sap-img.com/abap/sample-hr-reports-allocate-petrol-allowance.htm

www.sap-press.de/download/dateien/860/sappress_mysap_hr_technical_principles2.pdf

www.sap-community.de/default.aspx?g=profile&u=1467

Regards,

Padmam.

Re: Get PERNR

Former Member — Wed, 25 Jul 2007 14:57:44 GMT

Hi Anji

I too have a doubt pertaining to the usage of the LDB "PERNR".

I need a small clarification:

Is it that under GET PERNR Loop, we use any other Infotype (post declaring it in the report) for its value.

for Ex P0000-pqr, P0001-xyz or P0002-abc.

Kindly clear my Doubt...

Regards

Ravi