N_SBLE_IMPL_OLD_PUB_ONLY

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 N_SBLE_IMPL_OLD_PUB_ONLY.
-- 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 N_SBLE_IMPL_OLD_PUB_ONLY AS
SELECT
  _EnhoShortText.description AS description,
  Root.transported AS transported,
  _LastEnhoLogCreate.created_by AS created_by,
  _LastEnhoLogCreate.created_on AS created_on
FROM sble_w_root AS Root
LEFT OUTER JOIN sble_badi_draftn AS _Draft ON _Draft.implementationname = Root.implementation_name AND _Draft.owner = $session.user  -- association [0..1]
LEFT OUTER JOIN sble_clg_implmtn AS _ImplementationNew ON _ImplementationNew.implementation_id = Root.implementation_name  -- association [0..1]
LEFT OUTER JOIN enhheader AS _EnhoHeader ON _EnhoHeader.enhname = Root.implementation_name  -- association [0..1]
LEFT OUTER JOIN N_SBLE_ENH_SHORTTEXT AS _EnhoShortText ON _EnhoShortText.implementation_name = Root.implementation_name  -- association [0..1]
LEFT OUTER JOIN N_SBLE_LAST_ENHLOG AS _LastEnhoLogCreate ON _LastEnhoLogCreate.implementation_id = Root.implementation_name  -- association [0..1]
LEFT OUTER JOIN N_SBLE_LAST_SOURCE_VERSION AS _LastSourceVersion ON _LastSourceVersion.implementation_id = Root.implementation_name  -- association [0..1]
;