C_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 C_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: CSCHAGMRTRELDOC

CREATE VIEW C_Schedgagrmtreleasedoc AS
SELECT
  I_SchedgAgrmtReleaseDoc.SchedulingAgreement AS SchedulingAgreement,
  I_SchedgAgrmtReleaseDoc.SchedulingAgreementItem AS SchedulingAgreementItem,
  I_SchedgAgrmtReleaseDoc.SchedulingAgreementReleaseType AS SchedulingAgreementReleaseType,
  I_SchedgAgrmtReleaseDoc.ReleaseCode AS ReleaseCode,
  I_SchedgAgrmtReleaseDoc.SchedulingAgreementRelease AS SchedulingAgreementRelease,
  I_SchedgAgrmtReleaseDoc.SchedgAgreementItemRelText AS SchedgAgreementItemRelText,
  I_SchedgAgrmtReleaseDoc.SchedgAgreementItemRelStatus AS SchedgAgreementItemRelStatus,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtStopReleaseStatus AS SchedgAgrmtStopReleaseStatus,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtReleaseCreationDate AS SchedgAgrmtReleaseCreationDate,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtReleaseCreationTime AS SchedgAgrmtReleaseCreationTime,
  I_SchedgAgrmtReleaseDoc.SchedgAgreementItemNextRelDate AS SchedgAgreementItemNextRelDate,
  I_SchedgAgrmtReleaseDoc.ProductionGoAheadPeriodEndDate AS ProductionGoAheadPeriodEndDate,
  I_SchedgAgrmtReleaseDoc.MaterialGoAheadPeriodEndDate AS MaterialGoAheadPeriodEndDate,
  I_SchedgAgrmtReleaseDoc.LastGoodsReceiptQuantity AS LastGoodsReceiptQuantity,
  I_SchedgAgrmtReleaseDoc.LastGoodsReceiptDate AS LastGoodsReceiptDate,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtRelTransmissionDate AS SchedgAgrmtRelTransmissionDate,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtRelTransmissionTime AS SchedgAgrmtRelTransmissionTime,
  I_SchedgAgrmtReleaseDoc.OrderQuantityUnit AS OrderQuantityUnit,
  I_SchedgAgrmtReleaseDoc.IsSchedgAgreementItemReld AS IsSchedgAgreementItemReld,
  I_SchedgAgrmtReleaseDoc.InboundDeliveryNote AS InboundDeliveryNote,
  I_SchedgAgrmtReleaseDoc.SchedgAgrmtCumltvRcvdQty AS SchedgAgrmtCumltvRcvdQty,
  cast ('' as mm_oa_oc_type ) AS SchedgAgrmtOutpCtrlType,
  cast ('' as mm_oa_oc_status ) AS SchedgAgrmtOutpCtrlStatus,
  cast ('' as mm_oa_oc_status_txt ) AS SchedgAgrmtOutpCtrlStatusText,
  cast (0 as mm_oa_oc_time ) AS SchedgAgrmtOutpCtrlTime
FROM I_SchedgAgrmtReleaseDoc
LEFT OUTER JOIN C_Schedgagrmthdr AS _SchedgagrmthdrWithDraft ON _SchedgagrmthdrWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_Schedgagrmtitm AS _SchedgAgrmtItmWithDraft ON _SchedgAgrmtItmWithDraft.SchedulingAgreementItem = SchedulingAgreementItem AND _SchedgAgrmtItmWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_Schedgagrmtreldocsline AS _Schedgagrmtreldocsline ON SchedulingAgreement = _Schedgagrmtreldocsline.SchedulingAgreement AND SchedulingAgreementItem = _Schedgagrmtreldocsline.SchedulingAgreementItem AND SchedulingAgreementReleaseType = _Schedgagrmtreldocsline.SchedulingAgreementReleaseType AND ReleaseCode = _Schedgagrmtreldocsline.SchedulingAgreementRelease  -- association [0..*]
;