APJ_V_VISIBLE_SPOOLS

DDL: APJ_V_VISIBLE_SPOOLS SQL: APJ_V_SPOOL_VI Type: view Package: SBTI_APJ_RT
15 Fields 6 Data Sources

Spool exists check

APJ_V_VISIBLE_SPOOLS is a CDS View that provides data about "Spool exists check" in SAP S/4HANA. It reads from 6 data sources and exposes 15 fields with key fields jobname, jobcount, Stepcount, Spoolid, jobcount. Part of development package SBTI_APJ_RT.

Data Sources (6)

SourceAliasJoin Type
apj_d_job_exe exe inner
apj_d_job_exe exe inner
APJ_V_JCE_UNION jce inner
APJ_V_JCE_UNION jce_c inner
apj_d_job_chn jobs inner
tbtc_spoolid spool from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APJ_V_SPOOL_VI view
ClientDependent false view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Spool exists check view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY jobname tbtc_spoolid jobname Name of Send Process
KEY jobcount tbtc_spoolid jobcount Job number
KEY Stepcount tbtc_spoolid stepcount Step no.
KEY Spoolid tbtc_spoolid spoolid Number
RQIDENT
Spoolcount tbtc_spoolid spoolcount INT4
Recycled tbtc_spoolid recycled Boolean Variable (X = True, - = False, Space = Unknown)
created_by apj_d_job_exe created_by Version Created By
KEY jobcount tbtc_spoolid jobcount Job number
KEY Stepcount tbtc_spoolid stepcount Step no.
KEY Spoolid tbtc_spoolid spoolid Number
RQIDENT
Spoolcount tbtc_spoolid spoolcount INT4
Recycled tbtc_spoolid recycled Boolean Variable (X = True, - = False, Space = Unknown)
created_by apj_d_job_exe created_by Version Created By

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_VISIBLE_SPOOLS.
-- 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_SPOOL_VI

CREATE VIEW APJ_V_VISIBLE_SPOOLS AS
SELECT
  spool.jobname AS jobname,
  spool.jobcount AS jobcount,
  spool.stepcount AS Stepcount,
  spool.spoolid AS Spoolid,
  cast ( spool.spoolid as abap.int4 ) AS RQIDENT,
  spool.spoolcount AS Spoolcount,
  spool.recycled AS Recycled,
  exe.created_by AS created_by
FROM tbtc_spoolid AS spool
INNER JOIN apj_d_job_exe AS exe ON /* join condition not captured in parsed metadata */
INNER JOIN APJ_V_JCE_UNION AS jce ON /* join condition not captured in parsed metadata */
INNER JOIN apj_d_job_chn AS jobs ON /* join condition not captured in parsed metadata */
INNER JOIN APJ_V_JCE_UNION AS jce_c ON /* join condition not captured in parsed metadata */
;

Learn More