I_AvgDailyBalGroupReporting

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_AvgDailyBalGroupReporting.
-- 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: IADBGRCUBE
-- Parameters: P_FiscalYearStartDate : gle_dte_adb_keydate, P_FiscalHalfYearStartDate : gle_dte_adb_keydate, P_FiscalQuarterStartDate : gle_dte_adb_keydate, P_FiscalMonthStartDate : gle_dte_adb_keydate, P_ReportingDate : gle_dte_adb_keydate, P_ConsolidationDimension : fc_dimen, P_ConsolidationUnit : fc_bunit, P_ConsolidationVersion : fc_rvers, P_FiscalYearPeriod : fincs_fiscalyearper, P_CreationDateTimeRgFr : gle_dte_adb_timestamp, P_CreationDateTimeRgTo : gle_dte_adb_timestamp, P_ArchiveDataIsIncluded : abap_boolean

CREATE VIEW I_AvgDailyBalGroupReporting AS
SELECT
  ConsolidationRecordNumber,
  Ledger,
  LedgerGLLineItem,
  AccountingDocument,
  ConsolidationLedger,
  ConsolidationVersion,
  FiscalYear,
  ReferenceFiscalYear,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  P_GLE_ADB_GR_07.ConsolidationDimension AS ConsolidationDimension,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  CompanyCode,
  SubItemCategory,
  SubItem,
  tsl_m AS MTDAvgDailyBalInBalTransCrcy,
  tsl_q AS QTDAvgDailyBalInBalTransCrcy,
  tsl_h AS HYTDAvgDailyBalInBalTransCrcy,
  tsl_y AS YTDAvgDailyBalInBalTransCrcy,
  hsl_m AS MTDAvgDailyBalInCCCrcy,
  hsl_q AS QTDAvgDailyBalInCCCrcy,
  hsl_h AS HYTDAvgDailyBalInCCCrcy,
  hsl_y AS YTDAvgDailyBalInCCCrcy,
  ksl_m AS MTDAvgDailyBalInGlobCrcy,
  ksl_q AS QTDAvgDailyBalInGlobCrcy,
  ksl_h AS HYTDAvgDailyBalInGlobCrcy,
  ksl_y AS YTDAvgDailyBalInGlobCrcy,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  FinancialTransactionType,
  ChartOfAccounts,
  AssignmentReference,
  ControllingArea,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CreationDateTime,
  WBSElementInternalID,
  cast('' as char32 ) AS ReferenceDocumentNumber,
  cast('' as fc_congr) AS ConsolidationGroup,
  cast('0' as rrcty) AS GLRecordType,
  cast(' ' as fc_plevl) AS PostingLevel,
  cast(' ' as fincs_investeeconsunit) AS InvesteeConsolidationUnit,
  cast('000' as rpacq) AS ConsolidationAcquisitionPeriod,
  cast('0' as fc_rpflg) AS ConsolidationApportionment,
  cast('0' as fc_rtflg) AS CurrencyConversionsDiffType,
  cast('0000' as fc_ryacq) AS ConsolidationAcquisitionYear,
  cast('' as fc_docty) AS ConsolidationDocumentType
FROM P_GLE_ADB_GR_07
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON Ledger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND ReferenceFiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;