C_PurchaseReqnWorkItem

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_PurchaseReqnWorkItem.
-- 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: CPRWI

CREATE VIEW C_PurchaseReqnWorkItem AS
SELECT
  WorkflowTaskInternalID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  TechnicalWrkflwObjectType,
  _WorkItemPurReqnHdrDetailTP.PurReqnDescription AS PurReqnDescription,
  PurReqnItmWrkflwApprvlIsActv,
  PurReqnHdrWrkflwApprovalIsActv,
  PurReqnWrkflwIsChanged,
  PurReqnWrkflwIsRestartRqd,
  cast ( ('') as boolean ) AS IsEditable,
  cast ( '' as abap.char(10) ) AS WorkflowScenarioDefinition,
  cast ( ('') as boolean ) AS PurReqnReworkIsAllowed,
  AccountAssignmentIsAddable,
  WorkflowTaskRecipient,
  cast ( 0 as abap.int1 ) AS NmbrOfPurReqnWrkItmAttachments,
  cast ( 0 as abap.int1 ) AS NmbrOfPurReqnWorkItemNotes,
  cast ( ('') as boolean ) AS PurReqnIsLimitItemSupported,
  cast ( ('') as boolean ) AS PurReqnIsStandardItemSupported,
  cast ( ('') as boolean ) AS PurReqnApprovalIsNotAllowed,
  _WorkItemPurReqnItemDetailTP.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID
FROM I_PurchaseReqnWorkItemTP
LEFT OUTER JOIN C_WorkItemPurReqnHdrDetail AS _WorkItemPurReqnHdrDetailTP ON _WorkItemPurReqnHdrDetailTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _WorkItemPurReqnHdrDetailTP.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_WorkItemPurReqnItemDetail AS _WorkItemPurReqnItemDetailTP ON _WorkItemPurReqnItemDetailTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _WorkItemPurReqnItemDetailTP.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_WorkItemPurReqnHdrItemDetail AS _WrkItmPurReqnHdrItemDetailTP ON _WrkItmPurReqnHdrItemDetailTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisition = PurchaseRequisition  -- association [1..*]
LEFT OUTER JOIN C_PurReqnItemDeliveryAddress AS _PurReqnItemDeliveryAddress ON _PurReqnItemDeliveryAddress.PurchaseRequisition = PurchaseRequisition AND _PurReqnItemDeliveryAddress.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurReqnAcctAssignmentWrkItm AS _PurReqnAcctAssgmtWrkItmTP ON _PurReqnAcctAssgmtWrkItmTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurReqnAcctAssgmtWrkItmTP.PurchaseRequisition = PurchaseRequisition  -- association [1..*]
LEFT OUTER JOIN C_WrkItmPurRequisitionText AS _WrkItmPurReqnPrTxtTP ON _WrkItmPurReqnPrTxtTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _WrkItmPurReqnPrTxtTP.PurchaseRequisition = PurchaseRequisition  -- association [0..*]
LEFT OUTER JOIN C_WrkItmPurRequisitionHdrText AS _WrkItmPurReqnHdrTxtTP ON _WrkItmPurReqnHdrTxtTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _WrkItmPurReqnHdrTxtTP.PurchaseRequisition = PurchaseRequisition  -- association [0..*]
;