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