P_PurOrdOutputAutomation2

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 P_PurOrdOutputAutomation2.
-- 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: PMMOPAUT2
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdOutputAutomation2 AS
SELECT
  PurchaseOrder,
  POOutputMessageItemID,
  PurchaseOrderDate,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  POOutputChannel,
  cast( 1 as mm_a_nmbrofposprinted ) AS NmbrOfPurchaseOrdersPrinted,
  cast( 0 as mm_a_nmbrofposasxml ) AS NmbrOfPurOrdersOutputAsXML,
  cast( 0 as mm_a_nmbrofposasidoc ) AS NmbrOfPurOrdersOutputAsIDOC,
  cast( 0 as mm_a_nmbrofposasedi ) AS NmbrOfPurOrdersOutputAsEDI,
  cast( 0 as mm_a_nmbrofposemailed ) AS NmbrOfPurchaseOrdersEmailed,
  cast( 'M' as mm_a_output_channel_type ) AS PurchaseOrderOutputIsAutomated,
  cast (CONCAT(PurchaseOrder , POOutputMessageItemID) as char14 ) AS POOutputChannelManualUniqueID,
  cast ( ' ' as char14) as POOutputChannelAutomnUniqueID AS P_StartDate,
  cast ( ' ' as char14) AS POOutputChannelAutomnUniqueID
FROM P_PurOrdOutputAutomation3
-- UNION ALL with additional select branch(es): P_PurOrdOutputAutomation3
;