logical database names

[Former Member]

hi experts,

pls give me the main logical databases names used for taking reports using SAP query in sq02.

ex hr- pnp,material ckm etc

[suresh_datti]

You can do a look up( F4) in TCode SE36.

~Suresh

[Former Member]

Hi

Check the tables related to LDB's

LDBS

LDBT

T0220

see the doc on LDB

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 points for useful Answers

Regards

Anji

[Former Member]

I have used few LDB's :

BMM, LMM, LNM, MRM, PGQ -> these are related material document(MKPF Table)

Just look at SE36 or SLDB Transaction -> press f4 ( you will get many )

AAV Logical Database RV: Sales Documents

CKS MiniApp. for the Calculator: Sales Order Data

CKS_WAO MiniApp: Sales Order Items to be Processed

PSJ Project system

SD_ORDER Logical database for inquiries, contracts

SD_SALES_DOCUMENT Logical database for inquiries, contracts

VAV Logical Database RV: Sales Documents

VC1 List of Sales Activities

VC2 Generate Address List

Look the below thread.

https://forums.sdn.sap.com/click.jspa?searchID=3529375&messageID=3198627

Thanks

Seshu