APJ_D_JOB_EXE

Transparent Table Application Table
13 Fields 18 CDS Views

Application Job Execution

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

CDS Views using this table (18)

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_VISIBLE_SPOOLS view inner Spool exists check
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
R_FinancialClosingRunBatchJob view_entity from BASIC Financial Closing Run Batch Job
SAPJ_V_SPOOLREQS view from spool requests created by application jobs
XAJ_JOB_RUN_EXE view from Single Step Application Jobs
XAJ_JOB_STEP_INFO view inner Application Job Step Info

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)
);

Learn More