ARS_V_FLP_SNAPSHOT_BASE

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 ARS_V_FLP_SNAPSHOT_BASE.
-- 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: ARS_V_FLP_SNAPB

CREATE VIEW ARS_V_FLP_SNAPSHOT_BASE AS
SELECT
  snap.counter AS counter,
  last_action.action AS action,
  last_action.action_descr AS action_descr,
  snap.created_by AS created_by,
  dats_tims_to_tstmp( snap.created_on, snap.created_at, 'UTC', $session.client, 'NULL' ) as created_on AS clientNULLascreated_on,
  snap.is_outdated AS is_outdated
FROM ARS_V_SNAPSHOT AS snap
INNER JOIN ARS_V_FLP_SNAP_LAST_ACTION AS last_action ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_V_FLP_TOTAL_APIS_COUNT AS total_apis ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_V_FLP_NT_XTRC_APIS_COUNT AS not_extracted_apis ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_V_FLP_OBJECTS_IN_SNAPSHOT AS _content ON _content.software_component = snap.software_component AND _content.major_release = snap.major_release AND _content.minor_release = snap.minor_release AND _content.counter = snap.counter  -- association [0..*]
LEFT OUTER JOIN ARS_V_FLP_SNAP_STATE_HIST AS _history ON _history.software_component = snap.software_component AND _history.major_release = snap.major_release AND _history.minor_release = snap.minor_release AND _history.counter = snap.counter  -- association [0..*]
LEFT OUTER JOIN ARS_V_SNAPSHOT_NOTES AS _notes ON _notes.software_component = snap.software_component AND _notes.major_release = snap.major_release AND _notes.minor_release = snap.minor_release AND _notes.counter = snap.counter  -- association [0..*]
LEFT OUTER JOIN ARS_V_FLP_SNAP_BALLOG AS _ballog ON _ballog.software_component = snap.software_component AND _ballog.major_release = snap.major_release AND _ballog.minor_release = snap.minor_release AND _ballog.counter = snap.counter  -- association [0..1]
;