Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Add new field to SAP standard table

Former Member
0 Kudos
3,744

Hi,

If I have an access key for a SAP standard table , Can I directly add a standard field to a SAP standard table whithout using Include or append structure. Will it affect during the upgrade? I think its always done by using include or append structure. Can anyone please provide suggestion on this?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
1,099

Hi,

You can add field to standard table . We can enhance the standard tables by append and CI(customising includes) Append structures allows to add fields to a standard table without actually modify the table .

Regards,

Rajani

18 REPLIES 18

Former Member
0 Kudos
1,099

Better use append structure ,this will be added during upgrade

Former Member
0 Kudos
1,099

Hi Amar,

It's gd that u have the access key but u should always be careful while adding fields to any SAP Standard table, it creates problem in upgradation.

Yes, u can directly create new fields in any standard tables also u can modify the standard sap programs, but during upgradation sap re-builds all its tables & their structures so any modifications done to standrad tables will be affected & possibly your license to sap can be rejected (if any), it will cost u lot !! for support from SAP on this.

Hope my point is clear to understand.

Thanks

Ravi Aswani

Former Member
0 Kudos
1,099

Hi Amar,

Also Use of Append Structure is enabled with access key, so use this to add a new structure to your sap table.

Thanks

Ravi Aswani

Former Member
0 Kudos
1,099

hi,

Even though you have the access key to modify the standard contents, its preferred that the standard tables are not altered, because may be later on during upgradations there may be some inconsistencies.

So use append structures to add fields to the standard table.

Also try out CI include.

thanks

Sharath

Former Member
0 Kudos
1,099

Hi Amar,

Welcome to SDN.

it is not a good idea to alter standard tables directly as it may impact during upgardation. That is the reason why SAP has given the option of append structures and Customized includes. These are created under the customer namespace so they are not changed during upgradation.

I hope this helps.

Regards,

Sachin

Former Member
0 Kudos
1,099

Thank you all. I was doing this as a part of application of OSS note, where some changes have to be done manually.I wanted to make sure that i dont mess with standard functionality.

0 Kudos
1,099

>

> Thank you all. I was doing this as a part of application of OSS note, where some changes have to be done manually.I wanted to make sure that i dont mess with standard functionality.

If the OSS note is stating you should do it manually, then feel free to do so.

shadow
Participant
0 Kudos
1,099

Hi Amar,

You can use .INCLUDE or .APPEND for adding a field to the data base table,

if r u using .INCLUDE functionality , we can reuse the structure in SAPR/3.

or

Using .APPEND functionality we can restrict the structure to specific table.

So better u use .APPEND.

Regard;s

SHAIK.

Former Member
0 Kudos
1,099

hi

you can use both appen structures and customizing includes for addine fields to

standard table.Customizing includes are first created in the customer system

and filled with fields with special customizing transaction.So in this way customers can

enhance tables without realy modifing the standard table itself.

During upgrades these includes are not affected because they are in customer name space.

The fields added in this manner will be inserted in the new delivery.

These includes are also reusable.But append structures are not reusable.

Former Member
0 Kudos
1,099

Hi Amar,

Use only append structures to add fields to the standard table.

Then u will not have any error.

Thanks,

N.Neelima.

Former Member
0 Kudos
1,099

Hello Amar,

Adding new fields or structure to SAP standard table effects the process of upgrading, it is better idea to consult your Basis Consultant, before you proceed altering standard tables.

Hope it may help.

Courtesy: Zahackson

Former Member
0 Kudos
1,099

Hi ,

To add new fields to SAP tables it is always advisable to use APPEND structures or Customizing Includes.

For further details refer to the below link :

http://www.saptechies.com/in-how-many-ways-we-can-modify-sap-tables/

Regards,

Radhika.

Former Member
0 Kudos
1,099

Use Append Structure in SE11.

Regards,

Joan

Former Member
0 Kudos
1,100

Hi,

You can add field to standard table . We can enhance the standard tables by append and CI(customising includes) Append structures allows to add fields to a standard table without actually modify the table .

Regards,

Rajani

Former Member
0 Kudos
1,099

append structure is a better way

or you can create a new like-standard table,and use it later

Former Member
0 Kudos
1,099

Hi,

Please check with this link

[Link|]

Hope this link helpful to you

Regards,

Rajani

0 Kudos
1,099

Hi dear all,

does anybody knowhow to add new field in BKPF table?

thank you all

Edited by: Fernando Figueiredo on Mar 4, 2009 6:12 PM

Former Member
0 Kudos
1,099

Hi,

Use Append structure so that it will not give any problem during upgrade.