logical database,

[Former Member]

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

regards

vijay

[amit_khare]

Check the threads -

Regards,

Amit

[Former Member]

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>

[Former Member]

Hi,

pls go through

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 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

[Former Member]

Logical Database - SE36

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.

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

[Former Member]

Hi Vijay,

check this:

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

[Former Member]

thanks guys