APJ_D_JOB_EXE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA