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

relation between extract structure, ds, delta queue...

hi experts,

when i extract logistic data from r3, i am confused by some many concept like extract structure, qrfc, central delta management, delta queue and so on.

i want to know the data flow when extracting logistic data.

1> data generate by operation loaded into (where?), and the loaded method is set according the update method (direct, queue, V3).

2> when scheduled in LBWE (by hand or periodly), the data flow from (where?) into (where?)

3> when loaded by infoPackage, data flows from extract structure(i regard it a type of table which stores the data) via data source (a structure) to BW. so if some fields lie in extract structure but not in data source, i should enhance the datasource, right?

4> the update method is useful just to logistic data, and useless to other data, eg financial data?

5> what is the central delta management?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Feb 27, 2009 at 04:13 AM

    Hi,

    1> data generate by operation loaded into (where?), and the loaded method is set according the update method (direct, queue, V3).

    Once the data will enterd by users then it will goto update Q, then by V3 run it will come to Delta Q, so you load delts from ECC to BW. This is in case of Queued delta selected in LBWE.

    2> when scheduled in LBWE (by hand or periodly), the data flow from (where?) into (where?)

    You can configure DS in LBWE and you can run V3 job in LBWE, if you run the ob then the data will move from Update Q to Delta Q, i.e. SMQ1 to RSA7

    3> when loaded by infoPackage, data flows from extract structure(i regard it a type of table which stores the data) via data source (a structure) to BW. so if some fields lie in extract structure but not in data source, i should enhance the datasource, right?

    If you need extra filed then you can enhace the DataSouce, Structure won't store any data, only table will store teh data.

    4> the update method is useful just to logistic data, and useless to other data, eg financial data?

    For LO only we have V3 jobs.

    5> what is the central delta management?

    I think RSA7.

    Thanks

    Reddy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      see there are three types of delta mode :

      1. Direct delta

      Each document posting is directly transferred into the BW delta queue

      u2022 Each document posting with delta extraction leads to exactly one LUW in the respective BW delta queues

      Transaction postings lead to:

      1. Records in transaction tables and in update tables

      2. A periodically scheduled job transfers these postings into the BW delta queue

      3. This BW Delta queue is read when a delta load is executed.

      2. Queued delta

      Extraction data is collected for the affected application in an extraction queue

      u2022 Collective run as usual for transferring data into the BW delta queue

      Transaction postings lead to:

      1. Records in transaction tables and in extraction queue

      2. A periodically scheduled job transfers these postings into the BW delta queue

      3. This BW Delta queue is read when a delta load is executed.

      3. Unserilized v3 update

      V3 collective run transfers the data to BW Delta queue

      u2022 In contrast to serialized V3, the data in the updating collective run is without regard to sequence from the update tables

      Note: i. Pro 2: In doing so, up to 10000 delta extractions of documents for an LUW are compressed for each Data Source into the BW delta queue, depending on the application.

      ii. Pro 4: Even without a successful initial load and thus no BW delta queue yet available, document postings are already collected in the extraction queue.

      check this links :

      /people/happy.tony/blog/2006/11/24/gist-of-lo-cockpit-delta

      /people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

      /people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

      /people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

      Regards,

      shikha

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2009 at 04:09 AM

    Hi,

    Data source : It extracts the data, but doesn't store data

    Note: What all you see in RSA2 are components of data source

    Extract Structure : It is a part of data source, It tells data source the type of data to be extracted.

    CDM

    This is all about Delta loads(Change Logs). Whwn a new record has appeared in the table after filling etup tables, then the new record will be taken care by Delta loads, this process is called Central delta managment

    CDM update types are : V1, V2, V3(Serialized/un serialized), Direct delta, Queued delta

    Go through following blogs

    [https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1096] [original link is broken] [original link is broken] [original link is broken];

    [https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1183] [original link is broken] [original link is broken] [original link is broken];

    Add a comment
    10|10000 characters needed characters exceeded

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.