I_PPS_PurgDocBudgetOverview

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 I_PPS_PurgDocBudgetOverview.
-- 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 I_PPS_PurgDocBudgetOverview AS
SELECT
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  FundsMgmtAmountType,
  Ledger,
  FinMgmtAreaFiscalYear,
  FundsMgmtSequenceNumber,
  _RefDocCat.DomainText AS ReferenceDocumentCategoryName,
  CashEffectivityFiscalYear,
  FinMgmtAreaPeriod,
  PostingDate,
  FundsMgmtTransactionNumber,
  PPSFndsMgmtCmtmtItmCompltnSts,
  FundsMgmtCmtmtItemIsDeleted,
  TransactionCurrency,
  FinancialManagementArea,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  BusinessArea,
  CompanyCode,
  GLAccount,
  Supplier,
  FundsMgmtValueType,
  BusinessTransactionType,
  IsStatisticalItem,
  FundsManagementStatisticalType,
  FundsMgCarryForwardLevel,
  MaterialDescription,
  FundsMgmtCmtmtCarryFwdStatus,
  FundsMgmtUpdateDate,
  FundsMgmtObjectNumber,
  ProfitCenter,
  CommitmentItemFiscalYear
FROM I_FundsMgmtCmtmtEntryItemBasic AS _PurgDocBudgetOvwBasic
LEFT OUTER JOIN I_MasterDataDomainValueText AS _RefDocCat ON _RefDocCat.Language = $session.system_language AND _RefDocCat.Name = 'FM_REFBTYP' AND _RefDocCat.DomainValue = FundsMgmtRefDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemTxt ON _CommitmentItemTxt.Language = $session.system_language AND _CommitmentItemTxt.FinancialManagementArea = FinancialManagementArea AND _CommitmentItemTxt.CommitmentItem = PostedCommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_MasterDataDomainValueText AS _AmtTypeText ON _AmtTypeText.Language = $session.system_language AND _AmtTypeText.Name = 'FM_BTART' AND _AmtTypeText.DomainValue = FundsMgmtAmountType  -- association [0..1]
LEFT OUTER JOIN I_MasterDataDomainValueText AS _ValueTypeText ON _ValueTypeText.Language = $session.system_language AND _ValueTypeText.Name = 'FM_WRTTP' AND _ValueTypeText.DomainValue = FundsMgmtValueType  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterText AS _FundCtrText ON _FundCtrText.Language = $session.system_language AND _FundCtrText.FinancialManagementArea = FinancialManagementArea AND _FundCtrText.FundsCenter = PostedFundsCenter  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON _FundText.Language = $session.system_language AND _FundText.FinancialManagementArea = FinancialManagementArea AND _FundText.Fund = PostedFund  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.Language = $session.system_language AND _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON _GLAccountText.Language = $session.system_language AND _GLAccountText.ChartOfAccounts = 'INT' AND _GLAccountText.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItemBasic AS _CommitmentItem ON _CommitmentItem.FinancialManagementArea = FinancialManagementArea AND _CommitmentItem.FinMgmtAreaFiscalYear = CashEffectivityFiscalYear AND _CommitmentItem.CommitmentItem = PostedCommitmentItem  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurOrderItemExtension AS _PurOrderItemExtension ON ReferenceDocument = _PurOrderItemExtension.PurchaseOrder AND FundsMgmtReferenceDocumentItem = _PurOrderItemExtension.PurchaseOrderItem AND FundsMgmtRefDocumentCategory = '020'  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurReqnItmExtensionBasic AS _PurReqItemExtension ON ReferenceDocument = _PurReqItemExtension.PurchaseRequisition AND FundsMgmtReferenceDocumentItem = _PurReqItemExtension.PurchaseRequisitionItem AND FundsMgmtRefDocumentCategory = '010'  -- association [0..1]
;