I_CnsldtnReldAcctgJrnlEntrItm

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_CnsldtnReldAcctgJrnlEntrItm.
-- 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: IRELDJRNLITM
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW I_CnsldtnReldAcctgJrnlEntrItm AS
SELECT
  gl_sirid AS ConsolidationRecordNumber,
  rldnr_fin AS Ledger,
  rldnr AS ConsolidationLedger,
  rrcty AS GLRecordType,
  rvers AS ConsolidationVersion,
  ryear AS FiscalYear,
  rtcur AS TransactionCurrency,
  runit AS BaseUnit,
  drcrk AS DebitCreditCode,
  poper AS FiscalPeriod,
  fiscyearper AS FiscalYearPeriod,
  docct AS DocumentCategory,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  rcomp AS Company,
  rdimen AS ConsolidationDimension,
  cast( rbunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  cast( rbuptr as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  rcongr AS ConsolidationGroup,
  robukrs AS CompanyCode,
  sityp AS SubItemCategory,
  subit AS SubItem,
  plevl AS PostingLevel,
  rpflg AS ConsolidationApportionment,
  rtflg AS CurrencyConversionsDiffType,
  docty AS ConsolidationDocumentType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  cast( coicu as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  updhp AS CnsldtnHighestUpdatePeriod,
  tsl AS AmountInTransactionCurrency,
  hsl AS AmountInLocalCurrency,
  ksl AS AmountInGroupCurrency,
  msl AS QuantityInBaseUnit,
  sgtxt AS DocumentItemText,
  autom AS ConsolidationPostgItemAutoFlag,
  activ AS BusinessTransactionType,
  bvorg AS IntercompanyTransaction,
  budat AS PostingDate,
  wsdat AS CurrencyTranslationDate,
  refdocnr AS RefConsolidationDocumentNumber,
  refryear AS ReferenceFiscalYear,
  refdocln AS RefConsolidationPostingItem,
  refdocct AS RefConsolidationDocumentType,
  refactiv AS RefBusinessTransactionType,
  cpudt AS CreationDate,
  cputm AS CreationTime,
  usnam AS UserID,
  rvsdocnr AS ReverseDocument,
  orndocnr AS ReversedDocument,
  coiac AS InvestmentActivityType,
  coinr AS InvestmentActivity,
  cast( uppcu as fincs_investorconsunit preserving type ) AS InvestorConsolidationUnit,
  revyear AS ConsolidationDocReversalYear,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  logsys AS LogicalSystem,
  ktopl AS ChartOfAccounts,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  racct AS GLAccount,
  xblnr AS ReferenceDocumentNumber,
  zuonr AS AssignmentReference,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  ps_psp_pnr AS WBSElementInternalID,
  ps_posid AS WBSElementExternalID,
  ps_pspid AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  timestamp AS CreationDateTime
FROM P_ReportedFinancialData_RT
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON Ledger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.AccountingDocument AND ConsolidationPostingItem = _Extension.LedgerGLLineItem  -- association [1..1]
;