How to Add Calculation Base Columns in Data Browsers SE16 and SE11

  • by Faisal Altaf, SAP Technical Division Head, Al Yamamah Steel Industries Co.
  • August 17, 2015
Learn how to enhance the standard data browser functionality (transaction codes SE16 and SE11) to add calculation base columns in any table or view using implicit enhancement options. For example, you can add a column showing the number of days difference between the created-on date and billing-processed date of an invoice in the billing document header table. You can add as many fields as you want in any standard table without any modification. Every time a user browses the enhanced table, the system shows the added fields.
Learning Objectives
Reading this article, you will learn how to:
  • Implement implicit enhancement options
  • Add extra fields to a dynamic internal table at run time
  • Create a transport request and add an object to it
Key Concept

Enhancement options allow you to add your own functionality to SAP standard programs without modifying the original code. They resemble plug-ins that you can add or remove any time as per your requirement. Your functionality remains the same even after an upgrade. There are many enhancement types, but to fulfill the current requirement, the implicit enhancement is the key.

In data browser SE16 and SE11 you can see all the fields available in a database table or view. These fields physically exist at the database level. However, you can’t add any extra fields if you want to show the result based on calculations (e.g., the Column A + Column B result should be in a new Column X, but Column X is not part of a database table or view). The following examples explain the scenario in more detail.

A standard example scenario is that you have a requirement to show the difference in days between the creation of a billing document and the time that the billing is processed. To fulfill this requirement you need to add one column in table VBRK (Billing Document Header Data). This column obtains its value by subtracting the billing date [FKDAT] from the created on-date [ERDAT] (e.g., New Column = FKDAT – ERDAT).

In another scenario you have a requirement to add two columns in table VBAK (Sales Document: Header Data). The first column shows you the net value of your sales order in euros regardless of currency of your sales order, and the second column shows you the currency key (EUR).

To fulfill both these scenarios, follow these simple steps:

Step 1. Create an enhancement and add the required code

Step 2. Test the enhancement

Faisal Altaf

Faisal Altaf is a certified development consultant. He has more than seven years of experience and currently is working with Al Yamamah Steel Industries Co., Saudi Arabia, as the SAP technical division head. He completed his MS in software engineering and intends to complete his Ph.D. in the field of SAP.

 

 

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.