IUUC_DHADM_Mon_AccessPlanJobsB

DDL: IUUC_DHADM_MON_ACCESSPLANJOBSB Type: view_entity
27 Fields 7 Data Sources

Access Plan Jobs

IUUC_DHADM_Mon_AccessPlanJobsB is a CDS View that provides data about "Access Plan Jobs" in SAP S/4HANA. It reads from 7 data sources and exposes 27 fields with key fields SubscriberId, Objtype, Objname, AcdId, PartitionId.

Data Sources (7)

SourceAliasJoin Type
dhcdc_rtacdprttn acd from
dhcdc_rtacdprttn acd union_all
dhcdc_rtcalcstat acp inner
IUUC_DHADM_Mon_AccessPlanJobsJ jobcnt inner
IUUC_DHADM_Mon_AccessPlanJobsJ jobcnt inner
dhcdc_rtobjcalc objinfo inner
dhcdc_rtobjcalc objinfo inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Access Plan Jobs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SubscriberId dhcdc_rtobjcalc subscriber_id Subscriber ID
KEY Objtype dhcdc_rtobjcalc objtype Translation OType
KEY Objname dhcdc_rtobjcalc objname Table Name
KEY AcdId dhcdc_rtacdprttn acd_id Access Plan Head. ID
KEY PartitionId dhcdc_rtacdprttn partition_id UUID
KEY AcpId Access Plan ID
JobId dhcdc_rtacdprttn job_id Package ID
JobCount IUUC_DHADM_Mon_AccessPlanJobsJ JobCount Job number
JobName IUUC_DHADM_Mon_AccessPlanJobsJ JobName Name of Send Process
Status IUUC_DHADM_Mon_AccessPlanJobsJ JobStatus Purch Doc Job Status
StartDate IUUC_DHADM_Mon_AccessPlanJobsJ StartDate Valid From
StartTime IUUC_DHADM_Mon_AccessPlanJobsJ StartTime Time Stamp
EndDate IUUC_DHADM_Mon_AccessPlanJobsJ EndDate Term to
subscriber_idasSubscriberId
KEY Objtype dhcdc_rtobjcalc objtype Translation OType
KEY Objname dhcdc_rtobjcalc objname Table Name
KEY AcdId dhcdc_rtacdprttn acd_id Access Plan Head. ID
KEY PartitionId dhcdc_rtacdprttn partition_id UUID
KEY AcpId dhcdc_rtcalcstat acp_id Access Plan ID
JobId dhcdc_rtcalcstat job_id Package ID
JobCount IUUC_DHADM_Mon_AccessPlanJobsJ JobCount Job number
JobName IUUC_DHADM_Mon_AccessPlanJobsJ JobName Name of Send Process
Status IUUC_DHADM_Mon_AccessPlanJobsJ JobStatus Purch Doc Job Status
StartDate IUUC_DHADM_Mon_AccessPlanJobsJ StartDate Valid From
StartTime IUUC_DHADM_Mon_AccessPlanJobsJ StartTime Time Stamp
EndDate IUUC_DHADM_Mon_AccessPlanJobsJ EndDate Term to
EndTime IUUC_DHADM_Mon_AccessPlanJobsJ EndTime Time Stamp

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 IUUC_DHADM_Mon_AccessPlanJobsB.
-- 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.

CREATE VIEW IUUC_DHADM_Mon_AccessPlanJobsB AS
SELECT
  objinfo.subscriber_id AS SubscriberId,
  objinfo.objtype AS Objtype,
  objinfo.objname AS Objname,
  acd.acd_id AS AcdId,
  acd.partition_id AS PartitionId,
  cast( '00000' as dhcdc_rt_access_plan_id preserving type ) AS AcpId,
  acd.job_id AS JobId,
  jobcnt.JobCount AS JobCount,
  jobcnt.JobName AS JobName,
  jobcnt.JobStatus AS Status,
  jobcnt.StartDate AS StartDate,
  jobcnt.StartTime AS StartTime,
  jobcnt.EndDate AS EndDate,
  jobcnt.EndTime as EndTime AS subscriber_idasSubscriberId,
  jobcnt.EndTime AS EndTime
FROM dhcdc_rtacdprttn AS acd
INNER JOIN dhcdc_rtobjcalc AS objinfo ON /* join condition not captured in parsed metadata */
INNER JOIN IUUC_DHADM_Mon_AccessPlanJobsJ AS jobcnt ON /* join condition not captured in parsed metadata */
INNER JOIN dhcdc_rtcalcstat AS acp ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): dhcdc_rtacdprttn
;

Learn More