add new fields to a table

[Former Member]

how to add new fields to a standard sap table ?

Regards,

swathi.

[former_member386202]

Hi,

Using append structure u can add the field into satndard table.

Regards,

Prashant

[Former Member]

Hi,

You can't change standard sap objects.

IF u want to add additional firlds copy same structure into custom table and then add fields.

If u still want to change standard objects u must get acess key for that.

Reward if it helps...

Regards,

Sankar

[Former Member]

hI Swathi

u can find include in a standarc table.

if u have sap just open EQUI table and here u can findout CI_EQUI if u double click yhat one and u can add fields here.........

reward points to all helpful answers

kiran.M

[Former Member]

Hi,

Go to Se11 Tcode ---> Select Required Table ---> Display ---> Click on Append Structure Button on Application Toolbar ---> Choose Create button ---> Provide name of Include table then add required fields save and active .

After Activation of table , Check whether additional columns added at the last of the table.

Hope the above solution solves your problem.

With regards,

K K V

[suredarreddy_pulimamidi]

to add new fields to SAP standard tables use append structures or use customizing includes.For every data base table there is a include CI_INCLUDE field.when we use screen exits then we use customizing includes.

if helpful reward points.

[Former Member]

I like the way everyone jumps in with answers (some of which are wrong) without knowing all the facts. Perhaps they are after the points?

Extra fields can be added to SAP tables in some cases, but not in others.

What is the table you wish to add extra fields to?

What type of table is it?

A number of cluster tables, pool tables and SAP customising tables CANNOT be extended using APPEND structures via SE11. However most transparent tables can be. In newer versions of SAP a lot of tables are delivered with a customer include CI_... for addition of fields - this is often documented in SAP notes.

For some type of additional customer fields there are special instructions / methods of adding them - for example adding additional fields in the FI coding block is documented in OSS notes, as this affects a number of tables and transactions.

When addidng extra fields there are a number of factors you should consider - including how the field will be populated, will it be indexed, Is a data conversion necessary to pre-fill the field on existing records (even just with space instead of null), what impact will the field have on standard processing, what about archiving, change logging, security etc.

There are alternate options that can also be considerred:

- is the functionality for the required extra detail already available in the standard SAP process, but just hidden / disabled by current customizing settings. I have seen end users ask for functionality to be added that is there as standard, and then inexperienced ABAPers jump straight into coding without checking with functional consultants what SAP already supplies (sometimes as add-ons via SAP Note).

- does the table already include extra fields for customer use that can be set up in customizing? (eg assets table ANLZ has several fields that can be customised for customer usage)

- does the table already have a suitable size/format field that is not limited by SAP validation which can be re-labelled and safely used for the customer purpose?

- you can create a Z Table with an identical primary key and save customer fields in this table - this is useful even if you want to store additional data for records saved in Cluster / pooled tables. It also allows indexes as required without impact on the primary table.

Adding an append structure in SE11 is normally the best way to add customer fields for most standard SAP transparent tables. I would suggest you post more details of your actual requirement so that you can get a more accurate answer from this forum.

Andrew

[Former Member]

by using append structure and include stracture(ples refer abap 21 days)

[Former Member]

Hi Swathi,

You can add new fields to a standard table using APPEND STRUCTURE.

Check these links to create append structure and assigning it to table.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ebc9446011d189700000e8322d00/content.htm

Thanks,

Vinay