SAP BODS Online Training | Best SAP BODS Course Hyderabad USA

SAP BODS Online Training | Best SAP BODS Course Hyderabad USA: SAP BODS Online Training Course Content
Introduction to BODS

Place of BODS among modern DI software package
Competitive advantage of BODS
ETL and ELT approach
How both approaches can be combined in one tool
Data Services components and architecture

Basics of BODS

Concepts of Job, Workflow and Data Flow
Concepts of Datastore
Creating basic Batch Job
Transforms overview

Data profiling and Query Transform

Analyzing data sources
Joining data from multiple sources
Basic transformations and build-in functions
Aggregating data in BODS
Lookup

Working with Files

Defining file formats for file data source
Working with XML files(XSD,DTD)
COBAL COPY BOOKS
File Formats as Source and as Targets

Platform Transforms Overview

Case and Merge transforms
SQL transform
Validation transform
Row Generation
Map Operation
Combining Validation and Auditing – best practices

Data Integrator Transforms

Working with hierarchical data
Hierarchy Flattening transform
Merging data
Table Comparison transform
Other ways of merging data for RDBMS d



SAP BODS Online Training Course Content

 



Introduction to BODS
  • Place of BODS among modern DI software package
  • Competitive advantage of BODS
  • ETL and ELT approach
  • How both approaches can be combined in one tool
  • Data Services components and architecture
Basics of BODS
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Datastore
  • Creating basic Batch Job
  • Transforms overview
Data profiling and Query Transform
  • Analyzing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Lookup
Working with Files
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • COBAL COPY BOOKS
  • File Formats as Source and as Targets
Platform Transforms Overview
  • Case and Merge transforms
  • SQL transform
  • Validation transform
  • Row Generation
  • Map Operation
  • Combining Validation and Auditing – best practices
Data Integrator Transforms
  • Working with hierarchical data
  • Hierarchy Flattening transform
  • Merging data
  • Table Comparison transform
  • Other ways of merging data for RDBMS datastores
  • Slowly changing dimension support in BODS
  • History preserving transform
  • Using built-in functions
  • Use date and time functions and the date generation transform to build a dimension table
  • Use the lookup functions to look up status in a table
  • Use match pattern functions to compare input strings to patterns
  • Use database type functions to return information on data sources
Metadata Management
  • Local and Central repositories
  • Working in a group
  • Propagating Job from development to staging and production environment – best practices
  • Backing up metadata
  • ATL file. Export\Import operations
  • Validating, tracing, and debugging jobs
  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger
Management Console
  • Administrating BODS
  • Overview of all major tools
  • Execution of a Job from server
  • Scheduling a job
  • Auto Documentation reports
  • Designing ETLs with auto documentation in mind
BODS Scripting Language
  • Variables in BODS – Scope of variable
  • Scripting language – Advantages and limitations
  • Custom functions in BODS
  • Creating simple function
  • Database procedures
  • Custom functions vs. database functions
SAP BW 7.5 AND SAP ECC, SAP CRM BODS INTEGRATION
  • Connecting to SAP Applications
  • ABAP data Flow processing Using Dataservices
  • IDoc interface connectivity Using Dataservices
  • SAP Application table source in real jobs using Dataservices
  • Executing Batch jobs that contain ABAP Dataflows
  • Connecting to SAP Net weaver Business warehouse
  • Using Dataservices in SAP NW BW environments,Openhub tables
  • Defining SAP Net Weaver BW Datastores Using Data services
  • Loading into SAP NW BW using Dataservices
HANA 1.0 SPS8 BODS INTEGRATION
  • BODS 4.2 with HANA to builg Agile Datamarts using Diffrennt Transforms and File systems
Error Handling in BODS
  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow level – Try and Catch objects
  • Analyzing execution of Batch Job – Log files
  • Debugging in BODS
  • Handing execution errors – best practices
Performance optimization in BODS - Part 1
  • Push-down concept
  • Cases when push-down doesnít work
  • Data Transfer transform
  • Cashing in BODS
  • Defining cashing for lookups and Table Comparison
Performance optimization in BODS - Part 2
  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • Using MultiLoad for Teradata targets
  • Execution parameters
  • Rows per commit
  • Number of loaders
Using BODS Metadata
  • Access to BODS metadata
  • Operational metadata
  • Auditing metadata
  • Creating your own metadata by using BODS metadata
Possible Alternative Topics
  • Data Quality in BODS
  • SAP and SAP BODS / BODI
  • Real-time job
  • Integration with other applications
  • Automatic job creation from template

SAP FICO Online Training | SAP FICO Training | SAP FICO Certification Course

SAP FICO Online Training | SAP FICO Training | SAP FICO Certification Course: Winsomesoft Provides Best SAP FICO Training with FICO ECC 6.0 Certification Material, Learn SAP FICO Online Training by experts | Tutorial Videos | Attend free demo & you will find Winsomesoft is the best Institute within reasonable fee SAP FICO Training in Hyderabad Bangalore USA Canada UK Singapore Malaysia South Africa Australia Dubai Germany SAP consultant certification exam C_TFIN52_67 and C_TFIN22_67 Certified Associate





      SAP FICO Online Training Course Contents





Overview of SAP FICO


  • What is Finance and Controlling
  • Sub modules in Finance and Controlling
  • Introduction to General Ledger Accounting
  • Introduction to Accounts Receivables
  • Introduction to Accounts Payables
  • Introduction to Assets Accounting
  • Introduction to Controlling
  • Concepts of Integration with MM and SD and CO



Financial Accounting


Global Parameters-Basic Configuration Steps


  • Company and Company Code
  • Business Area and Credit Control Area
  • Field Year Varian-Types of Fiscal Years
  • Chat of Accounts-Types of COA
  • Account Groups
  • Posting Period Variant
  • Document Types
  • Field Status Variants & Groups
  • Multiple Currencies
  • Introduction to Multiple Ledgers
  • Other Aspects of Global Parameters G/L & new
  • Tolerances for employee groups



General Ledger Concepts


  • Retained Earnings and importance of Retained Earnings
  • Tolerance Groups for Employees
  • Exchange Rate Maintenance
  • Foreign Currency Valuation and Translation
  • Financial Statement Version
  • Transfer Balances and Carry Forward( Balance Sheet & P&L ltems)
  • Posting keys
  • Documents in G/L – Park & Posy, Hold, Recurring, Account Model etc…
  • G/L Reports
  • Month end closing and year end closing



End user Activities with respect to GL Accounting


  • Posting of GL documents
  • Multiple Line item Posting
  • Document parking and Holding
  • Blocking and Unblocking of GL Accounts
  • Reference Documents
  • Fast Data Entry
  • Reversal of Documents, Single and Multiple Reversals
  • Posting in Foreign Currency transactions
  • Generating GL related reports



New GL Concept


  • Importance and advantages of using of New GL in FI
  • Activating Document Splitting
  • Parallel Ledges
  • Posting in parallel legers
  • Define Currency for Additional Ledgers



Accounts Receivables


  • Customer Account Groups
  • Document Types for Customers
  • Number Range assignment for Customer Account groups
  • Customer Master Data
  • Reconciliation Account for customer and Vendor Master Data
  • Posting of Customer Invoices
  • Treatment of Customer Down payments
  • Treatment of Bills of Exchange
  • Dunning
  • Treatment of Customer Discounts
  • Customer Credit Notes
  • Generating Customer Party statement of Account
  • Interest Calculations on Customer
  • Integration between SD and FI modules
  • Management information Reports



Accounts Payables


  • Vendor Account Groups
  • Document Types for Vendors Documents
  • Number Range assignment for Account groups
  • Vendor Master Data
  • Reconciliation Accounts for Vendor Account groups
  • Posting of Vendor Invoices
  • Down Payments to Vendors
  • Bank Guarantees with special GL indicators
  • Tax Calculation Procedure
  • Detailed Configuration of Extended withholding Tax
  • Automatic determination of G/L accounts for Taxes,
  • Automatic Payment program (APP) and House Banks
  • Cheque Register, Cheque Maintenance,
  • Management Information Reports for Vendor
  • Integration between FI and MM modules.



Bank Accounting


  • Configuration of House Banks
  • Electronic and Manual Bank statement
  • BRS entries.



Asset Accounting


  • Chart of Depreciation
  • Define 0% tax Codes for Asset Accounting
  • Asset Classes and Account determination of Asset Classes
  • Depreciation Areas
  • Screen Layout Rules and Number Range Assignments
  • Group Assets
  • Asset Master data (Main and Sub Assets), low value assets
  • Assets Acquisition (direct and AuC)
  • Asset retirement (Scrapping, with Revenue with Customer and without Customer)
  • Inter and Intra Asset Transfers
  • Asset Reports/ with Different variants and Asset explorer
  • Strategy on data Migration related to Assets ( Legacy Assets- Upload Process)



Integration


  • FI – MM Integration (Configuration from MM to attain PO, GR and IR
  • Account Assignment Categories PO and business process to be used with different Account Assignment Categories.
  • Valuation Area, Valuation class and its importance in Material Master.
  • Accounting Aspects from Material Master
  • Material Movement Types
  • OBYC and G/L account assignments from MM process
  • FI-SD Automatic Accounts determination
  • Revenue Reorganization Process in FI and SD Integration



Controlling


  • Basic settings in Controlling Area
  • Define Controlling Area
  • Number Ranges in Controlling Area
  • Concept of Versions in Controlling Area
  • Assignment of Controlling area to Company Codes
  • Importance of Different Fields in controlling Area
  • Controlling & Cost Element Accounting
  • Activity Type
  • Activity type categories
  • Planning and Budgeting of cost Elements
  • Cost Elements Categories
  • Cost Elements groups
  • Cost Elements groups



Cost Center Accounting


  • Cost Center Hierarchy
  • Cost Center Groups
  • Cost Center Categories
  • Posting entries in Cost Centers
  • Manual Reposting of Costs
  • Distribution and Assessment
  • Cost Center Planning
  • Information system Cost Center Reports



Internal Orders


  • Order Management in Controlling Area
  • Define and Assign Number ranges to Order Groups
  • Internal order Planning, budgeting.
  • AuC (Assets) Process with Internal Order (Real)
  • Information System (Reports) for Internal Orders



Profit Center Accounting


  • Maintain Profit Center and Activation of Company Codes in Profit Center
  • Control Parameters for Actual data
  • Plan Versions
  • Profit Center Groups
  • Distribution & Assessment
  • Repots in Profit Center Accounting.

SAP MM (Material Management) Online Training

Winsomesoft is the best SAP MM Training Institute   Learn SAP MM  Online Training with Course Material | Tutorial Videos | Attend Free Demo & you will find Winsomesoft is the Best Institute for SAP MM Online Training within reasonable fee.
The Training in SAP Material Management  Course is every thing we explained based on real time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.



Read more »
Subscribe to: Posts (Atom)