How To Fix SDDL_PARSER_MSG123 - Union clauses in basis view & and extend & do not match

SDDL_PARSER_MSG123 - Overview

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 123

• Message text: Union clauses in basis view & and extend & do not match

What causes this issue?

If a CDS view contains a UNION clause, identical UNION clauses must be
used in a corresponding CDS view extend. This means, type (UNION or
UNION ALL) and number of linked elements must be the same.

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?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SDDL_PARSER_MSG123 - Union clauses in basis view & and extend & do not match ?

  The SAP error message SDDL_PARSER_MSG123 indicates that there is a mismatch between the union clauses in a basis view and an extended view in the context of SAP's Semantic Data Definition Language (SDDL). This typically occurs when you are trying to create or modify a CDS (Core Data Services) view that involves unions, and the structure of the union clauses does not align correctly.
  
  Cause:
  
  Mismatched Fields: The fields defined in the union clauses of the basis view and the extended view do not match in terms of data types, names, or the number of fields.
  Inconsistent Annotations: Annotations or metadata associated with the fields in the basis and extended views may not be consistent.
  Incorrect Union Logic: The logic used to create the union in either the basis or extended view may be incorrect, leading to discrepancies.
  
  
  Solution:
  
  Check Field Definitions: Ensure that the fields in the union clauses of both the basis and extended