How To Fix MC765 - Field specification with * and - only allowed for DB views

SAP Error Message - Details

• Message type: E = Error

• Message class: MC - Aggregate: views, matchcodes, lock objects

• Message number: 765

• Message text: Field specification with * and - only allowed for DB views

What causes this issue?

Including all the fields of a base table by specifying * is only
allowed for database views.
As a result, excluding fields by entering '-' in the view field name
is only allowed for database views.

System Response

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

How to fix this error?

Enter the fields explicitly for all other view types.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MC765 - Field specification with * and - only allowed for DB views ?

  The SAP error message MC765, which states "Field specification with * and - only allowed for DB views," typically occurs in the context of data extraction or reporting when you are trying to use a field specification that is not valid for the type of data source you are working with. This error is often encountered in the context of SAP's data extraction tools, such as InfoSets or queries.
  
  Cause:
  The error is triggered when you attempt to use a wildcard character (* or -) in a field specification for a data source that does not support it. Specifically, this is common when you are working with database views (DB views) or other types of data sources that have strict field selection criteria.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check the Data Source: Ensure that you are using a database view or another appropriate data source that allows for wildcard