Addition of fields to the standard tables in SAP BW
This document explains about the step by step procedure to enhance base tables along with screen shots.
Author: Deben Sahani
Company: L&T Infotech
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.
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.
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”.
Give the description and in domain give the data type.
You can either choose domain or predefined Type.
You can find the domain type in Entry help/check tab. For example any date field will be having domain type “DATUM”.
You can also give predefined data type as shown in the below screen shot.
Now go to se11 and display the base table you want to enhance.
Click on the append structure as shown in below screen shot.
Choose create Append and give a name started with “Z”.
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.
Now you have to fill the component and save it.
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.