C_CnsldtnJrnlEntr

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_CnsldtnJrnlEntr.
-- 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: CCNSLDTNJRNLENTR

CREATE VIEW C_CnsldtnJrnlEntr AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ReferenceFiscalYear,
  CompanyCode,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ConsolidationVersion,
  GLRecordType,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  ConsolidationDocumentType,
  DebitCreditCode,
  Company,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  _CostCenterText[1:Language = $session.system_language].AdditionalMasterDataText AS CostCenterName,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  _SegmentText[1:Language = $session.system_language].AdditionalMasterDataText AS SegmentName,
  PartnerCostCenter,
  _PartnerCostCenterText[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerCostCenterName,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  _PartnerBusinessAreaText[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerBusinessAreaName,
  PartnerCompany,
  PartnerSegment,
  _PartnerSegmentText[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerSegmentName,
  OrderID,
  Customer,
  _CustomerText[1:Language = $session.system_language].AdditionalMasterDataText AS CustomerName,
  Supplier,
  _SupplierText[1:Language = $session.system_language].AdditionalMasterDataText AS SupplierName,
  Material,
  Plant,
  FinancialTransactionType,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnJrnlEntryItemOrigin,
  MatchingReasonCode,
  OriginReference,
  OriginType,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  CnsldtnGroupJrnlEntryBundle,
  _AdhocItemText[1:Language = $session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
  _AdhocSetText[1:Language = $session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText,
  _BusinessAreaText.AdditionalMasterDataText AS BusinessAreaName,
  _ChartOfAccountsText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  _CnsldtnUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  _DocumentTypeText.ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  _FinancialStatementItemText.FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  _GLAcctInChartOfAccountsText.GLAccountName AS GLAccountName,
  _GLChartOfAccountsText.ChartOfAccountsName AS ChartOfAccountsName,
  _GroupText.ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
  _InvesteeUnitText.ConsolidationUnitText AS InvesteeConsolidationUnitText,
  _InvestmentActivityTypeText.InvestmentActivityTypeText AS InvestmentActivityTypeText,
  _PartnerProfitCenterText.AdditionalMasterDataText AS PartnerProfitCenterName,
  _PartnerUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  _PostingLevelText.PostingLevelText AS PostingLevelText,
  _ProfitCenterText.AdditionalMasterDataText AS ProfitCenterName,
  _VersionText.ConsolidationVersionText AS ConsolidationVersionText
FROM I_CnsldtnJrnlEntr AS CnsldtnJrnlEntr
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]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _ChartOfAccountsText ON ConsolidationChartOfAccounts = _ChartOfAccountsText.ConsolidationChartOfAccounts AND _ChartOfAccountsText.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 PartnerCostCenter = _PartnerCostCenterText.CostCenter AND _PartnerCostCenterText.Language = $session.system_language  -- 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_CnsldtnCustomerT AS _CustomerText ON Customer = _CustomerText.Customer AND _CustomerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLAccountT_2 AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount AND _GLAcctInChartOfAccountsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnLedgerT AS _LedgerText ON ConsolidationLedger = _LedgerText.ConsolidationLedger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentTypeT AS _DocumentTypeText ON ConsolidationDimension = _DocumentTypeText.ConsolidationDimension AND ConsolidationDocumentType = _DocumentTypeText.ConsolidationDocumentType AND _DocumentTypeText.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_CnsldtnProfitCenterT AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.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_CnsldtnSegmentT AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSupplierT AS _SupplierText ON Supplier = _SupplierText.Supplier AND _SupplierText.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 _InvesteeUnitText ON InvesteeConsolidationUnit = _InvesteeUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvmtEquityActyVH AS _InvestmentActivityTypeText ON InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _PartnerUnitText ON PartnerConsolidationUnit = _PartnerUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode AND _CompanyCodeText.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_CnsldtnPostingLevelText_2 AS _PostingLevelText ON PostingLevel = _PostingLevelText.PostingLevel AND _PostingLevelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _FinancialStatementItemText ON ConsolidationChartOfAccounts = _FinancialStatementItemText.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinancialStatementItemText.FinancialStatementItem AND _FinancialStatementItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroupTextEnhanced AS _GroupText ON ConsolidationGroup = _GroupText.ConsolidationGroup AND ConsolidationDimension = _GroupText.ConsolidationDimension AND _GroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccountsT AS _GLChartOfAccountsText ON ChartOfAccounts = _GLChartOfAccountsText.ChartOfAccounts AND _GLChartOfAccountsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnJrnlEntrItem AS _Item ON ConsolidationLedger = _Item.ConsolidationLedger AND ConsolidationDimension = _Item.ConsolidationDimension AND FiscalYear = _Item.FiscalYear AND ReferenceFiscalYear = _Item.ReferenceFiscalYear AND CompanyCode = _Item.CompanyCode AND ConsolidationDocumentNumber = _Item.ConsolidationDocumentNumber AND ConsolidationPostingItem = _Item.ConsolidationPostingItem AND ConsolidationVersion = _Item.ConsolidationVersion  -- association [0..*]
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]
;