How To Fix DDLS151 - As a minimum, the base objects (&) return double fields

SAP Error Message - Details

• Message type: E = Error

• Message class: DDLS - For DDL source handling

• Message number: 151

• Message text: As a minimum, the base objects (&) return double fields

What causes this issue?

In the field list, columns of at least the named base objects appear
several times through the use of the extension statement $EXTENSION.* or
$EXTENSION.<(><<)>table name>

System Response

The view cannot be activated.

How to fix this error?

The extension statement takes the fields of the attached appends from
all the base tables. The fields of the view appends are adopted from the
base views. It may be possible for you to deleted fields from the
appends. Afterwards, activate the DDL source again.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DDLS151 - As a minimum, the base objects (&) return double fields ?

  The SAP error message DDLS151 indicates that there is an issue with the data types of the fields in a database table or view definition. Specifically, it suggests that the base objects (like tables or views) that are being referenced must return double fields (i.e., fields of type FLOAT or DOUBLE), but they do not.
  
  Cause:
  
  Data Type Mismatch: The error typically arises when a field that is expected to be of type FLOAT or DOUBLE is defined as a different type (e.g., INT, CHAR, etc.) in the underlying database objects.
  View Definition: If you are working with a view that combines multiple tables, one or more of the tables may not have the correct data type for the fields being used in the view.
  Inconsistent Definitions: If there are changes in the underlying tables or views that have not been reflected in the definitions of the objects that depend on them, this can