Generic Datasource extraction in BW from Master Data table in ECC

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 →

How to create tables in SAP system-II

Creation of Transaction data table with variable currencies and units of measure

Method: Top down approach

Structure:

Continue reading →

How to create Package and TR in SAP System

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 →