ERP Database - The Unofficial ERP Knowledge Base

Facebook Twitter del.icio.us Digg it
ERP Database contains a huge collection of articles related to ERP System and Software. Many of the articles are specifically related to SAP. All these ERP/SAP articles are freely available to everyone.

If you would like to submit an article or share any document related to ERP or any specific ERP software. Please mail it to support@erpdb.info. Please make sure that the documents are not copyrighted.
Social Bookmarks:

Archive for September, 2009

Generic Extraction in SAP BI

Print This Post Email This Post Written by admin on Sep 28th, 2009 | Filed under: Business Warehouse (BIW)

When the data source is not readily available in the Business content. Even if the Business content data source is available and it is already being used up and if we want to simulate the same kind of extractor, we can go for generic extraction.

The T-code for creating Generic Extraction is RSO2.

We can create 3 types of data sources using generic extraction

  1. Transaction data
  2. Master data attribute
  3. Text

We can generate generic datasource using the following

  1. Table
  2. View
  3. Function module
  4. Infoset Query

Download the Document with Screen Shots (10999) on working with Generic Extractions in BI.


5 Comments Get FREE daily updates by RSS or e-mail

SAP BI (Business Intelligence) Overview

Print This Post Email This Post Written by jimstex on Sep 28th, 2009 | Filed under: Business Warehouse (BIW)

SAP BI Overview contains overview about:

  1. Difference between OLAP and OLTP
  2. Layout/steps in SAP BW
  3. ER-Model (Entity Relationship model)
  4. Designing DB
    1. Object Oriented
    2. Normalization
  5. DB concepts in OLTP
    1. Star Schema (traditional schema)
    2. Extended Star Schema (BW schema)
    3. Snow Flake scheme
    4. Hybrid schema
  6. Information about the first screen for BW

Download the document on SAP Business Intelligence overview (4252)


Leave a Comment Get FREE daily updates by RSS or e-mail

SAP Installation and Upgrades Screenshots.

Print This Post Email This Post Written by poojarychetan on Sep 28th, 2009 | Filed under: Basis

Attached is the link for all important installation that i have documented and would like to share to explore more on Basis activities.

http://rapidshare.com/files/284606380/install_upgradeSAP.rar

I will be adding more post on configuring CUA, and significance of Xcelsius tool.

Enjoy SAP.

Chetan Poojary.


7 Comments Get FREE daily updates by RSS or e-mail

Generate Temporary ABAP Program

Print This Post Email This Post Written by admin on Sep 10th, 2009 | Filed under: ABAP Programs

Ever had a need to create a temporary program during the run time. Here is a simple program which will allow you to learn that.

REPORT ZSOURCE2501.
* Internal table for source code, field for name of temporary program
DATA: SOURCE_TABLE(72) OCCURS 10 WITH HEADER LINE,
      PROGRAM_NAME LIKE SY-CPROG.
* Building the source code
APPEND 'report test.'                        TO SOURCE_TABLE.
APPEND 'form display.'                       TO SOURCE_TABLE.
APPEND 'write ''I am a temporary program''.' TO SOURCE_TABLE.
APPEND 'endform.'                            TO SOURCE_TABLE.
* Generating the temporary program
GENERATE SUBROUTINE POOL SOURCE_TABLE NAME PROGRAM_NAME.

Continue Reading …


Leave a Comment Get FREE daily updates by RSS or e-mail

SAP Installation Manuals with Screenshots

Print This Post Email This Post Written by jimstex on Sep 9th, 2009 | Filed under: Basis, Installation

Here is a collection of different SAP Installations manuals on SAP 4.7 to SAP ECC6 Upgrade, APO Installation, Installation of BW on solaris, mySAP upgrade, PI 7.0 Installation, SAP R3 Upgrade, and the general upgrade to ECC6 and finally XI Installation (ABAP & Java).

Download the installation manuals.

Like my post, leave a comment.


4 Comments Get FREE daily updates by RSS or e-mail