ldb1

[Former Member]

1- What are logical databases? What are the advantages/disadvantages of logical databases?

2- Is a logical database a requirement/must to write an ABAP query?

3 -How do you document ABAP programs?

4- What is output determination?

[RichHeilman · Accepted solution]

1) Logical databases are special ABAP programs that retrieve data and make it available to application programs. The most common use of logical databases is still to read data from database tables by linking them to executable ABAP programs.

However, from Release 4.5A, it has also been possible to call logical databases using the function module LDB_PROCESS. This allows you to call several logical databases from any ABAP program, nested in any way. It is also possible to call a logical database more than once in a program, if it has been programmed to allow this. This is particularly useful for programs with type 1.

Logical databases contain Open SQL statements that read data from the database. You do not therefore need to use SQL in your own programs. The logical database reads the program, stores them in the program if necessary, and then passes them line by line to the application program or the function module LDB_PROCESS using an interface work area.

2) No, you can code it all yourself.

3) You can use in-line comments

4) Output determination is configuration which tells the system when and how to output paperwork to specific recipients.

Regards,

Rich Heilman

[Former Member · Accepted solution]

Hi,

> 1- What are logical databases? What are the

> advantages/disadvantages of logical databases?

<i>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.</i>

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

> 2- Is a logical database a requirement/must to write

> an ABAP query?

<i>no</i>

> 3 -How do you document ABAP programs?

<i>I would assume that every company has their own templates for documentation.</i>

> 4- What is output determination?

<i>Output determination: What kinda output does a sales/delivery/billing document create and who gets it, where?. For example A partner might get an EDI notification for a sales order just confirmed, whereas a financial/leasing company gets the invoice!</i>

http://www.sap-img.com/sap-sd/sap-sd-interview-questions.htm

Regards,

Ville

[andreas_mann3 · Accepted solution]

Hi,

alternative: fm <b>LDB_PROCESS</b>advantage you can use diff. ldb's in 1 report

Andreas

[Former Member]

Hi,

<b>Logical databases</b> are special ABAP programs that read data from database tables. They are used by executable (type 1) programs. At runtime, you can regard the logical database and the executable program (reports) as a single ABAP program, whose processing blocks are called by the runtime environment in a particular, pre-defined sequence

also Check this link,

<u>http://help.sap.com/saphelp_erp2004/helpdata/en/fc/eb2d4d358411d1829f0000e829fbfe/frameset.htm</u>

Hope it helps u.

Thanks&Regards,

Ruthra