Skip to Content
author's profile photo Former Member
0
Former Member

extracting LDB

Posted on Jan 06, 2005 at 04:49 AM 72 Views

Hi,

Can you please tell me how to extract a LDB from R/3 using Generic data extraction?

And one more doubt,

When we are extracting data from R/3, with which layer of R/3(Application/Database) our BW system interacts?

In R/3 where(In Application layer/Database layer) LDBs stored? How BW accesses LDBs?

Thanks

Surya.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2005 at 09:47 AM
    2

    Hi Surya,

    there are two ways of using a logical database: either by linking it with an executable program or by using the function module LDB_PROCESS in any ABAP program.

    You can use directly these methods in your generic extractor or you can fill before a table and then build a datasource on it.

    A logical database is made up of three components (a structure that defines the data view of the logical database, a selection screen and a database program that contains the ABAP statements used to read the data and pass it to the user of the logical database)...as you can understand, LDBs are not really physical DB, but only logical view based on a foreign key relationships between hierarchical tables in the R/3 System.

    Hope it helps.

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 06, 2005 at 11:29 AM

      Ok,

      LDB is a logical view (in application layer) of data contained in database layer (that consists of a central database system containing ALL of the data in the R/3 system !).

      When you extract your data from BW, both Application Layer and Database Layer are involved (Presentation Layer too if you use the GUI): the application layer of an R/3 is made up of the application servers and the message server; application programs (as our extraction pgm) run on application servers that communicate with the database (layer) thanks to work processes...

      Hope now is clearer...

      Bye,

      Roberto

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.