SAP Knowledge Base Article - Public

3473063 - Field type is not changed in Views when changing the type in the based local tables

Symptom

When changing the field type in local tables it is observed that the related Views are not synchronized.

Environment

SAP Datasphere

Reproducing the Issue

Examples steps are :

  1. Create a VIEW
  2. Drag and drop the local table
  3. Change the local table field type without deploying
  4. Deploy the VIEW.

Cause

Modeling related objects in several browser tabs is not a supported use case. It can also lead to complex scenarios which cause issues.

Resolution

You may use following sequence:

  1. Create table.
  2. Create view on top of this table, then save (or deploy).
  3. Edit table, update column data type, save (or deploy). You will get message saying that the change may impact dependent view.
  4. Open view, you will see a message saying that the source has been updated. Save this view, data type will be updated.

Keywords

KBA , DS-MD-VIW , Views , Problem

Product

SAP Datasphere all versions