topic Re: logical database in Application Development and Automation Discussions

logical database

Former Member — Mon, 09 Jun 2008 05:25:41 GMT

Hi,

How do we find a logical data base for our programe, if logical data base exist..?

Thanks in Advance.....

Regards

Rai..

Re: logical database

Former Member — Mon, 09 Jun 2008 05:30:04 GMT

Hi,

By using ldbs u can reduce select statement, selection s-creen coding and all as LDBs will have the coding by default and what we need to do is go there and enter the required parameters and get it in the report.

Check this info.

A logical database is a special ABAP/4 program which combines the contents of certain database tables. You can link a logical database to an ABAP/4 report program as an attribute. The logical database then supplies the report program with a set of hierarchically structured table lines which can be taken from different database tables.

GET will fetch the table data immediately

GET LATE

In the LDB when you define the table structure in hierarchy, first it will fetch the higher node data and then all the below node tables data and comes to a second record in the top node table. for this GET Late is used.

You can create any number of primary keys in a table

GO THROUGH LINKS -

http://www.sap-basis-abap.com/saptab.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9bfa35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c6/8a15381b80436ce10000009b38f8cf/frameset.htm

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_Logical_Database_FAQ.html

www.sap-img.com/abap/abap-interview-question.htm

www.sap-img.com/abap/quick-note-on-design-of-secondary-database-indexes-and-logical-databases.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9bb935c111d1829f0000e829fbfe/content.htm

\[Don't ask for points! - content deleted by moderator\]

Thanks

Vikranth

Edited by: Jan Stallkamp on Jun 9, 2008 12:49 PM

Re: logical database

Former Member — Mon, 09 Jun 2008 05:30:24 GMT

Hi,

Follow this path

Menu path ~~-> goto menu~~---> attributes

here u find logical database used

Regards,

Shafi

Re: logical database

Former Member — Mon, 09 Jun 2008 05:32:12 GMT

Hi,

U can use se36 to see logical database.

Regards

Sandipan

Re: logical database

Former Member — Mon, 09 Jun 2008 05:32:39 GMT

Hi,

We can find which ldb using in program in program attributes in logical database screen field.

Re: logical database

Former Member — Mon, 09 Jun 2008 05:32:57 GMT

Hi Rai,

You should observe "Attributes" of the program from the transaction SE38.

Another way is to open the editor using SE38. Use the menu Goto->Attributes.

There would be an entry "Logical Database", if that shows nothing then there is no Logical database associated with ur program; otherwise the name would show up.

\[Don't ask for points! - content deleted by moderator\]

kiran

Edited by: Jan Stallkamp on Jun 9, 2008 12:51 PM

Re: logical database

Former Member — Mon, 09 Jun 2008 05:34:23 GMT

hi,

goto se80--~~>specify program name~~> goto on menu bar--->

attributes-----> find the ldb name.

thanks,

raji

Re: logical database

Former Member — Mon, 09 Jun 2008 05:35:21 GMT

Hi Rai,

First u need to know what type of data u are going to display or output.

depending on that u need to select the logical database.

for example:

To display Applicant data use PAP logical database

for Personnel Planning data use PCH Logical database.

for HR Master Data use PNP logical database

Best regards,

raam

Re: logical database

Former Member — Mon, 09 Jun 2008 05:40:24 GMT

SE36 IS THE logical data base Tcode.

There are two ways of using a logical database: Either by linking it with an executable program, or by using the function module LDB_PROCESS in any ABAP program.

When you link a logical database to an executable program, the user can enter values on the selection screen, and the data read by the logical database is passed back to the program using the interface work areas. If you call the logical database using a function module, the selection screen is not displayed. The calling program does not have to provide interface work areas. Instead, it uses special subroutines called callback routines, which are called by the function module and filled with the required data.

check dis link for further help..

http://help.sap.com/saphelp_46c/helpdata/en/60/183d78163011d2953c0000e8353423/content.htm

reward if helpful.

regards,

preet

Re: logical database

Former Member — Mon, 09 Jun 2008 05:58:39 GMT

Hi,

You can check up in the attributes of the program.

Have Fun!!

Ira!!