I_PurReqnAcctAssgmtWrkItmTP

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_PurReqnAcctAssgmtWrkItmTP.
-- 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: IPRACCTWRKITMWD

CREATE VIEW I_PurReqnAcctAssgmtWrkItmTP AS
SELECT
  _PurchaseReqnWorkItemTP.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbr,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbrForEdit,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.BaseUnit AS BaseUnit,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  Document.Quantity AS Quantity,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.PurReqnNetAmount AS PurReqnNetAmount,
  Document.IsDeleted AS IsDeleted,
  Document.CostElement AS CostElement,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SDDocument AS SDDocument,
  Document.SalesOrder AS SalesOrder,
  Document.SalesDocumentItem AS SalesDocumentItem,
  Document.SalesOrderItem AS SalesOrderItem,
  Document.ScheduleLine AS ScheduleLine,
  Document.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  Document.FixedAsset AS FixedAsset,
  Document.ProcessOrder AS ProcessOrder,
  Document.OrderID AS OrderID,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  Document.ProfitabilitySegment AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  Document.WBSElementInternalID_2 AS WBSElementInternalID_2,
  Document.WBSElementInternalID AS WBSElementInternalID,
  Document.WBSElement AS WBSElement,
  Document.WBSElementExternalID_2 AS WBSElementExternalID_2,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Document.CommitmentItem AS CommitmentItem,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.CreationDate AS CreationDate,
  Document.GoodsRecipientName AS GoodsRecipientName,
  cast ( Document.REInternalFinNumber as imkey ) AS RealEstateObject,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  Document.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  Document.OrderInternalID AS OrderInternalID,
  Document.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.CostCtrActivityType AS CostCtrActivityType,
  Document.BusinessProcess AS BusinessProcess,
  Document.GrantID AS GrantID,
  Document.ValidityDate AS ValidityDate,
  Document.ChartOfAccounts AS ChartOfAccounts,
  cast ('' as bukrs ) AS CompanyCode,
  cast ('' as abap.char(10) ) AS ProcurementHubSourceSystem,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FundedProgram AS FundedProgram,
  cast (' ' as vornr) AS NetworkActivity,
  cast ( ('') as boolean ) AS AccountAssignmentIsAddable
FROM I_PurReqnAcctAssignmentWrkItm AS Document
LEFT OUTER JOIN I_PurchaseReqnWorkItemTP AS _PurchaseReqnWorkItemTP ON _PurchaseReqnWorkItemTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurchaseReqnWorkItemTP.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
;