SAP BW Extraction Book for Beginners

Extraction programs that read data from extract structures and send it, in the required format, to the Business Information Warehouse also belong to the data staging mechanisms in the SAP system as well as the SAP Strategic Initiative products such as APO, CRM and SEM.

In this e-book you will find instructions of the following topics;

  • Data Extraction from SAP Source Systems: Introduction, Transfer Method – PSA and IDoc, DataSources, Data Extraction Logistics, LO Cockpit Functions, LO Data Sources Data Flow, Structure of Delta Method for LO Cockpit Data Sources, Delta Method, Delta Method Properties, Delta Queue Functions, Generic extraction, Generic Data Types, Generic Data sources
  • Extraction with Flat Files: Data from Flat Files (7.0, Data from Flat Files (3.x),
  • DB Connect
  • Universal Data Integration: Process Flow, Creating UD source system, Creating a DataSource for UD Connect,
  • BI JDBC Connector
  • BI XMLA Connector: Using InfoObjects with UD Connect, Using SAP Namespace for Generated Objects
  • XML Integration:
  • Data Mart Interface
  • Virtual InfoCubes

Read more →

/0 Comments/by

Step by Step Guide to Sending Purchase Order Via Email & Fax in SAP

This documents explains the required steps with screenshots for sending purchase order as an “External Send” in SAP. You will find following instructions in this tutorial;

  • Ordering via the Gateway – [ME21]
  • Attaching Documents
  • Refaxing Orders
  • Transmissions Logs [SOSB]

Read more →

/0 Comments/by

A Reference Study Material on Purchasing Process in SAP

After reading this step-by-step SAP Purchasing Process manual, users will understand the steps in the purchasing process and will learn how to perform each one of them, from creating a requisition to the final step of closing it. See contents below:

Creating and Maintaining Requisitions: learn how to use ME51, ME52, ME52N, and ME53 to create, display and maintain purchase requisitions in SAP
Goods Receipting in SAP: learn how to use MIGO in SAP to goods receipt all orders they have received
Reviewing Purchase Orders: learn how to use ME23N to review information on their Purchase Orders
Purchasing Reports: Participants will learn how to use various purchasing reports to pull important information on their documents
Read more →

/0 Comments/by

SAP HCM (HR) Organizational Structure Basics: What is Personnel Subarea?

Personnel sub areas are a subdivision of the Personnel Area. Personnel Subareas are used in personnel administration, personnel time management, and payroll accounting in SAP. In Customizing, the personnel subarea is identified by a four-digit alphanumeric key. The respective country-specific control features are stored here.

The most important organizational functions of personnel subareas are:
Read more →

/0 Comments/by

Advanced BW Reporting Concepts in SAP

This quick reference guide shows you how to perform the following BW reporting functions in SAP:

  • Executing A BW Report
  • Saving A BW Report Variant
  • Viewing/Removing Report Hierarchy Details
  • Changing How Report Data Is Displayed
  • Changing To Cumulative Output Amounts
  • Changing Sort Order of Report Data
  • Suppressing/Unsuppressing Zero Rows
  • Suppressing/Unsuppressing Total Rows
  • Normalizing Report Results
  • Swapping Displayed Report Fields
  • Adding Drilldown to a Report
  • Moving Back One Screen
  • Changing Where Totals Are Displayed
  • Suppressing/Unsuppressing Repeated Key Fields
  • Refreshing A Report
  • Changing Other Report Attributes
  • Other BW Reporting Buttons
  • Attaching A Chart To A Report
  • Protecting A Report From Formatting Changes
  • Saving A Report As A Favorite
  • Saving Report Data In An Excel Spreadsheet
  • Turning On/Off the Right-Click Functions
  • Business Explorer Menu

Read more →

/0 Comments/by

Business Warehouse Management Guide in SAP

This material contains exhaustive notes and step by step guides for SAP Warehouse Management of the following topics;

  • Structure of the Administrator Workbench
  • Scheduler: Steps for creating InfoPackage, Steps for scheduling a package, Inserting an InfoPackage into the Process Chain, Maintaining Data Transfer Control Parameters for DataSources, Handling Duplicate Data Records
  • Process Chain: Step by step Process Chain Creation, Loading Hierarchy using Process Chain,
  • InfoObject in SAP BW: Key Figures, Key Figures, Time Characteristics, Units, Technical Characteristics
  • Data Flow in BW: Dataflow in Detail, Creating Source System in BW, Datasource, PSA (Persistent Staging Area), Transfer Rules, Updates Rules, InfoSource, InfoPackage
  • Business Content: Activation Procedure, Installing Business Content,
  • Metadata Repository: Metadata Services Architecture, Metadata Repository,

Read more →

/0 Comments/by

SAP HCM (HR) Organizational Structure Basics: What is Personnel Area ?

In SAP, Personnel Areas represent a subdivision of the company code, applicable to employees. The individual personnel areas in a company code are defined in Customizing and have a four-digit alphanumeric identifier. The personnel area is only used in Personnel Administration and is unique within the client. They perform the following functions:

  • enables the generation of default values for data entry (eg determination of payroll accounting areas);
  • acts as a selection criterion for reporting; and
  • acts as a unit in authorisation checks.

Although a Personnel Area can only belong to one company code, they are further divided into Personnel Subareas.
Read more →

/0 Comments/by