APJ_W_JCE_ROOT

Transparent Table System Table (transport)
22 Fields 17 CDS Views

Application Job Catalog Entry

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

CDS Views using this table (17)

ViewTypeJoinVDMDescription
APJ_LANG_VRS_OBJ_ACTIVE_SAJC view_entity from Job Catalog Entries: ABAP Language Version of Active Objects
APJ_LANG_VRS_OBJ_EDIT_SAJC view_entity from Job Catalog Entries: ABAP Language Version of Edited Objects
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 from APJ JCE / JCE_X union
FCCX_V_APJ_TEMPLATE view 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
R_FinClsgRunGlobalJobTemplate view_entity inner BASIC Financial Closing Run Job Template

Fields (22)

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
crea_date_time TIMESTAMPL Time Stamp
crea_user_acct SYUNAME User Name
lst_ch_date_time TIMESTAMPL Time Stamp
lst_ch_user_acct SYUNAME User Name
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]
    CREA_DATE_TIME,             -- Time Stamp [TIMESTAMPL]
    CREA_USER_ACCT,             -- User Name [SYUNAME]
    LST_CH_DATE_TIME,           -- Time Stamp [TIMESTAMPL]
    LST_CH_USER_ACCT,           -- User Name [SYUNAME]
    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