![Page 1: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/1.jpg)
Day 6
SAP BW Training
![Page 2: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/2.jpg)
Extractors – Content & Generic
![Page 3: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/3.jpg)
3
Purpose
This course demonstrates the various data extraction methods.
Extraction Methods covered
Business Content
Generic Extractors
DataSource Enhancement
![Page 4: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/4.jpg)
4
Extraction
In many organizations, data is fragmented and spread across many databases and applications.
To be useful, data must be integrated, standardized, synchronized, and enriched – typically through ETL (extraction, transformation, and loading) processes.
SAP BI provides a broad set of ETL capabilities that support data extraction.
With the open interfaces of SAP BI, data can be loaded from virtually any source and can handle the huge amounts of transactional data typical of the enterprise landscape.
Thus extraction deals with extracting the data into the BW system for analyzing and reporting.
![Page 5: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/5.jpg)
5
Multiple Source Systems
![Page 6: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/6.jpg)
6
Types of Extractors
FI
SAP CRM
Types of Extractors
Application Specific Cross Application
BW Content
Extractors
Customer Generated
Extractors Generic Extractors
LO COCKPIT
HR CO LIS
FISL
COPA
DB View
Infoset
Function Module
Application
Specific DB Tables
Various SAP DB
tables Application
Specific DB Tables
FI
SAP CRM
![Page 7: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/7.jpg)
7
Business Content Extraction
FI
SAP CRM
Types of Extractors
Application Specific Cross Application
BW Content
Extractors
Customer Generated
Extractors Generic Extractors
LO COCKPIT
HR CO LIS
FISL
COPA
DB View
Infoset
Function Module
Application
Specific DB Tables
Various SAP DB
tables Application
Specific DB Tables
FI
SAP CRM
Business Content Extractors:
Application Specific Extractors
that are activated when
business content datasources
are transferred
![Page 8: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/8.jpg)
8
Business Content Extractors
SAP provides extractors for almost all applications. They are provided as an add on with the Business Content.
For each application like FI,CO and HR there are specific tables in the OLTP system.
BI Content extractors consist of extract structures which are based upon these tables and thus can be used to fetch the data in BW.
Hence when any company implements application like FI, CO it can directly use the already available BI Content Extractors without the need to create their own.
Business content DataSources from a Source System are available in BW for transferring data only after you have converted them from Delivered ( D ) version to Active ( A ) version in the source system and replicated them.
![Page 9: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/9.jpg)
9
Uses of BI Content Extractors
Built in Extractors
High coverage (Applications and Industries)
Available for both Transaction and Master data
Ready to use
Reduce implementation Costs and efforts
Delta capable
![Page 10: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/10.jpg)
10
Generic Extractors
FI
SAP CRM
Types of Extractors
Application Specific Cross Application
BW Content
Extractors
Customer Generated
Extractors Generic Extractors
LO COCKPIT
HR CO LIS
FISL
COPA
DB View
Infoset
Function Module
Application
Specific DB Tables
Various SAP DB
tables Application
Specific DB Tables
FI
SAP CRM
![Page 11: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/11.jpg)
11
Generic Extractors
Generic Extractors are Cross Application Extractors used in scenarios where the other type of extractors are unavailable.
Tcode to create generic datasource – RSO2
Generic extractors are of three types:
Based on Database view/Table
Based on InfoSet
Based on Function Module
![Page 12: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/12.jpg)
12
Tips & Tricks
Before starting an SAP BW project, analyze the reporting requirements against the standard DataSources available.
Zero-in on the standard DataSources satisfying the requirement.
If data that cannot be supplied by the standard sources, we can:
- Create a generic DataSources.
- Enhance the standard DataSource.
![Page 13: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/13.jpg)
13
Generic Extractors
When should you use generic extractors?
Business Content does not contain a DataSource for your application.
The application does not feature its own generic delta
extraction method
You are using your own programs in SAP R/3 to populate the tables
The tools for generic data extraction can be used to generate an extractor for all applications.
![Page 14: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/14.jpg)
14
DataSource Enhancement
Need for DataSource enhancement
When we require an additional field from a database table and it is not directly available from the datasource, then we can append the field in the extract structure of the datasource.
Then the logic to populate that field can be written in the customer exit.
![Page 15: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/15.jpg)
15
Update Modes
Full
Initialisation
With Data Transfer
Without data transfer
Delta
![Page 16: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/16.jpg)
16
Update Modes
Only the data since
last upload is
requested
Only the data since
last upload is
requested
![Page 17: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/17.jpg)
17
Delta Capable Datasource
Datasource
supports delta
Tcode : RSA6
![Page 18: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/18.jpg)
18
Delta Capable Datasource
Tcode : RSA6
Datasource does
not support delta
![Page 19: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/19.jpg)
19
Delta Queue Maintenance
Go to transaction
RSA7.
You can see that the
delta queue has been
successfully filled.
![Page 20: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/20.jpg)
20
Initialisation
![Page 21: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/21.jpg)
21
Delta Update -Selections(Scheduler)
Only the data since
last upload is
requested
Only the data since
last upload is
requested
![Page 22: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/22.jpg)
22
Recordmode
' ': The record provides an after image.
'X': The record provides a before image.
'A': The record provides an additive image.
'D': The record must be deleted.
'R': The record provides a reverse image.
'N': The record provides a new image.
![Page 23: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/23.jpg)
23
Recordmode
![Page 24: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/24.jpg)
24
Possible Data Targets
![Page 25: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/25.jpg)
25
Delta Tables
1. ROOSOURCE
![Page 26: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/26.jpg)
26
Delta Tables
Table RODELTAM
![Page 27: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/27.jpg)
55
Some Useful sites
www.sdn.sap.com
www.help.sap.com
www.service.sap.com
![Page 28: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/28.jpg)
56
![Page 29: Day 6.3 extraction_business_content_and_generic](https://reader034.vdocuments.us/reader034/viewer/2022052523/5560ca6ad8b42a13088b4a36/html5/thumbnails/29.jpg)
Thank You.