Purpose

This section provides all relevant information about Data Exraction and books , links , blogs and how tos regarding the same.

Resources  

Books

SAP BW Data Retrieval
by Norbert Egger, Jean-Marie R. Fiechter, Robert Salzmann, Ralf Patrick Sawicki, Thomas Thielen

SAP Course

BW350 (Business Information Warehouse (BW) - Extraction)
SAP Help Business Content
BI Best Practice

Useful Links

SAP Systems

Connection between Source Systems and BW
Creating SAP Source Systems
Connect with BW with SAP Source Systems(.doc)

R/3

Tables
How to find source tables

LO-Cockpit
Presentation Transcript ; New Update Methods in Logistics Extraction
SD
MM
Retail
How to retain deltas when you change LO extractor in Production system

Financials 
FI-CO

Data Extraction -Line Item Level- FI-CO
FI-SL
CO-PA

How to CO-PA Extraction 3.0x How to CO-PA - Retraction
HR

CRM
Tables; Find source tables

SCM-APO

SRM

Business One

Generic Extraction
Generic Extraction via Function Module
How to Create Generic Data Sources Which Use the Delta Queue* *

DB Connect
Creating DBMS as Source System
Transferring Data Using DB Connect
Transfer Data with DB Connect (.pdf)

UD Connect

Web Services

Related SAP Notes/KBAs

Notes describing DB Connect are below:

SAP DB (ada) or MaxDB (dbs) 520647
Microsoft SQL Server (mss) 512739 178949
Oracle (ora)  518241 339092
IBM DB2/390 (db2) 523552 160484
IBM DB2/400 (db4) 523381 81737 146624  445872
IBM DB2 UDB (db6) 523622  200225 200164