P_POCDKPILOG

DDL: P_POCDKPILOG SQL: POC_V_KPI_LOG Type: view BASIC
14 Fields 1 Data Sources

P_POCDKPILOG is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_POCDKPILOG2) and exposes 14 fields with key fields process_id, kpi_type_id, valuation_id.

Data Sources (1)

SourceAliasJoin Type
P_POCDKPILOG2 P_POCDKPILOG2 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName POC_V_KPI_LOG view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY process_id process_id Process Instance ID
KEY kpi_type_id kpi_type_id KPI Definition
KEY valuation_id valuation_id Valuation ID
kpi_count
kpi_duration kpi_duration LeadTime
kpi_category kpi_category Prc. Cl. Code
changed_at
kpi_dur_unit kpi_dur_unit Process KPI Unit
start_ba_id
start_bo_id
end_ba_id end_ba_id Task Instance ID
end_bo_type end_bo_type Business Object Type
end_bo_id end_bo_id Business Object ID
end_item_id end_item_id Item ID

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_POCDKPILOG.
-- 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: POC_V_KPI_LOG

CREATE VIEW P_POCDKPILOG AS
SELECT
  process_id,
  kpi_type_id,
  valuation_id,
  sum(kpi_count) AS kpi_count,
  kpi_duration,
  kpi_category,
  max(changed_at) AS changed_at,
  kpi_dur_unit,
  min(start_ba_id) AS start_ba_id,
  min(start_bo_id) AS start_bo_id,
  end_ba_id,
  end_bo_type,
  end_bo_id,
  end_item_id
FROM P_POCDKPILOG2
;

Learn More