APJ_V_JOB_TASK_DATA

DDL: APJ_V_JOB_TASK_DATA SQL: APJ_V_JOB_TASK Type: view Package: SBTI_APJ_RT
6 Fields 2 Data Sources

CDS View to retrieve the Template name

APJ_V_JOB_TASK_DATA is a CDS View that provides data about "CDS View to retrieve the Template name" in SAP S/4HANA. It reads from 2 data sources (tbtc_task, tbtc_task_det) and exposes 6 fields with key fields jobname, jobcount. Part of development package SBTI_APJ_RT.

Data Sources (2)

SourceAliasJoin Type
tbtc_task jobs from
tbtc_task_det task inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName APJ_V_JOB_TASK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View to retrieve the Template name view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY jobname tbtc_task jobname Name of Send Process
KEY jobcount tbtc_task jobcount Job number
taskid tbtc_task taskid Task ID
version tbtc_task_det version XML Vers.
periodic tbtc_task_det periodic Periodic job
template_id tbtc_task_det job_template_name Job Template Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view APJ_V_JOB_TASK_DATA.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: APJ_V_JOB_TASK

CREATE VIEW APJ_V_JOB_TASK_DATA AS
SELECT
  jobs.jobname AS jobname,
  jobs.jobcount AS jobcount,
  jobs.taskid AS taskid,
  task.version AS version,
  task.periodic AS periodic,
  task.job_template_name AS template_id
FROM tbtc_task AS jobs
INNER JOIN tbtc_task_det AS task ON /* join condition not captured in parsed metadata */
;

Learn More