myNotes from mySAP Learning

SAP BW Star schema is based on the extended of the classic star schema (aka “snowflake” schema). The enhancement comes from the fact that the dimension table does not contain master data information. This master data information is stored in separate tables, called master data tables. In SAP BW Star Schema, the distinction is made between two self-contained areas: infocube and surrogate ID (SID) tables. Read more… »

A Star Schema is a multi dimensional data model that organizing information or data in a data warehouse. It is based on a central fact table surrounded by several dimensional tables in shape of a star. Using star schema, we can view business information from many perspectives. SAP calls this schema as Classic Star Schema to differentiate with SAP BW data model developed by SAP.

Read more… »

Sometimes we need to add new fields into SAP standard tables to meet user requirements. Fortunately, SAP has provided tool to add fields without change the tables called Append Structure.

An append structure is a structure that is assigned to exactly one table or structure. There can be more than one append structure for a table or structure. As others user enhancements, the name of append structure should also reside in the customer namespace, which is the field names should begin with ZZ or YY. This prevents name conflicts with fields inserted in the table by SAP. Read more… »

In last two weeks, I have learned self-taught how to create table control in SAP Screen using ABAP 4. After trial and error, finally I have finished my small project. While learning about table control, I use SAP Help as main reference, some websites and presentation slides from Michael Adams, Queensland University of Technology.

A Table Control is a screen ‘container’ or object that allows display of multiple rows of a table (database or internal table) on a screen. It is good for displaying a one-to-many relationship on the one screen. The table control object has many features built in to enhance screen display and usability. Read more… »

The data flow in mySAP BW (Business Warehouse) begins with the transfer of data from the source system to the Persistent Staging Area (PSA) using InfoPackages. The data is stored in the PSA using tables, which are based on prior defined DataSources. After that the Data Transfer Process (DTP) transfers the data via transformation into an InfoSource and then to a Data Storage Object (DSO), which is the base for the following queries.

Read more… »