C_ProcMonKPIO2C365Total

DDL: C_PROCMONKPIO2C365TOTAL SQL: CPOCKPIALL365T Type: view CONSUMPTION
57 Fields 1 Data Sources

Order-to-Cash Performance KPI (last 365 days) - Totals

C_ProcMonKPIO2C365Total is a Consumption CDS View that provides data about "Order-to-Cash Performance KPI (last 365 days) - Totals" in SAP S/4HANA. It reads from 1 data source (C_ProcMonKPIO2CMonth) and exposes 57 fields with key fields ProcObsvrProcessUUID, ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrTaskUUID.

Data Sources (1)

SourceAliasJoin Type
C_ProcMonKPIO2CMonth C_ProcMonKPIO2CMonth from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPOCKPIALL365T view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Order-to-Cash Performance KPI (last 365 days) - Totals view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID Process ProcObsvrProcessUUID
KEY ProcObsvrKPIDefinition ProcObsvrKPIDefinition
KEY ValuationNumber ValuationNumber
KEY ProcObsvrTaskUUID ProcObsvrTaskUUID
ProcObsvrKPIDefDesc
ProcObsvrProcessDefinition ProcObsvrProcessDefinition
ProcObsvrProcessDefName
ProcObsvrProcessDefVersion ProcObsvrProcessDefVersion
ProcObsvrKPICategory _ProcMonKPIDefinition ProcObsvrKPICategory
ProcObsvrProcessStatus ProcObsvrProcessStatus
ProcObsvrProcessStatusName
ProcObsvrProcessVariantHash ProcObsvrProcessVariantHash
ProcObsvrProcessVariantLength ProcObsvrProcessVariantLength
EndUTCDateTime EndUTCDateTime Time Stamp
EndUTCDate EndUTCDate
EndSystDate EndSystDate
EndSystTime EndSystTime
CalendarYear CalendarYear Year
YearQuarter YearQuarter Year Quarter
CalendarQuarterName CalendarQuarterName
YearMonth YearMonth Year Month
CalendarMonthName CalendarMonthName
YearWeek YearWeek Year and Calendar Week
CalendarDate CalendarDate Calendar Date
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
CreationDate _SalesOrder CreationDate Time Stamp
CreationTime _SalesOrder CreationTime Time of Change
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
SalesOrderTypeName
SalesOrganization _SalesOrder SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
DivisionName
SalesGroup _SalesOrder SalesGroup Sales Group
SalesGroupName
SalesOffice _SalesOrder SalesOffice Sales Office
SalesOfficeName
BusinessArea _SalesOrder BusinessArea Business Area
BusinessAreaName
SoldToParty _SalesOrder SoldToParty Sold-to Party
CustomerName _Customer CustomerName Name of Customer
TotalNetAmount _SalesOrder TotalNetAmount Total Net Amount
SalesOrderTransactionCurrency _SalesOrder TransactionCurrency Transaction Currency
PricingDate _SalesOrder PricingDate Pricing Date
Material _SalesOrderItem Material Vehicle Model
MaterialName
SalesOrderItemText _SalesOrderItem SalesOrderItemText
SalesOrderItemCategory _SalesOrderItem SalesOrderItemCategory Item Category
SalesOrderItemType _SalesOrderItem SalesOrderItemType
ProductionPlant _SalesOrderItem Plant Valuation Area
PlantName _Plant PlantName Plant Name
NetAmount _SalesOrderItem NetAmount Stated Amount
TransactionCurrency _SalesOrderItem TransactionCurrency Transaction Currency
ProcObsvrKPICount ProcObsvrKPICount

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_ProcMonKPIO2C365Total.
-- 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: CPOCKPIALL365T
-- Parameters: P_Language : sylangu

CREATE VIEW C_ProcMonKPIO2C365Total AS
SELECT
  Process.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  ProcObsvrKPIDefinition,
  ValuationNumber,
  ProcObsvrTaskUUID,
  _ProcMonKPIDefinition._Text[1: Language=$parameters.P_Language].ProcObsvrKPIDefDesc AS ProcObsvrKPIDefDesc,
  ProcObsvrProcessDefinition,
  _ProcMonProcessDefinition._Text[1: Language=$parameters.P_Language].ProcObsvrProcessDefName AS ProcObsvrProcessDefName,
  ProcObsvrProcessDefVersion,
  _ProcMonKPIDefinition.ProcObsvrKPICategory AS ProcObsvrKPICategory,
  ProcObsvrProcessStatus,
  _ProcObsvrProcessStatus._Text[1: Language=$parameters.P_Language].ProcObsvrProcessStatusName AS ProcObsvrProcessStatusName,
  ProcObsvrProcessVariantHash,
  ProcObsvrProcessVariantLength,
  EndUTCDateTime,
  EndUTCDate,
  EndSystDate,
  EndSystTime,
  CalendarYear,
  YearQuarter,
  CalendarQuarterName,
  YearMonth,
  CalendarMonthName,
  YearWeek,
  CalendarDate,
  SalesOrder,
  SalesOrderItem,
  _SalesOrder.CreationDate AS CreationDate,
  _SalesOrder.CreationTime AS CreationTime,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesDocumentType._Text[1:Language=$parameters.P_Language].SalesDocumentTypeName AS SalesOrderTypeName,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrganization._Text[1:Language=$parameters.P_Language].SalesOrganizationName AS SalesOrganizationName,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _DistributionChannel._Text[1:Language=$parameters.P_Language].DistributionChannelName AS DistributionChannelName,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _Division._Text[1:Language=$parameters.P_Language].DivisionName AS DivisionName,
  _SalesOrder.SalesGroup AS SalesGroup,
  _SalesGroup._Text[1:Language=$parameters.P_Language].SalesGroupName AS SalesGroupName,
  _SalesOrder.SalesOffice AS SalesOffice,
  _SalesOffice._Text[1:Language=$parameters.P_Language].SalesOfficeName AS SalesOfficeName,
  _SalesOrder.BusinessArea AS BusinessArea,
  _BusinessArea._Text[1:Language=$parameters.P_Language].BusinessAreaName AS BusinessAreaName,
  _SalesOrder.SoldToParty AS SoldToParty,
  _Customer.CustomerName AS CustomerName,
  _SalesOrder.TotalNetAmount AS TotalNetAmount,
  _SalesOrder.TransactionCurrency AS SalesOrderTransactionCurrency,
  _SalesOrder.PricingDate AS PricingDate,
  _SalesOrderItem.Material AS Material,
  _Material._Text[1:Language=$parameters.P_Language].MaterialName AS MaterialName,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  _SalesOrderItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  _SalesOrderItem.SalesOrderItemType AS SalesOrderItemType,
  _SalesOrderItem.Plant AS ProductionPlant,
  _Plant.PlantName AS PlantName,
  _SalesOrderItem.NetAmount AS NetAmount,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  ProcObsvrKPICount
FROM C_ProcMonKPIO2CMonth
;

Learn More