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