I_MatrixConsolidationReportC

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_MatrixConsolidationReportC.
-- 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_ConsolidationUnitHierarchy : fincs_hryid_consunit, P_ConsolidationPrftCtrHier : fincs_hryid_profitcenter, P_ConsolidationSegmentHier : fincs_hryid_segment, P_KeyDate : vdm_v_key_date

CREATE VIEW I_MatrixConsolidationReportC AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  GLRecordType,
  ConsolidationVersion,
  ConsolidationVersionElement,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  PeriodMode,
  ConsolidationDocumentType,
  DebitCreditCode,
  Company,
  ConsolidationUnit,
  ConsolidationUnitForElim,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  CnsldtnQuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  ConsolidationPrftCtrForElim,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  ConsolidationSegmentForElim,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElementInternalID,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference,
  CnsldtnGroupJrnlEntryBundle,
  :P_ConsolidationUnitHierarchy AS ConsolidationUnitHierarchy,
  :P_ConsolidationSegmentHier AS ConsolidationSegmentHierarchy,
  :P_ConsolidationPrftCtrHier AS ConsolidationPrftCtrHierarchy,
  :P_KeyDate AS KeyDate
FROM I_MatrixCnsldtnFoundation
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension ON ConsolidationLedger = _Extension.ConsolidationLedger AND ConsolidationDimension = _Extension.ConsolidationDimension AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnLedger AS _Ledger ON ConsolidationLedger = _Ledger.ConsolidationLedger  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnDimension AS _Dimension ON ConsolidationDimension = _Dimension.ConsolidationDimension  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _Version ON ConsolidationVersion = _Version.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _VersionElement ON ConsolidationVersionElement = _VersionElement.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_Globalcompany AS _Company ON Company = _Company.Company  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_2 AS _CnsldtnUnit ON ConsolidationDimension = _CnsldtnUnit.ConsolidationDimension AND ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _CnsldtnUnit_3 ON ConsolidationUnit = _CnsldtnUnit_3.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnitForElimination AS _CnsldtnUnitForElimination ON ConsolidationDimension = _CnsldtnUnitForElimination.ConsolidationDimension AND ConsolidationUnitForElim = _CnsldtnUnitForElimination.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroupWithEmptyValue AS _CnsldtnGroup ON ConsolidationDimension = _CnsldtnGroup.ConsolidationDimension AND ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ChartOfAccounts ON ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_GroupReportingFSItem AS _FinStmntItm ON ConsolidationChartOfAccounts = _FinStmntItm.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItm.FinancialStatementItem  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_2 AS _PartnerUnit ON ConsolidationDimension = _PartnerUnit.ConsolidationDimension AND PartnerConsolidationUnit = _PartnerUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _PartnerUnit_3 ON PartnerConsolidationUnit = _PartnerUnit_3.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLAccount AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccounts AS _GLChartOfAccounts ON ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategory AS _SubItemCategory ON SubItemCategory = _SubItemCategory.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItem AS _SubItem ON SubItemCategory = _SubItem.SubItemCategory AND SubItem = _SubItem.SubItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType AS _DocumentType ON ConsolidationDimension = _DocumentType.ConsolidationDimension AND ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnPostingLevel AS _PostingLevel ON PostingLevel = _PostingLevel.PostingLevel  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_2 AS _InvesteeUnit ON ConsolidationDimension = _InvesteeUnit.ConsolidationDimension AND InvesteeConsolidationUnit = _InvesteeUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _InvesteeUnit_3 ON InvesteeConsolidationUnit = _InvesteeUnit_3.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnApportionment AS _Apportionment ON ConsolidationApportionment = _Apportionment.ConsolidationApportionment  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnCrcyCnvrsnDiffType AS _CrcyCnvrsnDiffType ON CurrencyConversionsDiffType = _CrcyCnvrsnDiffType.CurrencyConversionsDiffType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LocalCurrency ON LocalCurrency = _LocalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GroupCurrency ON GroupCurrency = _GroupCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnInternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSupplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterial AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPlant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinTransType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnWBSElement AS _WBSElement ON Project = _WBSElement.Project AND WBSElementExternalID = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProject AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenterForElim AS _ProfitCenterForElim ON ControllingArea = _ProfitCenterForElim.ControllingArea AND ConsolidationPrftCtrForElim = _ProfitCenterForElim.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegmentForElim AS _SegmentForElim ON ConsolidationSegmentForElim = _SegmentForElim.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.Company  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnSegment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBillingType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDivision AS _Division ON OrganizationDivision = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProduct AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterialGroup AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCountry AS _Country ON CustomerSupplierCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnIndustry AS _Industry ON CustomerSupplierIndustry = _Industry.Industry  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocItem AS _AdhocItem ON ConsolidationChartOfAccounts = _AdhocItem.ConsolidationChartOfAccounts AND CnsldtnAdhocItem = _AdhocItem.CnsldtnAdhocItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocSet AS _AdhocSet ON ConsolidationChartOfAccounts = _AdhocSet.ConsolidationChartOfAccounts AND CnsldtnAdhocSet = _AdhocSet.CnsldtnAdhocSet  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocSetItem AS _AdhocSetItem ON ConsolidationChartOfAccounts = _AdhocSetItem.ConsolidationChartOfAccounts AND CnsldtnAdhocSet = _AdhocSetItem.CnsldtnAdhocSet AND CnsldtnAdhocSetItem = _AdhocSetItem.CnsldtnAdhocSetItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitHierDirVH AS _CnsldtnUnitHierDir ON _CnsldtnUnitHierDir.ConsolidationUnitHierarchy = $parameters.P_ConsolidationUnitHierarchy  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnSegmentHierDirVH AS _SegmentHierDir ON _SegmentHierDir.ConsolidationSegmentHierarchy = $parameters.P_ConsolidationSegmentHier  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnProfitCenterHierDirVH AS _ProfitCenterHierDir ON _ProfitCenterHierDir.AdditionalMasterDataHierarchy = $parameters.P_ConsolidationPrftCtrHier  -- association [0..*]
;