APJ_D_JOB_EXE

Transparent Table Application Table
14 Fields 18 CDS Views

Application Job Execution

APJ_D_JOB_EXE is an SAP database table in S/4HANA. Application Job Execution. It contains 14 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 left_outer COMPOSITE Inventory analytics job
p_apj_job_run_exe view from Application Job Run Chain
P_APPL_JOB_RUN_DET view from BASIC Application Job Run Details
P_JOB_Overview_Analytics view from BASIC Job overview analytics
P_POCntrlAnlytsFailedJob view from BASIC PO Extraction for central Anlytcs
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 (14)

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
test_mode boolean Boolean Variable (X = True, - = False, Space = Unknown)

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]
    TEST_MODE,            -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PRIMARY KEY (CLIENT, JOB_NAME)
);

Learn More