topic Re: Cannot edit Data Definitions in Application Development and Automation Discussions

Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 06:38:48 GMT

Hi experts,

I have a list of data definitions that looks like generated. When I try to edit something, I get the error You cannot edit object R3TR DDLS XXX with the standard editor.

The definitions throw errors (Inconsistent) because the underlying data elements have been changed. I should delete the data definitions, but I don't know what to look for.

Re: Cannot edit Data Definitions

GK817 — Tue, 12 May 2020 06:43:12 GMT

Hi,

Do you know how those Data definitions were generated? Try to re-generate and then see.

Gaurav

Re: Cannot edit Data Definitions

former_member1716 — Tue, 12 May 2020 06:43:39 GMT

nw.,

Can you let us know what you mean by Data Definitions here? Is it CDS View that you are talking about?

Regards!

Re: Cannot edit Data Definitions

venkateswaran_k — Tue, 12 May 2020 06:53:20 GMT

I assume it is not a standard data definition, may be a IDOC segment. If it is so, please use transaction WE31 instead.

Regards,

Venkat

Re: Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 07:07:08 GMT

Unfortunately I don't know where they were generated, can I find that out somewhere?

I'm not sure they were generated, but they have names like "47H7FE56NKAM78."

Yes they are CDS views (extend).

Re: Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 07:12:32 GMT

Is there an easy way I can find out what kind of data definition it is?

Re: Cannot edit Data Definitions

former_member1716 — Tue, 12 May 2020 07:16:52 GMT

nw.,

Can you paste some screen shots for reference.

Re: Cannot edit Data Definitions

venkateswaran_k — Tue, 12 May 2020 07:20:26 GMT

If it is a CDS data then, you need the IDE.

The SAP Web IDE for SAP HANA provides editing tools specially designed to help you create and modify CDS documents.

You may do it with Eclipse with ADT plugin.

Regards,

Venkat

Re: Cannot edit Data Definitions

ClausB — Tue, 12 May 2020 07:20:35 GMT

You try to edit a CDS-Views.

CDS database views are created by activating a CDS source code for a CDS view and are defined in the database. They cannot be edited in the ABAP Dictionary (transaction SE11). CDS source texts are edited in the ABAP Developement Tools (ADT).

This SAP note describes how to delete a CDS-View

SAP Note 2602789

Re: Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 07:57:19 GMT

Okay, yes, I have to use Eclipse.

@Claus Brunner the note I had seen before, but unfortunately I don't have a source and don't know how to find it.
Maybe it helps, I have attached a picture of what I see.

cuserss50828desktop1.png

Re: Cannot edit Data Definitions

venkateswaran_k — Tue, 12 May 2020 08:01:12 GMT

I believe that solves your current problem? If this answer has solved your problem, accept the answer and close the thread. This will help other who search for the same solutions.

Re: Cannot edit Data Definitions

ClausB — Tue, 12 May 2020 09:58:34 GMT

What is the error in line 7?

Re: Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 10:09:37 GMT

"The column ZZVERNR is unknown."

There lies my original problem I should remove some tables, in the proof of use was not to be seen that CDS refer to it. The errors started after I took the tables from the search help of corresponding data elements, which can't be activated now because it leads to inconsistency.
My approach is to delete everything that refers to the data elements. (They are no longer used)

Re: Cannot edit Data Definitions

ClausB — Tue, 12 May 2020 12:16:21 GMT

Restore the table with your column and delete the CDS-View. Afterwards you can delete the table/column again.

Re: Cannot edit Data Definitions

former_member634879 — Tue, 12 May 2020 15:01:04 GMT

Thanks for the advice, I'll try that.