N_SBLE_IMPL_OLD_DRAFT_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_DRAFT_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_DRAFT_ONLY AS
SELECT
  _EnhoShortText.description AS description,
  _LastEnhoLogCreate.created_by AS created_by,
  _LastEnhoLogCreate.created_on AS created_on
FROM sble_badi_draftn AS Draft
INNER JOIN n_sble_impl_old_draft_owner AS DraftOwner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sble_w_root AS _Root ON _Root.implementation_name = Draft.implementationname  -- association [0..1]
LEFT OUTER JOIN sble_clg_implmtn AS _ImplementationNew ON _ImplementationNew.implementation_id = Draft.implementationname  -- association [0..1]
LEFT OUTER JOIN N_SBLE_LAST_SOURCE_VERSION AS _LastSourceVersion ON _LastSourceVersion.implementation_id = Draft.implementationname  -- association [0..1]
LEFT OUTER JOIN enhheader AS _EnhoHeader ON _EnhoHeader.enhname = Draft.draftname AND _EnhoHeader.version = 'A'  -- association [0..1]
LEFT OUTER JOIN N_SBLE_ENH_SHORTTEXT AS _EnhoShortText ON _EnhoShortText.implementation_name = Draft.draftname  -- association [0..1]
LEFT OUTER JOIN N_SBLE_LAST_ENHLOG AS _LastEnhoLogCreate ON _LastEnhoLogCreate.implementation_id = Draft.draftname  -- association [0..1]
;