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

[Former Member]

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?

[former_member181964 · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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];