2-1 Before you are able to fill the InfoCube with data, you need to set up the delta update function in the OLTP system. A delta initialization run then updates the data from the info structure into the BW.
2-1-1 On the Source Systems tab in Administrator Workbench, right-click on T90CLNT090 and choose the ‘Customizing for Extractors’ option to call up the Implementation Guide for the SAP OLTP source system.
2-1-2 Generate the delta update for your information structure S###. Describe the features of the update programs of the information structure.
The update programs have been regenerated and extended to include the delta update for BW. If you place your cursor over the name of a program and click on the ‘Display Generated Object’ option, the program is displayed.
2-1-3 Once it has been generated, activate the delta update. What settings are made by this report?
2-1-4 Load the data from your InfoStructure from the OLTP system to the BW system. You need to create an InfoPackage with the name ‘Delta
Initialization’ for your InfoSource ‘GRxx_2LIS_02_MM’ and the source system ‘T90CLNT090’. Make sure that the update mode is set to
‘Initialization of the delta method’. Schedule the InfoPackage to be loaded immediately. Use the Monitor function to monitor the data loading process.
2-1-5 Once the data has been loaded successfully, you can take a closer look at the data in the InfoCube. Choose the ‘Maintain InfoCube Contents’ function in the InfoCube tab.
2-2 Once you have completed the delta initialization for your InfoSource, you can carry out a delta update. You have to create a purchasing document (purchase order) in the OLTP to fill your InfoStructure.
2-2-1 First, however, you have to activate the InfoStructure for the update method in the OLTP system so that the data can be updated to the InfoStructure.
Choose the asynchronous V2 update.
2-2-2 In the OLTP system, create a purchase order document with the following data:
Field name Enter
Company code 1000
Vendor 1000
Document type NPO (normal purchase order)
Purchasing organization 1000
Purchasing group 026
Plant
(on item overview section of PO)
1200
Storage location
(on item overview section of PO)
0001
Material
(on item overview section of PO)
M-01 or M-02 or M-03...M-20
Purchase order quantity
(on item overview section of PO)
100
2-2-3 Which control table is updated in the OLTP for the BW delta extraction?
Take a look at the contents of the table using transaction ‘SE16’.
2-2-4 Carry out a delta update in the BW System. Create a new InfoPackage with the name ‘Delta update’ for your InfoSource ‘GR##_2LIS_02_MM’ and the source system ‘T90CLNT090’. Make sure that the update mode is set to
‘Delta update’. Schedule the InfoPackage to be loaded immediately. Use the Monitor function to monitor the data loading process.
2-2-5 Once the data has been successfully loaded, you can take a look at the data in the InfoCube again. Choose the ‘Maintain InfoCube Contents’ function in
© SAP AG BW350 3-55
Solutions
Unit: LIS Data Extraction
Topic: Connecting InfoStructures to BW
1-1 Before you are able to transfer the data from your LIS InfoStructure into BW, you have to prepare it for extraction. You use a program provided with the BW PlugIn to do this. Consult with the trainer before choosing ONE of the numbers for your InfoStructure from the following number ranges. Please do not pick a number at random, because the trainer has to make sure that there is no overlap with other courses that use the same system.
InfoStructure: S850 - S869 InfoStructure: S930 – S949
In the appendix there is an exercise on creating additional LIS structures if needed.
1-1-1 In the Administrator Workbench on the Source Systems tabstrip, open the context menu for the T90CLNT090 source system by right-clicking on it.
Choose the Customizing for Extractors option to display the IMG of the SAP OLTP source system.
BW Administration Administrator Workbench Source Systems Context menu (right mouse click) for source system T90CLNT090 Customizing for Extractors
1-1-2 Display the current settings for the connection between your information structure and the Business Information Warehouse. What information is contained in the log?
Business Information Warehouse Settings for application specific DataSources Logistics Logistics Information System Connect Information Structures (OR) Program RMCSBIWC under transaction SE38.
Field name Input Value
Information structure S###
Display settings Execute
010 Settings for Business Information Warehouse Customizing 011 Information structure: S###
013 LIS environment has not been set up.
003 InfoSource 2LIS_02_S### has not been generated.
1-1-3 Set up the LIS environment for your info structure S###.
Return to the previous screen.
Field name Input Value
Information structure S###
Set up LIS Environment Execute
1-1-4 What happens after you have configured your LIS environment?
Once you have configured the LIS environment, two transparent tables and one extract structure are generated for this spezial InfoStructure. You can use transaction SE11 in the OLTP system to display the tables
‘S###BIW1’, ‘S###BIW2’, and the structure ‘S###BIWS’ (make sure you change the data type to ‘Structure’ so that S##BIWS is displayed).
1-1-5 Generate the DataSource for your information structure S###. Use the default selection fields.
Return to the previous screen.
Field name Input Value
Information structure S###
Generate DataSource
Execute (As with all transport pop-ups, select only the ‘Local Object’
setting.) Save
Respond ‘No’ to the question; ‘1.2B BW systems connected, generate 1.2B
© SAP AG BW350 3-57 1-2 Once you have defined your DataSource at the OLTP level, you can transfer the
information to the BW system by replicating the DataSource and maintaining the communication structure and the transfer rules.
********** INSTRUCTOR ONLY **********
1-2-1 Your instructor will select the T90CLNT090 source system in the Administrator Workbench/Source Systems tab and upload the metadata.
BW Administration Administrator Workbench Source Systems Context menu (right mouse button) on source system ‘T90CLNT090‘
DataSource Overview Context menu (right mouse button) on Application Component MM (not MM-IO) Replicate DataSources
***********Exercises Continues Below ************
1-2-2 Find your DataSource 2LIS_02_S### and create the InfoSource for the DataSource.
Administrator Workbench Source Systems
Context menu (right mouse-click) on source system ‘T90CLNT090‘
DataSource Overview SAP Application Component: MM
Find
Field name Input Value
Search string 2LIS_02_Sxxx
Find
Expand tree
Context menu (right mous- button) on DataSource ‘2LIS_02_S###‘
Assign InfoSource
Field name Input Value
Other
InfoSource GR##_2LIS_02_MM
Select the ’Create’ icon.
Field name Input Value
InfoSource GR##_2LIS_02_MM
Long description GR##_2LIS_02_MM Template InfoSource
Click on OK /press the ‘Enter’ key.
The ”InfoSource to Data Source” dialog box opens.
Confirm the dialog box (ignore any warnings that are displayed ).
Confirm the message ‘Save assignment DataSource ‘2_LIS_02_S###’ to InfoSource ‘GRxx_2_LIS_02_MM?’ with Yes.
1-2-3 Before you maintain the communication structure, you must check that the R/3 field names are mapped properly to the BW InfoObjects. Many fields are not assigned automatically OR THEY MAY BE MAPPED TO THE WRONG INFOOBJECT
In the InfoObject – Field Assignment area of the Transfer Rules screen, check that the following InfoObjects are assigned to the following fields.
Leave the default assignments as they are, because these are not used in our communication structure.
When you have finished mapping the fields listed below to the
corresponding InfoObjects, you need to access the communication structure and transfer across ONLY the InfoObjects listed here, and then activate.
Fill in the InfoObject or change it where appropriate to enable you to complete the following assignments:
InfoObject Field name
0UNIT Base Unit of Measure
0PURCH_ORG Purchasing Organization
0CURRENCY Local Currency
0VENDOR Vendor Account Number
0MATL_GROUP Vendor Material Group
0MATERIAL Material Number
0QUANTITY Purchase Order Quantity
© SAP AG BW350 3-59
*Ignore any messages instructing you to check a log. This only refers to an inconsistency between the ‘matnr’ field and the ‘0material’ InfoObject.
The ‘matnr‘ R/3 field has a conversion routine for the entry, but BW does not need this.
Choose the ‘Expand Communication Structure’ icon to open the
‘Communication Structure’ section of the screen.
Select ONLY THE 13 InfoObjects that you mapped above, to be moved to the communication structure.
Move them to the left (into the communication structure )by selecting them and then choosing the
“Transfer Selected InfoObjects” icon.
Activate
1-2-4 Maintain the transfer rules for the assigned source system T90CLNT090 of your InfoSource.
You can ”collapse” the communication structure section of the screen.
The rest of the exercise focuses on the ’transfer rules’ section of the screen.
Note that only the period ‘day’ is updated in your LIS InfoStructure S###. If you want ‘Week’ and ‘Month’ to be filled in the BW InfoCube, the period must be converted in the transfer rules. You therefore have to specify special transfer routines for the InfoObjects 0CALWEEK (calendar year / week) and 0CALMONTH (calendar year / month).
1-2-5 Create a transfer routine and call it ‘Week_from_day GR##’ for the InfoObject 0CALWEEK. In this case, the calendar week has to be
determined from the calendar day using the DATE_GET_WEEK function module.
Select the ‘Calendar year / week’ line Choose the pushbutton ’TP‘
Click on the ‘Local routine’ radio button and then on the ‘Create’
icon.
Field name Value
Transfer Routine Week_from_day GR##
First, click on the icon to select all the fields, and then click on the corresponding radio button OR leave the “Selected Fields” radio button checked and select the 0CALDAY InfoObject, since this is really the only InfoObject you will need as input for the routine.
Confirm you entry.
Position the cursor one line after the line with the title:
“*$*$ begin of routine - insert your code only below this line *-*
(It should be round about 96, but this could change)
Add 7 lines (either press the ’Enter’ key 7 times or use the appropriate icon.)
Delete the ”Result =” line
Type in the following ABAP 4 code.
*$*$ begin of routine - insert your code only below this line *-*
call function 'DATE_GET_WEEK' exporting
date = tran_structure-sptag importing
week = result exceptions
date_invalid = 1 others = 2.
* Return code <> 0 means skip whole data package !!!
returncode = 0.
*$*$ end of routine - insert your code only before this line *-*
Check and save your routine (remembering to put a space before and after the equals sign - ”=”.)
© SAP AG BW350 3-61 1-2-6 Create a transfer routine and call it ‘Month_from_day GR##’ for the
InfoObject 0CALMONTH. In this case, the calendar month has to be determined from the calendar day field.
In exactly the same way as above, select the ‘calendar year/month’ line.
Choose the ‘TP’ pushbutton.
Click on the ‘Local routine’ radio button and then on the ‘Create’
icon.
Field name Value
Transfer Routine Month_from_day GR##
First, click on the icon to select all the fields, and then click on the corresponding radio button OR leave the “Selected Fields” radio button checked and select the 0CALDAY InfoObject, since this is really the only InfoObject you will need as input for the routine.
Value
Type in the following ABAP 4 code. Change the “result = “ line in exactly the same way as above.
*$ begin of routine - insert your code only below this line *-*
result = tran_structure-sptag(6).
* Return code <> 0 means skip whole data package !!!
returncode = 0.
*$*$ end of routine - insert your code only before this line *-*
Check and save your routine.
Check Save Value
1-2-7 Save and activate your transfer rules.
Save Activate
1-3 In the next step, you are going to create an InfoCube that contains data from the generated InfoSource.
1-3-1 Before you create the InfoCube, create an InfoArea ‘IAGR##’ with the description ‘InfoArea GR##’ under InfoArea Customer Training BW Customer Training BW220 – OLTP Extraction.
BW Administration Administrator Workbench Data Targets Expand ‘InfoArea Customer Training’ in the hierarchy tree
Expand BW Customer Training Context menu (right mouse-button) on InfoArea ‘BW220 Create
Field name Value
InfoArea IAGR##
Description InfoArea GR##
Value
1-3-2 Create an InfoCube ‘LISCUBE##’ with the description ‘GR## LIS Cube’ in the InfoArea with the name ‘InfoArea GR##’.
Context menu (right mouse- button) on InfoArea ‘InfoArea GR##’
Create InfoCube
Field name Input Value
InfoCube LISCUBE##
Description GR## LIS Cube
Choose ‘BasicCube’ as the InfoCube type Create .
1-3-3 In the ‘Characteristics’ tab of your InfoCube, select all the characteristics for the InfoSource ‘GRxx_2LIS_02_MM’ and copy all the InfoObjects to your InfoCube structure with the exception of ‘0REVERSEDOC’ and
‘0VTYPE’.
InfoSource
Position the cursor over InfoSource ‘GRxx_2LIS_02_MM’.
© SAP AG BW350 3-63 1-3-4 Distribute the characteristics of your InfoCube among the dimension tables
as follows:
Dimension Characteristics
Vendor 0VENDOR
Material 0MATERIAL material number
Purchasing area 0PURCH_ORG Purchasing organization 0MATL_GROUP Material group
Version 0VERSION: Version
Plant 0PLANT plant
‘Dimension’ pushbutton in the characteristics tab Choose ‘Create’
Field name Long description
LISCUBE##1 Vendor
Choose ‘Execute’
Field name Long description
LISCUBE##2 Plant
Choose ‘Create’
Field name Long description
LISCUBE##3 Material
Choose ‘Create’
Field name Long description
LISCUBE##4 Purchasing area
Choose ‘Create’
Field name Long description
LISCUBE##5 Version
‘Assign’ tab
Select 0VENDOR place cursor on the ‘Vendor’ dimension Choose
‘Assign’
Select 0PLANT place cursor on the ‘Plant’ dimension Choose
‘Assign’
Select 0MATERIAL cursor on the ‘Material’ dimension Choose
‘Assign’
Select 0PURCH_ORG, 0MATL_GROUP cursor on the ‘Purchasing Area’ dimension Choose ‘Assign’
Select 0VERSION place cursor on the ‘Value/Version’ dimension Choose ‘Assign’
Continue
1-3-5 Under the Key Figures tab, select the InfoSource ‘GRxx_2LIS_02_MM‘ as a template and copy all of the key figures into the InfoCube structure.
‘Key figures’ tab Select both key figures
Transfer fields
1-3-6 Under the Time Characteristics tab, select ‘Calendar day’, ‘Calendar year / week’, and ‘Calendar year / month’.
‘Time characteristics’ tab
Select the ‘0CALDAY’, ‘0CALWEEK’, and ‘0CALMONTH’ fields Transfer fields
1-3-7 Check your InfoCube and activate it.
Check Activate
1-3-8 Create update rules for the InfoSource ‘GRxx_2LIS_02_MM’ of your InfoCube. You should not need to define any settings here. Check and activate the update rules.
Find your InfoCube in the data targets tree Context menu (right mouse-button) on InfoCube ‘GR## LIS Cube’ Create update rules
Field name Value
INFOSOURCE ‚GRxx_2LIS_02_MM’
OK Check Activate
© SAP AG BW350 3-65
Unit: LIS Data Extraction Topic: Filling InfoCubes
2-1 Before you are able to fill the InfoCube with data, you need to set up the delta update function in the OLTP system. A delta initialization run then updates the data from the InfoStructure into the BW.
2-1-1 On the Source Systems tab in Administrator Workbench, right-click on T90CLNT090 and choose the ‘Customizing for Extractors’ option to call up the Implementation Guide for the SAP OLTP source system.
BW Administration Administrator Workbench Source Systems Context menu (right mouse-button) on source system ‘T90CLNT090’
Customizing for extractors
2-1-2 Generate the delta update for your information structure S###. Describe the features of the update programs of the information structure.
In the OLTP IMG (transaction code SBIW) Business Information Warehouse Settings for Application-Specific DataSources Logistics
Logistics Information System Connect Information Structures
Field name Value
Information structure S###
Generate update Execute
The update programs have been regenerated and extended to include the delta update for BW. If you place your cursor over the name of a program and click on the ‘Display Generated Object’ option, the program is displayed.
Go back to the main program.
2-1-3 Once it has been generated, activate the delta update. What settings are made by this report?
Field name Value
Information structure S###
Activate/deactivate Execute
The OLTP system has created an entry in the ‘TMCBIW’ control table automatically. Using transaction ‘SE16’ in the OLTP system, you can see that the ‘BIW active’ field for your InfoStructure now has the value ‘X’
and the ‘BIW status’ field has the value ‘1’ (refers to table S###BIW1).
2-1-4 Load the data from your InfoStructure from the OLTP system to the BW system. You need to create an InfoPackage with the name ‘Delta
Initialization’ for your InfoSource ‘GRxx_2LIS_02_MM’ and the source system ‘T90CLNT090’. Make sure that the update mode is set to
‘Initialization of delta method’. Schedule the InfoPackage to be loaded immediately. Use the Monitor function to monitor the data loading process.
BW-Administration Administrator Workbench InfoSources Expand ‘Application Components’ ‘Material Management’
‘GRxx_2LIS_02_MM’ context menu (right mouse-button) on source system ‘T90CLNT090‘ Create InfoPackage
Field name Value
InfoPackage name Delta initialization Save
Field name Value
Data target InfoCube and PSA
‘Update Parameters’ tab
Field name Value
© SAP AG BW350 3-67 2-1-5 Once the data has been loaded successfully, you can take a closer look at the
data in the InfoCube. Choose the ‘Maintain InfoCube Contents’ function in the InfoCube tab.
BW Administration Administrator Workbench Data Targets Expand the ‘Customer Training’ InfoArea BW Customer Training
‘BW220 OLTP Extraction’ ‘InfoArea GR##’ in the hierarchy tree Context menu (right mouse-button) on InfoCube ‘GR## LIS Cube’
Manage.
Select your InfoCube
Choose ‘Contents’ at the top of the screen.
Click on the ‘Field selection for output’ button to choose the fields that you want to appear in the result.
Execute
Execute
2-2 Once you have completed the delta initialization for your InfoSource, you can carry out a delta update. You have to create a purchasing document (purchase order) in the OLTP to fill your InfoStructure.
2-2-1 First, however, you have to activate the InfoStructure for the update method in the OLTP system so that the data can be updated to the InfoStructure.
Choose the asynchronous V2 update.
BW Administration Administrator Workbench Source Systems Context menu (right mouse-button) on source system ‘T90CLNT090‘
Customizing for Extractors in the OLTP system (Transaction /nOMO2) OR Business Information Warehouse Settings for Application-Specific DataSources Logistics Logistics Information System Activate Update
Place cursor on Purchasing Select ‘Choose’
Double -click on InfoStructure S###
Field name Value
Asynchronous update (2) OK
Save
Answer ‘Yes’ to the dialog box that appears..
2-2-2 Create a purchase order document with the following data in the OLTP system:
Field name Value
Company code 1000
Vendor 1000
Document type NPO (normal purchase order)
Purchasing organization 1000
Purchasing group 026
Plant
(on item overview section of PO)
1200
Storage location
(on item overview section of PO)
0001
Material
(on item overview section of PO)
M-01 or M-02 or M-03...M-20
Purchase order quantity
(on item overview section of PO)
100
OLTP System Logistics Material Management Purchasing Purchase orders Create Vendor/Supplying Plant known
Create the purchase order with the values specified above.
Some data is on the item overview section.
Note: A net price of 100$ may be required. Type in this amount if necessary.
Save
2-2-3 Which control table is updated in the OLTP for BW delta extraction? Take a look at the contents of the table using transaction ‘SE16’.
Display the contents of the control table ‘TMCBIW’ for your InfoStructure ‘S###’.
© SAP AG BW350 3-69 The ‘BIW status’ field contains the value ‘1’, which means that the table
‘S###BIW1’ will be updated.
Transaction ‘SE16’
Field name Value
Table name S###BIW1
Value Execute
All the purchase documents that are new since the last time the update was activated in the OLTP system are updated in the table.
2-2-4 Carry out a delta update in the BW system. Create a new InfoPackage with the name ‘Delta update’ for your InfoSource ‘GR##_2LIS_02_MM’ and the source system ‘T90CLNT090’. Make sure that the update mode is set to
‘Delta update’. Schedule the InfoPackage to be loaded immediately. Use the Monitor function to monitor the data loading process.
BW-Administration Administrator Workbench InfoSource Expand ‘Application component’ ‘Material Management’
GR##_2LIS_02_MM Context menu (right mouse-button) on source system ‘T90CLNT090‘ Create InfoPackage
Field name Value
InfoPackage name Delta update Save
‘Update Parameters’ tab
Field name Value
Delta update
‘Schedule’ tab
Field name Value
Start loading data immediately Select ‘Start’
Monitor
Select the ‘Execute’ function
2-2-5 Once the data has been loaded successfully, you can take a look at the data
2-2-5 Once the data has been loaded successfully, you can take a look at the data