P_DocToWorkitem

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_DocToWorkitem.
-- 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: PDOCWFITM

CREATE VIEW P_DocToWorkitem AS
SELECT
  _doc.CompanyCode AS CompanyCode,
  _doc.AccountingDocument AS AccountingDocument,
  _doc.FiscalYear AS FiscalYear,
  _latestWorkflow.Workflow AS Workflow,
  _latestTask.WorkItem AS WorkItem,
  _doc.AccountingDocumentType AS AccountingDocumentType,
  _doc.ReferenceDocument AS ReferenceDocument,
  _doc.DocumentDate AS DocumentDate,
  _doc.FiscalPeriod AS FiscalPeriod,
  _doc.LastChangeDate AS LastChangeDate,
  _doc.LedgerGroup AS LedgerGroup,
  _doc.HeaderDescription AS HeaderDescription,
  _doc.PostingDate AS PostingDate,
  _doc.CreatedByUser AS CreatedByUser,
  _doc.CreationDateTime AS CreationDateTime,
  _doc.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _doc.ObjectKey AS ObjectKey,
  _doc.TransactionCode AS TransactionCode,
  _doc.ParkingTransactionCode AS ParkingTransactionCode,
  _doc.Currency AS Currency,
  _doc.CompanyCodeCurrency AS CompanyCodeCurrency,
  _doc.GlobalCurrency AS GlobalCurrency,
  _doc.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _doc.AccountingDocumentCategory AS AccountingDocumentCategory,
  _doc.ParkedByUser AS ParkedByUser,
  _doc.Batch AS Batch,
  _doc.IntercompanyTransaction AS IntercompanyTransaction,
  _doc.ReversalReason AS ReversalReason,
  _doc.PlannedReversalDate AS PlannedReversalDate,
  _latestWorkflow.ReleaseDateTime AS ReleaseDateTime,
  _latestTask.WorkflowTaskType AS WorkflowTaskType,
  _latestTask.WorkflowTaskPriority AS WorkflowTaskPriority,
  _latestTask.TaskProcessingStatus AS WorkflowTaskStatus,
  _latestWorkflow.JournalEntryWorkflowStatus AS JournalEntryWorkflowStatus,
  _latestTask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  _WorkflowDecisionStatus.AccountingDocumentStatus AS AccountingDocumentStatus
FROM I_DocWithWorkflowStatus AS _doc
LEFT OUTER JOIN I_WorkflowDecisionStatus AS _WorkflowDecisionStatus ON Workflow = _WorkflowDecisionStatus.Workflow AND _WorkflowDecisionStatus.AccountingDocumentStatus <> 'N'  -- association [0..1]
;