AJM_METADATA_INIT

DDL: AJM_METADATA_INIT SQL: AJM_META_INIT Type: view Package: S_OPS_JOBMON
31 Fields 4 Data Sources

AJM : Join init to central system

AJM_METADATA_INIT is a CDS View that provides data about "AJM : Join init to central system" in SAP S/4HANA. It reads from 4 data sources (apj_d_job_exe, tbtco, tbtcp, tbtcs) and exposes 31 fields with key fields jobname, tbtcp_step. Part of development package S_OPS_JOBMON.

Data Sources (4)

SourceAliasJoin Type
apj_d_job_exe apj_d_job_exe from
tbtco tbtco inner
tbtcp tbtcp inner
tbtcs tbtcs inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName AJM_META_INIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label AJM : Join init to central system view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY jobname tbtco jobname Name of Send Process
KEY tbtcp_step tbtcp stepcount Step no.
jobcount tbtco jobcount Job number
stepcount tbtco stepcount Step no.
sdlstrtdt tbtco sdlstrtdt Start Date
sdlstrttm tbtco sdlstrttm Start Time
sdldate tbtco sdldate Schedule date
sdltime tbtco sdltime Schedule date
sdluname tbtco sdluname Job scheduler
lastchdate tbtco lastchdate Last job change
lastchtime tbtco lastchtime Last job change
lastchname tbtco lastchname Last job change by
reluname tbtco reluname User that released scheduled batch job
prdmins tbtco prdmins Periodic job
prdhours tbtco prdhours Periodic job
prddays tbtco prddays Periodic job
prdweeks tbtco prdweeks Periodic job
prdmonths tbtco prdmonths Periodic job
periodic tbtco periodic Periodic job
status tbtco status Workflow Status
authcknam tbtco authcknam User Name
authckman tbtco authckman Client ID
joblog tbtco joblog Name
laststrtdt tbtco laststrtdt Latest Date
laststrttm tbtco laststrttm Latest Time
calendarid tbtco calendarid FactoryCalendar
progname tbtcp progname Tcode/program
step_sdldate tbtcp sdldate Schedule date
step_sdltime tbtcp sdltime Schedule date
variant tbtcp variant Variant Saved
job_text apj_d_job_exe job_text Description

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 AJM_METADATA_INIT.
-- 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: AJM_META_INIT

CREATE VIEW AJM_METADATA_INIT AS
SELECT
  tbtco.jobname AS jobname,
  tbtcp.stepcount AS tbtcp_step,
  tbtco.jobcount AS jobcount,
  tbtco.stepcount AS stepcount,
  tbtco.sdlstrtdt AS sdlstrtdt,
  tbtco.sdlstrttm AS sdlstrttm,
  tbtco.sdldate AS sdldate,
  tbtco.sdltime AS sdltime,
  tbtco.sdluname AS sdluname,
  tbtco.lastchdate AS lastchdate,
  tbtco.lastchtime AS lastchtime,
  tbtco.lastchname AS lastchname,
  tbtco.reluname AS reluname,
  tbtco.prdmins AS prdmins,
  tbtco.prdhours AS prdhours,
  tbtco.prddays AS prddays,
  tbtco.prdweeks AS prdweeks,
  tbtco.prdmonths AS prdmonths,
  tbtco.periodic AS periodic,
  tbtco.status AS status,
  tbtco.authcknam AS authcknam,
  tbtco.authckman AS authckman,
  tbtco.joblog AS joblog,
  tbtco.laststrtdt AS laststrtdt,
  tbtco.laststrttm AS laststrttm,
  tbtco.calendarid AS calendarid,
  tbtcp.progname AS progname,
  tbtcp.sdldate AS step_sdldate,
  tbtcp.sdltime AS step_sdltime,
  tbtcp.variant AS variant,
  apj_d_job_exe.job_text AS job_text
FROM apj_d_job_exe
INNER JOIN tbtcs ON /* join condition not captured in parsed metadata */
INNER JOIN tbtco ON /* join condition not captured in parsed metadata */
INNER JOIN tbtcp ON /* join condition not captured in parsed metadata */
;

Learn More