Reg. Logical Database

[Former Member]

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]

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]

Hi

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]

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]

This was Answered