Business Intelligence: Generic Extraction

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

CHAPTER – 4
EXTRACTIONS
It is mainly used for extracting the data form other Source Systems like R/3 etc.
DataSource: Defines as extract structure and transfer structure from source system (like SAP R/3) and transfer structure from BW side.
ES -> What data to be extracted from source system
TS -> What data to be extracted from source system to BW. TS is a group of fields which indicated how the data is coming from the source system BW

R/3
L

ES
E

TS

SAP – BW

T

TS

FLAT FILE

SAP R/3

SAP BW

1

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

TYPES OF EXTRACTIONS

APPLICATION SPECIFIC

BW CONTENT
EXTRACTOR

FI
HR, CO
SAP CRM
LO COCKPIT

CUSTOMER
GENERATED
EXTRACTOR

LIS
FI-SL
CO-PA

APPLIACTION
SPECIFIC
DB TABLES

APPLICATION
SPECIFIC
DB TABLES

BASICS

DELTA METHOD

2

CROSS APPLICATION

GENERIC
EXTRACTOR

DB VIEW
INFOSET
FUNCTION
MODULE

VARIOUS SAP
DB TABLES

ENHANCEMENTS

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

GENERIC EXTRACTION
1. Why do you go for Generic extraction?
- When the data source is not readily available in the Business content
- Even if the Business content data source is available and it is already being used up. And if we want to simulate the same kind of extractor, we can go for generic extraction.
2. The T-code for creating Generic Extraction is RSO2.
3. We can create 3 types of data sources using generic extraction
- Transaction data
- Master data attribute
- Text
4. We can generate generic datasource using the following
- Table
- View
- Function module
- Infoset Query
STEPS TO CREATE GENERIC EXTRATION: (MASTER DATA)
1. Go to T-Code SBIW otherwise go to T-Code RSO2.

3

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

-> Select the radio button Master data Attribute, give name and click on CREATE

-> Select the Application Component by pressing F4