atov_ppl_merge_staging

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 atov_ppl_merge_staging.
-- 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 atov_ppl_merge_staging AS
SELECT
  StagingBaseItem.ItemType AS ItemType,
  StagingBaseItem.ItemId AS ItemId,
  StagingBaseItem.StagingChangedBy AS StagingChangedBy,
  StagingBaseItem.StagingChangedAt AS StagingChangedAt,
  StagingBaseItem.ItemDescription AS ItemDescription,
  StagingBaseItem.ConflictStatus AS ConflictStatus,
  StagingBaseItem.LastBranchActionAt AS LastBranchActionAt,
  StagingBaseItem.Status AS DifferenceToMainline,
  StagingBaseItem.CollectionId AS CollectionId,
  Collection.description_text AS CollectionDescription,
  Adaptation_Type_Texts,
  Adaptation_Type,
  Col_Item_Status_Texts,
  Changed_By_Description,
  PPL_Conflict_State_Texts
FROM ATOV_PPL_MERGE_STAGING_BASE AS StagingBaseItem
LEFT OUTER JOIN ATOV_TEXT_ADAPTATION_TYPE AS Adaptation_Type_Texts ON Adaptation_Type_Texts.code = StagingBaseItem.ItemType AND Adaptation_Type_Texts.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_TEXT_COL_ITEM_STATUS AS Col_Item_Status_Texts ON Col_Item_Status_Texts.code = StagingBaseItem.Status AND Col_Item_Status_Texts.language = $session.system_language  -- association [1]
LEFT OUTER JOIN ATOV_TEXT_PPL_CONFLICT_STATE AS PPL_Conflict_State_Texts ON PPL_Conflict_State_Texts.code = StagingBaseItem.ConflictStatus AND PPL_Conflict_State_Texts.language = $session.system_language  -- association [1]
LEFT OUTER JOIN ATOV_USER AS Changed_By_Description ON Changed_By_Description.name = StagingBaseItem.StagingChangedBy  -- association [1]
LEFT OUTER JOIN ATOV_ADAPTATION_TYPE AS Adaptation_Type ON Adaptation_Type.code = StagingBaseItem.ItemType  -- association [1]
LEFT OUTER JOIN ato_cols AS Collection ON Collection.collection_id = StagingBaseItem.CollectionId  -- association [1]
;