I_CnsldtnGrpJrnlEntr

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 I_CnsldtnGrpJrnlEntr.
-- 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: ICNSLDTNGRPJRNL

CREATE VIEW I_CnsldtnGrpJrnlEntr AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ReferenceFiscalYear,
  CompanyCode,
  CnsldtnGroupJrnlEntry AS ConsolidationDocumentNumber,
  CnsldtnGroupJrnlEntryItem AS ConsolidationPostingItem,
  ConsolidationVersion,
  GLRecordType,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  ConsolidationDocumentType,
  Company,
  cast ( ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  cast ( PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  ConsolidationGroup,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  cast ( InvesteeConsolidationUnit as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  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,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  FinancialTransactionType,
  cast( Project as ps_pspid_edit ) AS Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  cast('U' as fincs_jrnl_entry_item_origin) AS CnsldtnJrnlEntryItemOrigin,
  cast('00000000000000000000000' as fis_fp_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast('000000' as fis_fp_data_packet) AS FinancialPlanningDataPacket,
  cast(0 as fis_fp_entry_item) AS FinancialPlanningEntryItem,
  cast('' as fins_ledger) AS Ledger,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginReference,
  OriginType,
  CnsldtnGroupJrnlEntryBundle
FROM I_CnsldtnGroupJrnlEntryItem AS GroupReportingLineItem
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON Ledger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND ConsolidationDocumentNumber = _Extension_acdoca.AccountingDocument AND ConsolidationPostingItem = _Extension_acdoca.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension_acdocu ON ConsolidationLedger = _Extension_acdocu.ConsolidationLedger AND ConsolidationDimension = _Extension_acdocu.ConsolidationDimension AND FiscalYear = _Extension_acdocu.FiscalYear AND ConsolidationDocumentNumber = _Extension_acdocu.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension_acdocu.CnsldtnGroupJrnlEntryItem  -- association [0..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension_acdocp ON FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc AND FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem  -- association [0..1]
LEFT OUTER JOIN I_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_Globalcompany AS _Company ON Company = _Company.Company  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnFinTransType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- 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_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_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]
;