POC_D_KPI_LOG2

Transparent Table Application Table
27 Fields 7 CDS Views

Task Log KPI Values

POC_D_KPI_LOG2 is an SAP database table in S/4HANA. Task Log KPI Values. It contains 27 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ProcMonKPI view from BASIC Process Observer: All KPIs
I_ProcMonKPIDuration view from BASIC Process Observer: Duration KPIs
P_POCDKPIACT2 view from BASIC
P_POCDKPIACT2 view union_all BASIC
P_POCDKPILOG2 view left_outer BASIC
P_POCDKPILOG2 view union_all BASIC
P_POCVTRACKTHR view left_outer BASIC

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY process_id poc_process_id Process Instance ID
KEY kpi_type_id poc_process_kpi_type KPI Definition
KEY valuation_id poc_kpi_valuation_id Valuation ID
KEY start_prc_step_id poc_process_step_id Activity ID
KEY start_ba_id poc_ba_id Task Instance ID
start_bo_type poc_bo_type Business Object Type
start_bo_id poc_bo_id Business Object ID
start_item_id poc_item_id Item ID
start_timestamp timestampl Time Stamp
end_prc_step_id poc_process_step_id Activity ID
end_ba_id poc_ba_id Task Instance ID
end_bo_type poc_bo_type Business Object Type
end_bo_id poc_bo_id Business Object ID
end_item_id poc_item_id Item ID
end_timestamp timestampl Time Stamp
process_type_id poc_process_type_id Process Def. ID
process_version poc_process_version Process Version
kpi_count poc_process_kpi_count_value Total
kpi_duration poc_process_kpi_dura_value LeadTime
kpi_category poc_kpi_ctg_type Prc. Cl. Code
changed_at poc_changed_time Last Changed At
kpi_dur_unit poc_process_kpi_unit Process KPI Unit
start_date sydatum Current Date
start_time syuzeit Time
end_date sydatum Current Date
end_time syuzeit Time

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Task Log KPI Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE POC_D_KPI_LOG2 (
    MANDT,              -- Client [mandt]
    PROCESS_ID,         -- Process Instance ID [poc_process_id]
    KPI_TYPE_ID,        -- KPI Definition [poc_process_kpi_type]
    VALUATION_ID,       -- Valuation ID [poc_kpi_valuation_id]
    START_PRC_STEP_ID,  -- Activity ID [poc_process_step_id]
    START_BA_ID,        -- Task Instance ID [poc_ba_id]
    START_BO_TYPE,      -- Business Object Type [poc_bo_type]
    START_BO_ID,        -- Business Object ID [poc_bo_id]
    START_ITEM_ID,      -- Item ID [poc_item_id]
    START_TIMESTAMP,    -- Time Stamp [timestampl]
    END_PRC_STEP_ID,    -- Activity ID [poc_process_step_id]
    END_BA_ID,          -- Task Instance ID [poc_ba_id]
    END_BO_TYPE,        -- Business Object Type [poc_bo_type]
    END_BO_ID,          -- Business Object ID [poc_bo_id]
    END_ITEM_ID,        -- Item ID [poc_item_id]
    END_TIMESTAMP,      -- Time Stamp [timestampl]
    PROCESS_TYPE_ID,    -- Process Def. ID [poc_process_type_id]
    PROCESS_VERSION,    -- Process Version [poc_process_version]
    KPI_COUNT,          -- Total [poc_process_kpi_count_value]
    KPI_DURATION,       -- LeadTime [poc_process_kpi_dura_value]
    KPI_CATEGORY,       -- Prc. Cl. Code [poc_kpi_ctg_type]
    CHANGED_AT,         -- Last Changed At [poc_changed_time]
    KPI_DUR_UNIT,       -- Process KPI Unit [poc_process_kpi_unit]
    START_DATE,         -- Current Date [sydatum]
    START_TIME,         -- Time [syuzeit]
    END_DATE,           -- Current Date [sydatum]
    END_TIME,           -- Time [syuzeit]
    PRIMARY KEY (MANDT, PROCESS_ID, KPI_TYPE_ID, VALUATION_ID, START_PRC_STEP_ID, START_BA_ID)
);

Learn More