C_PurReqnAccountAssignment

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_PurReqnAccountAssignment.
-- 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: CPURREQNACCTA

CREATE VIEW C_PurReqnAccountAssignment AS
SELECT
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  I_PurReqnAcctAssgmt.CostCenter AS CostCenter,
  I_PurReqnAcctAssgmt.MasterFixedAsset AS MasterFixedAsset,
  _Purchaserequisitionitem.CompanyCode AS CompanyCode,
  I_PurReqnAcctAssgmt.IsDeleted AS IsDeleted,
  I_PurReqnAcctAssgmt.GLAccount AS GLAccount,
  I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent AS PurReqnAcctAssgmtDistrPct,
  _Purchaserequisitionitem.BaseUnit AS BaseUnit,
  ProjectNetwork,
  I_PurReqnAcctAssgmt.Quantity AS Quantity,
  _Purchaserequisitionitem.BaseUnit AS UnitOfMeasure,
  I_PurReqnAcctAssgmt.ControllingArea AS ControllingArea,
  I_PurReqnAcctAssgmt.BusinessArea AS BusinessArea,
  I_PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  I_PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  I_PurReqnAcctAssgmt.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_PurReqnAcctAssgmt.FixedAsset AS FixedAsset,
  I_PurReqnAcctAssgmt.ProcessOrder AS ProcessOrder,
  I_PurReqnAcctAssgmt.OrderID AS OrderID,
  I_PurReqnAcctAssgmt.UnloadingPointName AS UnloadingPointName,
  I_PurReqnAcctAssgmt.CostObject AS CostObject,
  I_PurReqnAcctAssgmt.ProfitabilitySegment AS PrmtHbProfitabilitySegment,
  I_PurReqnAcctAssgmt.ProfitCenter AS ProfitCenter,
  I_PurReqnAcctAssgmt.WBSElementInternalID_2 AS WBSElementInternalID,
  I_PurReqnAcctAssgmt.WBSElementExternalID_2 AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  I_PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurReqnAcctAssgmt.CommitmentItemShortID AS CommitmentItemShortID,
  I_PurReqnAcctAssgmt.FundsCenter AS FundsCenter,
  I_PurReqnAcctAssgmt.Fund AS Fund,
  I_PurReqnAcctAssgmt.FunctionalArea AS FunctionalArea,
  I_PurReqnAcctAssgmt.CreationDate AS CreationDate,
  I_PurReqnAcctAssgmt.GoodsRecipientName AS GoodsRecipientName,
  _REObjectByIntFinNumber.REIdentification AS REIdentification,
  I_PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAcctAssgmt.NetworkActivity AS NetworkActivity,
  I_PurReqnAcctAssgmt.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurReqnAcctAssgmt.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurReqnAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurReqnAcctAssgmt.OrderInternalID AS OrderInternalID,
  I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_PurReqnAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_PurReqnAcctAssgmt.GrantID AS GrantID,
  I_PurReqnAcctAssgmt.ValidityDate AS ValidityDate,
  _GrantStdVH._Text[1:Language = $session.system_language].GrantName AS GrantName,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  I_PurReqnAcctAssgmt.BudgetPeriod AS BudgetPeriod,
  _FundedProgram.FundedProgram AS FundedProgram,
  I_PurReqnAcctAssgmt.ServiceDocID AS ServiceDocID,
  I_PurReqnAcctAssgmt.ServiceDocItemID AS ServiceDocItemID,
  I_PurReqnAcctAssgmt.ServiceDocumentType AS ServiceDocumentType,
  I_PurReqnAcctAssgmt.ProcmtHubWBSElementExternalID AS AssignedWBSElementExternalID,
  I_PurReqnAcctAssgmt.ExtNetworkActivityForPurg AS ExtNetworkActivityForPurg,
  I_PurReqnAcctAssgmt._BusinessArea AS _BusinessArea,
  I_PurReqnAcctAssgmt._BusinessAreaText AS _BusinessAreaText
FROM I_PurReqnAcctAssgmt
LEFT OUTER JOIN I_MM_SalesOrderItemVH AS _SalesOrderItem ON _SalesOrderItem.SalesOrder = SalesOrder AND _SalesOrderItem.SalesOrderItem = SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityDate <= _CostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_MM_FixedAssetValueHelp AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset AND companycode = _FixedAsset.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND companycode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _Purchaserequisitionitem ON PurchaseRequisition = _Purchaserequisitionitem.PurchaseRequisition AND PurchaseRequisitionItem = _Purchaserequisitionitem.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_MM_LogisticsOrderVH AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MM_ProfitCenterValueHelp AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate <= _ProfitCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderValueHelp AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON GrantID = _GrantStdVH.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedPgmByPurReqnAcctAssgmt AS _FundedProgram ON PurchaseRequisition = _FundedProgram.PurchaseRequisition AND PurchaseRequisitionItem = _FundedProgram.PurchaseRequisitionItem AND PurchaseReqnAcctAssgmtNumber = _FundedProgram.PurchaseReqnAcctAssgmtNumber  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON companycode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
;