SAP Tutorials

SID

SID (Surrogate-ID) translates a potentially long key for an InfoObject into a short four-byte integer, which saves I/O and memory during OLAP.

Source system

A source system is a protocol that BW uses to find and extract data. When the source system is a non-SAP system, such as a flat file or a third-party tool, the maximum number of characters allowed for the technical name is 10. When the source system is an SAP system, either R/3 or BW, the technical name matches the logical system name. The maximum number of characters allowed for the technical name is 32.

Star schema

A star schema is a technique used in the data warehouse database design to help data retrieval for online analytical processing.

Statistics

For a SQL statement, many execution plans are possible. The database optimizer generates the most efficient execution plan based on either the heuristic ranking of available execution plans or the cost calculation of available execution plans. Statistics is the information that the cost-based optimizer uses to calculate the cost of available execution plans and select the most appropriate one for execution. BW uses the cost-base optimizer for Oracle databases.

System Administration Assistant

System Administration Assistant is a collection of tools used to monitor and analyze general system operation conditions.

System landscape

The system landscape specifies the role of each system and the paths used in transporting objects among the various systems.

tables created for master data

a. P table - Time independent master data attributes

b. Q table - Time dependent master data attributes

c. M view - Combines P and Q

d. X table - Interface between master data SIDs and time independent navigational attributes SIDs ( P is linked to the X table)

e. Y table - Interface between master data SIDs and time dependent navigational attributes SIDs (Q is linked to the Y table)