Author Archives
DSO or Data Store Object is a SAP BW object primarily used to store detailed transactional data on an atomic level. Unlike multidimensional data storage InfoCubes, it’s designed as a 2-dimensional flat database table that contains key fields and data fields. Data is normally held in a DSO for several years. There are 3 types […]
SAP provides a number of tricks to make it easier to navigate through the various menus and carry out the day to day activities. These tricks provide a 3 way advantage:
Most businesses need to carry out repetitive activities on a daily, weekly, monthly or yearly basis. For example, consider a business which needs to produce monthly sales reports for the senior management for each of the product lines. When a report is run by the end user, selection data needs to be entered on the selection screen of the report.
The end user may be required to enter around ten fields to generate the report. SAP makes it possible to enter this data every time with a single click. This would save a lot of time for the end user and also prevent the generation of the wrong report due to human error while entering data in the selection screen. A number of such tricks are described below.
SAP arranges all the transactions in the form of drill down menus as shown below.
The sales & distribution (SD) module in SAP allows the supply chain process for the business to be mapped into the software. SAP provides various components like the sales area, distribution channel, division, etc. for setting up the sales and distribution organizational structure. The sales and distribution enterprise structure does not exist in isolation from the rest of the modules in SAP. The sales and distribution module is closely integrated with the other modules like FI and MM. SAP best practices dictate that a good organizational structure must meet the company’s current needs and at the same time must be flexible enough to incorporate any future requirements. This makes the organizational structure scalable and ready to change with the growth of the company.
The sales and distribution organizational structure is set in two steps. First of all the organizational elements are created and then they are linked to each other by specific assignments. For e.g. a sales organization is created first, and then it is assigned to a company code.
A sales organization is the highest entity in the sales and distribution organizational structure. A sales organization represents the sales department in a company and is primarily responsible for the sale and distribution of its products and services. A sales organization needs to be mentioned while creating any sales related documents and needs to be assigned to a company code. The other sales and distribution organizational elements are assigned to the sales organization.
As a part of the best SAP business practices, it is recommended to keep the number of sales organizations to a minimum. Ideally there should be only a single sales organization for a single company code. Having a single sales organization makes the reporting process simple.
The Business Explorer Analyzer (BEx Analyzer) is the analysis and reporting tool of the Business Explorer that is embedded in Microsoft Excel. You can call up the BEx Query Designer in the BEx Analyzer, in order to define queries.
Full Course – Click Here
Subsequently, you can analyze the selected Info Provider data by navigating to the query created in the Query Designer and create different query views of the data. You can add the different query views for a query or add multiple queries to a workbook and save them there.
You can save the workbook in your favorites or in your role on the BW Server. You can also save the workbook locally on your computer. Beyond that you can distribute the workbook by e-mail to recipients.
In this document we will learn how to access and run BEx queries in addition to introducing some reporting functionalities used within BEx.
Access BEx Analyzer
To start the BEx Analyzer, choose Start→ All Programs → Business Explorer →Analyze. This will open Microsoft Excel with the SAP BEx plugins enabled.
Login
Click on the Add-ins tab
Add-Ins Tab
Choose the Open Icon in the BEX Analysis toolbox
Open Icon In The BEX Analysis Toolbox
In the Opened menu click on “Open Query”
Open Query
A window will pop up asking you to log on to the BW system. Insert your SAP BW username and password?Note that the User for BW client is different from the user in ERP client.
There are many reasons why a run-time error can occur such as un-handled exceptions, a resource or system problem or an error in coding. Let’s look a little deeper…
When faced with a program that crashes, developers end up spending a lot of time debugging ABAP code to find and trace what went wrong. But they should know that SAP records all the warnings, exceptions and system errors in the System Log. So, when we get an error we can make best use of time by taking a good look at the System Logs first to help find and correct the errors in our code quickly and easily.
System Logs Go To Transaction SM21
Basic financial statements are created in SAP on the basis of the company code. For traditional statements, all the transactions are grouped according to the company code and financial statements like balance sheet and Profit & Loss statements are drawn separately for every company code. But at times there is a need to carry out analysis across company codes according to some criteria other than the company code.
As an example, if there is a need to generate a financial report on the basis of a product line, geographical location or divisional sales, then this can be done using Business Areas. The purpose of business areas is to report on similar activities that occur across company multiple codes resulting is cross company reporting.
However the financial statements generated on the basis of business areas cannot be used for legal reporting purposes. For this reason, it is not possible to create the legally required financial statements and tax reports at business area level. Financial statements at business area level are therefore only suitable for internal reporting.
Concept Of A Business Area: Cross Company Code Analysis
Consider a situation where there are four companies in all, ABC Apparel, ABC Sports, ABC Shoes and ABC Services.
Undoubtedly, the most important tool in a ABAP programmers toolbox is the ABAP debugger, but here in this tutorial we are not going to focus on that, rather we will focus on “Tools for Analysis”. In a later article I will focus on “Tools for Troubleshooting”.
With the help of the code inspector you can check your ABAP code for performance, security, syntax, error proneness and Statistical information. You can perform different code checks using this tool on a single object (simple check on programs, function modules or classes) or a set of objects (special check on set of objects).
Example of Checking a single object:
Calling code inspector for single objects is very easy, to call it from programs go to Program (SE38) then from the menu choose Check=> Code Inspector
From Function Modules go to Function Modules – SE37 then from the menu choose Check=> Code Inspector.