C_MatrixCnsldtnJrnlEntr

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 C_MatrixCnsldtnJrnlEntr.
-- 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: CMXJRNLENTR
-- Parameters: P_ConsolidationUnitHierarchy : fincs_hryid, P_ConsolidationPrftCtrHier : fincs_hryid, P_ConsolidationSegmentHier : fincs_hryid, P_KeyDate : sydate

CREATE VIEW C_MatrixCnsldtnJrnlEntr 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,
  ConsolidationGroup,
  FiscalPeriod,
  PeriodMode,
  ReferenceFiscalYear,
  CompanyCode,
  _GroupText.ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
  _PeriodModeText.PeriodModeText AS PeriodModeText,
  GLRecordType,
  ConsolidationVersion,
  _VersionText.ConsolidationVersionText AS ConsolidationVersionText,
  ConsolidationVersionElement,
  _VersionElementDescription.ConsolidationVersionText AS CnsldtnVersionElementDesc,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  cast(FiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod,
  FiscalYearVariant,
  PostingFiscalPeriod,
  DocumentCategory,
  ConsolidationDocumentType,
  _DocumentTypeText.ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  DebitCreditCode,
  Company,
  ConsolidationUnit,
  _CnsldtnUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationUnitForElim,
  ConsolidationChartOfAccounts,
  _ChartOfAccountsText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FinancialStatementItemText.CnsldtnFSItemMediumText AS FinancialStatementItemMdmText,
  PartnerConsolidationUnit,
  _PartnerUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  SubItemCategory,
  SubItem,
  PostingLevel,
  _PostingLevelText.PostingLevelText AS PostingLevelText,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  _CostCenterText.AdditionalMasterDataText AS CostCenterName,
  ProfitCenter,
  _ProfitCenterText.AdditionalMasterDataText AS ProfitCenterName,
  ConsolidationPrftCtrForElim,
  FunctionalArea,
  _FunctionalAreaText.AdditionalMasterDataText AS FunctionalAreaName,
  BusinessArea,
  _BusinessAreaText.AdditionalMasterDataText AS BusinessAreaName,
  ControllingArea,
  _ControllingAreaText.AdditionalMasterDataText AS ControllingAreaName,
  Segment,
  _SegmentText.AdditionalMasterDataText AS SegmentName,
  ConsolidationSegmentForElim,
  PartnerCostCenter,
  _PartnerCostCenterText.AdditionalMasterDataText AS PartnerCostCenterName,
  PartnerProfitCenter,
  _PartnerProfitCenterText.AdditionalMasterDataText AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  _PartnerFunctionalAreaText.AdditionalMasterDataText AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  _PartnerBusinessAreaText.AdditionalMasterDataText AS PartnerBusinessAreaName,
  PartnerCompany,
  PartnerSegment,
  _PartnerSegmentText.AdditionalMasterDataText AS PartnerSegmentName,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  FinancialTransactionType,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnJrnlEntryItemOrigin,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference,
  _AdhocItemText[1:Language = $session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
  _AdhocSetText[1:Language = $session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText
FROM I_MatrixCnsldtnJrnlEntr
LEFT OUTER JOIN I_CnsldtnGroupT_2 AS _GroupText ON ConsolidationGroup = _GroupText.ConsolidationGroup AND _GroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnVersionT AS _VersionText ON ConsolidationVersion = _VersionText.ConsolidationVersion AND _VersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnVersionT AS _VersionElementDescription ON ConsolidationVersionElement = _VersionElementDescription.ConsolidationVersion AND _VersionElementDescription.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPeriodModeText AS _PeriodModeText ON PeriodMode = _PeriodModeText.PeriodMode AND _PeriodModeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitForEliminationT AS _CnsldtnUnitEliminatedText ON ConsolidationDimension = _CnsldtnUnitEliminatedText.ConsolidationDimension AND ConsolidationUnitForElim = _CnsldtnUnitEliminatedText.ConsolidationUnit AND _CnsldtnUnitEliminatedText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _CnsldtnUnitText ON ConsolidationUnit = _CnsldtnUnitText.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _PartnerUnitText ON PartnerConsolidationUnit = _PartnerUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnControllingAreaT AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea AND _ControllingAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenterForElimT AS _ProfitCenterEliminatedT ON ControllingArea = _ProfitCenterEliminatedT.ControllingArea AND ConsolidationPrftCtrForElim = _ProfitCenterEliminatedT.ProfitCenter AND _ProfitCenterEliminatedT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenterT AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenterT AS _PartnerProfitCenterText ON ControllingArea = _PartnerProfitCenterText.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenterText.ProfitCenter AND _PartnerProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenterT AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenterT AS _PartnerCostCenterText ON ControllingArea = _PartnerCostCenterText.ControllingArea AND CostCenter = _PartnerCostCenterText.CostCenter AND _PartnerCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegmentForElimT_2 AS _CnsldtnSegmentEliminatedT ON ConsolidationSegmentForElim = _CnsldtnSegmentEliminatedT.Segment AND _CnsldtnSegmentEliminatedT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegmentT AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegmentT AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment AND _PartnerSegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _ChartOfAccountsText ON ConsolidationChartOfAccounts = _ChartOfAccountsText.ConsolidationChartOfAccounts AND _ChartOfAccountsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemText_2 AS _FinancialStatementItemText ON ConsolidationChartOfAccounts = _FinancialStatementItemText.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinancialStatementItemText.CnsldtnFinancialStatementItem AND _FinancialStatementItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentTypeText_2 AS _DocumentTypeText ON ConsolidationDocumentType = _DocumentTypeText.ConsolidationDocumentType AND _DocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPostingLevelText_2 AS _PostingLevelText ON PostingLevel = _PostingLevelText.PostingLevel AND _PostingLevelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocItemText AS _AdhocItemText ON ConsolidationChartOfAccounts = _AdhocItemText.ConsolidationChartOfAccounts AND CnsldtnAdhocItem = _AdhocItemText.CnsldtnAdhocItem AND _AdhocItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocSetText AS _AdhocSetText ON ConsolidationChartOfAccounts = _AdhocSetText.ConsolidationChartOfAccounts AND CnsldtnAdhocSet = _AdhocSetText.CnsldtnAdhocSet AND _AdhocSetText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalAreaT AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalAreaT AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea AND _PartnerFunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessAreaT AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessAreaT AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
;