C_ProcMonKPIO2C365Total

Order-to-Cash Performance KPI (last 365 days) - Totals | view: CPOCKPIALL365T | Extraction: Not supported | Component: Process Orchestration for Built-In Processes
Column Name Description
ProcObsvrProcessUUID FK Process ID
ProcObsvrKPIDefinition FK Key Performance Indicator Definition ID
ValuationNumber KPI Valuation ID
ProcObsvrTaskUUID Task Instance ID
Column Name Description
💲 SD Document Currency (SalesOrderTransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
Column Name Description
EndUTCDate KPI Calculation Date (in UTC)
EndSystDate System Date
EndSystTime System Time
CalendarDate Calendar Date
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
PricingDate Date for Pricing and Exchange Rate
Column Name Description
ProcObsvrKPICategory KPI Type Show values
ProcObsvrProcessStatus Status of Process in System Show values
SalesOrderItemType Item Type Show values
Column Name Description Domain name
ProcObsvrKPIDefDesc KPI Name TEXT60
ProcObsvrProcessDefinition Process Definition ID POC_PROCESS_TYPE_ID
ProcObsvrProcessDefName Process Definition TEXT60
ProcObsvrProcessDefVersion Process Version POC_PROCESS_VERSION
ProcObsvrProcessStatusName Process Status Description POC_PROCESS_STATUS_DESC
ProcObsvrProcessVariantHash Hash for Process Variant
ProcObsvrProcessVariantLength Length of Process Variant
EndUTCDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CalendarYear Calendar Year NUM4
YearQuarter Year Quarter NUM5
CalendarQuarterName Short Text for Fixed Values DDTEXT
YearMonth Year Month NUM6
CalendarMonthName Short Text for Fixed Values DDTEXT
YearWeek Year Week NUM6
SalesOrder Sales Order VBELN
SalesOrderItem Item ID POC_ITEM_ID
SalesOrderTypeName Sales Document Type Description TEXT20
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SalesGroupName Sales Group Description TEXT20
SalesOfficeName Sales Office Description TEXT20
BusinessAreaName Business Area Description TEXT30
CustomerName Name of Customer TEXT80
MaterialName Material Description TEXT40
SalesOrderItemText Short text for sales order item TEXT40
ProductionPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
ProcObsvrKPICount Count KPI Value as Integer
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_PROCMONKPIO2C365TOTAL.MANDT == TGSB.MANDT
  • C_PROCMONKPIO2C365TOTAL.BUSINESSAREA == TGSB.GSBER
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVKOV.MANDT
  • C_PROCMONKPIO2C365TOTAL.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_PROCMONKPIO2C365TOTAL.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Client
  • Material Number
  • C_PROCMONKPIO2C365TOTAL.MANDT == MARA.MANDT
  • C_PROCMONKPIO2C365TOTAL.MATERIAL == MARA.MATNR
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVTA.MANDT
  • C_PROCMONKPIO2C365TOTAL.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_PROCMONKPIO2C365TOTAL.ORGANIZATIONDIVISION == TVTA.SPART
  • C_PROCMONKPIO2C365TOTAL.SALESORGANIZATION == TVTA.VKORG
Key Performance Indicator Definition ID
  • Client
  • ?
  • ?
  • Key Performance Indicator Definition ID
  • C_PROCMONKPIO2C365TOTAL.MANDT == POC_C_PRC_KPI.MANDT
  • C_PROCMONKPIO2C365TOTAL.[column in domain "POC_PROCESS_VERSION"] == POC_C_PRC_KPI.PROCESS_VERSION
  • C_PROCMONKPIO2C365TOTAL.[column in domain "POC_PROCESS_TYPE_ID"] == POC_C_PRC_KPI.PROCESS_TYPE_ID
  • C_PROCMONKPIO2C365TOTAL.PROCOBSVRKPIDEFINITION == POC_C_PRC_KPI.KPI_TYPE_ID
Sales group
  • Client
  • Sales group
  • Sales office
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVBVK.MANDT
  • C_PROCMONKPIO2C365TOTAL.SALESGROUP == TVBVK.VKGRP
  • C_PROCMONKPIO2C365TOTAL.SALESOFFICE == TVBVK.VKBUR
Sales document item category
  • Client
  • Sales document item category
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVPT.MANDT
  • C_PROCMONKPIO2C365TOTAL.SALESORDERITEMCATEGORY == TVPT.PSTYV
Currency in order header
  • Client
  • SD Document Currency
  • SD Document Currency
  • C_PROCMONKPIO2C365TOTAL.MANDT == TCURC.MANDT
  • C_PROCMONKPIO2C365TOTAL.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PROCMONKPIO2C365TOTAL.SALESORDERTRANSACTIONCURRENCY == TCURC.WAERS
Order type in order header
  • Client
  • Sales Order Type
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVAK.MANDT
  • C_PROCMONKPIO2C365TOTAL.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVKO.MANDT
  • C_PROCMONKPIO2C365TOTAL.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • C_PROCMONKPIO2C365TOTAL.SOLDTOPARTY == KNA1.KUNNR
  • C_PROCMONKPIO2C365TOTAL.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • C_PROCMONKPIO2C365TOTAL.MANDT == TCURC.MANDT
  • C_PROCMONKPIO2C365TOTAL.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PROCMONKPIO2C365TOTAL.SALESORDERTRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • Sales Organization
  • C_PROCMONKPIO2C365TOTAL.MANDT == TVKBZ.MANDT
  • C_PROCMONKPIO2C365TOTAL.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_PROCMONKPIO2C365TOTAL.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_PROCMONKPIO2C365TOTAL.SALESOFFICE == TVKBZ.VKBUR
  • C_PROCMONKPIO2C365TOTAL.SALESORGANIZATION == TVKBZ.VKORG