POC_D_TRACK_THR2

14 Fields 2 CDS Views

Generated Table for View

POC_D_TRACK_THR2 is an SAP database table in S/4HANA. Generated Table for View. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProcMonThresholdLog view from BASIC Process Observer: Threshold Log
P_POCVTRACKTHR2 view from BASIC

Fields (14)

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 thr_def_id POC_THR_DEF_ID Threshold
thr_count POC_THR_VAL_COUNT Count Threshold
thr_classific POC_THR_VAL_CLAS Class. Thr
thr_start_time TIMESTAMPL Time Stamp
thr_end_time TIMESTAMPL Time Stamp
thr_duration POC_THR_VAL_DUR Dur. Threshold
thr_dura_unit POC_DUR_THR_UNIT Unit
thr_notif_time POC_THR_NOTIF_TIME Notif.Time
thr_notif_sydate SYDATUM Current Date
thr_notif_sytime 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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE POC_D_TRACK_THR2 (
    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]
    THR_DEF_ID,        -- Threshold [POC_THR_DEF_ID]
    THR_COUNT,         -- Count Threshold [POC_THR_VAL_COUNT]
    THR_CLASSIFIC,     -- Class. Thr [POC_THR_VAL_CLAS]
    THR_START_TIME,    -- Time Stamp [TIMESTAMPL]
    THR_END_TIME,      -- Time Stamp [TIMESTAMPL]
    THR_DURATION,      -- Dur. Threshold [POC_THR_VAL_DUR]
    THR_DURA_UNIT,     -- Unit [POC_DUR_THR_UNIT]
    THR_NOTIF_TIME,    -- Notif.Time [POC_THR_NOTIF_TIME]
    THR_NOTIF_SYDATE,  -- Current Date [SYDATUM]
    THR_NOTIF_SYTIME,  -- Time [SYUZEIT]
    PRIMARY KEY (MANDT, PROCESS_ID, KPI_TYPE_ID, VALUATION_ID, THR_DEF_ID)
);

Learn More