Logical database

[Former Member]

Hi,

Can any body give me some idea on 'Logical Database' and it's use

I have the following requirement

a) select bukrs,gjahr,belnr,blart from bkpf where

bukrs=sel.screen-bukrs

gjahr=sel.screen-gjahr

blart='KR'

b) select bukrs,gjahr,belnr,wrbtr,mwskz,koart,lifnr from bseg for all entries of bkpf where

bukrs=bkpf-bukrs

gjahr=bkpf-bukrs

belnr=bkpf-belnr

c) select lifnr,name1,ort01,pstlz from lfa1 for all entries of bseg where

lifnr=bseg-lifnr

for getting the above is it possible by using Logical Database 'BRF' or I have to go for seperate select queries only.

regards

mallik

[Former Member]

hi,

A logical database is a special ABAP/4 program which combines the contents of certain database tables.

Using logical databases facilitates the process of reading database tables.

Main Functions of the logical database PNP:

Standard Selection screen

Data Retrieval

Authorization check

eg: PNP,PAP,APP,PCH.

Regards

Reshma

[Former Member]

HI,

with logical db 'BRF', u cannot do it, because node LIFNR is not under nodes 'BKPF' and 'BSEG' (actlly they all are in the same level).......

u can try with ldb "KDF", but you cant get the reqd Selection screen... so try crating a ldb with 3 nodes like 'BKPF' as root, 'BSEG' at level 1 and 'LFA1' at level 2....

[Former Member]

Hi

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=...

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 if useful

regards

Anji