VB_CDSVIEWS_DEFQUERY_EXTN

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view VB_CDSVIEWS_DEFQUERY_EXTN.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VBCDSDEFQRYEXTNS

CREATE VIEW VB_CDSVIEWS_DEFQUERY_EXTN AS
SELECT
  Cds_Views.DDLSourceName AS DDLSourceName,
  CdsDefinition.FieldName AS FieldName,
  CdsDefinition.fieldname_raw AS FieldNameText,
  Cds_Views.CDSName AS CDSName,
  CdsDefinition.DataElement AS DataElement,
  CdsDefinition.DataType AS DataType,
  CdsDefinition.FieldPosition AS FieldPosition,
  CdsDefinition.ElementType AS ElementType,
  CdsDefinition.Length AS Length,
  CdsDefinition._Text[Language = $session.system_language].DataElementText AS DataElementText,
  CdsDefinition._Text[Language = $session.system_language].DataElementText_Medium AS DataElementText_Medium
FROM Cds_Views
INNER JOIN Vb_Core_Cds_Definition AS CdsDefinition ON /* join condition not captured in parsed metadata */
INNER JOIN Vb_Core_Cds_Definition AS ExtendedDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Vb_Core_Cds_Field_Annotation AS _CdsFieldAnnotation ON CDSName = _CdsFieldAnnotation.CDSName AND FieldName = _CdsFieldAnnotation.FieldName  -- association [0..*]
-- UNION with additional select branch(es): Cds_Views_Extn
;