Day 6

SAP BW Training

Extractors – Content & Generic

3

Purpose

This course demonstrates the various data extraction methods.

Extraction Methods covered

Business Content

Generic Extractors

DataSource Enhancement

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.

5

Multiple Source Systems

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

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

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.

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

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

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

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.

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.

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.

15

Update Modes

Full

Initialisation

With Data Transfer

Without data transfer

Delta

16

Update Modes

Only the data since

last upload is

requested

Only the data since

last upload is

requested

17

Delta Capable Datasource

Datasource

supports delta

Tcode : RSA6

18

Delta Capable Datasource

Tcode : RSA6

Datasource does

not support delta

19

Delta Queue Maintenance

Go to transaction

RSA7.

You can see that the

delta queue has been

successfully filled.

20

Initialisation

21

Delta Update -Selections(Scheduler)

Only the data since

last upload is

requested

Only the data since

last upload is

requested

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.

23

Recordmode

24

Possible Data Targets

25

Delta Tables

1. ROOSOURCE

26

Delta Tables

Table RODELTAM

55

Some Useful sites

www.sdn.sap.com

www.help.sap.com

www.service.sap.com

56

Thank You.