2006 Dec 19 10:53 AM
Hi
I have done HR reports,but i didnt use logical databases.
I used HR tables,results table,technical wage types and displayed output.
Is it mandatory to use Logical databases?what is PNP and PNCP?
where do we use these PNP and PNCP?in se37?or in program?ad what are the advantages if we use logical database?
Thanks in advance.
2006 Dec 19 10:56 AM
its not mandatory to USE LDB's
Advantages : Less coding and no need to check for Authorization(?) manually , No need to design the selection
screen .. U can change the sel. screen using the report categories provided or create your own categories.
Disadvantages : Performance problems if data base is huge.
We'll give these in SE38 in the Attributes screen
We use PNP , PCH , PNPCE .. No PNCP LDB ..
PNPCE we get the Central person concept which is not there is 4.6c
2006 Dec 19 10:56 AM
its not mandatory to USE LDB's
Advantages : Less coding and no need to check for Authorization(?) manually , No need to design the selection
screen .. U can change the sel. screen using the report categories provided or create your own categories.
Disadvantages : Performance problems if data base is huge.
We'll give these in SE38 in the Attributes screen
We use PNP , PCH , PNPCE .. No PNCP LDB ..
PNPCE we get the Central person concept which is not there is 4.6c
2006 Dec 19 10:56 AM
Hi,
PNP and PNPCE are used for PA reporting.
They are logical database.If you are going to use them in the program,you need to give them in the program attribute screen.
Logical database(tcode se36) advantages:
selection screen
authorisation
Data retrival
2006 Dec 19 11:01 AM
Hi,
LDB's just help with a selection screen, authorization check and data extraction for mentioned infotypes.
PNP & PNPCE holds different table datas to extract.
Check their code in SE36.
For a good example just go throught report RPLICO10.
Regards,
Amit
2006 Dec 19 11:04 AM
Hi
Thanks guys
One question
Do we need to use provide * <infotype> if we use ldb's or also we can write
normal selects also??
any example ??
Thanks
2006 Dec 19 11:07 AM
with LDB.. the declared infotypes are loaded for each pernr at the GET PERNR event.. you don't need to use the SELECT again.. you can use PROVIDE or LOOP to read the infotype itabs p0001,p0002 etc..
~Suresh
2006 Dec 19 11:34 AM
Hi,
If you are using LDB (say PNP),you should use <b>Get pernr</b> statement after start-of-selection.
infotypes p0001.
start-of-selection.
get pernr.
provide * from p0001 between pn-begda and pn-endda.
write : / p0001-pernr, p0001-stell.
endprovide.
end-of-selection.
This will fetch the data according to your selections in logical database selection screen.
If you are using select statement while using ldb,it won't be meaningful.
Main advantage is using ldb will take care of authorisation.But select statement won't take care of authorisation.
Check these links for HR ABAP information.
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PAPA/PAPA.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PAPD/PAPD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PYINT/PYINT_BASICS.pdf
http://www.atomhr.com/training/Technical_Topics_in_HR.htm
http://www.planetsap.com/hr_abap_main_page.htm
you can see some Standard Program examples in this one..
http://www.sapdevelopment.co.uk/programs/programshr.htm
These are the FAQ's that might helps you
2006 Dec 19 11:50 AM
Hi,
Check the coding here for provide...endprovide without using LDB.
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/provide.htm