topic Re: logical database, in Application Development and Automation Discussions

logical database,

Former Member — Fri, 11 May 2007 10:07:52 GMT

what is the advantage of logical database and whats the use of it

regards

vijay

Re: logical database,

amit_khare — Fri, 11 May 2007 10:09:58 GMT

Check the threads -

Regards,

Amit

Re: logical database,

Former Member — Fri, 11 May 2007 10:10:39 GMT

Logical databases are SAP standard programs that are desinged with selections screens that helps easy retrival and access of data from various tables in and efficient manner.

You can get to know more about the logical databases from the SAP documentation or the following links.

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.

Advantages of Logical database -

1) No need of programming for retrieval , meaning for data selection

2) Easy to use standard user interface, have check completeness of user input.

Disadvantages

1) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower.

GO THROUGH this -

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

<b>USE TCODE SE36 to create new logical database</b>

Re: logical database,

Former Member — Fri, 11 May 2007 10:10:39 GMT

Hi,

pls go through

Advantages of Logical database -

1) No need of programming for retrieval , meaning for data selection

2) Easy to use standard user interface, have check completeness of user input.

Disadvantages

1) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower.

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

pls give reward if it helpful

Thanks

Vana

Re: logical database,

Former Member — Fri, 11 May 2007 10:12:33 GMT

Logical Database - SE36

Reading a SAP standard logical database in your ABAP/4 program.

start-of-selection.

get is equal to select * from....

get mdkp.

check field-name.

get mdtb.

check field-name

end-of-selection.

ALL THE STRUCTURE IS PREDEFINED IN IT.. JUST U NEED TO MODIFY THE EXISTING STRUCTRE ACCORDING TO UR REQUIREMENT.

THE ESENTISL THINGS ARE GET AND PUT PARAMETERS

Re: logical database,

Former Member — Fri, 11 May 2007 10:13:14 GMT

Hi Vijay,

check this:

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

Re: logical database,

Former Member — Fri, 11 May 2007 10:18:20 GMT

thanks guys