DHADM_MON_JobsOverview

DDL: DHADM_MON_JOBSOVERVIEW Type: view_entity

Jobs overview

DHADM_MON_JobsOverview is a CDS View that provides data about "Jobs overview" in SAP S/4HANA. It reads from 2 data sources (dhcdc_rtacdprttn, dhcdc_rtcalcstat) and exposes 2 fields.

Data Sources (2)

SourceAliasJoin Type
dhcdc_rtacdprttn acd from
dhcdc_rtcalcstat acp inner

Annotations (6)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
acd_id dhcdc_rtacdprttn acd_id Access Plan Head. ID
acp_id dhcdc_rtcalcstat acp_id Access Plan ID

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 DHADM_MON_JobsOverview.
-- 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 DHADM_MON_JobsOverview AS
SELECT
  acd.acd_id AS acd_id,
  acp.acp_id AS acp_id
FROM dhcdc_rtacdprttn AS acd
INNER JOIN dhcdc_rtcalcstat AS acp ON /* join condition not captured in parsed metadata */
;