P_MatrixCnsldtnFoundation

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 P_MatrixCnsldtnFoundation.
-- 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.
-- SQL view name: PMCFNDN
-- Parameters: P_ConsolidationUnitHierarchy : fincs_hryid, P_ConsolidationPrftCtrHier : fincs_hryid, P_ConsolidationSegmentHier : fincs_hryid, P_KeyDate : sydate

CREATE VIEW P_MatrixCnsldtnFoundation AS
SELECT
  rldnr AS ConsolidationLedger,
  rdimen AS ConsolidationDimension,
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  rcongr AS ConsolidationGroup,
  poper AS FiscalPeriod,
  period_mode AS PeriodMode,
  year_period AS FiscalYearPeriod,
  cast ('K4' as fis_periv) AS FiscalYearVariant,
  poper_posting AS PostingFiscalPeriod,
  cast (rrcty as fincs_rrcty preserving type ) AS GLRecordType,
  cast (rvers as fincs_vers_elem preserving type ) AS ConsolidationVersionElement,
  ref_version AS ConsolidationVersion,
  rtcur AS TransactionCurrency,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  runit AS BaseUnit,
  docct AS DocumentCategory,
  docty AS ConsolidationDocumentType,
  drcrk AS DebitCreditCode,
  rcomp AS Company,
  rbunit AS ConsolidationUnit,
  rbunit_eliminated AS ConsolidationUnitForElim,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  rbuptr AS PartnerConsolidationUnit,
  robukrs AS CompanyCode,
  sityp AS SubItemCategory,
  subit AS SubItem,
  plevl AS PostingLevel,
  rpflg AS ConsolidationApportionment,
  rtflg AS CurrencyConversionsDiffType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  coicu AS InvesteeConsolidationUnit,
  tsl AS AmountInTransactionCurrency,
  hsl AS AmountInLocalCurrency,
  ksl AS AmountInGroupCurrency,
  msl AS QuantityInBaseUnit,
  sgtxt AS DocumentItemText,
  autom AS ConsolidationPostgItemAutoFlag,
  activ AS BusinessTransactionType,
  budat AS PostingDate,
  wsdat AS CurrencyTranslationDate,
  refdocnr AS RefConsolidationDocumentNumber,
  refryear AS ReferenceFiscalYear,
  refdocln AS RefConsolidationPostingItem,
  refdocct AS RefConsolidationDocumentType,
  refactiv AS RefBusinessTransactionType,
  timestamp AS CreationDateTime,
  cpudt AS CreationDate,
  cputm AS CreationTime,
  usnam AS UserID,
  rvsdocnr AS ReverseDocument,
  orndocnr AS ReversedDocument,
  coiac AS InvestmentActivityType,
  coinr AS InvestmentActivity,
  revyear AS ConsolidationDocReversalYear,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  logsys AS LogicalSystem,
  ktopl AS ChartOfAccounts,
  racct AS GLAccount,
  zuonr AS AssignmentReference,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  prctr_eliminated AS ConsolidationPrftCtrForElim,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  segment_eliminated AS ConsolidationSegmentForElim,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  cast ( ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  ps_posid AS WBSElementExternalID,
  ps_pspid AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldMaterial,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  CnsldtnJrnlEntryItemOrigin,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  rldnr_fin AS Ledger,
  adhocitem AS CnsldtnAdhocItem,
  adhocset AS CnsldtnAdhocSet,
  adhocsetitem AS CnsldtnAdhocSetItem,
  rcode AS MatchingReasonCode,
  orig_type AS OriginType,
  orig_ref AS OriginReference
FROM P_MJEL_CnsldtnFoundation
INNER JOIN I_CnsldtnVersion AS CnsldtnVersion ON /* join condition not captured in parsed metadata */
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_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_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_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_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]
;