Logistics Data Extraction Configuration
Below figure illustrates the logistics data flow from ECC tables to BW
Customizing Cockpit: LBWE
The extraction structure and DataSources are maintained in the logistics extraction structures’ Customizing cockpit in transaction SBIW.
Maintain Extraction Structure: Example
During this step, one can select which fields needs to be transferred to BW. One can add or remove fields from the extract structure.
The extract structure for LO cockpit cannot be enhanced using SAPI function enhancement. Instead one can assign fields from communication structure or use enhancement options provided by LIS communication structure.
The logistics extraction structure customizing cockpit (LBWE) contains following functionality:
- Maintaining extraction structure
- Maintenance of Datasources
- Activation of updating
- Job control
- Update mode
- Deleting content from restructuring tables (setup tables)
Maintaining Extraction Structure:
The extraction structure is filled with the assigned communication structures. You can only use selected fields from
the communication structures. SAP already delivers extraction structures, which you can also enhance. After you set up the extraction structure, the system automatically generates it.
Maintenance of DataSources:
Here you can select field if any should be hidden or if any should be allowed for selection of values.
Activation of updating:
Activate so that the structures start filling with data (either through online jobs or set up table filling)
Schedule jobs to run in background to fill the delta queue
Here you can set how data is updated to delta queue.
Set up tables are filled which are read during initialization. To enable the restructuring to be restarted after termination, assign a name to each background run of filling the set up tables.
The restructuring should run in the background.
Deleting content from the restructuring tables:
Always delete set up tables before filling them.
Maintaining DataSources (2):
There is a DataSource (for example, 2LIS_11_VAITM) with extraction structure (for example, MC11VA0ITM) in the OLTP system. A maintenance screen is displayed in which you can assign other properties to the fields of the extraction structure.
The following options are available:
● Selection fields
● Hide fields
● Cancellation fields (field is inverted when canceled (*-1))
Logistics Data Extraction to SAP BW
It is important that no one generates or changes application data during the initialization phase.
By using selective initialization of the Delta Process, the time needed to suspend application loading can be minimized.
When you extract transaction data with the LO method, you need a restructuring.
The data is stored in cluster tables (_SETUP) from where they are read during the initialization run.
Filling the Restructuring Table
The restructuring process fills restructuring tables that are read during the initialization.
SAP recommends that you run this in simulation mode beforehand (the simulation mode is only possible in some application areas: SD customer sales orders, LE deliveries, SD billing documents).
A full update into SAP BW is also performed with the restructuring tables.
DTP: Delta Initialization
If you want to transfer data in delta mode, the process must be initialized at some point. To do this, simply run the DTP with Extraction Mode set to Delta . Assuming you do want to transfer data, do not select Data Init Without Data .
LO Cockpit Update Modes
The LO Cockpit has the following Update Mode options:
● Direct Delta
● Queued Delta
● Unseralized V3 update
With this update mode, the extraction data is transferred directly to the delta queue with
every document posting. The sequence of the transfer therefore corresponds with the
chronological order of data creation.
With queued delta, new and changed records are collected in an Extraction Queue and then
updated to the Operational Delta Queue with an update collection run. Depending on the
application, up to 10,000 records can be included in a LUW (Logical Unit Of Work) in the delta
queue per DataSource.
The logistics queue overview function (transaction LBWQ) is available for monitoring the
Unserialized V3 Update
The extraction data is written to update tables with V3 update mode without consideration of sequence when transferred to ODQ.
Note: This method is generally not used.
Steps for LO data extraction
- Transfer LO datasource from BI content (RSA5 and RSA6)
- Maintain the extract structure (tcode LBWE)
- Maintain the datasource and generate it again.
- Create datasource in ODP SAP source system
- Maintain aDSO
- Maintain transformation between datasource and aDSO
- Create a DTP with Extraction Mode set to Delta for example
- Set the extraction structure for updating to active (transaction LBWE).
- Fill the restructuring table (OLI*BW)
- Select the update method (V3 or direct delta)
- Execute the DTP to update from set up tables
- Start V3 collection run (tcode LBWE) (this step is not required for direct delta update mode)
- Schedule the Delta DTP in a process chain.
- Delete the contents of the set-up table. (tcode LBWG)