Addition of fields to the standard tables in SAP BW

Summary

This document explains about the step by step procedure to enhance base tables along with screen shots.

Author: Deben Sahani

Company: L&T Infotech

Author Bio

Deben Sahani, working in L&T Infotech has three and half year experience in SAP BI 7.0 and he has been working in Implementation and Custom development projects.

Scenario

Some business scenario requires a customized field which needs to be added to the standard table provided by SAP. In below example  release date is being added to EKPO table.

Step1

For enhancing a base table you will need a data element. For creating a data element you need to follow below procedure.

Go to transaction code SE11 and create a data element. The name of data type should be start with “ZZ”.

Step2

Give the description and in domain give the data type.

Step 3

You can either choose domain or predefined Type.

Step 4

You can find the domain type in Entry help/check tab. For example any date field will be having domain type “DATUM”.

Step 5

You can also give predefined data type as shown in the below screen shot.

Step 7

Now go to se11 and display the base table you want to enhance.

Step 8

Click on the append structure as shown in below screen shot.

Step 9

Choose create Append and give a name started with “Z”.

Step 10

In the component give the component name and in “Component Type” give the component name and click on “Search for Data Elements” and search the data element you created.

Step 11

Now you have to fill the component and save it.

Step 12

After saving the object, while you try to activate the changes it will show screen like below .Just make sure the append structure created you by you is being highlighted. You can press  button to make the changes effective.

After this field will be reflected in view of the base table.