APJ_X_JT_ROOT

Transparent Table Application Table
11 Fields 12 CDS Views

Local Application Job Templates

APJ_X_JT_ROOT is an SAP database table in S/4HANA. Local Application Job Templates. It contains 11 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
APJ_V_JOB_RUN_JT_X view from Job Template
APJ_V_JT_SEQUENCE_X view from View JT Sequences Customers
APJ_V_JT_X_COLLECTIVE view from collective job templates
APJ_V_JT_X_COLLECTIVE view union collective job templates
APJ_V_JT_X_PARAMETERS view union Parameters for customer templates
APJ_V_X_JOB_TEMPLATE view from
FCCX_V_X_APJ_TEMPLATE view_entity from Customer Defined APJ Template
P_APJ_JC_JT_U view inner Job Catalog + Template Union
P_APJ_JT_SEQUENCE view from sequences
P_APJ_JT_SEQUENCE view union sequences
P_APJ_X_JOB_TEMPLATE view from Client-dependent Job Template
XAJ_JOB_TEMPLATE_VALUES view union_all JT Parameter Values

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client symandt Client ID
KEY job_template_name apj_job_template_name Job Template Name
KEY job_template_version apj_object_version Object Version
KEY user_name syuname User Name
layer_c apj_object_layer_c Layer Code
job_catalog_entry_name apj_job_catalog_entry_name Job Catalog
job_periodic_granularity apj_job_periodic_granularity Recurrence Pattern
job_periodic_value apj_job_periodic_value Periodic value
text apj_job_template_text Job Template
text_sequence apj_job_template_text Job Template
technical_ind apj_jt_technical_ind Technical Indicator

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 Templates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APJ_X_JT_ROOT (
    CLIENT,                    -- Client ID [symandt]
    JOB_TEMPLATE_NAME,         -- Job Template Name [apj_job_template_name]
    JOB_TEMPLATE_VERSION,      -- Object Version [apj_object_version]
    USER_NAME,                 -- User Name [syuname]
    LAYER_C,                   -- Layer Code [apj_object_layer_c]
    JOB_CATALOG_ENTRY_NAME,    -- Job Catalog [apj_job_catalog_entry_name]
    JOB_PERIODIC_GRANULARITY,  -- Recurrence Pattern [apj_job_periodic_granularity]
    JOB_PERIODIC_VALUE,        -- Periodic value [apj_job_periodic_value]
    TEXT,                      -- Job Template [apj_job_template_text]
    TEXT_SEQUENCE,             -- Job Template [apj_job_template_text]
    TECHNICAL_IND,             -- Technical Indicator [apj_jt_technical_ind]
    PRIMARY KEY (CLIENT, JOB_TEMPLATE_NAME, JOB_TEMPLATE_VERSION, USER_NAME)
);

Learn More