Determine standard values of a production order via SAP ECC tables

Ever heard of norm time per operation? If you did, then you don’t have to read further, for those who didn’t please continue.

Last week a business user asked me if it was possible to calculate the norm time per operation on a production order and to add this Key Performance Indicator to an existing BW report. I actually never heard of this KPI. Nonetheless the formula behind it is pretty easy.

Norm time = Base quantity / Standard value of machine

So with this formula in mind my journey began in the SAP ECC source system. Via transaction CO03 I went to a production order and went to an individual operation. Per operation you are able to consult the standard values and the base quantity. The base quantity is straightforward and can be easily extracted via table AFVV.
Standard values of a operation for a specific production order
Extracting standard values is a little bit more complicated, due to the fact that these are attached to a specific work center via a formula parameter. There are multiple standard values available like labor, setup & machine time. For our norm time KPI we are only interested in the machine time.

Suppress Bex Broadcaster email footer

Per default an email footer is attached to every email which is send by the SAP BW system via the Bex Broadcaster. This footer contains a reference to the SAP portal. In some cases this footer is not applicable, for e.g. when an customer is not using the Bex Web Analyzer to execute reports. To prevent end users to get confused by seeing this footer it is necessary to disable it.
Suppress Bex Broadcaster email footer
This footer can be disabled by execution transaction code RSCUSTV29 and enabling the option suppress footer. Once done the footer message will magically disappear.
Suppress Bex Broadcaster email footer transaction RSCUSTV29
Some other (customizing) transactions related to the Bex Broadcaster functionality are mentioned in the table below.

SAP transaction code Description
RSRD_LOG Broadcaster application log
RSRD_ADMIN Broadcasting administration
RSRD_START Start broadcaster for test purposes
CRMC_CIC_BROAD IC WinClient broadcast profile
RSPRECADMIN BW Excel workbook precalculation server admini
RSCUSTV29 Settings for Web Template
RSRD_REPLACE Restart broadcasting for log number

Schedule Bex Broadcaster report using a process chain

A couple of weeks ago I posted a blog about changing Bex Broadcaster variables. Now this post is an follow-up on that article which describes how to automate the process of changing Bex Broadcaster variables and sending the reports to the users.

One way of automating this process is by creating a process chain. Leaving aside that this is probably the most easiest activity for a SAP BI consultant, creating a process chain with a Bex Broadcaster step could be challenging. Why? Because the default program which SAP advises to use for sending Bex Broadcaster workbooks, sets the monitor of the process chain directly to green. This results in multiple workbooks being calculated at the same time, which then leads to a decrease in performance on our Precalculation servers.

SAP tables and relations

Sometimes it’s useful to know how the different tables of SAP are related to each other, especially when developing new functionality in BW or ECC. Christopher Solomon and some other (yet unknown) people have composed a .pdf file where per functional area the entities and their relations are graphically displayed. Refer to the attached file to see the result.

Attachments

Bex Broadcaster dynamic variables

A couple of weeks ago I got a question from a sales analyst asking if it’s possible to automatically send out workbooks. Every morning the sales analyst is waiting for output of multiple workbooks. This consumes a lot of time. I responded that for this purpose SAP has a standard functionality available in the form of the Bex Broadcaster, but that I needed some time to setup the infrastructure and testing it.

If you have already worked with the Bex Broadcaster you probably know that scheduling queries can be used out of the box, without any additional server. However if you want to schedule workbooks you will need a precalculation server (which is actually a Windows computer with Excel and the precalculation service installed). Since the sales analyst is using workbooks with more than 35 queries in it (we are not talking about efficiency here), this additional precalculation server is required. All steps to setup this server are mentioned in this post on SCN.

During the testing phase scheduling a simple workbook worked straight out of the box (that’s a good thing!). Second test was executing the workbook consisting out 35 (!) queries. Believe it or not, this also worked. The only downside of scheduling this workbook, is that the variables which are assigned to the underlying queries were fixed values. This is a disadvantage because the workbook is refreshed every day based on the current calendar day. One option I considered in order to solve this, is to redesign the complete workbook (including the queries). This will take a lot of time, thus I started searching on Google and SCN, resulting in viewing this post. There someone explains how workbook variables can be changed dynamically by using a program he created. My quest was finished! We will use this program to manipulate Bex Broadcaster variables.