topic Re: Logical Database? in Application Development and Automation Discussions

Logical Database?

Former Member — Wed, 06 Dec 2006 11:03:11 GMT

Can anyone explain, how to create an LDB (Logical Database)?

I need a step by step explanation, if possible with an example.

Re: Logical Database?

Former Member — Wed, 06 Dec 2006 11:04:19 GMT

Hi srihari,

1. A logical database is in fact

a program only.

2. This LDB provides two main things :

a) a pre-defined selection screen

which handles all user inputs and validations

b) pre defined set of data

based upon the user selection.

3. So we dont have to worry about from

which tables to fetch data.

4. Moreover, this LDB Program,

handles all user-authorisations

and is efficient in all respects.

5. tcode is SLDB.

*----

1. To get a taste of it.

2. create a new z program.

3. while creating type PNP

in logical database field.

4. paste this code and execute.

REPORT ABC.

*----

infotypes : 0001.

TABLES : PERNR.

*----

GET PERNR.

WRITE 😕 PERNR-PERNR.

5. The selection screen which u see

is coming from logical database PNP program.

6. Execute

7. U will get a list of pernr.

SAPDBPNP

this is the main program of LDB PNP

which does the main work.

SAPDB + ldb name.

regards,

amit m.

Re: Logical Database?

suresh_datti — Wed, 06 Dec 2006 11:06:26 GMT

Use Tcode Se36 & Pl take a look at this <a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm">SAP Help</a>

~Suresh

Re: Logical Database?

Former Member — Wed, 06 Dec 2006 11:07:39 GMT

HI,

check out these links

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c6/8a15381b80436ce10000009b38f8cf/frameset.htm

Regards,

pankaj singh(syntel)

Re: Logical Database?

Former Member — Thu, 07 Dec 2006 04:10:45 GMT

Thank You Amit.. n thank you all.