C_SchedgAgrmtItemMonitor

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_SchedgAgrmtItemMonitor.
-- 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: CMMSCHDAGMTMNTR
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_SchedgAgrmtItemMonitor AS
SELECT
  SchedulingAgreement.SchedulingAgreement AS SchedulingAgreement,
  SchedulingAgreement.SchedulingAgreementItem AS SchedulingAgreementItem,
  SchedulingAgreement.CompanyCode AS CompanyCode,
  Material,
  _Material.MaterialName AS MaterialName,
  MaterialGroup,
  _MaterialGroup.MaterialGroupName AS MaterialGroupName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingDocumentType,
  _PurchasingDocType.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  DocumentCurrency,
  PurchasingDocumentOrderDate,
  PurchasingDocumentCategory,
  cast( 1 as mm_nmbr_schedg_agrmt_items ) AS NumberOfSchedgAgrmtItems,
  SchedAgrmtValidityStatus,
  cast(_ValidityStatusText[1: Language = $session.system_language].PurContrValidityStatusName as mm_schagmt_validity_status) AS PurContrValidityStatusName,
  ValidityStartDate,
  ValidityEndDate,
  SchedgAgreementItemNextRelDate,
  NextDeliveryDate AS ScheduleLineDeliveryDate,
  _NextDeliveryDateText._Text[1: Language = $session.system_language].DomainText AS SchedulingAgreementRelease,
  SchedAgrmtItemIsOverdue,
  _DeliveryStatusText._Text[1: Language = $session.system_language].DomainText AS SchedgAgrmtOverdueStsName,
  SchedAgrmtItmInApprvlSts,
  _ApprovalStatusText._Text[1: Language = $session.system_language].DomainText AS SchedAgrmtItmInApprvlStsName,
  OrderQuantityUnit,
  TargetQuantity,
  cast( SchedgAgrmtItmNextDelivQty as vdm_nextscheddelivqty) AS SchedgAgrmtItmNextDelivQty,
  cast(SchedgAgrmtItmOverdueQty as mm_a_overduequantity ) AS SchedgAgrmtItmOverdueQty,
  cast(SchedgAgrmtItmDueDeliveryQty as mm_a_duedeliveryquantity) AS SchedgAgrmtItmDueDeliveryQty,
  InvoiceReceiptQty,
  GoodsReceiptQuantity AS GoodsReceiptQty,
  cast( case when ScheduleLineOrderQuantity > 0 then ScheduleLineOrderQuantity - GoodsReceiptQuantity else 0 end as abap.quan(13,3) ) as StillToBeDeliveredQuantity AS quan133asStillToBeDeliveredQuantity,
  cast( case when ScheduleLineOrderQuantity > 0 then ScheduleLineOrderQuantity - InvoiceReceiptQty else 0 end as abap.quan(13,3) ) as StillToInvoiceQuantity AS quan133asStillToInvoiceQuantity,
  DisplayCurrency,
  TargetAmount,
  SchedulingAgreementSpend,
  GoodsReceiptAmountInDspCrcy,
  InvoiceAmtInDisplayCurrency
FROM P_SchedgAgrmtItemHistory
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchasingDocumentItemExt ON SchedulingAgreement = _PurchasingDocumentItemExt.PurchasingDocument AND SchedulingAgreementItem = _PurchasingDocumentItemExt.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_PurchasingDocTypeValueHelp AS _PurchasingDocType ON PurchasingDocumentType = _PurchasingDocType.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocType.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _Plant ON Plant = _Plant.Plant AND PurchasingOrganization = _Plant.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _Material ON Material = _Material.Material AND Plant = _Material.Plant  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _Supplier ON Supplier = _Supplier.Supplier AND CompanyCode = _Supplier.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ProcmtDelivSchedDate AS _NextDeliveryDateText ON SchedgAgreementItemNextRelDate = _NextDeliveryDateText.PlannedDeliveryDuration  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtOverdueDelivSts AS _DeliveryStatusText ON SchedAgrmtItemIsOverdue = _DeliveryStatusText.SchedAgrmtItemIsOverdue  -- association [0..1]
LEFT OUTER JOIN I_ProcmtApprovalStsWthDelivDte AS _ApprovalStatusText ON SchedAgrmtItmInApprvlSts = _ApprovalStatusText.SchedAgrmtItmInApprvlSts  -- association [0..1]
LEFT OUTER JOIN I_PurContrValidityText AS _ValidityStatusText ON SchedAgrmtValidityStatus = _ValidityStatusText.PurchaseContractValidityStatus AND _ValidityStatusText.Language = $session.system_language  -- association [0..1]
;