C_ProcMonKPIO2CMonth

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_ProcMonKPIO2CMonth.
-- 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: CPOCKPIALLMON
-- Parameters: P_Language : sylangu, P_NumberOfEvaluationMonths : poc_numberofmonths

CREATE VIEW C_ProcMonKPIO2CMonth AS
SELECT
  ProcessKPI.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  ProcessKPI.ProcObsvrKPIDefinition AS ProcObsvrKPIDefinition,
  ProcessKPI.ValuationNumber AS ValuationNumber,
  ProcessKPI.ProcObsvrTaskUUID AS ProcObsvrTaskUUID,
  ProcessKPI.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  ProcessKPI._ProcMonKPIDefinition._Text[1: Language=$parameters.P_Language].ProcObsvrKPIDefDesc AS ProcObsvrKPIDefDesc,
  ProcessKPI._ProcMonProcessDefinition._Text[1: Language=$parameters.P_Language].ProcObsvrProcessDefName AS ProcObsvrProcessDefName,
  ProcessKPI.ProcObsvrProcessDefVersion AS ProcObsvrProcessDefVersion,
  _ProcMonKPIDefinition.ProcObsvrKPICategory AS ProcObsvrKPICategory,
  ProcessKPI.ProcObsvrProcessStatus AS ProcObsvrProcessStatus,
  ProcessKPI._ProcObsvrProcessStatus._Text[1: Language=$parameters.P_Language].ProcObsvrProcessStatusName AS ProcObsvrProcessStatusName,
  ProcessKPI.ProcObsvrProcessVariantHash AS ProcObsvrProcessVariantHash,
  ProcessKPI.ProcObsvrProcessVariantLength AS ProcObsvrProcessVariantLength,
  ProcessKPI.EndUTCDateTime AS EndUTCDateTime,
  ProcessKPI.EndUTCDate AS EndUTCDate,
  ProcessKPI.EndSystDate AS EndSystDate,
  ProcessKPI.EndSystTime AS EndSystTime,
  Date.CalendarYear AS CalendarYear,
  Date.YearQuarter AS YearQuarter,
  Date._CalendarQuarter._Text[1: Language=$parameters.P_Language]. CalendarQuarterName AS CalendarQuarterName,
  Date.YearMonth AS YearMonth,
  Date._CalendarMonth._Text[1: Language=$parameters.P_Language]. CalendarMonthName AS CalendarMonthName,
  Date.YearWeek AS YearWeek,
  Date.CalendarDate AS CalendarDate,
  ProcessKPI.SAPBusinessObjectType AS SAPBusinessObjectType,
  ProcessKPI.BusinessObject AS BusinessObject,
  ProcessKPI.BusinessObjectItem AS BusinessObjectItem,
  cast(ProcessKPI.BusinessObject as vdm_sales_order) AS SalesOrder,
  ProcessKPI.BusinessObjectItem AS SalesOrderItem,
  _SalesOrder.CreationDate AS CreationDate,
  _SalesOrder.CreationTime AS CreationTime,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder._SalesOrderType._Text[1:Language=$parameters.P_Language].SalesDocumentTypeName AS SalesOrderTypeName,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder._SalesOrganization._Text[1:Language=$parameters.P_Language].SalesOrganizationName AS SalesOrganizationName,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder._DistributionChannel._Text[1:Language=$parameters.P_Language].DistributionChannelName AS DistributionChannelName,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder._OrganizationDivision._Text[1:Language=$parameters.P_Language].DivisionName AS DivisionName,
  _SalesOrder.SalesGroup AS SalesGroup,
  _SalesOrder._SalesGroup._Text[1:Language=$parameters.P_Language].SalesGroupName AS SalesGroupName,
  _SalesOrder.SalesOffice AS SalesOffice,
  _SalesOrder._SalesOffice._Text[1:Language=$parameters.P_Language].SalesOfficeName AS SalesOfficeName,
  _SalesOrder.BusinessArea AS BusinessArea,
  _SalesOrder._BusinessArea._Text[1:Language=$parameters.P_Language].BusinessAreaName AS BusinessAreaName,
  _SalesOrder.SoldToParty AS SoldToParty,
  _SalesOrder._SoldToParty.CustomerName AS CustomerName,
  _SalesOrder.TotalNetAmount AS TotalNetAmount,
  _SalesOrder.TransactionCurrency AS SalesOrderTransactionCurrency,
  _SalesOrder.PricingDate AS PricingDate,
  _SalesOrderItem.Material AS Material,
  _SalesOrderItem._Material._Text[1:Language=$parameters.P_Language].MaterialName AS MaterialName,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  _SalesOrderItem.ProductHierarchyNode AS ProductHierarchyNode,
  _SalesOrderItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  _SalesOrderItem.SalesOrderItemType AS SalesOrderItemType,
  _SalesOrderItem.Plant AS ProductionPlant,
  _SalesOrderItem._Plant.PlantName AS PlantName,
  _SalesOrderItem.NetAmount AS NetAmount,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  ProcessKPI.ProcObsvrKPICount AS ProcObsvrKPICount,
  ProcessKPI.ProcObsvrKPIDurationInSeconds AS ProcObsvrKPIDurationInSeconds,
  cast( 'SEC' as poc_dur_unit ) AS UnitOfMeasureISOCode,
  cast(division(ProcessKPI.ProcObsvrKPIDurationInSeconds, 3600, 3) as poc_process_kpi_dura_value_h ) AS ProcObsvrKPIDurationInHours,
  cast(division(ProcessKPI.ProcObsvrKPIDurationInSeconds, 86400, 3) as poc_process_kpi_dura_value_day ) AS ProcObsvrKPIDurationInDays,
  _SalesOrder._SalesOrderType AS _SalesDocumentType,
  _SalesOrder._SalesOrganization AS _SalesOrganization,
  _SalesOrder._DistributionChannel AS _DistributionChannel,
  _SalesOrder._OrganizationDivision AS _Division,
  _SalesOrder._SoldToParty AS _Customer,
  _SalesOrderItem._Material AS _Material,
  _SalesOrderItem._Plant AS _Plant,
  _SalesOrder._SalesGroup AS _SalesGroup,
  _SalesOrder._SalesOffice AS _SalesOffice,
  _SalesOrder._BusinessArea AS _BusinessArea
FROM I_ProcMonKPIO2CUNI AS ProcessKPI
LEFT OUTER JOIN I_Order2CashSalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = BusinessObject  -- association [0..1]
LEFT OUTER JOIN I_Order2CashSalesOrderItem AS _SalesOrderItem ON _SalesOrderItem.SalesOrder = BusinessObject AND _SalesOrderItem.SalesOrderItem = SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN C_ProcMonKPIO2C365 AS _ProcMonKPIO2C365 ON _ProcMonKPIO2C365.ProcObsvrProcessUUID = ProcessKPI.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonKPIO2C365Total AS _ProcMonKPIO2C365Total ON _ProcMonKPIO2C365Total.ProcObsvrProcessUUID = ProcessKPI.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonKPIO2C365TotalItem AS _ProcMonKPIO2C365TotalItem ON _ProcMonKPIO2C365TotalItem.ProcObsvrProcessUUID = ProcessKPI.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonKPIO2C365Lead AS _ProcMonKPIO2C365Lead ON _ProcMonKPIO2C365Lead.ProcObsvrProcessUUID = ProcessKPI.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonKPIO2C365LeadItem AS _ProcMonKPIO2C365LeadItem ON _ProcMonKPIO2C365LeadItem.ProcObsvrProcessUUID = ProcessKPI.ProcObsvrProcessUUID  -- association [0..*]
;