P_CnsldtnGrpJrnlEntrItmConVers

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_CnsldtnGrpJrnlEntrItmConVers.
-- 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 P_CnsldtnGrpJrnlEntrItmConVers AS
SELECT
  EntryItem.ConsolidationLedger AS ConsolidationLedger,
  EntryItem.ConsolidationDimension AS ConsolidationDimension,
  EntryItem.FiscalYear AS FiscalYear,
  EntryItem.CnsldtnGroupJrnlEntry AS CnsldtnGroupJrnlEntry,
  EntryItem.CnsldtnGroupJrnlEntryItem AS CnsldtnGroupJrnlEntryItem,
  EntryItem.GLRecordType AS GLRecordType,
  CnsldtnVersionRelation.ConsolidationVersion AS ConsolidationVersion,
  CnsldtnVersionRelation.ConsolidationVersionElement AS ConsolidationVersionElement,
  EntryItem.TransactionCurrency AS TransactionCurrency,
  EntryItem.LocalCurrency AS LocalCurrency,
  EntryItem.GroupCurrency AS GroupCurrency,
  EntryItem.BaseUnit AS BaseUnit,
  EntryItem.FiscalPeriod AS FiscalPeriod,
  EntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  EntryItem.DocumentCategory AS DocumentCategory,
  EntryItem.Company AS Company,
  EntryItem.ConsolidationUnit AS ConsolidationUnit,
  EntryItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  EntryItem.FinancialStatementItem AS FinancialStatementItem,
  EntryItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  EntryItem.ConsolidationGroup AS ConsolidationGroup,
  EntryItem.CompanyCode AS CompanyCode,
  EntryItem.SubItemCategory AS SubItemCategory,
  EntryItem.SubItem AS SubItem,
  EntryItem.PostingLevel AS PostingLevel,
  EntryItem.ConsolidationApportionment AS ConsolidationApportionment,
  EntryItem.CurrencyConversionsDiffType AS CurrencyConversionsDiffType,
  EntryItem.ConsolidationDocumentType AS ConsolidationDocumentType,
  EntryItem.ConsolidationAcquisitionYear AS ConsolidationAcquisitionYear,
  EntryItem.ConsolidationAcquisitionPeriod AS ConsolidationAcquisitionPeriod,
  EntryItem.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  EntryItem.InvestorConsolidationUnit AS InvestorConsolidationUnit,
  EntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  EntryItem.AmountInLocalCurrency AS AmountInLocalCurrency,
  EntryItem.AmountInGroupCurrency AS AmountInGroupCurrency,
  EntryItem.QuantityInBaseUnit AS QuantityInBaseUnit,
  EntryItem.CnsldtnQuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  EntryItem.CnsldtnCstmSignAmtInTransCrcy AS CnsldtnCstmSignAmtInTransCrcy,
  EntryItem.CnsldtnCstmSignAmtInLoclCrcy AS CnsldtnCstmSignAmtInLoclCrcy,
  EntryItem.CnsldtnCstmSignAmtInGrpCrcy AS CnsldtnCstmSignAmtInGrpCrcy,
  EntryItem.CnsldtnCstmSignQtyInBaseUnit AS CnsldtnCstmSignQtyInBaseUnit,
  EntryItem.CnsldtnCstmSignLongQtyInBsUnit AS CnsldtnCstmSignLongQtyInBsUnit,
  EntryItem.DocumentItemText AS DocumentItemText,
  EntryItem.ConsolidationPostgItemAutoFlag AS ConsolidationPostgItemAutoFlag,
  EntryItem.BusinessTransactionType AS BusinessTransactionType,
  EntryItem.PostingDate AS PostingDate,
  EntryItem.CurrencyTranslationDate AS CurrencyTranslationDate,
  EntryItem.RefConsolidationDocumentNumber AS RefConsolidationDocumentNumber,
  EntryItem.ReferenceFiscalYear AS ReferenceFiscalYear,
  EntryItem.RefConsolidationPostingItem AS RefConsolidationPostingItem,
  EntryItem.RefConsolidationDocumentType AS RefConsolidationDocumentType,
  EntryItem.RefBusinessTransactionType AS RefBusinessTransactionType,
  EntryItem.CreationDateTime AS CreationDateTime,
  EntryItem.CreationDate AS CreationDate,
  EntryItem.CreationTime AS CreationTime,
  EntryItem.UserID AS UserID,
  EntryItem.ReverseDocument AS ReverseDocument,
  EntryItem.ReversedDocument AS ReversedDocument,
  EntryItem.InvestmentActivityType AS InvestmentActivityType,
  EntryItem.InvestmentActivity AS InvestmentActivity,
  EntryItem.ConsolidationDocReversalYear AS ConsolidationDocReversalYear,
  EntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  EntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  EntryItem.LogicalSystem AS LogicalSystem,
  EntryItem.ChartOfAccounts AS ChartOfAccounts,
  EntryItem.GLAccount AS GLAccount,
  EntryItem.AssignmentReference AS AssignmentReference,
  EntryItem.CostCenter AS CostCenter,
  EntryItem.ProfitCenter AS ProfitCenter,
  EntryItem.FunctionalArea AS FunctionalArea,
  EntryItem.BusinessArea AS BusinessArea,
  EntryItem.ControllingArea AS ControllingArea,
  EntryItem.Segment AS Segment,
  EntryItem.PartnerCostCenter AS PartnerCostCenter,
  EntryItem.PartnerProfitCenter AS PartnerProfitCenter,
  EntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  EntryItem.PartnerBusinessArea AS PartnerBusinessArea,
  EntryItem.PartnerCompany AS PartnerCompany,
  EntryItem.PartnerSegment AS PartnerSegment,
  EntryItem.OrderID AS OrderID,
  EntryItem.Customer AS Customer,
  EntryItem.Supplier AS Supplier,
  EntryItem.Material AS Material,
  EntryItem.MaterialGroup AS MaterialGroup,
  EntryItem.Plant AS Plant,
  EntryItem.FinancialTransactionType AS FinancialTransactionType,
  EntryItem.WBSElementInternalID AS WBSElementInternalID,
  EntryItem.WBSElementExternalID AS WBSElementExternalID,
  EntryItem.Project AS Project,
  EntryItem.BillingDocumentType AS BillingDocumentType,
  EntryItem.SalesOrganization AS SalesOrganization,
  EntryItem.DistributionChannel AS DistributionChannel,
  EntryItem.OrganizationDivision AS OrganizationDivision,
  EntryItem.SoldMaterial AS SoldMaterial,
  EntryItem.SoldProduct AS SoldProduct,
  EntryItem.SoldProductGroup AS SoldProductGroup,
  EntryItem.CustomerGroup AS CustomerGroup,
  EntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  EntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  EntryItem.SalesDistrict AS SalesDistrict,
  EntryItem.BillToParty AS BillToParty,
  EntryItem.ShipToParty AS ShipToParty,
  EntryItem.CnsldtnAdhocItem AS CnsldtnAdhocItem,
  EntryItem.CnsldtnAdhocSet AS CnsldtnAdhocSet,
  EntryItem.CnsldtnAdhocSetItem AS CnsldtnAdhocSetItem,
  EntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  EntryItem.MatchingReasonCode AS MatchingReasonCode,
  EntryItem.OriginType AS OriginType,
  EntryItem.OriginReference AS OriginReference,
  EntryItem.CnsldtnGroupJrnlEntryBundle AS CnsldtnGroupJrnlEntryBundle,
  EntryItem.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  EntryItem.FinancialServicesBranch AS FinancialServicesBranch,
  EntryItem.FinancialDataSource AS FinancialDataSource,
  EntryItem.GHGScope AS GHGScope,
  EntryItem.GHGCategory AS GHGCategory,
  EntryItem.GHGScope2CalculationMethod AS GHGScope2CalculationMethod,
  EntryItem.GHGScope2ContractualInstrument AS GHGScope2ContractualInstrument,
  EntryItem.GHGDataQualityCharacteristic AS GHGDataQualityCharacteristic,
  EntryItem.GHGEnergyClassification AS GHGEnergyClassification,
  EntryItem.GHGEnergyMix AS GHGEnergyMix,
  EntryItem.GHGEnergySourcingType AS GHGEnergySourcingType,
  EntryItem.SustainabilityModeOfTransport AS SustainabilityModeOfTransport,
  EntryItem.FinancialManagementArea AS FinancialManagementArea,
  EntryItem.Fund AS Fund,
  EntryItem.GrantID AS GrantID,
  EntryItem.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  EntryItem.CashLedgerAccount AS CashLedgerAccount,
  EntryItem.PartnerFund AS PartnerFund
FROM I_CnsldtnGroupJrnlEntryItem AS EntryItem
INNER JOIN I_CnsldtnVersionRelation AS CnsldtnVersionRelation ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion AS CnsldtnVersion ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CnsldtnGroupJrnlEntryItem
;