APJ_V_JOB_RUN_OVERVIEW

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.

-- Job overview
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APJ_V_JOB_RUN_OVERVIEW (
    JOB_NAME,
    JOB_RUN_COUNT,
    FACTORY_CALENDAR_ID,
    JOB_CALC_TIMEZONE,
    JOB_CATALOG_ENTRY_NAME,
    JOB_CATALOG_ENTRY_TEXT,
    JOB_CATALOG_ENTRY_TYPE_C,
    JOB_CREATED_AT,
    JOB_CREATED_BY,
    JOB_CREATED_BY_FORMATTED_NAME,
    JOB_PERIODIC_DAYS,
    JOB_PERIODIC_HOURS,
    JOB_PERIODIC_IND,
    JOB_PERIODIC_MINUTES,
    JOB_PERIODIC_MONTHS,
    JOB_PERIODIC_WEEKS,
    JOB_RUN_CREA_DATETIME,
    JOB_RUN_END_DATE,
    JOB_RUN_END_DATETIME,
    JOB_RUN_END_TIME,
    JOB_RUN_HAS_RESULTS_IND,
    JOB_RUN_ORIG_JOB_COUNT,
    JOB_RUN_ORIG_JOB_NAME,
    JOB_RUN_PLANNED_START_DATETIME,
    JOB_RUN_PLANNED_START_TIME,
    JOB_RUN_RESTART_COUNT,
    JOB_RUN_RESTART_MODE,
    JOB_RUN_START_DATE,
    JOB_RUN_START_DATETIME,
    JOB_RUN_START_TIME,
    JOB_RUN_STATUS,
    JOB_STEP_COUNT,
    JOB_TASK_END_DATETIME,
    JOB_TASK_END_MAX_ITERATIONS,
    JOB_TASK_USE_WORKDAYS_IND,
    JOB_TASK_WEEKDAY_INFO,
    JOB_TASK_WORKDAY_CDIR,
    JOB_TASK_WORKDAY_NO,
    JOB_TEMPLATE_NAME,
    JOB_TEMPLATE_TEXT,
    JOB_TEXT,
    SCHEDULE_TYPE_C,
    START_RESTRICTION_CODE,
    PRIMARY KEY (JOB_NAME, JOB_RUN_COUNT)
);