C_CntrlProcmtJobMntr

DDL: C_CNTRLPROCMTJOBMNTR SQL: CCNTRLPRCJOBMNTR Type: view CONSUMPTION
15 Fields 1 Data Sources 2 Associations

Central Procurement Job Monitor

C_CntrlProcmtJobMntr is a Consumption CDS View that provides data about "Central Procurement Job Monitor" in SAP S/4HANA. It reads from 1 data source (P_CNTRLPROCMTJOBMNTR) and exposes 15 fields with key field ApplicationJobName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CNTRLPROCMTJOBMNTR P_CNTRLPROCMTJOBMNTR from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProcmtHubSourceJobXtrctn _ProcmtHubSourceJobXtrctn $projection.MMApplicationArea = _ProcmtHubSourceJobXtrctn.MMApplicationArea
[0..1] C_ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH $projection.ProcmtHubBackendBusSyst = _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCNTRLPRCJOBMNTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Procurement Job Monitor view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
UI.headerInfo.typeName Central Procurement Job view
UI.headerInfo.typeNamePlural Central Procurement Jobs view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ApplicationJobName ApplicationJobName Job Name
ApplicationJob ApplicationJob Job ID
ApplicationJobStatusText ApplicationJobStatusText
ProcmtHubJobIsInitialLoad ProcmtHubJobIsInitialLoad Import Type
ApplicationJobParameter ApplicationJobParameter
MMApplicationArea MMApplicationArea Extraction Type
ProcmtHubBackendBusSyst ProcmtHubBackendBusSyst On Connected System
ProcurementHubSourceSystemName _ProcmtHubBackendSrceSystemVH ProcurementHubSourceSystemName Connected Sys Name
ApplicationJobStartDateTime ApplicationJobStartDateTime Time Since Job Failed
CreationDateTime ApplicationJobStartDateTime Creation Date
ApplicationJobDescription ApplicationJobDescription Job Description
IsDismissed IsDismissed Boolean Variable (X = True, - = False, Space = Unknown)
JobIsRestarted
_ProcmtHubSourceJobXtrctn _ProcmtHubSourceJobXtrctn
_ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH

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 C_CntrlProcmtJobMntr.
-- 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: CCNTRLPRCJOBMNTR

CREATE VIEW C_CntrlProcmtJobMntr AS
SELECT
  ApplicationJobName,
  ApplicationJob,
  ApplicationJobStatusText,
  ProcmtHubJobIsInitialLoad,
  ApplicationJobParameter,
  MMApplicationArea,
  ProcmtHubBackendBusSyst,
  _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
  ApplicationJobStartDateTime,
  ApplicationJobStartDateTime AS CreationDateTime,
  ApplicationJobDescription,
  IsDismissed,
  cast ('' as abap.char( 1 )) AS JobIsRestarted
FROM P_CNTRLPROCMTJOBMNTR
LEFT OUTER JOIN I_ProcmtHubSourceJobXtrctn AS _ProcmtHubSourceJobXtrctn ON MMApplicationArea = _ProcmtHubSourceJobXtrctn.MMApplicationArea  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _ProcmtHubBackendSrceSystemVH ON ProcmtHubBackendBusSyst = _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem  -- association [0..1]
;

Learn More