R_PPS_PurchaseReqnAcctAssgmtTP

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 R_PPS_PurchaseReqnAcctAssgmtTP.
-- 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.

CREATE VIEW R_PPS_PurchaseReqnAcctAssgmtTP AS
SELECT
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbr,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.Quantity AS Quantity,
  Document.BaseUnit AS BaseUnit,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  cast ( Document.PurReqnItemCurrency as pps_e_pr_item_currency preserving type ) AS PurReqnItemCurrency,
  Document.PurReqnNetAmount AS PurReqnNetAmount,
  Document.IsDeleted AS IsDeleted,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SalesOrder AS SalesOrder,
  Document.SalesOrderItem AS SalesOrderItem,
  Document.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  Document.FixedAsset AS FixedAsset,
  Document.OrderID AS OrderID,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  cast( Document.ProfitabilitySegment as rkeobjnr_char ) AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  Document.WBSElementInternalID_2 AS WBSElementInternalID,
  cast ( Document.WBSElementExternalID_2 as pps_e_pr_wbs_ext_id preserving type ) AS WBSElementExternalID,
  cast( Document.WBSElement as ps_posid_edit preserving type ) AS WBSElement,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast( Document.CommitmentItemShortID as fm_fipex ) AS CommitmentItem,
  Document.CommitmentItemShortID AS CommitmentItemShortID,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.CreationDate AS CreationDate,
  Document.GoodsRecipientName AS GoodsRecipientName,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  cast ( Document.NetworkActivityInternalID as pps_e_pr_internal_id preserving type ) AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  Document.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  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.Plant AS Plant,
  Document.BudgetPeriod AS BudgetPeriod,
  cast (' ' as ps_s4_vornr) AS NetworkActivity,
  CompanyCode,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  Document.PubSecSplitBatchNumberID AS PubSecSplitBatchNumberID,
  Document.PubSecSplitAuthznGroup AS PubSecSplitAuthznGroup,
  _AccAssignmentExtension.PPSAccountAssignmentIsUnfunded AS PPSAccountAssignmentIsUnfunded,
  _AccAssignmentExtension.PPSPurReqnNetAmount AS PPSPurReqnNetAmount,
  _AccAssignmentExtension.PPSPurReqnNetAmountCurrency AS PPSPurReqnNetAmountCurrency,
  _AccAssignmentExtension.PPSAcctAsgtRefNmbr AS PPSAcctAsgtRefNmbr,
  _AccAssignmentExtension.PPSAcctAsgtSublineItmNmbr AS PPSAcctAsgtSublineItmNmbr
FROM R_PPS_PurchaseReqnAcctAssgmt AS Document
LEFT OUTER JOIN R_PPS_PurchaseReqnTP AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON _BudgetPeriodText.BudgetPeriod = BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurReqnAcctAssgmtExtn AS _AccAssignmentExtension ON _AccAssignmentExtension.PurchaseRequisition = PurchaseRequisition AND _AccAssignmentExtension.PurchaseRequisitionItem = PurchaseRequisitionItem AND _AccAssignmentExtension.PPSPurgDocAcctAssgmtNumber = PurReqnAcctAssgmtNmbr  -- association [1..1]
LEFT OUTER JOIN I_FundsCenterText AS _FundsCenterText ON _FundsCenterText.Language = $session.system_language AND _FundsCenterText.FundsCenter = FundsCenter AND _FundsCenterText.FinancialManagementArea = FinancialManagementArea AND _FundsCenterText.ValidityStartDate <= $session.system_date AND _FundsCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.CostCenter = CostCenter AND _CostCenterText.ControllingArea = ControllingArea AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON FixedAsset = _FixedAsset.FixedAsset AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND CompanyCode = _FixedAsset.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FuncnlAreaText ON FunctionalArea = _FuncnlAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFundsDocumentMMVH AS _EarmarkedFundsDocumentMMVH ON EarmarkedFundsDocument = _EarmarkedFundsDocumentMMVH.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN E_Purreqnacctassgmt AS _PurReqnAcctAssgmtExtension ON PurchaseRequisition = _PurReqnAcctAssgmtExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmtExtension.PurchaseRequisitionItem AND PurReqnAcctAssgmtNmbr = _PurReqnAcctAssgmtExtension.PurchaseReqnAcctAssgmtNumber  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemText ON CommitmentItemShortID = _CommitmentItemText.CommitmentItem AND FinancialManagementArea = _CommitmentItemText.FinancialManagementArea AND _CommitmentItemText.FinMgmtAreaFiscalYear = '0000' AND _CommitmentItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND CompanyCode = _GLAccountText.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;