How To Fix DDLS490 - SQL view &1 for DDL source &4 in use; cannot be renamed as &2

DDLS490 - Overview

• Message type: E = Error

• Message class: DDLS - For DDL source handling

• Message number: 490

• Message text: SQL view &1 for DDL source &4 in use; cannot be renamed as &2

What causes this issue?

The CDS view extension <(>&<)>V4 contains an append view that you want
to rename from <(>&<)>V1 to <(>&<)>V2. This cannot be done here, since
the previous append view is referenced in the structure <(>&<)>V3.

System Response

The name check produces an error and nothing can be activated while the
previous append view <(>&<)>V1 is still in use.

How to fix this error?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

DDLS490 - Details

• The SAP error message DDLS490 indicates that there is an issue with renaming a SQL view in the Data Dictionary (DDLS) because the view is currently in use. This typically occurs when the SQL view you are trying to rename is being referenced or utilized by other database objects, such as tables, views, or programs.
  
  Cause:
  
  Active Dependencies: The SQL view you are trying to rename has active dependencies, meaning that other objects are referencing it.
  Open Sessions: There may be open sessions or transactions that are currently using the SQL view.
  Locks: The view might be locked by another user or process, preventing any changes.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check Dependencies:
  
  Use transaction code SE11 (Data Dictionary) to check the dependencies of the SQL view. Look for any objects that are referencing the view.
  You can also use transaction SE80 (Object Navigator) to analyze the dependencies.
  
  
  
  Close Open Sessions:
  
  Ensure that there are