I_MatrixCnsldtnFndnPeriodic

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_MatrixCnsldtnFndnPeriodic.
-- 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_MatrixCnsldtnFndnPeriodic AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  CnsldtnGroupJrnlEntry AS ConsolidationDocumentNumber,
  CnsldtnGroupJrnlEntryItem AS ConsolidationPostingItem,
  ConsolidationGroup,
  FiscalPeriod,
  cast('PER' as fincs_period_mode) AS PeriodMode,
  FiscalYearPeriod,
  FiscalPeriod AS PostingFiscalPeriod,
  GLRecordType,
  ConsolidationVersion AS ConsolidationVersionElement,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  ConsolidationDocumentType,
  cast('' as shkzg preserving type) AS DebitCreditCode,
  Company,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  InvestorConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  CnsldtnQuantityInBaseUnit,
  CnsldtnCstmSignAmtInTransCrcy,
  CnsldtnCstmSignAmtInLoclCrcy,
  CnsldtnCstmSignAmtInGrpCrcy,
  CnsldtnCstmSignQtyInBaseUnit,
  CnsldtnCstmSignLongQtyInBsUnit,
  AmountInTransactionCurrency AS CnsldtnIntSignAmtInTransCrcy,
  AmountInLocalCurrency AS CnsldtnIntSignAmtInLocalCrcy,
  AmountInGroupCurrency AS CnsldtnIntSignAmtInGroupCrcy,
  CnsldtnQuantityInBaseUnit AS CnsldtnIntSignQtyInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  FinancialTransactionType,
  WBSElementInternalID,
  cast(WBSElementExternalID as abap.char( 24 )) AS WBSElementExternalID,
  cast(WBSElementExternalID as abap.char( 24 )) AS WBSElement,
  cast(Project as abap.char( 24 )) AS Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference,
  cast('U' as fincs_jrnl_entry_item_origin) AS CnsldtnJrnlEntryItemOrigin,
  CnsldtnGroupJrnlEntryBundle,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType,
  GHGCategory,
  GHGScope,
  GHGScope2CalculationMethod,
  GHGScope2ContractualInstrument,
  SustainabilityModeOfTransport,
  FinancialManagementArea,
  Fund,
  GrantID,
  CnsldtnCashLedgerChartOfAccts,
  CashLedgerAccount,
  PartnerFund,
  cast( LocalCurrency as fincs_currency preserving type ) AS Currency,
  ConsolidationQuestion,
  ConsolidationPredefinedAnswer,
  ConsolidationFreeTextAnswer
FROM P_CnsldtnGroupJrnlEntrItmEnhcd
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 _VersionElement ON ConsolidationVersionElement = _VersionElement.ConsolidationVersion  -- 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_2 AS _CnsldtnUnit ON ConsolidationDimension = _CnsldtnUnit.ConsolidationDimension AND ConsolidationUnit = _CnsldtnUnit.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_CnsldtnFSItem_2 AS _CnsldtnFSItem_2 ON ConsolidationChartOfAccounts = _CnsldtnFSItem_2.ConsolidationChartOfAccounts AND FinancialStatementItem = _CnsldtnFSItem_2.CnsldtnFinancialStatementItem  -- 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_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_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.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_2 AS _InvestorUnit ON ConsolidationDimension = _InvestorUnit.ConsolidationDimension AND InvestorConsolidationUnit = _InvestorUnit.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 AND WBSElement = _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_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_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_CnsldtnMaterial AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Material  -- 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]
;