P_CNTRLPROCMTJOBMNTR

DDL: P_CNTRLPROCMTJOBMNTR SQL: PCNTRLPRCJOBMNTR Type: view CONSUMPTION
19 Fields 2 Data Sources

Central Procurement Job Monitor

P_CNTRLPROCMTJOBMNTR is a Consumption CDS View that provides data about "Central Procurement Job Monitor" in SAP S/4HANA. It reads from 2 data sources (P_APPL_JOB_RUN_DET, I_CtlgItmExtractionJobDets) and exposes 19 fields with key field ApplicationJobName.

Data Sources (2)

SourceAliasJoin Type
P_APPL_JOB_RUN_DET _ApplicationJobs left_outer
I_CtlgItmExtractionJobDets _CtlgItmExtractionJobDets from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRLPRCJOBMNTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Central Procurement Job Monitor view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ApplicationJobName I_CtlgItmExtractionJobDets ApplicationJobName Job Name
ApplicationJob I_CtlgItmExtractionJobDets ApplicationJob Job No.
ProcmtHubPlant ProcmtHubPlant Plant
ProcmtHubCompanyCode ProcmtHubCompanyCode Company Code
ApplicationJobStatusText ApplicationJobStatusText Workflow Status
PurchasingCentralMaterial PurchasingCentralMaterial Material
MaterialGroup MaterialGroup Product Group
ProcmtHubMaterialGroup ProcmtHubMaterialGroup Material Group
ProcmtHubJobIsInitialLoad ProcmtHubJobIsInitialLoad Boolean Variable (X = True, - = False, Space = Unknown)
ApplicationJobEndDateTime ApplicationJobEndDateTime Ended On
ProcmtHubCreatedByUser ProcmtHubCreatedByUser Entered By
ApplicationJobParameter ApplicationJobParameter Import Parameters
MMApplicationArea MMApplicationArea Application that triggered extraction job in procurement hub
ProcmtHubJobIsDeltaRelevant ProcmtHubJobIsDeltaRelevant TRUE
ProcmtHubBackendBusSyst ProcmtHubBackendBusSyst Connected System ID
ProcmtHubProduct ProcmtHubProduct Material
IsDismissed IsDismissed Boolean Variable (X = True, - = False, Space = Unknown)
ApplicationJobStartDateTime P_APPL_JOB_RUN_DET ApplicationJobStartDateTime Started On
ApplicationJobDescription P_APPL_JOB_RUN_DET ApplicationJobDescription External 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 P_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: PCNTRLPRCJOBMNTR

CREATE VIEW P_CNTRLPROCMTJOBMNTR AS
SELECT
  _CtlgItmExtractionJobDets.ApplicationJobName AS ApplicationJobName,
  _CtlgItmExtractionJobDets.ApplicationJob AS ApplicationJob,
  ProcmtHubPlant,
  ProcmtHubCompanyCode,
  ApplicationJobStatusText,
  PurchasingCentralMaterial,
  MaterialGroup,
  ProcmtHubMaterialGroup,
  ProcmtHubJobIsInitialLoad,
  ApplicationJobEndDateTime,
  ProcmtHubCreatedByUser,
  ApplicationJobParameter,
  MMApplicationArea,
  ProcmtHubJobIsDeltaRelevant,
  ProcmtHubBackendBusSyst,
  ProcmtHubProduct,
  IsDismissed,
  _ApplicationJobs.ApplicationJobStartDateTime AS ApplicationJobStartDateTime,
  _ApplicationJobs.ApplicationJobDescription AS ApplicationJobDescription
FROM I_CtlgItmExtractionJobDets AS _CtlgItmExtractionJobDets
LEFT OUTER JOIN P_APPL_JOB_RUN_DET AS _ApplicationJobs ON /* join condition not captured in parsed metadata */
;

Learn More