2007 Jul 25 7:41 AM
Hi,
Can anyone explain in detail, on how get pernr works?
Thanks,
Sriram.
Hi,
Can anyone explain in detail, on how get pernr works?
Thanks,
Sriram.
2007 Jul 25 7:44 AM
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
2007 Jul 25 7:47 AM
2007 Jul 25 7:52 AM
Hi
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
2007 Jul 25 3:57 PM
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
2007 Jul 25 7:55 AM
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.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |