I_PurReqnHdrItmAcAsWrkItm

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_PurReqnHdrItmAcAsWrkItm.
-- 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: IPRHDITACTWRKITM

CREATE VIEW I_PurReqnHdrItmAcAsWrkItm AS
SELECT
  _PurchaseRequisitionWorkItem.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseReqnAcctAssgmtNumber AS PurReqnAcctAssgmtNmbr,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  IsDeleted,
  SDDocument,
  CostElement,
  BusinessArea,
  SalesOrder,
  SalesDocumentItem,
  SalesOrderScheduleLine,
  SalesOrderItem,
  ScheduleLine,
  FixedAsset,
  ControllingArea,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementInternalID_2,
  WBSElement,
  WBSElementExternalID_2,
  cast(CommitmentItemShortID as fipos) AS CommitmentItem,
  FundsCenter,
  Fund,
  ProcessOrder,
  ProfitabilitySegment,
  CostObject,
  UnloadingPointName,
  FunctionalArea,
  OrderID,
  CreationDate,
  ProjectNetworkInternalID,
  _PurchaseReqnItem.BaseUnit AS BaseUnit,
  _PurchaseReqnItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  GoodsRecipientName,
  RealEstateObject,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  ValidityDate,
  ChartOfAccounts,
  BudgetPeriod,
  cast (' ' as fm_measure) AS FundedProgram,
  GLAccount,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  PurReqnNetAmount
FROM I_PurReqnAcctAssgmt AS _PurchaseReqnAcctAssgmt
LEFT OUTER JOIN I_PurchaseReqnHeaderWorkItem AS _PurchaseRequisitionWorkItem ON PurchaseRequisition = _PurchaseRequisitionWorkItem.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_WorkItemPurReqnHdrItemDetail AS _WorkItemPurReqnHdrItemDetail ON PurchaseRequisition = _WorkItemPurReqnHdrItemDetail.PurchaseRequisition AND PurchaseRequisitionItem = _WorkItemPurReqnHdrItemDetail.PurchaseRequisitionItem AND workflowtaskinternalid = _WorkItemPurReqnHdrItemDetail.WorkflowTaskInternalID  -- association [1..1]
LEFT OUTER JOIN I_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON CommitmentItem = _CommitmentItem.CommitmentItem  -- association [0..*]
;