I_MatrixCnsldtnReportC_2

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_MatrixCnsldtnReportC_2.
-- 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, P_ConsolidationPrftCtrHier : fincs_hryid, P_ConsolidationSegmentHier : fincs_hryid, P_KeyDate : sydate

CREATE VIEW I_MatrixCnsldtnReportC_2 AS
SELECT
  entity: { name: 'I_CnsldtnUnitHierDirVH', element: 'ConsolidationUnitHierarchy' AS P_ConsolidationUnitHierarchy,
  P_ConsolidationPrftCtrHier: $parameters.P_ConsolidationPrftCtrHier AS P_ConsolidationPrftCtrHier,
  P_ConsolidationSegmentHier: $parameters.P_ConsolidationSegmentHier AS P_ConsolidationSegmentHier,
  ConsolidationDimension,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  GLRecordType,
  ConsolidationVersion,
  ConsolidationVersionElement,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  cast( FiscalYearPeriod as fis_jahrper_conv ) AS FiscalYearPeriod,
  FiscalYearVariant,
  PeriodMode,
  ConsolidationDocumentType,
  DebitCreditCode,
  Company,
  cast ( ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ConsolidationUnitForElim,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  cast ( PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  cast ( InvesteeConsolidationUnit as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  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,
  cast( WBSElementExternalID as ps_posid_edit ) AS WBSElementExternalID,
  cast( Project as ps_pspid_edit ) AS Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference
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_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_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_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_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]
;