Logical Database

[Former Member]

Hi !!!!!!!!!

Can You Please Explain about logical database....Where V'll use this in real scenario.

Regards

Sandeep.

[Former Member]

Logical Database is a special abap program where data is retreived from some related tables. this is used coz it provides standard selection screen, automatic authorization checks and reduces code in your program.

eg PNP, PCH, PAP etc

Reward points if helpful

[Former Member]

Hi Sandeep,

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.

Logical database structures

There are three defining entities in an SAP logical database. You must be clear on all three in order to create and use one.

Table structure: Your logical database includes data from specified tables in SAP. There is a hierarchy among these tables defined by their foreign keys (all known to SAP), and you are going to define a customized relationship between select tables. This structure is unique and must be defined and saved.

Data selection: You may not want or need every item in the referenced tables that contributes to your customized database. There is a selection screen that permits you to pick and choose.

Database access programming: Once you’ve defined your logical database, SAP will generate the access subroutines needed to pull the data in the way you want it pulled.

Creating your own logical database

Here’s a step-by-step guide:

1) Call up transaction SLDB (or transaction SE36). The path you want is Tools | ABAP Workbench | Development | Programming Environment | Logical Databases. This screen is called Logical Database Builder.

2) Enter an appropriate name in the logical database name field. You have three options on this screen: Create, Display, and Change. Choose Create.

3) You’ll be prompted for a short text description of your new logical database. Enter one. You’ll then be prompted to specify a development class.

4) Specify a root node, or a parent table, as the basis of your logical database structure. You can now place subsequent tables under the root table as needed to assemble the data object you want. You can access this tree from this point forward, to add additional tables, by selecting that root node and following the path Edit | Node | Create. Once you’ve saved the structure you define in this step, the system will generate the programming necessary to access your logical database. The best part is you don’t have to write a single line of code.

thanks,

Swati