C_PurOrdOutputAutomnCube

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_PurOrdOutputAutomnCube.
-- 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: CMMPOOPAUCUBE
-- Parameters: P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW C_PurOrdOutputAutomnCube AS
SELECT
  Automation.PurchaseOrder AS PurchaseOrder,
  POOutputMessageItemID,
  Automation.POOutputChannel AS POOutputChannel,
  Automation.Supplier AS Supplier,
  Automation.PurchasingOrganization AS PurchasingOrganization,
  Automation.PurchasingGroup AS PurchasingGroup,
  Calendar.CalendarYear AS CalendarYear,
  Calendar.CalendarQuarter AS CalendarQuarter,
  Calendar.CalendarMonth AS CalendarMonth,
  Calendar.CalendarWeek AS CalendarWeek,
  PurchaseOrderDate,
  POOutputChannelManualUniqueID,
  POOutputChannelAutomnUniqueID,
  PurchaseOrderOutputIsAutomated,
  NmbrOfPurchaseOrdersPrinted,
  NmbrOfPurchaseOrdersEmailed,
  NmbrOfPurOrdersOutputAsXML,
  NmbrOfPurOrdersOutputAsIDOC,
  NmbrOfPurOrdersOutputAsEDI,
  cast(1 as abap.int4 ) AS NmbrOfPurOrdsWithAutomnOutput,
  cast( 1 as abap.int4 ) AS NmbrOfPurOrdsWithNonAutomnOutp,
  cast( 1 as abap.int4 ) AS NmbrOfPOOutputItems
FROM P_PurOrdOutputAutomation2
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS Calendar ON PurchaseOrderDate = Calendar.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_POChannelOutputType AS _OutputType ON _OutputType.PurchaseOrderOutputIsAutomated = PurchaseOrderOutputIsAutomated  -- association [1..1]
;