Generic Datasources / Extractors – Cross Application (RSO2, SBIW)
Master data / Attributes extraction/ acquisition from SAP R/3 ECC (OLTP) to SAP BI (OLAP) using generic data sources – cross application
Eg. 1. Using a Database table
T-codes: SBIW, RSO2, SE11, SE16, RSA3, RSA7, RSA11, RSA13, RSA14, RSD1, RSDS, RSMO, RSMON, LISTCUBE, RSPC, RSPC1, RSPCM
Part 1: Data Modeling
Step 1: Logon to SAP R/3 system
Step 2: Check the data in the table
Enter tcode SE11 Continue reading “Generic Datasource extraction in BW from Master Data table in ECC”
Before starting any development, it is mandatory to have a package and TR assigned to your user id so that you can neatly collect all your changes in the TR and transport it without any errors. One should avoid collecting objects in the local package unless necessary.
Below are the steps outlined to create a package and a TR in SAP system. You can also check my video below-
Continue reading “How to create Package and TR in SAP System”
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.
Data extraction / Acquisition from SAP R/3 ECC (OLTP) to SAP Netweaver BI (OLAP) using Business Content Datasources
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 “How to extract data using BI Content Datasource in SAP BW”