The APJ_X_JT_ROOT table in SAP ERP or S/4HANA stores APJ: local job templates data. There are total 13 fields in APJ_X_JT_ROOT table. The APJ: local job templates table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of APJ_X_JT_ROOT table. It is in Application jobs – design time (SBTI_APJ_DT) ABAP package and is part of the Catalog based Application Job (BC-SRV-APS-APJ) module.
SAP APJ_X_JT_ROOT Table Fields
Following is the list of fields that are available in SAP APJ_X_JT_ROOT table. The primary key fields of the table are CLIENT (Client ID), JOB_TEMPLATE_NAME (Application Job – Job Template Name), JOB_TEMPLATE_VERSION (Application Job Object Version), USER_NAME (User Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client ID | SYMANDT | CLNT (3) | |
| JOB_TEMPLATE_NAME | Application Job – Job Template Name | APJ_JOB_TEMPLATE_NAME | CHAR (40) | |
| JOB_TEMPLATE_VERSION | Application Job Object Version | APJ_OBJECT_VERSION | NUMC (1) | |
| USER_NAME | User Name | SYUNAME | CHAR (12) | |
| LAYER_C | Application Job Template Layer Code | APJ_OBJECT_LAYER_C | CHAR (1) | |
| JOB_CATALOG_ENTRY_NAME | Job Catalog Entry | APJ_JOB_CATALOG_ENTRY_NAME | CHAR (40) | |
| CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| CREA_USER_ACCT | User Name | SYUNAME | CHAR (12) | |
| LST_CH_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| LST_CH_USER_ACCT | User Name | SYUNAME | CHAR (12) | |
| JOB_PERIODIC_GRANULARITY | Periodic granularity | APJ_JOB_PERIODIC_GRANULARITY | CHAR (2) | |
| TEXT | Application Job Template Text | APJ_JOB_TEMPLATE_TEXT | CHAR (120) | |
| TECHNICAL_IND | Technical job template indicator | APJ_JT_TECHNICAL_IND | CHAR (1) |
