P_SBTI_APJ_PARAMETERS_DYNAMIC

DDL: P_SBTI_APJ_PARAMETERS_DYNAMIC SQL: SBTI_V_JOB_PARD Type: view Package: SBTI_API
10 Fields 4 Data Sources

APJ Params with dynamic dates conversion

P_SBTI_APJ_PARAMETERS_DYNAMIC is a CDS View that provides data about "APJ Params with dynamic dates conversion" in SAP S/4HANA. It reads from 4 data sources (tbtco, tbtc_task_params, tbtcp, tbtc_task) and exposes 10 fields with key fields taskid, jobname, jobcount, stepcount, paramguid. Part of development package SBTI_API.

Data Sources (4)

SourceAliasJoin Type
tbtco job inner
tbtc_task_params params from
tbtcp step inner
tbtc_task task inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SBTI_V_JOB_PARD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientDependent false view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label APJ Params with dynamic dates conversion view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY taskid tbtc_task_params taskid Task ID
KEY jobname tbtc_task jobname Name of Send Process
KEY jobcount tbtc_task jobcount Job number
KEY stepcount tbtcp stepcount Step no.
KEY paramguid tbtc_task_params paramguid char8
KEY selname tbtc_task_params selnamevar Selection
kind tbtc_task_params kindvar Selection Type
sign tbtc_task_params signvar INCL/EXCL
opt tbtc_task_params optionvar Option
high tbtc_task_params highvar Field Value

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 P_SBTI_APJ_PARAMETERS_DYNAMIC.
-- 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: SBTI_V_JOB_PARD

CREATE VIEW P_SBTI_APJ_PARAMETERS_DYNAMIC AS
SELECT
  params.taskid AS taskid,
  task.jobname AS jobname,
  task.jobcount AS jobcount,
  step.stepcount AS stepcount,
  params.paramguid AS paramguid,
  params.selnamevar AS selname,
  params.kindvar AS kind,
  params.signvar AS sign,
  params.optionvar AS opt,
  params.highvar AS high
FROM tbtc_task_params AS params
INNER JOIN tbtc_task AS task ON /* join condition not captured in parsed metadata */
INNER JOIN tbtcp AS step ON /* join condition not captured in parsed metadata */
INNER JOIN tbtco AS job ON /* join condition not captured in parsed metadata */
;

Learn More