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
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