I_ChangeRecdRefLabelSetTP_2

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_ChangeRecdRefLabelSetTP_2.
-- 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: ICHGRECREFLBLTP2

CREATE VIEW I_ChangeRecdRefLabelSetTP_2 AS
SELECT
  reference_lbl.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  _LabelSet.LabelSetInternalID AS LabelSetInternalID,
  _LabelSet.LabelSetSpecificationIntID AS LabelSetSpecificationIntID,
  _Identifier(P_KeyDate : $session.system_date).SpecIdfgDescText AS SpecIdfgDescText,
  reference_lbl.ChangeRecordUUID AS ChangeRecordUUID,
  reference_lbl.ChangeRecord AS ChangeRecord,
  reference_lbl.ChangeRecordType AS ChangeRecordType,
  reference_lbl.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_lbl.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_lbl.ChangeRecordReference AS ChangeRecordReference,
  reference_lbl.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_lbl.IsMainReference AS IsMainReference,
  reference_lbl.CreatedByUser AS CreatedByUser,
  reference_lbl.CreationDateTime AS CreationDateTime,
  reference_lbl.LastChangedByUser AS LastChangedByUser,
  reference_lbl.LastChangeDateTime AS LastChangeDateTime,
  reference_lbl.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_lbl.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_lbl.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_lbl.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  reference_lbl.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  reference_lbl.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  reference_lbl.ChgRecRefInternalKey4 AS ChgRecRefInternalKey4,
  reference_lbl.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID
FROM I_ChgRecdRefLabelBsc AS reference_lbl
LEFT OUTER JOIN I_SpecificationNonHistoric AS _SpecificationNonHistoric ON LabelSetSpecificationIntID = _SpecificationNonHistoric.SpecificationInternalID  -- association [1..1]
LEFT OUTER JOIN I_LabelSetIdfrBscForKeyDate AS _Identifier ON LabelSetSpecificationIntID = _Identifier.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN E_ChgRecdRefLabelBsc AS _LabelExtension ON ChangeRecordReferenceUUID = _LabelExtension.ChangeRecordReferenceUUID  -- association [0..1]
;