I_USFedAPInvoiceStatusCube

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_USFedAPInvoiceStatusCube.
-- 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.
-- Parameters: P_ClearingStatus : fis_clearingstatusselection

CREATE VIEW I_USFedAPInvoiceStatusCube AS
SELECT
  CompanyCode,
  SourceLedger,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccount,
  AccountingDocumentType,
  _AccDoc.InvoiceReceiptDate AS InvoiceReceiptDate,
  FiscalYear AS USFedFiscalYearBlank,
  Fund,
  FinancialManagementArea,
  ChartOfAccounts,
  BudgetPeriod,
  FundsCenter,
  FunctionalArea,
  FundedProgram,
  _WBS._Project.ProjectExternalID AS USFedProjectIdentifier,
  Supplier,
  _Supplier.OrganizationBPName1 AS OrganizationBPName1,
  ControllingArea,
  ProfitCenter,
  Segment,
  BusinessArea,
  FiscalYearPeriod,
  FiscalYearVariant,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  DocumentDate,
  ClearingDate,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  IsOpenItemManaged,
  FinancialAccountType,
  PostingDate,
  -1 * curr_to_decfloat_amount( AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  Segment AS FndsMgmtRptgSegmentForHier,
  Fund AS FndsMgmtRptgFundForHierarchy,
  GLAccount AS GLAccountForHierarchy,
  FundedProgram AS FndsMgmtRptgFnddPgmForHier,
  ProfitCenter AS FndsMgmtRptgPrftCtrForHier,
  BudgetPeriod AS FndsMgmtRptgBdgtPerdForHier,
  FunctionalArea AS FndsMgmtRptgFctArForHierarchy,
  FundsCenter AS FndsMgmtRptgFndsCtrForHier
FROM I_GLAccountLineItemRawData
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
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 USFedProjectIdentifier = _Project.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccDoc ON CompanyCode = _AccDoc.CompanyCode AND AccountingDocument = _AccDoc.AccountingDocument AND FiscalYear = _AccDoc.FiscalYear  -- association [0..1]
;