APJ_D_JOB_EXE

Transparent Table Application Table

Application Job Execution

APJ_D_JOB_EXE is an SAP database table in S/4HANA. Application Job Execution. It contains 13 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
AJM_METADATA_INFO view inner AJM: metadata info to central system
AJM_METADATA_INIT view from AJM : Join init to central system
APJ_V_JOB_RUN_AB_FIN_ENDDATE view from All aborted or finished application jobs
Apj_V_Job_Run_Aborted_Finished view from All aborted or finished application jobs
APJ_V_JOB_RUN_OVERVIEW view inner Job overview
APJ_V_JOB_RUN_OVERVIEW_S view inner Job overview
APJ_V_JOB_STATUS_INT view from konvertiert internen in externen Status
Apj_V_Spool_Exists view inner Spool exists check
Apj_V_Spool_Exists_W_SC view inner Spool exists check with stepcount
I_APJ_JOB_USR_OVERVIEW view_entity inner Application Job Users Overview
I_InventoryAnalyticsJob view_entity inner COMPOSITE Inventory analytics job
p_apj_job_run_exe view from Application Job Run Chain
P_APPL_JOB_RUN_DET view from BASIC
P_JOB_Overview_Analytics view from BASIC
P_POCntrlAnlytsFailedJob view from BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client symandt Client ID
KEY job_name btcjob Job Name
job_count btcjobcnt Job No.
job_catalog_entry apj_job_catalog_entry_name Job Catalog
job_template_name apj_job_template_name Job Template Name
created_by syuname User Name
created_at timestampl Time Stamp
job_text apj_job_text Description
exe_type apj_job_schedule_type_c Schedule Type Code
report raldb_repo Report Name
variant variant Variant
scheduling_timezone timezone Time Zone
jce_type_c apj_job_catalog_entry_type_c Entry Type

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.

-- Application Job Execution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APJ_D_JOB_EXE (
    CLIENT,               -- Client ID [symandt]
    JOB_NAME,             -- Job Name [btcjob]
    JOB_COUNT,            -- Job No. [btcjobcnt]
    JOB_CATALOG_ENTRY,    -- Job Catalog [apj_job_catalog_entry_name]
    JOB_TEMPLATE_NAME,    -- Job Template Name [apj_job_template_name]
    CREATED_BY,           -- User Name [syuname]
    CREATED_AT,           -- Time Stamp [timestampl]
    JOB_TEXT,             -- Description [apj_job_text]
    EXE_TYPE,             -- Schedule Type Code [apj_job_schedule_type_c]
    REPORT,               -- Report Name [raldb_repo]
    VARIANT,              -- Variant [variant]
    SCHEDULING_TIMEZONE,  -- Time Zone [timezone]
    JCE_TYPE_C,           -- Entry Type [apj_job_catalog_entry_type_c]
    PRIMARY KEY (CLIENT, JOB_NAME)
);