Apj_V_Spool_Exists_W_SC

DDL: APJ_V_SPOOL_EXISTS_W_SC SQL: APJ_V_SPOOL_EXWC Type: view
7 Fields 1 Data Sources

Spool exists check with stepcount

Apj_V_Spool_Exists_W_SC is a CDS View that provides data about "Spool exists check with stepcount" in SAP S/4HANA. It reads from 1 data source (apj_d_job_exe) and exposes 7 fields with key fields jobname, jobcount, stepcount.

Data Sources (1)

SourceAliasJoin Type
apj_d_job_exe jobs inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APJ_V_SPOOL_EXWC view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Spool exists check with stepcount view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY jobname spool jobname Name of Send Process
KEY jobcount spool jobcount Job number
KEY stepcount spool stepcount Step no.
recycled spool recycled Boolean Variable (X = True, - = False, Space = Unknown)
recycledXthenXelseendasspool_exists
created_by apj_d_job_exe created_by Version Created By
own_spool

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_Spool_Exists_W_SC.
-- 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_EXWC

CREATE VIEW Apj_V_Spool_Exists_W_SC AS
SELECT
  spool.jobname AS jobname,
  spool.jobcount AS jobcount,
  spool.stepcount AS stepcount,
  spool.recycled AS recycled,
  case when spool.recycled != 'X' then 'X' else ' ' end as spool_exists AS recycledXthenXelseendasspool_exists,
  jobs.created_by AS created_by,
  case when created_by = $session.user then 'X' else ' ' end AS own_spool
INNER JOIN apj_d_job_exe AS jobs ON /* join condition not captured in parsed metadata */
;

Learn More