Here are step by step how to create characteristic in SAP BW InfoObject Tree.
To meet the user requirements, sometime we must modify original SAP ABAP program code (known as enhancement) beside add some fields or Structures into SAP tables. We must register access key for the object first to modify original SAP program code, but actually we do not need it since SAP has been provide source-code plugins. Read more… »
In SAP BW, InfoObject is defined as the smallest available information entity or object. Technically, it is same as field in a table. InfoObjects are part of the SAP BW metadata repository. They describe the properties (technical definition and business logic) of the application field as shown on the following table. Read more… »
The Administrator Workbench (AWB) is the tool for data warehouse management in SAP BW (Business Information Warehouse). Using AWB we can manage, control and monitor all relevant objects and processes in SAP BW including scheduling, data load monitoring and metadata maintenance. Following are the functions that we can perform using AWB: modeling, monitoring, transport connection, documents, business content, translation, and metadata repository. Read more… »
In this post, I will summarize the comparisons (advantages and disadvantages) between Classic Star Schema and SAP BW Star Schema. Note that there are so many similarities in the terminology and concepts used in SAP BW Star Schema compared with Classic Star Schema. The two critical terminologies different between them are dimension and attributes. Read more… »
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.
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.
