what is s table in lo extraction

[Former Member]

hi this is narendra,

i have a doubt ,is there any 's' table in lo cockpit,if it ie there can u pls help me out.

[chemicala_srimallikarjuna]

Hi,

Setup Tables:

It contains the initial Data which you need to pull from r/3. ( Nite : This does not contain the data)Setup tables are kind of interface between the application tables and extractor. LO extractor takes data from set up table while initalization and full upload and hitting the application table for selection is avoided. As these tables are required only for full and init load, you can delete the data after loading in order to avoid duplicate data. Setup tables are filled with data from application tables.The setup tables sit on top of the actual applcation tables(like VBAK,VBEP etc).During the Setup run, these setup tables are filled. Normally it's a good practice to delete the existing setup tables before executing the setup runs so as to avoid duplicate records for the same selections.part of dat-flow in LO extraction.Without setup tables you cannot extract data into BW in LO cockpit.For generic the data flow is different.Setup tables has got nothing to do in generic extraction.In Generic data is extracted directly from your table/view/FM.where as in LO,when you are loading first time data into BW using LO the system picks data from setup tables,this is to avoid not to disturb your applicationtables(databasetables) as it causes heavy burden on your system.we usually fill setup tables in the night times as it usually takes long time to fill and it locks all the users not to create any further records at the time of extraction.So we give termination time till next day before business hours start.

The init loads in BW pull data from the set up tables. The setup tables are only used in case of first init/full loads.You can delete setup tables by using t-code-LBWG Give application as 03 for MM and 11 for SD and give name of run and date of termination in future(preferably the next morning date).

T-code for filling setup tables

OLI7BW-SD Sales

OLI8bw-SD deliveries/shipping

OLI9BW-SD Billing

Significance :

Please refer to the attached link which explains most of it..

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

Chek this blogs from Roberto for LO:

/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

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

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Also go through this link to know the procedure step by step

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

Also the How to docs:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

BI content:

http://help.sap.com/saphelp_nw2004s/helpdata/en/17/cd5e407aa4c44ce10000000a1550b0/frameset.htm

Hope This Helps.

Regards,