• Handling Table Controls in BDC
• Legacy System Migration Workbench

• Different Methods
• Flat file creation
• Uploading data

• File Handling

• Application Server
• Presentation Server

SAP Scripts

• SAP Scripts Introduction
• Components of SAP Scripts

• Layout Set
• Standard Text
• Out Put Program

• Modifying Standard SAP Script Layouts
• Including Logos
• SAP Script Utilities - Upload / Download
• Writing print program and designing layouts

Smart Forms

• Smart Forms Introduction
• Graphics Management
• Style Maintenance

• Paragraph Formats
• Character Formats

• Writing print program and designing layouts

Runtime Analysis & SQL Tracing
Cross Applications

• Introduction to Distributed Environment
• Introduction to Cross Applications

RFC

• Introduction to RFC
• Creating RFC Destination between 2 Systems
• Creating Remote Enabled Function Modules
• Creating program using Remote Enabled Function Modules

ALE

• ALE Basics
• Overview of Outbound & Inbound Process
• Configuration Steps
• Define logical systems
• Assign client to logical system
• RFC destination
• Customer distribution model
• Creating Ports

IDocs

• ALE Basics
• Overview of Outbound & Inbound Process
• Configuration Steps
• Define logical systems
• Assign client to logical system
• RFC destination
• Customer distribution model
• Creating Ports

EDI

• EDI Basics
• Difference between ALE & EDI
• Overview of Outbound & Inbound Process
• Configuration Steps
• Port Creation
• Partner Profile Creation

User Exits

• User Exits Overview
• Types of User Exits

• Field Exit
• Screen Exit
• Function Exit
• Menu Exit

BAPIs

• BAPI Overview
• Creation of BAPI

BADIs

• BADIs Overview
• Defining a BADI
• Implementing a BADI
• Difference between Customer exits and BAdI
• Search Criteria for BAdI

SAP Netweaver 2004s BI

ERP Overview

• What is ERP?
• Why we need ERP?
• Advantages of ERP
• Major ERP Packages

SAP BW/BI Overview

• Chronology of SAP & BI

SAP Architecture

• R3 Architecture
• Client Server Technology, Landscape
• Creation of User
• Data, Tables, Rows, Columns?
• Types of Data
• OLTP Vs OLAP

Modelling
RSA1 (Data Warehouse Work bench)


Info object,
Types of Info Object

• Characteristic Info Object
• Keyfigure Info Object
• Technical Characteristic
• Time Characteristic
• Unit Characteristic

Creating Master Data info Object

Data Sources Creation
Types of Data Sources

• Master Data sources
• Text Data sources
• Transaction Data sources
• Hierarchical Data source

Loading Master Data, Text Data from Flat file
Info Package & Datasource in Details

Data Transfer Process (DTP)
Types of DTP’s

• Standard DTP
• Direct Access DTP
• Error DTP

Data Flow BW 3.5 Vs BI 7.0

Star Schema
Extended Star Schema

Info Cube – creation
Loading info cube from flat file
Transformation,

• Start Routine
• End Routine
• Expert routine
• Field/Characteristic Routine

Info Cube – Administration
Real time Cube


Virtual Info provider

• Based on DTP Direct access allowed
• Based on Function Module
• Based on BAPI

Data Store Object (DSO)
Types of DSO’s

• Standard DSO
• Write Optimized DSO
• Direct Update DSO

Load DSO from flat file
DSO Administration, Repair Full Update


Info Set

• Left Outer Join
• Right Inner Join
• Temporal Join

Multi-Provider
Open Hub Destination
Process Chains

• Process Types
• Monitoring Process Chains
• Local Chains
• Meta Chains

Performance Tuning Concepts
Compression
Aggregates
Index
Line Item Dimension
Cardinality
Partitioning, Repartitioning
BI Statistics
BI Accelerator

Miscellaneous Topics
Net weaver
Remodeling
Migration from 3.x to BI 7.0
Transportation
BI Content Installation
Information Broadcasting

Extraction
Data Extraction from R3
Source System, Data Source
Load Master Data from R3 System
Generic Extraction – Table
Generic Extraction – View
Generic Extraction – Delta
Generic Extraction – FM based
Logistics Extraction
Logistics – Delta
Data source Enhancements

• Using Customer-Exits
• Using BAdI

FI – GL, AR, AP Extraction
COPA Extraction
Real Time Extraction

Business Explorer (BEx) Reporting

• Query Designer
• Web Analyzer
• BEx Analyzer
• Web Application Designer (WAD)
• Report Designer

Reporting Over View
Characteristics – Properties
Key figure – Properties
Query Properties
New Selection, Restricted key figure
New Formula, Calculated key figure
Hierarchies
Structure
Cell Editor
Exception
Condition
Filters, Restrictions
Variables

• Characteristic Values
• Hierarchies
• Hierarchy Nodes
• Texts
• Formula Elements

Processing Types

• Manual Entry/Default Value
• Replacement Path
• Customer-Exit
• SAP Exit
• Authorization

Jump Query (RRI)
Business Objects –Overview

• Crystal Reports
• Xcelsius

ABAP FOR BI

1. ABAP-Dictionary (SE11)

Data Base Tables

• Table Creation
• Table Relation ship Using Foreign Key Concept
• Data Element
• Domain

VIEWS

• Data base View
• Maintenance View
• Help View
• Projection View

STRUCTURES

• Structure Creation
• Types of Structures

2. PROGRAMMING

ABAP Editor (SE38)

• Simple Write Statement
• Additions of WRITE statement
• Data Types
• Operators
• Simple commands of ABAP language
• Operators : Logical, Mathematical
• Control Statements (CASE, DO,WHILE)
• String commands
• Parameters
• Select-Options and RANGES
• Radio Button, Check Box
• System Fields
• Displaying ICONs
• Declarative Statements
• Data Elements as Data Types

3. INTERNAL TABLES

Types of Internal Tables

• Standard
• Sorted
• Hashed

Internal tables with Header Line
Internal tables without Header Line

4. Writing Routines

•  Start Routine
• End Routine
• Expert Routine
• Field/Characteristic Routine

5. DEBUGGING Techniques
6. Messages and Message Classes
7. Modularization Techniques

• Includes
• Macros
• Subroutines
• FunctionModules

8. Events in Abap
9. Classical Reports, Interactive Reports
10. Data Source Enhancement

• Using Customer-Exit (RSAP0001)
• Using BAdI (RSU5_SAPI_BADI)

11. Enhancements (SMOD,CMOD)
12. BAdI – Overview (SE18 , SE19)

• Creating BAdI
• Working With BAdI
• Finding BAdI