topic Re: logical databases in Application Development and Automation Discussions

logical databases

Former Member — Thu, 21 Jun 2007 05:54:19 GMT

how do i use the select options and parameters from a logical database in my program. i am using logical database QMI on the selection screen of my PM Notifications report.

Re: logical databases

Former Member — Thu, 21 Jun 2007 05:58:59 GMT

Go to SE36 tcode

enter the QMI LDB

see the selections (defined selection screen for that LDB)

you have to write the

LDB statements like GET <table>, GET <table> LATE statements to fetch the data.

where is the need for useing the where condn in your select statements to pass your own parameters?

see the doc

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.

LDB offers an easy-to-use selection screens. You can modify the pre-generated selection screen to your needs. It offers check functions to check whether user input is complete, correct, and plausible. It offers reasonable data selections. It contains central authorization checks for data base accesses. Enhancements such as improved performance immediately apply to all report programs that use the logical database.

Less coding s required to retrieve data compared to normal internel tables.

Tables used LDB are in hierarchial structure.

Mainly we used LDBs in HR Abap Programming.

Where all tables are highly inter related so LDBs can optimize the performance there.

Check this Document. All abt LDB's

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=%2flibrary%2fabap%2fabap-code-samples%2fldb+browser.doc

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

Gothru the blog which provides info on LDB's:

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

Reward points for useful Answers

Regards

Anji

Re: logical databases

Former Member — Thu, 21 Jun 2007 06:00:15 GMT

Hi,

You can check the following link:

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm">Logical Databases</a>

Thanks...

Preetham S

Message was edited by:

Preetham S

Re: logical databases

Former Member — Thu, 21 Jun 2007 06:01:46 GMT

HI,

Go thru the following Link,

http://help.sap.com/saphelp_nw04s/helpdata/en/9f/dba65c35c111d1829f0000e829fbfe/frameset.htm

Regards,

Padmam.

Re: logical databases

jayanthi_jayaraman — Thu, 21 Jun 2007 06:07:52 GMT

Hi,

Include QMI as Logical Database in program attributes.

In the program code, include the statement

tables diqmel.

Then you can use the selections in ldb in the program.The name of those can be get using tcode SE36->Give the name od LDB as QMI and then choose selections.You can see the name as dy_ofn,dy_rst,matnr,etc.,

In your program,you can code as follows.

tables diqmel.

at selection-screen on matnr.

if matnr is initial.

message i000 with 'cannnot be iniital'.

leave list-processing.

endif.