I_CnsldtnReleasedRptdFinData

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_CnsldtnReleasedRptdFinData.
-- 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: IREPFINDRLAG

CREATE VIEW I_CnsldtnReleasedRptdFinData AS
SELECT
  rldnr AS ConsolidationLedger,
  rdimen AS ConsolidationDimension,
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  gl_sirid AS ConsolidationRecordNumber,
  rrcty AS GLRecordType,
  rvers AS ConsolidationVersion,
  rtcur AS TransactionCurrency,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  runit AS BaseUnit,
  drcrk AS DebitCreditCode,
  poper AS FiscalPeriod,
  fiscyearper AS FiscalYearPeriod,
  docct AS DocumentCategory,
  rcomp AS Company,
  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,
  timestamp AS CreationDateTime,
  racct AS GLAccount,
  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,
  rmvct AS FinancialTransactionType,
  matnr AS Material,
  werks AS Plant,
  kunnr AS Customer,
  lifnr AS Supplier,
  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,
  zuonr AS AssignmentReference,
  aufnr AS OrderID,
  xblnr AS ReferenceDocumentNumber,
  matkl_mm AS MaterialGroup,
  ps_psp_pnr AS WBSElementInternalID,
  ktopl AS ChartOfAccounts
FROM P_ReportedFinancialData_RL_AG
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension ON ConsolidationLedger = _Extension.ConsolidationLedger AND ConsolidationDimension = _Extension.ConsolidationDimension AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
;