SAP BW LO Cockpit 数据抽取

转载： http://blog.sina.com.cn/s/blog_5d3b01030100jf34.html

1. Data Flow



2. Steps

3.Roberto Negro Blogs about Logistic cockpit
a) V3 Update, the 'Serializer': http://weblogs.sdn.sap.com/pub/wlg/1096
b) V3 Update, when some problems can occur...: http://weblogs.sdn.sap.com/pub/wlg/1106
c) the new update methods: http://weblogs.sdn.sap.com/pub/wlg/1183

4. Relevant T-Codes
a) Initializtion
LBWE: Maintain Extract Structure, DataSource, Active Status, Job Control, Update Mode

SBIW, then follow tree menu path: Settings for App-Specific DS(PI) -> Logistics -> Managing Extract Structures -> Initialization -> App-Specific Setup of Statistical Data -> Choose XX Application -> Delete/Fill Setup(reconstructing) Table content

RSA3: Check content of setup table

b) Delta upload
SM13: Display update table/Extraction Queue content
RSA7: Display Delta Queue content
LBWE

5. LO Cockpit Step By Step
Cite From: http://sap-img.com/business/lo-cockpit-step-by-step.htm

LO EXTRACTION
- Go to Transaction LBWE (LO Customizing Cockpit)
1). Select Logistics Application
SD Sales BW
Extract Structures
2). Select the desired Extract Structure and deactivate it first.
3). Give the Transport Request number and continue
4). Click on `Maintenance' to maintain such Extract Structure
Select the fields of your choice and continue
Maintain DataSource if needed
5). Activate the extract structure
6). Give the Transport Request number and continue

- Next step is to Delete the setup tables
7). Go to T-Code SBIW
8). Select Business Information Warehouse
Setting for Application-Specific Datasources
Logistics
Managing Extract Structures
Initialization
Delete the content of Setup tables (T-Code LBWG)
Select the application (01 – Sales & Distribution) and Execute

- Now, Fill the Setup tables
9). Select Business Information Warehouse
Setting for Application-Specific Datasources
Logistics
Managing Extract Structures
Initialization
Filling the Setup tables
Application-Specific Setup of statistical data
SD Sales Orders – Perform. Setup (T-Code OLI7BW)
Specify a Run Name and time and Date (put future date)
Execute

- Check the data in Setup tables at RSA3
- Replicate the DataSource

Use of setup tables:
You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.
Full loads are always taken from the setup tables

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25433510/viewspace-694134/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25433510/viewspace-694134/