I_MDSubstnSource

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 I_MDSubstnSource.
-- 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.

CREATE VIEW I_MDSubstnSource AS
SELECT
  source AS MDSubstnSrce,
  object_type AS MDSubstnObjectType,
  implementation AS MDSubstnImplmtnName,
  rule_name AS MDSubstnRule,
  context_type1 AS MDSubstnContextObjectType,
  context_type2 AS MDSubstnContextObjectType2
FROM mdsubsrce
LEFT OUTER JOIN I_SAPObjectType AS _MDObjectType ON MDSubstnObjectType = _MDObjectType.SAPObjectType  -- association [1..1]
LEFT OUTER JOIN I_SAPObjectType AS _ContextObjectTypeCode ON MDSubstnContextObjectType = _ContextObjectTypeCode.SAPObjectType  -- association [0..1]
LEFT OUTER JOIN I_SAPObjectType AS _ContextObjectTypeCode2 ON MDSubstnContextObjectType2 = _ContextObjectTypeCode2.SAPObjectType  -- association [0..1]
LEFT OUTER JOIN I_MDSubstnSourceText AS _SourceText ON MDSubstnSrce = _SourceText.MDSubstnSrce  -- association [0..*]
LEFT OUTER JOIN I_MDSubstnRule AS _Rule ON MDSubstnRule = _Rule.MDSubstnRule  -- association [0..1]
;