C_MntrSuplrConfDeliveryDate

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_MntrSuplrConfDeliveryDate.
-- 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: CSCONFDELIVDATE

CREATE VIEW C_MntrSuplrConfDeliveryDate AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  _SuplrconfItems.SupplierConfirmationCategory AS SupplierConfirmationCategory,
  _SuplrconfItems.ScheduleLine AS ScheduleLine,
  DurationToNextStatusInDays,
  cast ( _SuplrConfDelivDateDeadlineWk._Text[1: Language = $session.system_language].DomainText as vdm_deliveryscheduledate ) AS DomainText,
  _SuplrconfItems.OrderedQuantity AS OrderedQuantity,
  _SuplrconfItems.BalanceQuantity AS CommittedQuantity,
  _SuplrconfItems.Supplier AS Supplier,
  _SuplrconfItems._Supplier AS _Supplier,
  cast( 1 as mm_a_contractitems ) AS NumberOfContractItems,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  Plant,
  SupplierAccountGroup,
  AuthorizationGroup
FROM P_SuplrConfDelivDate AS _SuplrconfItems
LEFT OUTER JOIN I_SuplrConfDelivDateDeadlineWk AS _SuplrConfDelivDateDeadlineWk ON _SuplrConfDelivDateDeadlineWk.DurationToNextStatusInDays = DurationToNextStatusInDays  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [1..1]
;