I_SchedgAgrmtReleaseDoc

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_SchedgAgrmtReleaseDoc.
-- 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: ISCHAGMRTRELDOC

CREATE VIEW I_SchedgAgrmtReleaseDoc AS
SELECT
  ReleaseDocument.SchedulingAgreement AS SchedulingAgreement,
  ReleaseDocument.SchedulingAgreementItem AS SchedulingAgreementItem,
  ReleaseDocument.SchedulingAgreementReleaseType AS SchedulingAgreementReleaseType,
  ReleaseDocument.ReleaseCode AS ReleaseCode,
  SchedulingAgreementRelease,
  ReleaseDocument.SchedgAgrmtStopReleaseStatus AS SchedgAgrmtStopReleaseStatus,
  ReleaseDocument.SchedgAgrmtReleaseCreationDate AS SchedgAgrmtReleaseCreationDate,
  ReleaseDocument.SchedgAgrmtReleaseCreationTime AS SchedgAgrmtReleaseCreationTime,
  ReleaseDocument.LastGoodsReceiptDate AS LastGoodsReceiptDate,
  ReleaseDocument.LastGoodsReceiptQuantity AS LastGoodsReceiptQuantity,
  ReleaseDocument.ProductionGoAheadPeriodEndDate AS ProductionGoAheadPeriodEndDate,
  ReleaseDocument.MaterialGoAheadPeriodEndDate AS MaterialGoAheadPeriodEndDate,
  ReleaseDocument.SchedgAgrmtRelTransmissionDate AS SchedgAgrmtRelTransmissionDate,
  ReleaseDocument.SchedgAgrmtRelTransmissionTime AS SchedgAgrmtRelTransmissionTime,
  ReleaseDocument.IsSchedgAgreementItemReld AS IsSchedgAgreementItemReld,
  ReleaseDocument.InboundDeliveryNote AS InboundDeliveryNote,
  ReleaseDocument.SchedgAgrmtCumltvRcvdQty AS SchedgAgrmtCumltvRcvdQty,
  _Schedgagrmtreldocstatustext.SchedgAgreementItemRelStatus AS SchedgAgreementItemRelStatus,
  _Schedgagrmtreldocstatustext.SchedgAgreementItemRelStsText AS SchedgAgreementItemRelStsText,
  _SchedgAgrmtRelType._Text[1: Language = $session.system_language].SchedgAgreementItemRelText AS SchedgAgreementItemRelText,
  _SchedgAgrmtItm.OrderQuantityUnit AS OrderQuantityUnit,
  cast( ' ' as sdraft_is_active preserving type ) AS IsActiveEntity,
  cast( ' ' as sdraft_has_active preserving type ) AS HasActiveEntity,
  cast( ' ' as sdraft_has_draft preserving type ) AS HasDraftEntity
FROM I_Purgscheagrmtreldoc AS ReleaseDocument
LEFT OUTER JOIN I_Schedgagrmthdr AS _Schedgagrmthdr ON SchedulingAgreement = _Schedgagrmthdr.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtItm AS _SchedgAgrmtItm ON SchedulingAgreement = _SchedgAgrmtItm.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtItm.SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmtreldocsline AS _Schedgagrmtreldocsline ON SchedulingAgreement = _Schedgagrmtreldocsline.SchedulingAgreement AND SchedulingAgreementItem = _Schedgagrmtreldocsline.SchedulingAgreementItem AND SchedulingAgreementReleaseType = _Schedgagrmtreldocsline.SchedulingAgreementReleaseType AND ReleaseCode = _Schedgagrmtreldocsline.SchedulingAgreementRelease  -- association [0..*]
LEFT OUTER JOIN I_SchedgAgrmtRelType AS _SchedgAgrmtRelType ON SchedulingAgreementReleaseType = _SchedgAgrmtRelType.DomainValue  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmtreldocstatustext AS _Schedgagrmtreldocstatustext ON IsSchedgAgreementItemReld = _Schedgagrmtreldocstatustext.IsSchedgAgreementItemReld AND _Schedgagrmtreldocstatustext.Language = $session.system_language  -- association [1..1]
;