APJ_W_JCE_ROOT

Transparent Table System Table (transport)
18 Fields 14 CDS Views

Application Job Catalog Entry

APJ_W_JCE_ROOT is an SAP database table in S/4HANA. Application Job Catalog Entry. It contains 18 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
APJ_V_JCE_TEXT view from BASIC JCE text for current logon language
APJ_V_JCE_TO_REPORT view inner List of job catalog entries with reports
APJ_V_JCE_TO_REPORT_UNION view left_outer Union view JCE to report
APJ_V_JCE_UNION view from Union View Job Catalog Entry
APJ_V_JOB_CATALOG_ENTRY view from
APJ_V_JOB_RUN_COLL_BASIC_JCE view left_outer Basic JCEs per Collective JCE
APJ_V_JOB_TEMPLATE view inner
APJ_V_JT_X_COLLECTIVE view inner collective job templates
APJ_V_X_COLLECTIVE_JCE_PAR view left_outer
APJ_V_X_JCE_TO_REPORT view left_outer Customer job catalog entries w/ reports
FCCX_V_APJ_JCE_UNION view_entity from APJ JCE / JCE_X union
FCCX_V_APJ_TEMPLATE view_entity inner Application Job Template
P_APJ_JC_JT_U view union_all Job Catalog + Template Union
P_APJ_JOB_CATALOG_F4 view from Job Catalog + Tempalte Union

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY job_catalog_entry_name apj_job_catalog_entry_name Job Catalog
KEY job_catalog_entry_version apj_object_version Object Version
report_name raldb_repo Report Name
job_type_c apj_job_type_c Job Type
scoping_relevant_ind apj_scoping_relevant_ind Scoping-Relevant
check_class apj_jce_check_class Check Class
log_handling_type_c apj_log_handling_type_c Log Handling
job_catalog_entry_type_c apj_job_catalog_entry_type_c Entry Type
job_delete_exit_class apj_jce_job_delete_exit_class Delete Exit Class
value_help_exit_class apj_jce_value_help_exit_class Value Help Exit
text_exit_class apj_jce_text_exit_class Text Exit Class
notif_exit_class apj_jce_job_notif_exit_class Notif. Exit Class
no_appl_chk_dt apj_jce_no_appl_chk_dt No appl. spec. check
spool_type_c apj_spool_type_c Results
intent apj_intent Spool Intent
log_intent apj_log_intent Log Intent
abap_language_version abap_language_version Language Version
auth_group secu Authorization Group

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 Catalog Entry
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APJ_W_JCE_ROOT (
    JOB_CATALOG_ENTRY_NAME,     -- Job Catalog [apj_job_catalog_entry_name]
    JOB_CATALOG_ENTRY_VERSION,  -- Object Version [apj_object_version]
    REPORT_NAME,                -- Report Name [raldb_repo]
    JOB_TYPE_C,                 -- Job Type [apj_job_type_c]
    SCOPING_RELEVANT_IND,       -- Scoping-Relevant [apj_scoping_relevant_ind]
    CHECK_CLASS,                -- Check Class [apj_jce_check_class]
    LOG_HANDLING_TYPE_C,        -- Log Handling [apj_log_handling_type_c]
    JOB_CATALOG_ENTRY_TYPE_C,   -- Entry Type [apj_job_catalog_entry_type_c]
    JOB_DELETE_EXIT_CLASS,      -- Delete Exit Class [apj_jce_job_delete_exit_class]
    VALUE_HELP_EXIT_CLASS,      -- Value Help Exit [apj_jce_value_help_exit_class]
    TEXT_EXIT_CLASS,            -- Text Exit Class [apj_jce_text_exit_class]
    NOTIF_EXIT_CLASS,           -- Notif. Exit Class [apj_jce_job_notif_exit_class]
    NO_APPL_CHK_DT,             -- No appl. spec. check [apj_jce_no_appl_chk_dt]
    SPOOL_TYPE_C,               -- Results [apj_spool_type_c]
    INTENT,                     -- Spool Intent [apj_intent]
    LOG_INTENT,                 -- Log Intent [apj_log_intent]
    ABAP_LANGUAGE_VERSION,      -- Language Version [abap_language_version]
    AUTH_GROUP,                 -- Authorization Group [secu]
    PRIMARY KEY (JOB_CATALOG_ENTRY_NAME, JOB_CATALOG_ENTRY_VERSION)
);

Learn More