topic Re: Reg. Logical Database in Application Development and Automation Discussions

Reg. Logical Database

Former Member — Fri, 25 May 2007 11:53:13 GMT

Hi Experts,

This is with reference to Logical Database (LDB) , I have some Doubts\Clarifications ,

1, What is the Significance of the Hierarchy of LDB structure (I.e Nodes\Tables).?

2, How to find the relation between to Nodes\Tables that is with which field references the tables were interlinked.

Thanks in Advance,

Regards,

Sen

suresh_datti — Fri, 25 May 2007 12:04:07 GMT

Use the Tcode SE36 & display any LDB & use the radiobuttons to know more about the LDB structure,Selections,Documentaion,Databse Program etc.

~Suresh

Former Member — Fri, 25 May 2007 12:04:14 GMT

The Hierarchy/Tree structure of tables indicates the order of database tables data fetching. As per the order it should fetch.

For example take sales order 3tables VBAK,VBAP, VBEP

so the data has to be fetched from VBAK first, then VBAP and lastly from VBEP.

You can't fetch the data from VBEP starting. it is wrong.

Always tables were interlinked with the correct Keys fields.

for example if you take the above tables VBAK and VBAP are linked with VBELN field

and VBAP and VBEP are linked with VBELN and POSNR fields

So always LDB is created with such a linking tables only, not with any table just like that.

Reward points if useful

Regards

Anji

anversha_s — Fri, 25 May 2007 12:13:12 GMT

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.

Rgds

Anversha

Former Member — Fri, 08 Jun 2007 05:03:22 GMT

This was Answered