APJ_X_JCE_ROOT

Transparent Table Application Table
21 Fields 7 CDS Views

Local Application Job Catalog Entry

APJ_X_JCE_ROOT is an SAP database table in S/4HANA. Local Application Job Catalog Entry. It contains 21 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
APJ_V_JCE_UNION view union_all Union View Job Catalog Entry
APJ_V_JT_X_COLLECTIVE view inner collective job templates
APJ_V_X_COLLECTIVE_JCE_LIST view from List of key user created collective job catalog entries
APJ_V_X_JCE_TO_REPORT view left_outer Customer job catalog entries w/ reports
FCCX_V_APJ_JCE_UNION view_entity union_all APJ JCE / JCE_X union
P_APJ_JC_JT_U view from Job Catalog + Template Union
R_FinClsgRunLocalJobTemplate view_entity inner BASIC FinClosing Run Local Job Template

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client symandt Client ID
KEY job_catalog_entry_name apj_job_catalog_entry_name Job Catalog
KEY job_catalog_entry_version apj_object_version Object Version
KEY user_name syuname User Name
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
text apj_job_catalog_entry_text Job Catalog Text
log_message apj_log_text Message After Compl.
layer_c apj_catalog_entry_layer_c Layer Code
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

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.

-- Local Application Job Catalog Entry
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APJ_X_JCE_ROOT (
    CLIENT,                     -- Client ID [symandt]
    JOB_CATALOG_ENTRY_NAME,     -- Job Catalog [apj_job_catalog_entry_name]
    JOB_CATALOG_ENTRY_VERSION,  -- Object Version [apj_object_version]
    USER_NAME,                  -- User Name [syuname]
    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]
    TEXT,                       -- Job Catalog Text [apj_job_catalog_entry_text]
    LOG_MESSAGE,                -- Message After Compl. [apj_log_text]
    LAYER_C,                    -- Layer Code [apj_catalog_entry_layer_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]
    PRIMARY KEY (CLIENT, JOB_CATALOG_ENTRY_NAME, JOB_CATALOG_ENTRY_VERSION, USER_NAME)
);

Learn More