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,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  GLRecordType,
  _VersionText.ConsolidationVersionText AS ConsolidationVersionText,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  ConsolidationDocumentType,
  _DocumentTypeText.ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  DebitCreditCode,
  Company,
  cast ( ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  _CnsldtnUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  _ChartOfAccountsText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FinancialStatementItemText.FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  cast ( PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  _PartnerUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  ConsolidationGroup,
  _GroupText.ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
  SubItemCategory,
  SubItem,
  PostingLevel,
  _PostingLevelText.PostingLevelText AS PostingLevelText,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  cast ( InvesteeConsolidationUnit as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  _InvesteeUnitText.ConsolidationUnitText AS InvesteeConsolidationUnitText,
  InvestmentActivityType,
  _InvestmentActivityTypeText.InvestmentActivityTypeText AS InvestmentActivityTypeText,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  _GLChartOfAccountsText.ChartOfAccountsName AS ChartOfAccountsName,
  GLAccount,
  _GLAcctInChartOfAccountsText.GLAccountName AS GLAccountName,
  AssignmentReference,
  CostCenter,
  _CostCenterText[1:Language = $session.system_language].AdditionalMasterDataText AS CostCenterName,
  ProfitCenter,
  _ProfitCenterText.AdditionalMasterDataText AS ProfitCenterName,
  FunctionalArea,
  BusinessArea,
  _BusinessAreaText.AdditionalMasterDataText AS BusinessAreaName,
  ControllingArea,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  Segment,
  _SegmentText[1:Language = $session.system_language].AdditionalMasterDataText AS SegmentName,
  PartnerCostCenter,
  _PartnerCostCenterText[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerCostCenterName,
  PartnerProfitCenter,
  _PartnerProfitCenterText.AdditionalMasterDataText AS PartnerProfitCenterName,
  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,
  CnsldtnAdhocSetItem,
  CnsldtnGroupJrnlEntryBundle,
  CnsldtnAdhocItem,
  _AdhocItemText[1:Language = $session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
  CnsldtnAdhocSet,
  _AdhocSetText[1:Language = $session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText,
  FinancialServicesProductGroup,
  _FinancialServicesProductGroup._Text[1:Language = $session.system_language].FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranch._Text[1:Language = $session.system_language].FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSource._Text[1:Language = $session.system_language].FinancialDataSourceName AS FinancialDataSourceName,
  FinancialManagementArea,
  _FinancialManagementArea._Text[1:Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  GrantID,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  CnsldtnCashLedgerChartOfAccts,
  _CashLedgerChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS CnsldtnCashLdgrChtOfAcctsText,
  CashLedgerAccount,
  _CashLedgerAccount._Text[1:Language = $session.system_language].GLAccountName AS CashLedgerAccountName,
  PartnerFund,
  _PartnerFund._Text[1:Language = $session.system_language].FundName AS PartnerFundText,
  GHGScope,
  _GHGScope._Text[1:Language = $session.system_language].GHGScopeName AS GHGScopeName,
  GHGCategory,
  _GHGCategory._Text[1:Language = $session.system_language].GHGCategoryName AS GHGCategoryName,
  GHGScope2CalculationMethod,
  _GHGScope2CalculationMethod._Text[1:Language = $session.system_language].GHGScope2CalculationMethodName AS GHGScope2CalculationMethodName,
  GHGScope2ContractualInstrument,
  _GHGScp2ContractualInstrument._Text[1:Language = $session.system_language].GHGScp2CntrctlInstrName AS GHGScp2CntrctlInstrName,
  SustainabilityModeOfTransport,
  _SustainabilityModeOfTransport._Text[1:Language = $session.system_language].SustModeOfTransportName AS SustModeOfTransportName,
  GHGDataQualityCharacteristic,
  _GHGDataQualityCharacteristic._Text[1:Language = $session.system_language].GHGDtaQltyCharacteristicName AS GHGDtaQltyCharacteristicName,
  GHGEnergyClassification,
  _GHGEnergyClassification._Text[1:Language = $session.system_language].GHGEnergyClassificationName AS GHGEnergyClassificationName,
  GHGEnergyMix,
  _GHGEnergyMix._Text[1:Language = $session.system_language].GHGEnergyMixName AS GHGEnergyMixName,
  GHGEnergySourcingType,
  _GHGEnergySourcingType._Text[1:Language = $session.system_language].GHGEnergySourcingTypeName AS GHGEnergySourcingTypeName
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]
LEFT OUTER JOIN I_CnsldtnFinSrvcsProductGroup AS _FinancialServicesProductGroup ON FinancialServicesProductGroup = _FinancialServicesProductGroup.FinancialServicesProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinServicesBranch AS _FinancialServicesBranch ON FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinancialDataSource AS _FinancialDataSource ON FinancialDataSource = _FinancialDataSource.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGrant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccounts AS _CashLedgerChartOfAccounts ON CnsldtnCashLedgerChartOfAccts = _CashLedgerChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLAccount_2 AS _CashLedgerAccount ON CnsldtnCashLedgerChartOfAccts = _CashLedgerAccount.ChartOfAccounts AND CashLedgerAccount = _CashLedgerAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND Fund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScope AS _GHGScope ON GHGScope = _GHGScope.GHGScope  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGCategory AS _GHGCategory ON GHGCategory = _GHGCategory.GHGCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CalcMethod AS _GHGScope2CalculationMethod ON GHGScope2CalculationMethod = _GHGScope2CalculationMethod.GHGScope2CalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CntrctlInstr AS _GHGScp2ContractualInstrument ON GHGScope2ContractualInstrument = _GHGScp2ContractualInstrument.GHGScope2ContractualInstrument  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSustModeOfTransport AS _SustainabilityModeOfTransport ON SustainabilityModeOfTransport = _SustainabilityModeOfTransport.SustainabilityModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGDtaQltyCharc AS _GHGDataQualityCharacteristic ON GHGDataQualityCharacteristic = _GHGDataQualityCharacteristic.GHGDataQualityCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEngyClassification AS _GHGEnergyClassification ON GHGEnergyClassification = _GHGEnergyClassification.GHGEnergyClassification  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEnergyMix AS _GHGEnergyMix ON GHGEnergyMix = _GHGEnergyMix.GHGEnergyMix  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEnergySourcingType AS _GHGEnergySourcingType ON GHGEnergySourcingType = _GHGEnergySourcingType.GHGEnergySourcingType  -- association [0..1]
;