I_PurchasingDocSimulationJob

DDL: I_PURCHASINGDOCSIMULATIONJOB SQL: IPURGDOCSIM Type: view BASIC Package: VDM_MM_PUR
24 Fields 1 Data Sources

Purchase Document Simulation Job

I_PurchasingDocSimulationJob is a Basic CDS View that provides data about "Purchase Document Simulation Job" in SAP S/4HANA. It reads from 1 data source (mmpur_massapljob) and exposes 24 fields with key fields SimulationJobUUID, ProcurementHubSourceSystem. Part of development package VDM_MM_PUR.

Data Sources (1)

SourceAliasJoin Type
mmpur_massapljob mmpur_massapljob from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPURGDOCSIM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Purchase Document Simulation Job view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SimulationJobUUID id WorklistID
KEY ProcurementHubSourceSystem procurementhubsourcesystem Connected System ID
ApplicationJob jobcount Job number
ApplicationJobName jobname Name of Send Process
ApplicationLogHandle loghandle LogsHandle
PlannedStartDate plndstrtdt Start Date
PlannedStartTime plndstrttm Start Time
AsyncApplicationJobStatus status Workflow Status
ReleaseDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ApplicationJobDescription jobdesc External ID
CreatedByUser createdby User Name
LogNumber lognumber UUID
PurgDocMassUpdtIsSimulated issimulationjob Is Simulated Job
PurchasingDocumentCategory doccategory Doc. Category
ReferenceApplicationJobName actualrunjobname Job Name
ApplicationJobTemplate job_template_name Job Template Name
ApplicationJobTemplateVersion job_template_version Object Version
PurchasingDocumentSubtype docsubtype Control
NumberOfUniqueErrors numberofuniqueerrors Unique Error Count
NumberOfUniqueWarnings numberofuniquewarnings Unique Warning Count
NumberOfUniqueInfoSuccessMsgs numberofuniqueinfosuccessmsgs Unique Success Info
NumberOfErrorMsgDocuments numberoferrormsgdocuments Document Error Count
NumberOfWarningMsgDocuments numberofwarningmsgdocuments Doc Warning Count
NumberOfInfoSuccessMsgDocs numberofinfosuccessmsgdocs Doc Success Info

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 I_PurchasingDocSimulationJob.
-- 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: IPURGDOCSIM

CREATE VIEW I_PurchasingDocSimulationJob AS
SELECT
  id AS SimulationJobUUID,
  ProcurementHubSourceSystem,
  jobcount AS ApplicationJob,
  jobname AS ApplicationJobName,
  loghandle AS ApplicationLogHandle,
  plndstrtdt AS PlannedStartDate,
  plndstrttm AS PlannedStartTime,
  status AS AsyncApplicationJobStatus,
  timestamp AS ReleaseDateTime,
  jobdesc AS ApplicationJobDescription,
  createdby AS CreatedByUser,
  LogNumber,
  issimulationjob AS PurgDocMassUpdtIsSimulated,
  doccategory AS PurchasingDocumentCategory,
  actualrunjobname AS ReferenceApplicationJobName,
  job_template_name AS ApplicationJobTemplate,
  job_template_version AS ApplicationJobTemplateVersion,
  docsubtype AS PurchasingDocumentSubtype,
  NumberOfUniqueErrors,
  NumberOfUniqueWarnings,
  NumberOfUniqueInfoSuccessMsgs,
  NumberOfErrorMsgDocuments,
  NumberOfWarningMsgDocuments,
  NumberOfInfoSuccessMsgDocs
FROM mmpur_massapljob
;

Learn More