P_CnsldtnGLAvgDailyBal

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_CnsldtnGLAvgDailyBal.
-- 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: PCNSLDTNADB
-- 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 P_CnsldtnGLAvgDailyBal AS
SELECT
  cast('' as gu_recid) AS ConsolidationRecordNumber,
  cast('' as xblnr1 ) AS ReferenceDocumentNumber,
  cast(Source.SubItemCategory as fc_sityp) AS SubItemCategory,
  cast(Source.SubItem as fc_sitem) AS SubItem,
  cast(coalesce(Source.PartnerConsolidationUnit,'') as fc_buptr) AS PartnerConsolidationUnit,
  cast(Source.BaseUnit as meins) AS BaseUnit,
  Source.FinancialTransactionType AS FinancialTransactionType,
  Source.FunctionalArea AS FunctionalArea,
  Source.BusinessArea AS BusinessArea,
  Source.CostCenter AS CostCenter,
  Source.GLAccount AS GLAccount,
  Source.ProfitCenter AS ProfitCenter,
  Source.Segment AS Segment,
  Source.MTDAvgDailyBalInBalTransCrcy AS MTDAvgDailyBalInBalTransCrcy,
  Source.QTDAvgDailyBalInBalTransCrcy AS QTDAvgDailyBalInBalTransCrcy,
  Source.HYTDAvgDailyBalInBalTransCrcy AS HYTDAvgDailyBalInBalTransCrcy,
  Source.YTDAvgDailyBalInBalTransCrcy AS YTDAvgDailyBalInBalTransCrcy,
  Source.MTDAvgDailyBalInGlobCrcy AS MTDAvgDailyBalInGlobCrcy,
  Source.QTDAvgDailyBalInGlobCrcy AS QTDAvgDailyBalInGlobCrcy,
  Source.HYTDAvgDailyBalInGlobCrcy AS HYTDAvgDailyBalInGlobCrcy,
  Source.YTDAvgDailyBalInGlobCrcy AS YTDAvgDailyBalInGlobCrcy,
  Source.MTDAvgDailyBalInCCCrcy AS MTDAvgDailyBalInCCCrcy,
  Source.QTDAvgDailyBalInCCCrcy AS QTDAvgDailyBalInCCCrcy,
  Source.HYTDAvgDailyBalInCCCrcy AS HYTDAvgDailyBalInCCCrcy,
  Source.YTDAvgDailyBalInCCCrcy AS YTDAvgDailyBalInCCCrcy,
  cast(Source.BalanceTransactionCurrency as rtcur) AS TransactionCurrency,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  cast(Source.ConsolidationUnitLocalCurrency as lcurr) AS LocalCurrency,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.ConsolidationVersion AS ConsolidationVersion,
  Source.ConsolidationLedger AS ConsolidationLedger,
  cast(Source.GroupCurrency as gcurr) AS GroupCurrency,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  Source.CompanyCode AS CompanyCode,
  Source.ChartOfAccounts AS ChartOfAccounts,
  Source.AssignmentReference AS AssignmentReference,
  Source.ControllingArea AS ControllingArea,
  Source.PartnerCostCenter AS PartnerCostCenter,
  Source.PartnerProfitCenter AS PartnerProfitCenter,
  Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  Source.PartnerBusinessArea AS PartnerBusinessArea,
  Source.PartnerCompany AS PartnerCompany,
  Source.PartnerSegment AS PartnerSegment,
  Source.OrderID AS OrderID,
  Source.Customer AS Customer,
  Source.Supplier AS Supplier,
  Source.Material AS Material,
  Source.MaterialGroup AS MaterialGroup,
  Source.Plant AS Plant,
  cast(Source.WBSElementExternalID as fis_wbsext_no_conv) AS WBSElementExternalID,
  cast(Source.Project as fis_project_no_conv) AS Project,
  Source.BillingDocumentType AS BillingDocumentType,
  Source.SalesOrganization AS SalesOrganization,
  Source.DistributionChannel AS DistributionChannel,
  Source.OrganizationDivision AS OrganizationDivision,
  Source.SoldProduct AS SoldProduct,
  Source.SoldProductGroup AS SoldProductGroup,
  Source.CustomerGroup AS CustomerGroup,
  Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  Source.SalesDistrict AS SalesDistrict,
  Source.BillToParty AS BillToParty,
  Source.ShipToParty AS ShipToParty,
  Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  cast(Source.WBSElementInternalID as fis_wbsint_no_conv) AS WBSElementInternalID,
  Source.CreationDateTime AS CreationDateTime,
  Source.SourceLedger AS SourceLedger,
  Source.Ledger AS Ledger,
  Source.LedgerGLLineItem AS LedgerGLLineItem,
  cast(Source.AccountingDocument as belnr_d) AS AccountingDocument,
  Source.ReferenceFiscalYear AS ReferenceFiscalYear
FROM P_CnsldtnGLAvgDailyBal_02
;