transport error - ABAP Dictionary activation

[Former Member]

Hello,

I modified a custom database table (ZGRGI) by adding a new field (MODNO). I transported my changes from the development box to the Quality box but I encountered the following error: ABAP Dictionary Activation. When I looked in the details of the error, I found the following:

" Field ZGRGI-ROWID does not exist

Key field ZGRGI-MBLNR missing. Specify maintenance status 'read only'.

Key field ZGRGI-MJAHR missing. Specify maintenance status 'read only'.

Key field ZGRGI-ZEILE missing. Specify maintenance status 'read only'. "

Here are some additional details of the error:

[Diagnosis:

A key field of the base table was not included in a view which is not marked as 'read only'. Views with which data is to be changed or inserted must contain all the key fields of the base table.

Procedure:

Include the missing key fields in the view or set the maintenance status to R (read only).]

Note: I can see the additional field in the Quality box but the status of table ZGRGI is "Partly Active".

Please advise for any action that I should take.

Thanks in advance,

Joseph Ian Valdez

Philippines

[Former Member]

Joseph,

Looks like some key field specifications were missed out.

I suggest you attach the entire table and retransport the new request.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Hi Ravi,

Thanks. But how do I attach the entire table?

[Former Member]

Hi,

Create a tr. request (SE09) and you can insert a object manually in that.

PgmID Obj Object name

R3TR TABL ZMUTCUSDET

I think this will attach the entire table again. However, I would check with the BASIS team once.

Regards,

Ravi

Note : Please close the thread if the issue is resolved.

[Former Member]

Hi,

did you modify a Table or a View since the error is addressing a view. May be the reason is in a view you added a field of a table without adding its primary key fields. If this is a view then use * sign in View Field and Field colums and the table name in the table to add all the fields of a table or specify the primary keys of the table alse. Or if you are not using this view for updation or insertion in the Maint. Status tab select <b>read only</b>.

[Former Member]

Hi Khusro,

I just added a new field in the table and the primary keys are already specified even before my modification.

About the Maint. status to READ ONLY, how will I do it? What will be the transaction? Is is still SE11?

[Former Member]

Hi joseph,

1. Is there any view related to that table ?

2. if yes, then check in your development server

thru se11,

and see if it can be activated ?

regards,

amit m.

[Former Member]

Hi Amit,

Good questions. I think you understood the situation and we are in the right track.

I do not know how to check if the table is related to a view. How do I do that? How can I know the name of the view related to the table?

[Former Member]

Hi again,

1. do a where-used search for that table

, in se11.

2. In the selection window,

TICK THE CHECK BOX FOR VIEW.

(u may untick the others)

3. The extra field which u added,

is it a part of the primary key of the table,

or normal field ?

regards,

amit m.

[Former Member]

Hi Amit,

I did the steps 1 and 2 but the table is not used related to a view.

The extra field that I added is just a normal field.

[Former Member]

Hello Joseph,

Is ZGRGI a maint. View whiere u add a field? as the error indicates that the key fields are missing as this view is meant for maint.

[Former Member]

Hi Abhijit,

ZGRGI is a custom database table but the error details say that the VIEW has missing fields. Is the table related to a view? How can I check for the name of the VIEW?

[Former Member]

The best option is to do where list. Goto SE11. Enter ZGRGI and do whereused. From the error I think there was something more in your transport which is not available in the Quality.

Also ROWID field is missing.

[Former Member]

Hi joseph,

Pls check with the transaction SE03/SE01. In this transaction objects can be included into a workbench request.

Award some points, if its useful.

Thanks,

Bharadwaja R

[Former Member]

Can u check what was sent in via the transport request which went to Quality. Goto SE01, enter the transport and let us know what all was transported.

[Former Member]

Hi Abhijit,

The transport request contains only the table definition for table ZGRGI.

Thanks a lot.

[Former Member]

Hi again,

1. can u logon to QA system

and open that table ZGRGI in se11,

and try to ACTIVATE it there itself.

regards,

amit m.