BW (SAP Business Warehouse), SAP BW

MM Extractions

In this document, I will take you through the MM extraction data flow. MM extraction is the combination of both LO Extraction and Standard Extractions.

The data flow is as shown below

BW (SAP Business Warehouse), SAP BW

Pre-requisites:

  1. Make sure that RFC Connection exists between ECC system and BI system
  2. Delete the data from setup tables for ‘03’ application on ECC side (LBWG)
  3. Perform the business content installation for info cube ‘0IC_C03’ on BI side

Steps for MM Extraction:

Go to ECC Side:

  1. Go to RSA5, find the data source 2LIS_03_BX and activate it (If activated
    successfully, it can be seen in RSA6)
  2. Go to LBWE, activate the data sources 2LIS_03_BF and 2LIS_03_UM

Go to SAP BI side:

  1. Go to RSA1
  2. Go to ‘Source Systems’ section, right click on ECC source system and select ‘Display data source tree’
    Right click on ‘MM’ application component and select ‘Replicate Metadata’

Working with data source 2LIS_03_BX:

Go to ECC side:

  1. Fill the setup tables using tcode MCNB

Go to SAP BI side:

  1. Right click on data source and select ‘Create Info package’ (you will observe only ‘Generate Initial Status’ in update tab page of info package), load the data till PSA
  2. Right click on data source and select ‘Create Transformation’, give the target as ‘Info cube’ with technical name (0IC_C03) and create necessary transformation rule types
  3. Activate the transformation
  4. Right click and select ‘Create DTP’ to load the data into info cube
  5. Go to ‘Collapse’ tab page and do not select ‘No marker update’ checkbox and click on
    ‘Release’ button

Working with data source 2LIS_03_BF:

Go to ECC side:

  1. Delete the data from setup tables for ‘03’ application (LBWG)
  2. Fill the setup tables using tcode OLI1BW. Select option ‘Posting date’, give posting date if required and click on ‘Execute’

Go to SAP BI side:

  1. Right click on data source and select ‘Create Info package’ , go to update tab page and select ‘Initialization’ option
  2. Right click on data source and select ‘Create Transformation’, give the target as ‘Info cube’ with technical name (0IC_C03) and create necessary transformation rule types
  3. Activate the transformation
  4. Right click and select ‘Create DTP’ to load the data into info cube
  5. Go to ‘Collapse’ tab page and select ‘No marker update’ checkbox and click on ‘Release’ button
  6. Create delta Info package to load the delta records till PSA
  7. Create another DTP to load the delta records into info cube, go to ‘Collapse’ tab page and do no select ‘No marker update’ checkbox and click on ‘Release’

Working with data source 2LIS_03_UM:

Go to ECC side:

  1. Delete the data from setup tables for ‘03’ application (LBWG)
  2. Fill the setup tables using tcode OLIZBW. Give ‘Company Code’, select option ‘Posting date’, give posting date if required and click on ‘Execute’

Go to SAP BI side:

  1. Right click on data source and select ‘Create Info package’ , go to update tab page and select ‘Initialization’ option
  2. Right click on data source and select ‘Create Transformation’, give the target as ‘Info cube’ with technical name (0IC_C03) and create necessary transformation rule types
  3. Activate the transformation
  4. Right click and select ‘Create DTP’ to load the data into info cube
  5. Go to ‘Collapse’ tab page and select ‘No marker update’ checkbox and click on ‘Release’ button
  6. Create delta Info package to load the delta records till PSA
  7. Create another DTP to load the delta records into info cube, go to ‘Collapse’ tab page and do no select ‘No marker update’ checkbox and click on ‘Release’

Leave a Reply

Your email address will not be published. Required fields are marked *