I_USFedPrptPaytInvcStsCube

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_USFedPrptPaytInvcStsCube.
-- 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_USFedPrptPaytInvcStsCube AS
SELECT
  _UniversalJournal.CompanyCode AS CompanyCode,
  _UniversalJournal.SourceLedger AS SourceLedger,
  _UniversalJournal.FiscalYear AS FiscalYear,
  _UniversalJournal.AccountingDocument AS AccountingDocument,
  _UniversalJournal.LedgerGLLineItem AS LedgerGLLineItem,
  _UniversalJournal.GLAccount AS GLAccount,
  _UniversalJournal.AccountingDocumentType AS AccountingDocumentType,
  _UniversalJournal.FiscalYear AS USFedFiscalYearBlank,
  _UniversalJournal.Fund AS Fund,
  _UniversalJournal.FinancialManagementArea AS FinancialManagementArea,
  _UniversalJournal.ChartOfAccounts AS ChartOfAccounts,
  _UniversalJournal.BudgetPeriod AS BudgetPeriod,
  _UniversalJournal.FundsCenter AS FundsCenter,
  _UniversalJournal.FunctionalArea AS FunctionalArea,
  _UniversalJournal.FundedProgram AS FundedProgram,
  _WBS._Project.ProjectExternalID AS ProjectExternalID,
  _UniversalJournal.Supplier AS Supplier,
  _UniversalJournal.ControllingArea AS ControllingArea,
  _UniversalJournal.ProfitCenter AS ProfitCenter,
  _UniversalJournal.Segment AS Segment,
  _UniversalJournal.BusinessArea AS BusinessArea,
  _UniversalJournal.FiscalYearPeriod AS FiscalYearPeriod,
  _UniversalJournal.FiscalYearVariant AS FiscalYearVariant,
  _UniversalJournal.DocumentDate AS DocumentDate,
  _UniversalJournal.PostingDate AS PostingDate,
  _UniversalJournal.ClearingDate AS ClearingDate,
  _UniversalJournal.ClearingJournalEntry AS ClearingJournalEntry,
  _UniversalJournal.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _UniversalJournal.IsOpenItemManaged AS IsOpenItemManaged,
  _UniversalJournal.FinancialAccountType AS FinancialAccountType,
  _OperationalAcctgDoc.DocumentReferenceID AS DocumentReferenceID,
  _OperationalAcctgDoc.InvoiceReceiptDate AS InvoiceReceiptDate,
  _OperationalAcctgDoc.DueCalculationBaseDate AS DueCalculationBaseDate,
  _OperationalAcctgDoc.CashDiscount1Days AS CashDiscount1Days,
  _OperationalAcctgDoc.CashDiscount2Days AS CashDiscount2Days,
  _OperationalAcctgDoc.NetPaymentDays AS NetPaymentDays,
  _OperationalAcctgDoc.CashDiscount1Percent AS CashDiscount1Percent,
  _OperationalAcctgDoc.CashDiscount2Percent AS CashDiscount2Percent,
  _OperationalAcctgDoc.PaymentDueDate AS PaymentDueDate,
  _OperationalAcctgDoc.CashDiscount1DueDate AS CashDiscount1DueDate,
  _OperationalAcctgDoc.CashDiscount2DueDate AS CashDiscount2DueDate,
  _UniversalJournal.AmountInCompanyCodeCurrency * -1 AS AmountInCompanyCodeCurrency,
  _UniversalJournal.CompanyCodeCurrency AS CompanyCodeCurrency,
  _OperationalAcctgDoc.NumberOfInvoices AS NumberOfInvoices,
  _UniversalJournal.Segment AS FndsMgmtRptgSegmentForHier,
  _UniversalJournal.Fund AS FndsMgmtRptgFundForHierarchy,
  _UniversalJournal.GLAccount AS GLAccountForHierarchy,
  _UniversalJournal.FundedProgram AS FndsMgmtRptgFnddPgmForHier,
  _UniversalJournal.ProfitCenter AS FndsMgmtRptgPrftCtrForHier,
  _UniversalJournal.BudgetPeriod AS FndsMgmtRptgBdgtPerdForHier,
  _UniversalJournal.FunctionalArea AS FndsMgmtRptgFctArForHierarchy,
  _UniversalJournal.FundsCenter AS FndsMgmtRptgFndsCtrForHier,
  _UniversalJournal._CompanyCode AS _CompanyCode,
  _UniversalJournal._Ledger AS _Ledger,
  _UniversalJournal._FiscalYear AS _FiscalYear,
  _UniversalJournal._JournalEntry AS _JournalEntry,
  _UniversalJournal._AccountingDocumentType AS _AccountingDocumentType,
  _UniversalJournal._Fund AS _Fund,
  _UniversalJournal._FinancialManagementArea AS _FinancialManagementArea,
  _UniversalJournal._ChartOfAccounts AS _ChartOfAccounts,
  _UniversalJournal._BudgetPeriod AS _BudgetPeriod,
  _UniversalJournal._FundsCenter AS _FundsCenter,
  _UniversalJournal._FunctionalArea AS _FunctionalArea,
  _UniversalJournal._FundedProgram AS _FundedProgram,
  _UniversalJournal._Supplier AS _Supplier,
  _UniversalJournal._ControllingArea AS _ControllingArea,
  _UniversalJournal._ProfitCenter AS _ProfitCenter,
  _UniversalJournal._Segment AS _Segment,
  _UniversalJournal._BusinessArea AS _BusinessArea,
  _UniversalJournal._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  _UniversalJournal._FiscalYearVariant AS _FiscalYearVariant,
  _UniversalJournal._FinancialAccountType AS _FinancialAccountType,
  _UniversalJournal._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts
INNER JOIN I_USFedPrptPaytDoc AS _OperationalAcctgDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalAreaHierarchy ON FndsMgmtRptgFctArForHierarchy = _FunctionalAreaHierarchy.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _SegmentHierarchy ON FndsMgmtRptgSegmentForHier = _SegmentHierarchy.Segment  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _FundHierarchy ON FinancialManagementArea = _FundHierarchy.FinancialManagementArea AND FndsMgmtRptgFundForHierarchy = _FundHierarchy.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgramHierarchy ON FinancialManagementArea = _FundedProgramHierarchy.FinancialManagementArea AND FndsMgmtRptgFnddPgmForHier = _FundedProgramHierarchy.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenterHierarchy ON ControllingArea = _ProfitCenterHierarchy.ControllingArea AND FndsMgmtRptgPrftCtrForHier = _ProfitCenterHierarchy.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriodHierarchy ON FndsMgmtRptgBdgtPerdForHier = _BudgetPeriodHierarchy.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenterHierarchy ON FinancialManagementArea = _FundsCenterHierarchy.FinancialManagementArea AND FndsMgmtRptgFndsCtrForHier = _FundsCenterHierarchy.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountHierarchy ON ChartOfAccounts = _GLAccountHierarchy.ChartOfAccounts AND GLAccountForHierarchy = _GLAccountHierarchy.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND USFedFiscalYearBlank = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBS ON FundedProgram = _WBS.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_USFedProjectBasicDetail AS _Project ON ProjectExternalID = _Project.ProjectExternalID  -- association [0..1]
;