Logical Database?

[Former Member]

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

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

[Former Member]

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.

[suresh_datti]

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

[Former Member]

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)

[Former Member]

Thank You Amit.. n thank you all.