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: 

transport error - ABAP Dictionary activation

Former Member
0 Kudos
1,634

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
350

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.

16 REPLIES 16

Former Member
0 Kudos
350

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

0 Kudos
350

Hi Ravi,

Thanks. But how do I attach the entire table?

0 Kudos
350

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
0 Kudos
350

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

0 Kudos
350

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?

0 Kudos
350

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.

0 Kudos
350

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?

0 Kudos
350

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.

0 Kudos
350

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
0 Kudos
351

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.

0 Kudos
350

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
0 Kudos
350

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
0 Kudos
350

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
0 Kudos
350

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.

0 Kudos
350

Hi Abhijit,

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

Thanks a lot.

0 Kudos
350

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.