C_Sspprmaint_Accassign

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_Sspprmaint_Accassign.
-- 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: CSSPPRMAINTACC

CREATE VIEW C_Sspprmaint_Accassign AS
SELECT
  I_PurReqnAccAssignment_WD.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAccAssignment_WD.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAccAssignment_WD.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_PurReqnAccAssignment_WD.CompanyCode AS CompanyCode,
  I_PurReqnAccAssignment_WD.ChartOfAccounts AS ChartOfAccounts,
  I_PurReqnAccAssignment_WD.GLAccount AS GLAccount,
  I_PurReqnAccAssignment_WD.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_PurReqnAccAssignment_WD.Quantity AS Quantity,
  I_PurReqnAccAssignment_WD.PurReqnNetAmount AS PurReqnNetAmount,
  I_PurReqnAccAssignment_WD.BaseUnit AS BaseUnit,
  I_PurReqnAccAssignment_WD.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_PurReqnAccAssignment_WD.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_PurReqnAccAssignment_WD.CostCenter AS CostCenter,
  I_PurReqnAccAssignment_WD.ValidityEndDate AS ValidityEndDate,
  I_PurReqnAccAssignment_WD.MasterFixedAsset AS MasterFixedAsset,
  I_PurReqnAccAssignment_WD.FixedAsset AS FixedAsset,
  I_PurReqnAccAssignment_WD.SDDocument AS SDDocument,
  I_PurReqnAccAssignment_WD.SalesDocumentItem AS SalesDocumentItem,
  I_PurReqnAccAssignment_WD.ScheduleLine AS ScheduleLine,
  I_PurReqnAccAssignment_WD.OrderID AS OrderID,
  I_PurReqnAccAssignment_WD.ProjectNetwork AS ProjectNetwork,
  I_PurReqnAccAssignment_WD.NetworkActivity AS NetworkActivity,
  I_PurReqnAccAssignment_WD.ControllingArea AS ControllingArea,
  I_PurReqnAccAssignment_WD.ProfitCenter AS ProfitCenter,
  I_PurReqnAccAssignment_WD.Fund AS Fund,
  I_PurReqnAccAssignment_WD.FundsCenter AS FundsCenter,
  I_PurReqnAccAssignment_WD.FunctionalArea AS FunctionalArea,
  I_PurReqnAccAssignment_WD.BusinessArea AS BusinessArea,
  I_PurReqnAccAssignment_WD.UnloadingPointName AS UnloadingPointName,
  I_PurReqnAccAssignment_WD.ProfitabilitySegment AS ProfitabilitySegment,
  I_PurReqnAccAssignment_WD.WBSElementInternalID AS WBSElementInternalID,
  I_PurReqnAccAssignment_WD.WBSElement AS WBSElement,
  I_PurReqnAccAssignment_WD.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurReqnAccAssignment_WD.GoodsRecipientName AS GoodsRecipientName,
  I_PurReqnAccAssignment_WD.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAccAssignment_WD.OrderInternalID AS OrderInternalID,
  I_PurReqnAccAssignment_WD.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurReqnAccAssignment_WD.ExtNetworkActivityForPurg AS ExtNetworkActivityForPurg,
  I_PurReqnAccAssignment_WD.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurReqnAccAssignment_WD.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_PurReqnAccAssignment_WD.CostCtrActivityType AS CostCtrActivityType,
  I_PurReqnAccAssignment_WD.BudgetPeriod AS BudgetPeriod,
  I_PurReqnAccAssignment_WD.FundedProgram AS FundedProgram,
  I_PurReqnAccAssignment_WD.CommitmentItem AS CommitmentItem,
  I_PurReqnAccAssignment_WD.BusinessProcess AS BusinessProcess,
  I_PurReqnAccAssignment_WD.GrantID AS GrantID,
  _Purchaserequisition_Wd.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  _Purchaserequisition_Wd.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _Purchaserequisition_Wd.BusinessUser AS BusinessUser
FROM I_PurReqnAccAssignment_WD
LEFT OUTER JOIN C_Sspprmaint_Hdr AS _Purchaserequisition_Wd ON PurchaseRequisition = _Purchaserequisition_Wd.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_Sspprmaint_Itm AS _Purchaserequisitionitem_Wd ON PurchaseRequisition = _Purchaserequisitionitem_Wd.PurchaseRequisition AND PurchaseRequisitionItem = _Purchaserequisitionitem_Wd.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN C_SSPFixedAssetVH AS _MM_FixedAssetValueHelp ON CompanyCode = _MM_FixedAssetValueHelp.CompanyCode AND FixedAsset = _MM_FixedAssetValueHelp.FixedAsset AND MasterFixedAsset = _MM_FixedAssetValueHelp.MasterFixedAsset AND ProcurementHubSourceSystem = _MM_FixedAssetValueHelp.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _MM_WBSElementValueHelp ON WBSElementInternalID = _MM_WBSElementValueHelp.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MM_CommitmentItemVH AS _MM_CommitmentItemVH ON CommitmentItem = _MM_CommitmentItemVH.CommitmentItem  -- association [0..*]
;