Skip to Content

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”.

/wp-content/uploads/2014/04/ss1_432804.jpg

Step2

Give the description and in domain give the data type.

/wp-content/uploads/2014/04/ss2_432821.jpg

Step 3

You can either choose domain or predefined Type.

/wp-content/uploads/2014/04/ss3_432822.jpg

Step 4

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

/wp-content/uploads/2014/04/ss5_432836.jpg

Step 5

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

/wp-content/uploads/2014/04/ss6_432899.jpg

Step 7

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

/wp-content/uploads/2014/04/ss7_432900.jpg

Step 8

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

/wp-content/uploads/2014/04/ss8_432901.jpg

Step 9

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

/wp-content/uploads/2014/04/ss9_432905.jpg

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.

/wp-content/uploads/2014/04/ss10_432906.jpg

Step 11

Now you have to fill the component and save it.

/wp-content/uploads/2014/04/ss11_432907.jpg

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.

/wp-content/uploads/2014/04/ss12_432908.jpg

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Raman Korrapati

    Are you adding fields to table at BW side?

    As my guess you might be added at ECC side not in bw. because in bw we don’t have sap standard tables(EKKO,EKPO and Etc..)

    Even this more belongs to ABAP development not to bw space.

    Thanks

    (0) 

Leave a Reply