SE11 error.

[Former Member]

Hi Friends I have changed the primary key and also have changed the field length for some of the fields. However after I did this the system gave me an error message and I am not sure of what it is.

Below is the error message.

Structure change at field level (convert table ZSD_BDS_COMMUNI)

Message no DT 064

Diagnosis

The structure of the table changed at field level. This change requires a conversion of the table. This situation can occur for example if the data type or field length of the domain upon which the field is based was changed. A conversion is also generally necessary if the key of the table was changed. System Response Procedure

Convert the table using the Database Utility (SE14).

Let me know if you guys need anything else.

Shejal.

[Manohar2u]

1. Go to se14 and give the table name.

2. click EDIT.

3. Click and adjust and activate table option (Remember to check radio button with data)

Regds

Manohar

[Former Member]

Thanks Manohar.

I will do it.

Thanks again.

Shejal.

[Former Member]

Manohar,

I have done whatever you said but whats the purpose of this and why do we need to do this.

ANy Documentation on this would be helful.

Shejal.

[Manohar2u]

I have given above the link for database utility.

<b>The database utility is the interface between the ABAP Dictionary and the underlying relational database.</b>

Like whenever we change the dictionary structure either by adding/removing/changing field it should make it sync with underlying database object like example in oracle.

Forexample in any dbase we use ALTER commands to change our database objects. SE14 is similar to it.

While conversion it has some predefined steps it does, like creates a mirror table, moves data to morror table, deletes this table, creates/adjust this table, then brings back the data to original table, then deletes mirror/temp table.

Regds

Manohar

Regds

Manohar

[Former Member]

Thanks Manohar,

However now the table is not allowing me to add any entries to the data base. (ie, Utilities, table contents, create entries).

Its giving me a pop window window with the message,

The table is cross client.

SO can add any entries or not.

Shejal.

[Manohar2u]

This is because mandt field is missing in the table.

If you like to have this table client independent ( maintaining entries in one client will be available in all clients ) then add mandt field as first field.

It is an information message, you can add entries to table.

Regds

Manohar

Message was edited by: Manohar Reddy

[Former Member]

So you mean to say if we dont have the mandt field in the table i cant really use the table in different cleint, ie i have it in DEvelopment server and so when i transport to testing i really cant use the table. However if i have the mandt field(the first field) i can add entries in development and can move in to testing i will have the data there and can use it.

Is this right.

Shejal.

[Manohar2u]

No. Its not the way.

Data moving from client is depend upon the table type.

>>However if i have the mandt field(the first field) i can add entries in development and can move in to testing i will have the data there and can use it.

If you maintain the table as customizing table then you can capture the entries (records) in a request to transport the entries to Testing system. Even this can be client specific or client independent.

Refer this link for more detailed help

http://help.sap.com/saphelp_47x200/helpdata/en/69/c2511b4ba111d189750000e8322d00/frameset.htm

Regds

Manohar

[Manohar2u]

Refer to this help for Activating and adjusting dictionary objects.

http://help.sap.com/saphelp_47x200/helpdata/en/a4/3790360ee65840e10000009b38f839/frameset.htm

Regds

Manohar