Spirit Softs, Hyderabad

Course Details

Course

Introduction
• Introduction to Data Warehousing
• Characteristics of Data Warehousing
• Introduction of Data Mart
• Difference between Data Mart and Data Warehouse
• Introduction to OLTP
• Difference between OLTP and Data Warehouse

Installation of BO
• Pre-requites of Business Objects
• Creation of Databases for CMS & Audit
XI Architecture
• SAP Business Objects XI 3.1
• SAP Business Object 4
Central Management Console
• Introduction to CMC
• Contents of CMC
• Starting & Stopping Servers
• Users and Groups
• Event
• Bursting (Single and Multiple)

BI Launch Pad
• How to launch BI Launch Pad
• Setting Preference
• Applications
• Viewing Report
• Adding Documents

Audit
• What is Audit database?
• Configuring the Audit database

Universe Designer
• Introduction to Universe Designer
• Role of Universe Designer
• What is Universe
• Connection to Non-SAP Data Source
• Universe Structure
• Inserting Non-SAP Tables in Universe
• Joins
• Types of Joins
• Creating Joins in Universe
• What is Classes and Objects
• Creating Classes and Objects
• What is Filters
• Creating Pre-defined Filters
• What is hierarchy
• Creating Hierarchy
• List of Values
• Cascading List of Value
• What is loop
• Detect loop
• What is Fan Trap
• What is Context
• How to resolve loop
• What is Restriction
• What is Row level security Non-SAP
• What is Object level security Non-SAP
• Implementing row level security Non-SAP
• Implementing Object level security Non-SAP
• Importing and exporting Universes
• Migration of Universe (3.1-4)

OLAP Universe
• What is OLAP Universe
• OLAP Data Sources
• Connection to BW
• Configuration Parameter to OLAP Universe
• Creating Universe using SAP BW
• Customizing Olap Universe
• Building Universe based on InfoCube
• Refreshing Universe
• Regenerating Universe
• Building Universe based on MultiCube

Information Design Tool
• What is Information Design Tool
• Working With Projects
• Working with Connections
• Working With Data Foundation
• Working With Business Layer
• Using Query Panel
• Checking Integrity
• Publishing Resources
• Working With Repository
• Managing Security

Web Intelligence Rich Client
• Accessing information with Web Intelligence
• Understanding how universes allow you to query databases using everyday business terms
• Understanding Web Intelligence core functionalities
• Creating a document in the Web Intelligence Rich Client
• Viewing a Web Intelligence document in Info View
• Building a simple query
• Modifying a document query
• Working with query properties
• Restricting data with query filters
• Modifying a query with a predefined query filter
• Applying a single‐value query filter
• Using prompts to restrict data
• Using complex filters
• Working in the Report Panel
• Displaying data in tables and charts
• Presenting data in free‐standing cells
• Using breaks, calculations, and report filters
• Formatting breaks and crosstabs
• Using default and custom sorts
• Ranking data to see top or bottom values
• Tracking data changes
• Using alerter to highlight information
• Organizing a report into sections
• Copying data to other applications
• Preparing documents for PDF and print
• Document formatting
• Formatting charts
• Understanding formulas and variables
• Understanding how Web Intelligence calculates data
• Creating formulas and variables to calculate data
• Adding a new query using a personal data provider
• Creating multiple queries in a document
• Synchronizing data with merged dimensions
• Analyzing the data cube
• Drilling into the data
• Setting Web Intelligence drill options
• Exporting documents from the Rich Client
• Accessing Info View
• Managing documents in Info View
• Sharing documents in Info View
• Scheduling a Web Intelligence document
• Setting Info View preferences

Crystal Report 4
• Planning a Report
• Creating a Report
• Selecting Records
• Organizing Data on a Report
• Formatting a Report
• Creating Basic Formulas
• Representing Data Visually
• Distributing Reports
• Using the Repository
• Creating Formulas
• Managing Reports
• Using Variables and Arrays
• Building Parameterized Reports
• Using Report Templates
• Summarizing Data with Crosstab
• Using Report Sections
• Building Specialized Reports
• Report Processing
• Using Sub‐Reports
• Creating Complex Formulas
• Using Custom Functions
• Using XML and Web Services Data

Query as web service
• Using Query as web service
• configuring qaaws
• Creating a web service report using universe

Life Cycle Manager
• Introduction LCM
• Advantages of LCM
• Configuration of LCM
• Creating New Job
• Connecting to Server
• Adding Content on Job
• Managing Dependency
• Testing the LCM Job

Version Control
• What is Version Control
• Adding content to Version Control
• Check in
• History of content
• Get latest Version

SAP BO Widgets
• Using BI widgets to access BI Services
• Logging into BI Widgets
• Using BI Widgets explorer
• Using Widgets with Xcelsius Documents

Scheduling
• Scheduling Mechanism
• Scheduling using Calendar
• Scheduling Using Event
• Difference between CMC & BI Launch Pad Scheduling
• Scheduling via CMC
• Scheduling Via BI Lunch Pad

Live Office
• Getting Started with Live Office
• Describe the benefits of using Live Office
• Connect to the repository
• Navigate the Live Office menu
• Find help documentation
• Set general options
• Inserting Live Office Objects
• Insert charts, crosstabs, and fields from a Crystal report
• Insert report parts from a Web Intelligence document
• Insert a new query based on a Universe
• Insert Live Office objects into an email
• Copy and paste between Microsoft Office applications
• Managing Live Office Objects
• Navigate and refresh Live Office objects
• Enable consolidated prompts
• Set refresh settings for objects
• Set parameter binding
• Take a snap shot
• Publishing and Viewing Live Office Documents
• Save Live Office documents to the repository
• Open and view Live Office documents from the repository

Xcelsius
• Introduction
• Getting to Know Xcelcius
∗ Navigate in Xcelcius
∗ Crop the canvas
∗ Define the canvas size
∗ Find help
∗ Learn how to use the Knowledge Accelerator interface
• Importing Excel Files

∗ Re‐import an Excel file
• Using Charts
∗ Define the available charts
∗ Create a chart with a data range
∗ Create a chart with series
∗ Create a chart with ignore end blanks
• Using Single Value Components
∗ Define the available single value components
∗ Create an interactive model
• Using Selectors
∗ Define the available selectors
∗ Create a model with a list box selector
∗ Create an interactive model with play options
∗ Create a model with a radio button selector
∗ Create a model with a list builder selector
∗ Create a model with a graphic selector
• Applying Formatting
∗ Change the appearance of a component
∗ Change the font for a model
∗ Apply a global style to a model
∗ Apply a skin to a model
• Publishing Models
∗ Take a snapshot from preview mode
∗ Export to Flash or HTML
∗ Publish to PowerPoint, Outlook, Adobe PDF and Word
∗ Export to BusinessObjects Enterprise
• Setting up Alerts
∗ Create a model with a value‐based alert
∗ Create a model with a percentage‐based alert
• Setting up Dynamic Visibility
∗ Create a model with dynamic visibility using “insert in”
∗ Create a model with dynamic visibility using a formula
• Adding Graphics and Animations
∗ Add graphics and backgrounds
∗ Create an interactive map with graphics
∗ Create a multi‐layer model
• Setting up Drill‐Down Functionality
∗ Create a model with a drill‐down chart
• Using Tables
∗ Create a model with table output
∗ Create a model with a table selector
• Using Maps
∗ Create an interactive map
• Using Other Components
∗ Define other available components
∗ Create a model with an interactive calendar
∗ Create a model with a local scenario button
∗ Add text to a model
• Creating Advanced Models
∗ Create an advanced model
• Using Excel 2003 XML Maps
∗ Link to live data using Excel 2003 XML maps
∗ Refresh data using the XML Map Refresh component
• Using the Live Office Connector
∗ Use a Live Office spreadsheet as a data source
• Using Query as a Web Service (QaaWS)
∗ Creating a standard query using QaaWS
∗ Creating a prompted query using QaaWS
∗ Creating a list of values query using QaaWS
∗ Populating a chart using QaaWS
∗ Populating a selector using QaaWS
∗ Generating dynamic models using QaaWS
∗ Personalizing models using BOE security

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

ID S. No. Topic Duration
1 1 Introduction to Data Warehouses, Data Marts and ETL Process 1 Hour and 30 Mins
2 1.1 Operational systems and their characteristics
3 1.2 Analytical systems (or DWHs) and their characteristics
4 1.3 Data Marts
5 1.4 Comparison of (a) Operational systems and Analytical systems and (b) Data Warehouses and Data Marts
6 1.5 Basic Data Warehouse Architecture - various layers
7 1.6 Facts and Dimensions - An example Star schema
8 1.7 Slowly Changing Dimensions - Type 1, Type 2 and Type 3 with examples
9 1.8 What is ETL - Extraction, Transformation and Load
10 1.9 Extraction types - Full and Incremental
11 1.10 Load types - Full and Incremental
12 2 Introduction to BO Data Services 45 Mins
13 2.1 Standard Data Services Achitecture - Designer, Repository, Job Server, Engine, Access Server, Administrator, Web Server and Service
14 2.2 Basic Data Services Components - Designer, Server Manager, Repository Manager and Management Console
15 2.3 Data Services Objects and Object Hierarchy
16 3 Preliminary workouts with Data Services 30 Mins
17 3.1 Create a local respository using Repository Manager
18 3.2 Configure a job server using Server Manager
19 3.3 Associate repository to the Job server
20 3.4 Connect repository to the Administrator
21 4 Working with Designer
22 4.1 Logging into the Designer 15 Mins
23 4.2 Walk through of Designer User Interface 15 Mins
24 4.3 Create and execute a simple Batch Job 3 Hours
25 4.3.1 Create DataBase DataStore and import metadata
26 4.3.2 Create and edit File formats (.txt, .csv, .xls), File format features
27 4.3.3 Create Data Flow, Work Flow, Job and Project
28 4.3.4 Execute the job and monitor its progress
29 4.4 Built-in Transforms - All important DI, DQ and Platform Transforms 8 Hours
30 4.5 DS Scripting Language and working with Functions 4 Hours
31 4.5.1 Script and the scripting language
32 4.5.2 Built-in functions (Important functions such as exec, ifthenelse, decode, is_valid_date, lookup, lookup_ext, lookup_seq, nvl, and sql
etc.)
33 4.5.3 Custom functions, Database functions and stored procedures
34 4.6 Other important Objects 2 Hours
35 4.6.1 Conditional
36 4.6.2 While loop
37 4.6.3 Try
38 4.6.4 Catch
39 4.6.5 Annotation
40 4.7 Working with variables and parameters 1 Hour
41 4.7.1 Global variables
42 4.7.2 Local variables
Page 1
ID S. No. Topic Duration
43 4.7.3 Parameters
44 4.8 Working with nested data - extracting data from XML sources 1 Hour
45 4.9 Debug features 1 Hour
46 4.9.1 using "View Where Used"
47 4.9.2 using "View Data"
48 4.9.3 using the interactive debugger
49 4.10 Working with Full sources, Time stamped sources and CDC sources 4 Hours
50 4.10.1 Implementing type 1 SCD - Full extraction
51 4.10.2 Implementing type 2 SCD - Full extraction
52 4.10.3 Implementing type 1 SCD - Incremental extraction (Time stamped source)
53 4.10.4 Implementing type 2 SCD - Incremental extraction (Time stamped source)
54 4.10.5 Implementing type 1 SCD - Incremental extraction (CDC Source)
55 4.10.6 Implementing type 2 SCD - Incremental extraction (CDC source)
56 4.10.7 Benefits of Incremental extraction over full extraction
57 5 Working in multi user environment 1 Hour
58 5.1 Setting up multi user environment - Creating, defining a connection to and activating Non-secure and Secure central repositories
59 5.2 Accessing central repository from a local repository - Adding objects, Checking out objects, Undoing check out, Checking in objects,
Filtering, Getting objects, Labeling objects, Comparing objects, Viewing object history and Deleting objects
60 6 Code migration from one phase to another phase of a project 1 Hour
61 6.1 Using Export/Import method
62 6.1.1 .ATL method
63 6.1.1.1 Exporting objects to file (.ATL)
64 6.1.1.2 Exporting whole repository to file (.ATL)
65 6.1.1.3 Importing from .ATL file
66 6.1.2 Directly exporting objects from one repository to another repository
67 6.2 Using central repository method
68 7 Processing data with problems 1 Hour
69 7.1 Using overflow files
70 7.2 Pass bad data to a database table for further analysis and action
71 8 Recovering from unsuccessful job execution 30 Mins
72 8.1 Automatic Recovery
73 8.2 Manual Recovery
74 9 DS Management Console
75 9.1 Administrator 2 Hours
76 9.1.1 Walk-through of Administrator UI
77 9.1.2 Management - Adding repositories, Managing user roles and Setting the log retention period etc.
78 9.1.3 Central repository users and groups management
79 9.1.4 Server group - Achitecture, Executing jobs using SG and the advantage of load balancing
80 9.1.5 Executing, scheduling and monitoring batch jobs
81 9.1.6 Troubleshooting - Understanding error and trace logs
82 9.1.7 Use of Export execution command option
83 9.2 Using Impact and Lineage Analysis reports 15 Mins
84 9.3 Using Operational Dashboards 15 Mins
Page 2
ID S. No. Topic Duration
85 9.4 Using Auto Documentation 15 Mins
86 10 Loading a tiny DWH - Customer Dim from relational sources, Location Dim from flat file sources, Product Dim from xml sources, Time Dim
from relational sources and Revenue Fct from relational sources; Managing dependencies between jobs
3 Hours
87 11 Performance Tuning 4 Hours
88 11.1 Using DB Indices properly
89 11.2 Maximize Push-Down using Data_Transfer transform and pushdown_sql function
90 11.3 Using proper caches
91 11.3.1 Sources - In-memory or Pageable
92 11.3.2 Lookups - NO_CACHE, PRE_LOAD_CACHE and DEMAND_LOAD_CACHE
93 11.3.3 Table Comparisons - ROW_BY_ROW_SELECT, CACHED_COMPARISON_TABLE and SORTED_INPUT
94 11.4 Maximize Parallel execution where possible using Table partitioning and DOP option
95 11.5 Splitting data flow into sub data flows using "Run as separate process" option
96 11.6 Using Bulk Loading option
97 11.7 Using Join ranks and array fetch size options
98 11.8 Using Rows per commit option
99 12 A brief view of repository tables

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Introduction (1 Hr)
• Introduction to ERP, SAP, Data Warehouse
• Overview of BW, BI, Data Base.
• Overview of BW Architecture, Landscape

Basic Modeling (2 hr )
• Multi-Dimensional Star Schema (Classical Approach)
• Multi-Dimensional Star Schema in BW (Extended star Schema)
• The OLAP Concept and differences between OLAP and OLTP

Business Modeling (20 Hrs)
• Info Area
• Info Object Catalogs
• Info Objects
• PSA
• Application Component
• Info Source
• Data Source
• Transfer Rules
• Update Rules
• Transfer Structure
• Communication Structure
• Info Package
• Transformation
• Data Transfer Process
• Loading Transactional Data into BW info Cube
• Loading MD with TD into BW System
• BW and BI Comparisons
• Master data loading-new(BI) ETL process
• Info cube & Types
• Standard Info cube and Loading with new ETL Process
• Generate Report with BI master and Transaction Data
• Manual Uploading of MD like Attributes, Text, Hierarchy
• Different Types of Attributes
• Transformations , Rule types

Routines (2 Hr)
• Start Routine
• End Routine
• Expert Routine

DTP (Data Transfer Process) (1 Hr)
• Standard DTP
• Error DTP
• Direct Access DTP
• Real time DTP

DSO (Data Store Object) (1 Hr)
• Standard DSO
• Write optimized DSO
• Direct update DSO
• APD (Analysis Process & Design)

Update Methods (1 Hr)
• Full updates
• Initialization
• Delta Updates

Info Providers(5 Hrs)
• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning
• Open-Hub Destination
• Data Marts

Info Cube Maintenance (2 Hr)
• Aggregates
• Roll-up
• Compression
• Reconstruction

Process Management (2 Hr)
• Process Chains, Process Types
• Scheduling
• Monitor (Header, Status, Details)

Reporting(15Hrs)
• Business Explorer
• BEX Query designer
• BEX Analyzer
• BEX WAD
• BEX Report Designer
Functional Overview of Bex Query Designer

 Reusable Query Elements
• Query Controls with Variables
• Calculated Key Figures
• Restricted Key Figures
• Formulae
• Structures

 Variable Definition in Detail
• Characteristic values variables
• Text Variables
• Formula Variables
• Hierarchy Variable
• Hierarchy Node Variable..
Process Types:

Manual input
Customer exit
Replacement path
SAP Exit
Authorzatio

 Analysis Functions
• Conditions
• Exceptions

 Reporting Drilldown
• Drilldown to DSO from Info Cube (RRI)
• Copying Queries from Cubes
• Bex Analyzer
• Bex WAD
• Bex Report Designer
• Migration Objects from BW 3.x to BI 7.0
• Transportation

Extraction (10)
• Generic Data Extraction using MD/TD Tables
• COPA Extraction
• Business Content Extractions using MD/TD
• LO-COCKPIT Data Extraction

 Delta types For
• Generic Extraction
• LO Extraction
• ASAP methodology

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Introduction
o Overall Introduction to ERP
o What is SAP?
o What is ABAP/4?
o Architecture of SAP R/3
o ABAP/4 syntax
o ABAP program layout
o Working with ABAP Programs
o Data Types & Data Objects
o String operations
o Control statements
o ABAP Workbench tools

Data Dictionary
o What is DDIC?
o Tables
o Data elements
o Views
o Domains
o Search Help
o Lock Objects
o Table Maintenance Generator
Primary & foreign key
Internal Tables
o Purpose of Internal Tables
o Types of Internal Tables
o Examples on internal Tables
Debugging Concepts
o Debugger's six diff. views
o Break points
o Types
o Watch points
Database Concepts
o Open SQL
o Examples
Modularization Techniques
o Subroutines
o Function Modules
o Macros
o INCLUDE programs
JOINS
o Inner join
Left-outer joins

Reports
o Selection screens
o Types of Reports (Classical & Interactive Reports)
o Events
o Working with Selection screens, [Select - Options, Parameters, check boxes, Radio Buttons, Push Buttons.]
o Menu painter
o Hide & Hotspot
o Message class creation & Message types
o ALV Reports
SAP Scripts
o Components of Scripts
o Layout Sets
o Export to Dataset
Import from Dataset
BDC
o Overview of BDC
o Recording
o Call Transaction method
o Session method
o Error handling
o Handling Table Controls in BDC
File Handling
o Presentation server
o Application server
LSMW
o Using Batch Input recording method
o Using BAPI
Using IDoc
MODULE POOL PROGRAMMING/ TRANSACTIONS
o Structure of the Transactions
o Working with Flow logic (PAI, PBO, POV, POH)
o Screen Painter, Menu Painter
o Working with Buttons, Step loops, Table control
o Creation of
o Sub screens
o Table controls
o Tab strips
o Step Loops
Dynamic screen
o Call screen
o Set screen
o Leave to screen
o Leave screen
Enhancements
o Concepts of Enhancements
o User exits and Customer Exits
BADI's
ALE
o Defining Logical systems used for interfaces
o Outbound/Inbound processing
o Transferring of Master Data from one system to another system
o Distribution Model View
o Outbound using change pointer methods
Idoc's
o Structure of Idoc
o Idoc-Types
o Creation of Segments, Idocs & Message types
OO-ABAP Concepts
o Data Abstraction
o Encapsulation
o Inheritance
o Polymorphism
o Classes
o Object Handling
o Interfaces
o Methods
o Events
Performance Tuning
o Database Access
o Internal Tables
o SQL trace
o Runtime Analysis
Database Updates
o SAPLUW & DBLUW
o SAP Locks
o Building Techniques
LUW Processing

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

SAP Overview
 Introduction to ERP And SAP
 History of SAP
 Organization
 Technology
 Implementation Tools (Asap and Solution Manager)
 System Landscape
 Roles And Responsibilities of a Consultant
 Types of Projects
 Change Transport System

Course Overview

 Navigation
 Organizational Elements, General Ledger’s and Postings.
 Currencies
 Bank Accounting
 Accounts Payables & Accounts Receivables
 Asset Accounting
 Closing Operations
 Reports
 General Controlling
 Cost And Revenue Element Accounting
 Cost Center Accounting
 Internal Orders
 Profit Center Accounting
 Product Costing
 Profitability Analysis ( CO-PA)
 Integration With the Other Modules

Navigation

 Logging on to the R/3 System
 Screen Elements
 Creating Favorites
 Adding Transaction to Favorites

FINANCIAL ACCOUNTING

Basic Settings

Overview of Organizational Elements in Accounting
Organizational Units
Define and Assign Organizational Units for Finance: Ex: - Country, Regions, Company, Company Codes, Business Areas, Functional Areas, e.t.c…
Variant Principle
Fiscal Year and Posting Periods
Field Status Variants
Document types and Number Ranges
Posting Keys
Define Tolerance for GL Accounts and Employees
Global Parameters

General Ledger

Master Data Overview
Chart of Accounts
Types of Chart of Accounts
Define and Assign Chart of Accounts,
Define Account Groups and Screen Layout for GL Accounts,
Define Retained Earnings Account,
Creations of GL Accounts Master Records,
Postings, Display GL Account Balances and Document.

Currencies

Maintain Exchange Rates Maintain Table
Define Translation Ratios for Currency
Define Accounts for Exchange Rate Differences
Posting with Foreign Currency
Define Methods for Foreign Currency Valuation
Prepare Automatic Posting for foreign currency valuation
Revaluation of foreign currency balances

Accounting Documents

Parking Document
Holding Document
Reference Document
Recurring Document
Sample Document
Account Assignment Model
Fast Data Entry

Reversals

Individual Reversals
Mass Reversals
Reversals of Reversals
Cleared item Reversals

Bank Accounting

Define House Banks with Bank Accounts
Creation of check number ranges for check lot
Define void reason codes
Issue of a check
Manual payment
Cancellation of issue check with reason codes
Check register

Validations and Substitutions

Validations and Substitution
Define Validation for posting
GL Posting to check Validation

Accounts Payables

Overview on Procurement Process
Overview on Vendor Master Data
Define Account Groups with Screen Layout
Define Number Ranges for Vendor Accounts
Assign Number Ranges to Vendor Account Groups
Reconciliation Accounts
GL Account Creation
Creation of Vendor Master Records
Vendor Document Types and Number Ranges
Posting Keys
Define Payment Terms
Define Tolerance for Vendors/Customers
Posting of Purchase Invoices
Display Vendor Line Items
Outgoing Payments
Vendor Clearings
Credit Memo Postings
Special GL Transactions (Down Payments Made)
Posting Down Payments
Clearing of Down Payments against Invoices
Reason Codes for under and over Payment
Automatic Payment Program

Accounts Receivables

Overview on Sales Process
Complete Customer Master Data
Define Account Groups with the Screen Layouts
Create Number Ranges to Customer Accounts
Assign Number Ranges to Customer Account Groups
Reconciliation Accounts
Create Customer Master Records
Document Types and Number Ranges
Posting Keys
Payment Terms
Posting of Sales Invoices
Incoming Receipt with Clearings
Display Customer Line Items
Display GL Account Balances
Special GL Transactions (Down Payments Received)
Posting of Down Payments (Advance Receipt)
Clearing of Down Payments
Customer Credit Memo
Dunning Procedure.

Management of Account

• Open Item Management
• Types of Payments
• Standard Payment
• Partial Payment
• Residual Payment

Taxes

Tax on Sales & Purchases
With Holding Tax (TDS)
Country India Version (CIN)

Asset Accounting

Overview on Asset Accounting
Depreciation Methods
Organizational Structures
Chart of Depreciation
Depreciation Areas
Account Determination
Screen Layout
Number Ranges
Functions of Asset Classes
Creation of GL Accounts
Assign GL Accounts
Calculation Methods
Depreciation Keys
Screen Layout for Asset Master Data
Asset Master Records
Sub Asset Master Records
Acquisition of Assets
Depreciation Run
Retirement of Assets
Transfer of Assets
Scrapping of Assets
Reports on Asset Accounting

Cash Journal

Cash Journal Configuration
Cash Journal Transaction

Closing Operations

GL Report
AR Report
AP Reports
AM Reports
Scheduler Manager

Integration with Other Modules

• FI-MM
• FI-SD
• FI-HR

CONTROLLING

 Introduction to Controlling.
 Importance of Controlling.

General Controlling.

• Maintain controlling area
• Activate components for controlling area
• Assignment of company code to controlling area
• Maintain number ranges for controlling area documents
• Maintain versions and setting for fiscal year

Cost Element Accounting

• Introduction to Cost Element Accounting
• Primary and Secondary Cost Elements
• Define Cost Element Categories
• Manual & Automatic Creation of Primary and Secondary Cost Elements
• Define Cost Element Standard Hierarchy and Groups

Cost Centre Accounting

• Introduction to cost centers
• Define Standard hierarchy for cost centers
• Define cost center categories
• Master data maintenance
• Cost centre groups
• Set planner profile for cost centre
• Create activity types
• Maintain statistical key figures
• Post transaction to cost centers
• Generate cost center reports
• Plan values and quantities for activity prices
• Calculate activity prices
• Periodical reposting of cost
• Create and execute assessment cycle
• Create and execute distribution cycles
• Activity allocations
• Settings for automatic posting

Internal Orders

• Introduction to Internal order
• Activate order management in controlling area
• Maintain budget and planning profiles
• Planning
• Define order types
• True orders and statistical orders
• Settlements
• Display internal order report

Product Costing

Product Cost Planning (PCP)
Cost Object Controlling (OBJ)
Actual Costing / Material Ledger (ACT)

Profit Centre Accounting

• Introduction to Profit centre accounting
• Maintain Standard Hierarchy
• Create Dummy Profit Centre
• Maintain Profit Centre Groups
• Creation of Profit Centre
• Assignment of Profit Centers in cost Center Master Data
• Maintain Automatic Account Assignments for Revenue Elements
• Profit Center for Balance Sheet and Profit and Loss
• Planning And Postings
• Display Profit Center Reports

Profitability Analysis.

• Introduction to profitability analysis
• Maintain operating concern
• Define profitability segment
• Maintain characteristics values
• Define derivation rules
• Setting for data flow from SD
• Setting for data flow from FI and MM
• Display reports in COPA
• Mapping of SD/MM Conditions to CO-PA value fields Overview

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

SAP SD Syllabus

Organization mapping
- Enterprise structure

Master data
- Customer Master
- Material Master
- Customer material information record

Sales Cycle (Different sales processes)
- Sales document Structure
- Configuration of Sales Header, Item categories and schedule line categories.
- Configuration of item category and schedule line category determination
- Inquiry
- Quotation
- Standard order
Special sales orders
- Cash sales and Rush order

Agreements
- Contracts and scheduling agreements

Complaints
- Returns, credit memo request, debit memo request, Subsequent free of charged deliveries , free of charged deliveries and invoice correction request.
- Item proposal

Special business scenarios
- Intercompany sales
- Intercompany STO
- Intracompany STO
- Consignment
- Third party sales
- Individual purchase order BOM
Basic Functions
- Pricing
- Free goods
- Cross selling
- Material determination
- Listing/Exclusion
- Revenue account determination
- Rebates
- Credit management
- Output determination
- Partner determination
- Text determination
- Tax determination
- Incompletion Log
- Copy controls
- Availability Check and Transfer of requirement (TOR)
Shipping
- Delivery creation, Picking creation and PGI
- Combined delivery and delivery split
- Delivery document and item category configuration
- Plant determination
- Shipping point determination
- Route Determination
- Storage location determination
Billing
- Billing creation
- Combined billing and Invoice split
- Billing type configuration
- Pricing In billing
Additional Information –Real time
- ASAP Methodology
- RICEFW:
- Reports, Interfaces, Conversions, Enhancements, Forms and Workflow
- Overview of User exits and Formula Routine’s
- Overview of BAPI and BADI
- LSMW
- Different documents involved in implementation
- Support Process in real time
- Support tolls usage and few Support Issues discussion
- Change management Process
- Roll out process

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

♣ERP:
• Introduction to ERP
• ERP Comparison
♣Architecture:
• R/3 Architecture
• R/2 Architecture
• Architecture comparison
• SAP Instance
• Work process Services
♣SAP Landscape:
• Multi system Landscape
• 3 System Landscape
• 2 System Landscape
• 1 System Landscape
♣Implementation Phases:
• Project preparation
• Blue print
• Realization
• Testing
• Go live and support
♣Installation (Windows)
• Pre Installation activities
• Installation
• Post Installation
• Installation of SAP ECC with EHP5 on Oracle 10G
• Starting and stopping of SAP System

♣SAP Licensing:
• Overview of applying SAP license from SAP AG
• Install / Edit /Delete / License

♣SAP Directories:
♣User Administration:
• User master records
• User creation, deletion, lock, unlock, copy
• Mass user creation / deletion
♣Client Administration:
• Local client copy
• Remote client copy
• Client export / import
♣SAP securities:
• Roles
• Profiles
• Authorizations
• Single sign on
♣TMS (Transport Management System)
• Landscape design
• Transport domain
• Transport group
• Transport routes
• Transport layers
• Transporting at OS level and SAP level
♣CCMS (Computing Central Management System)
• Health check
• Profile parameters
• Operation modes
• Background Jobs
• Standard Jobs
♣Spool Administration:
• Local printing
• Remote Printing
• Access method
• Temp Se Administration
♣Patch Management:
• Knowledge about OSS (Online Support Services)
• Adding patches and plug ins
• Kernel patches
♣Database Administration:
• Oracle database administration
♣SAPDBA:
• Table space administration
• Starting and stopping instances
• Reorganization
• Exporting database
• Database backup
• Restoring database backup
• Archive logs
• Database file system

♣Advanced topics:
• Live demonstration of SAP market place
• Solution Manager Maintenance optimizer
• Solution Manager Early watch alerts
• System copy
• Knowledge of DB refresh
• Knowledge of upgrades

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Introduction (1 Hr)

• Introduction to ERP, SAP, Data Warehouse
• Overview of BW, BI, Data Base.
• Overview of BW Architecture, Landscape
Basic Modeling (2 hr )
• Multi-Dimensional Star Schema (Classical Approach)
• Multi-Dimensional Star Schema in BW (Extended star Schema)
• The OLAP Concept and differences between OLAP and OLTP
Business Modeling (20 Hrs)
• Info Area
• Info Object Catalogs
• Info Objects
• PSA
• Application Component
• Info Source
• Data Source
• Transfer Rules
• Update Rules
• Transfer Structure
• Communication Structure
• Info Package
• Transformation
• Data Transfer Process
• Loading Transactional Data into BW info Cube
• Loading MD with TD into BW System
• BW and BI Comparisons
• Master data loading-new(BI) ETL process
• Info cube & Types
• Standard Info cube and Loading with new ETL Process
• Generate Report with BI master and Transaction Data
• Manual Uploading of MD like Attributes, Text, Hierarchy
• Different Types of Attributes
• Transformations , Rule types
Routines (2 Hr)
• Start Routine
• End Routine
• Expert Routine
DTP (Data Transfer Process) (1 Hr)
• Standard DTP
• Error DTP
• Direct Access DTP
• Real time DTP
DSO (Data Store Object) (1 Hr)
• Standard DSO
• Write optimized DSO
• Direct update DSO
• APD (Analysis Process & Design)
Update Methods (1 Hr)
• Full updates
• Initialization
• Delta Updates
Info Providers(5 Hrs)
• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning
• Open-Hub Destination
• Data Marts
Info Cube Maintenance (2 Hr)
• Aggregates
• Roll-up
• Compression
• Reconstruction
Process Management (2 Hr)
• Process Chains, Process Types
• Scheduling
• Monitor (Header, Status, Details)
Reporting(15Hrs)
• Business Explorer
• BEX Query designer
• BEX Analyzer
• BEX WAD
• BEX Report Designer
Functional Overview of Bex Query Designer
 Reusable Query Elements
• Query Controls with Variables
• Calculated Key Figures
• Restricted Key Figures
• Formulae
• Structures
 Variable Definition in Detail
• Characteristic values variables
• Text Variables
• Formula Variables
• Hierarchy Variable
• Hierarchy Node Variable..
Process Types:

Manual input
Customer exit
Replacement path
SAP Exit
Authorzatio
 Analysis Functions
• Conditions
• Exceptions
 Reporting Drilldown
• Drilldown to DSO from Info Cube (RRI)
• Copying Queries from Cubes
• Bex Analyzer
• Bex WAD
• Bex Report Designer
• Migration Objects from BW 3.x to BI 7.0
• Transportation
Extraction (10)
• Generic Data Extraction using MD/TD Tables
• COPA Extraction
• Business Content Extractions using MD/TD
• LO-COCKPIT Data Extraction
 Delta types For
• Generic Extraction
• LO Extraction
• ASAP methodology

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Human Resource Essentials

•Components of HR Module
•How HR is different from Other Module
•HR Technical Overview
•Functional Overview
•Personnel Administration
•Organizational Management
•Payroll
•Time Management
•Benefits

HR programming
•Logical database PNP
•Structure Of Database Tables in PA
•Infotypes
•Time constraint Class
•Data retrivel
•Repetive Structure and List Display
•Logical database PCH And PAP
•Structure of DB Tables in PCH and PAP
•Data Retrivel using LDBs and Macros
•Practice Session – 1 1

Custom Infotype creation and enhancements
•Customer Infotype
•Infotype Enhancements
•Screen modifications
•Data Model in HR
•Important Table In HR

Basic Payroll
•Entering payroll data
•Organizing a live payroll run
•Payroll process
•Payroll reports
•Practice Session

Payroll Programming
•Payroll Cluster
•Payroll Programming using clusters
•Practice Session

Authorizations
•General authorization checks

Reporting
•Reporting methods
•Reporting in OM
•Payroll and time management infotypes

Final Evaluation
•Modularization techniques
•Performance tuning
•Requirement Analysis & debugging
•Interview Techniques

Misc Topics
•HR Forms
•HR Administrative Processes and Forms
•Report Category

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

SAP NETWEAVER TRAINING CURRICULUM Session 1

Introduction

NetWeaver Architecture

Installation

Portal User Experience

Navigation

Personalization

WYSWAS

Portal Administration

Concept -> Reality

Content Admin

User Admin

Users, Roles, Groups

Portal Content

Portal Content Directory (PCD)

iViews

Pages

Worksets

Roles

Users

Delta-links

GD*

Portal Runtime & Portal Apps

PRT Definition

Portal Components

PAR File Format

Deployment Descriptor

GD*

Portal Runtime & Portal Apps

Introduction to Portal API

Introduction to HTMLB

DynPage Model

Events

GD*

Session 2

Portal Runtime & Portal Apps

Introduction to Beans

GD

JSPDynpage

HTMLB in JSP

¡P Forms

¡P Compilation

Element IDs

GD*

Portal Runtime & Portal Apps

Client Events

Eventing Framework ¡V EPCF

Raising and Subscribing to events.

GD*

Server Events

GD*

Session 3

DB Connectors

Configuring Connectors

GD*

Visual Composer

GD*

Webservices overview for VC

Introduction to WebDynpro programming model.

GD*

WebDynpro Contexts.

Context Mapping ¡V External & Internal.

GD*

Session 4

Configuring EP Gateway to connect to SAP.

Configuring SAP connectors.

Adaptive RFC.

GD*

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No