C_PurchaseReqnAcctAssgmt

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_PurchaseReqnAcctAssgmt.
-- 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: CPRACCTASSGMT

CREATE VIEW C_PurchaseReqnAcctAssgmt AS
SELECT
  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.PurReqnNetAmount AS PurReqnNetAmount,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  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,
  _GrantStdVH._Text[1:Language = $session.system_language].GrantName AS GrantName,
  Document.ValidityDate AS ValidityDate,
  Document.ChartOfAccounts AS ChartOfAccounts,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FundedProgram AS FundedProgram,
  Document.NetworkActivity AS NetworkActivity,
  Document.PurReqnNetworkActivityForDsp AS PurReqnNetworkActivityForDsp,
  cast( '' as ps_s4_ltxa1 ) AS NetworkActivityDescription,
  Document.CompanyCode AS CompanyCode,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  Document._BusinessArea AS _BusinessArea,
  Document._BusinessAreaText AS _BusinessAreaText,
  Document._FunctionalArea AS _FunctionalArea,
  Document._FunctionalAreaText AS _FunctionalAreaText
FROM T_PurchaseReqnAcctAssgmt AS Document
LEFT OUTER JOIN C_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
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_ProfitCenterValueHelp AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate <= _ProfitCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderValueHelp AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_MM_WBSElementByIntKeyVH AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MM_WBSElementByIntKeyVH AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_MM_CommitmentItemVH AS _CommitmentItem ON CommitmentItem = _CommitmentItem.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_MM_LogisticsOrderVH AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MM_ControllingAreaVH AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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_FundStdVH AS _FundStdVH ON _FundStdVH.Fund = Fund AND _FundStdVH.FinancialManagementArea = financialmanagementarea  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON _FundsCenterStdVH.FundsCenter = FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemStdVH AS _CommitmentItemStdVH ON _CommitmentItemStdVH.CommitmentItem = CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_FndsMgmtFuncnlAreaStdVH AS _FndsMgmtFuncnlAreaStdVH ON _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_MM_NetworkActivityVH AS _NetworkActivityVH ON ProjectNetwork = _NetworkActivityVH.ProjectNetwork AND NetworkActivity = _NetworkActivityVH.NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON GrantID = _GrantStdVH.GrantID  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
;