P_SBTI_APJ_PARAMETERS

DDL: P_SBTI_APJ_PARAMETERS SQL: SBTI_V_JOB_PAR Type: view
11 Fields 3 Data Sources

APJ Parameters

P_SBTI_APJ_PARAMETERS is a CDS View that provides data about "APJ Parameters" in SAP S/4HANA. It reads from 3 data sources (tbtc_task_params, tbtcp, tbtc_task) and exposes 11 fields with key fields taskid, jobname, jobcount, stepcount, paramguid.

Data Sources (3)

SourceAliasJoin Type
tbtc_task_params params from
tbtcp step inner
tbtc_task task inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SBTI_V_JOB_PAR view
AbapCatalog.compiler.compareFilter true view
ClientDependent false view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label APJ Parameters view

Fields (11)

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
low tbtc_task_params lowvar Field Value
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.
-- 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_PAR

CREATE VIEW P_SBTI_APJ_PARAMETERS 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.lowvar AS low,
  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 */
;

Learn More