Lo Cockpit. Activation of Extract Structures

[Former Member]

Hello all

I have soome question on LO and I hope someone can help me out.

1. what happens exactly when an extract structure is activated?

I believe that extract struct tables are generated which will receive any OLTP transaction or setup table data.

In the case of setup tables I beleive these tables are filled using OLI*BW run ok. Why do we need setup tables? Why can't we directly load data into extract struct tables generated? instead of setup tables.

In the whole process where do the setuptables fit in? before or after extract struct

During update run the V3 or queued delta gets data from SM13 or LBWQ. where does the extract struct come in during this case.

I know there is something that I am missing out in the whole process. If anyone can clarify me on this, I would really appreciate it.

Thanks for any help.

Raj

[Former Member]

Hi Raj,

since LC mechanism doesn't permit to access directly onto application tables for performance reason (VBAK, VBAP and son for sales order, for example..), in order to load all the historycal data you need to load setup table (and related program below OLI*BW transaction in this case select data from application tables).

Extract structure works during every data upload (this is the reason for which OLI* transaction checks if there is some active extract structure)...

Hope now is clearer...

Bye,

Roberto

[Former Member]

Hi Robert

That was very helpful.

Can you tell me how does extract structures fit in Delta Upload. The data gets loaded into the Update Table sm13 and then the V3 collective run gets the data from there to delta que RSA7. what is the role played by the extract struct in here.

Thanks Raj

[Former Member]

Hi Raj,

if you want to better understand where extract structures play your roles, take a look to OSS Note 328181 'Changes to extract structures in Customizing Cockpit'...by analyzing every object/process affected by a changes to extract structures you will be able to find an answer to your doubt...anyway refer to MCEX_UPDATE* FM to see some sample code and MCEX_BW_LO_API...

Hope it helps!

Bye,

Roberto

[Former Member]

Hi Robert

Please help me