Steps to enhance LO Datasource in SAP ECC

Enhance LO standard business content data source with a field not present in the data source extract structure

Scenario 1:

The field to be added in the LO Data source is not present in the extract structure but it is available in the communication structure.

Steps:

If the field to be added is available in the communication structure, no need to enhance the data source in such cases. You simply have to add that field from the communication structure into the extract structure. Continue reading →

How to extract data using BI Content Datasource in SAP BW

This video and post is about how to extract data from SAP ECC to BW system using Business content standard Datasources.

The video outlines step by step approach on how to create the data model and schedule the delta loads in the BW system.

Aim

Data extraction / Acquisition from SAP R/3 ECC (OLTP) to SAP Netweaver BI (OLAP) using Business Content Datasources

Tcodes

SBIW, RSA9, RSA5, RSA6, RSA3, RSA7, RSA1, RSA2, RSA13, RSA14, RSDS, RSD1, RSD5, RSDCUBE, RSORBCT, RSORMDR, SE11, SE16, RSPC, RSPC1, RSPCM, RSMO, RSMON, LISTCUBE…

Part I – Data Modeling

Step 1: Logon to SAP R/3 ECC

Step 2: Activate / transfer application component hierarchy (need to be performed once) (RSA9 or SBIW)

Step 3: Install and activate the required Datasource Continue reading →