C_PurReqnAcctAssignmentWrkItm

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_PurReqnAcctAssignmentWrkItm.
-- 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: CPRACCTASSMTWI

CREATE VIEW C_PurReqnAcctAssignmentWrkItm AS
SELECT
  WorkflowTaskInternalID,
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbr,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurReqnAcctAssgmtNmbrForEdit AS PurReqnAcctAssgmtNmbrForEdit,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.BaseUnit AS BaseUnit,
  Document.Quantity AS Quantity,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  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 AS WBSElementInternalID,
  Document.WBSElement AS WBSElement,
  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,
  Document.RealEstateObject 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.GrantID AS GrantID,
  Document.ValidityDate AS ValidityDate,
  Document.ChartOfAccounts AS ChartOfAccounts,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FundedProgram AS FundedProgram,
  Document.NetworkActivity AS NetworkActivity,
  Document._BusinessArea AS _BusinessArea,
  Document._BusinessAreaText AS _BusinessAreaText,
  Document.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  Document.AccountAssignmentIsAddable AS AccountAssignmentIsAddable,
  Document._FunctionalArea AS _FunctionalArea,
  Document._FunctionalAreaText AS _FunctionalAreaText
FROM I_PurReqnAcctAssgmtWrkItmTP AS Document
LEFT OUTER JOIN C_PurchaseReqnWorkItem AS _PurchaseReqnWorkItem ON _PurchaseReqnWorkItem.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurchaseReqnWorkItem.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_SSPGeneralLedgerAccountVH AS _MM_GLAccountVH ON GLAccount = _MM_GLAccountVH.GLAccount AND ProcurementHubSourceSystem = _MM_GLAccountVH.ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN C_SSPCostCenterVH AS _MM_CostCenterValueHelp ON CostCenter = _MM_CostCenterValueHelp.CostCenter AND ProcurementHubSourceSystem = _MM_CostCenterValueHelp.ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON FundsCenter = _FundsCenterStdVH.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemStdVH AS _CommitmentItemStdVH ON CommitmentItem = _CommitmentItemStdVH.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFundsStdVH AS _EarmarkedFundsStdVH ON EarmarkedFundsDocument = _EarmarkedFundsStdVH.EarmarkedFunds  -- association [0..*]
LEFT OUTER JOIN I_FndsMgmtFuncnlAreaStdVH AS _FndsMgmtFuncnlAreaStdVH ON _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN C_SSPNetworkActivityVH AS _MM_NetworkActivityVH ON ProjectNetwork = _MM_NetworkActivityVH.ProjectNetwork AND NetworkActivity = _MM_NetworkActivityVH.NetworkActivity AND ProcurementHubSourceSystem = _MM_NetworkActivityVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPWrkBrkdwnStrucElementVH AS _MM_WBSElementVH ON WBSElement = _MM_WBSElementVH.WBSElement AND ProcurementHubSourceSystem = _MM_WBSElementVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPLogisticsOrderVH AS _MM_LogisticsOrderVH ON OrderID = _MM_LogisticsOrderVH.OrderID AND ProcurementHubSourceSystem = _MM_LogisticsOrderVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPProjectNetworkVH AS _MM_ProjectNetworkVH ON ProjectNetwork = _MM_ProjectNetworkVH.ProjectNetwork AND ProcurementHubSourceSystem = _MM_ProjectNetworkVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_SSPFixedAssetVH AS _MM_FixedAssetValueHelp ON FixedAsset = _MM_FixedAssetValueHelp.FixedAsset AND MasterFixedAsset = _MM_FixedAssetValueHelp.MasterFixedAsset AND ProcurementHubSourceSystem = _MM_FixedAssetValueHelp.ProcurementHubSourceSystem  -- association [0..*]
;