Is LDB obsolete?

[Former Member]

Hi Friends,

Is it advisable to use LDB to fetch details from HR infotypes. I know there would be advantages like Selection screen, Authorisation and so on.. these things can be achieved ourselves in code.. but I feel when i use LDB like PNP and select with out passing pernr it takes more time than using class CL_HRPA_READ_INFOTYPE.

Basically I want to know.. do people still use LDBs??? Are LDBs obsolete?

Thnx.

[Former Member]

Hi Friends,

Is it advisable to use LDB to fetch details from HR infotypes. I know there would be advantages like Selection screen, Authorisation and so on.. these things can be achieved ourselves in code.. but I feel when i use LDB like PNP and select with out passing pernr it takes more time than using class CL_HRPA_READ_INFOTYPE.

Basically I want to know.. do people still use LDBs??? Are LDBs obsolete?

Thnx.

[seshatalpasai_madala]

Hi,

The answer to this is NO, LDB is still a integral part of most of the HR related programs. The whole idea behind LDB is to avoid every application in HR creating their own coding for handling authorizations, buffering and selection screens etc provided by LDB, LDB is a program that is re-used across lots of HR programs. I dont think that should effect your performance, may be the performance will be little less at the LDB is event based.

Regards,

Sesh

[former_member188827]

no dey arent..infact dey are da first option to be used for data retreival...but b4 using ldb, make sure dat da node of ldb whose data u need isnt deep down da heirachy..for intance u need data from a node in ldb prior to whixh dere are 7 other nodes whose data u dont require..den da data retrieval 'll be slow and dere is no point using da LDB..

[Former Member]

Thanks for the replies.. but can you please tell me how to see the structure ..for eq in case of PNP i need to fetch infotype 8 details(basic pay) .. how will I know where it is in the structure?

[seshatalpasai_madala]

Hi,

Use transaction SLDB and open PNP LDB in it and select Structure radio button to see the strucutre. Also if you are creatig a new report use PNPCE instead of PNP. PNPCE is concurrent employement enabled.

But not sure if you can actually see the infotypes in the structure.

Regards,

Sesh

[former_member188827]

in program attributes where u specify ur logical database, double click on LDB name.

[former_member188827]

u can also check tcodes se36 or sldb to view LDB info

[Former Member]

Sesh, I have earlier tried the same option you have mentioned.. but I could not see the structure for the infotype I actually needed..Is there is any other way to see the structure..

Thnx

[seshatalpasai_madala]

Vimal,

I just checked out the structure, its PERNR at the first level and then you have other nodes on the second level.

But the infotype which you are looking for that 0008 is not read by this LDB, PNP reads only 0000 and 0001. Also it reads payroll results.

Regards,

Sesh

[Former Member]

Sesh,

I guess 8 (basic pay) also should be there in structure only thing we are not able to find in it .. because I used this in earlier programs .. I used Get Pernr and using macro rp-provide i have read 8 details as well..

Thxs..

[seshatalpasai_madala]

Vimal,

Check this standard program RPLPRRJ0. This is an SAP provided program. In this program we direclty read from table p0008 to get the basic pay details. Also note that this report is using LDB PNP. if PNP reads 0008 then this report should not be reading direclty from P0008. Being a standard SAP program why will someone write code to read from p0008 direclty if PNP already reads the data for you. Hence I am sure that PNP does not read 0008.

Regards,

Sesh

[Former Member]

I have written many program to read details from 0008, 0015 ..etc.using PNP and they are all working fine.. anyways thanks for your inputs...