P_CnsldtnGLAvgDailyBal_02

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_02.
-- 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_02
-- Parameters: P_FiscalYearStartDate : 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

CREATE VIEW P_CnsldtnGLAvgDailyBal_02 AS
SELECT
  case when tf103a_runit.BreakdownType = '0' or tf103a_runit.BreakdownType is null then '' when tf103a_runit.BreakdownType = '3' then Source.BaseUnit end as BaseUnit AS BaseUnitendasBaseUnit,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.ConsolidationVersion AS ConsolidationVersion,
  Source.FSItemMappingVersion AS FSItemMappingVersion,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.GroupCurrency AS GroupCurrency,
  Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  Source.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  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.MTDAvgDailyBalInBalTransCrcy AS MTDAvgDailyBalInBalTransCrcy,
  Source.QTDAvgDailyBalInBalTransCrcy AS QTDAvgDailyBalInBalTransCrcy,
  Source.YTDAvgDailyBalInBalTransCrcy AS YTDAvgDailyBalInBalTransCrcy,
  Source.MTDAvgDailyBalInCCCrcy AS MTDAvgDailyBalInCCCrcy,
  Source.QTDAvgDailyBalInCCCrcy AS QTDAvgDailyBalInCCCrcy,
  Source.YTDAvgDailyBalInCCCrcy AS YTDAvgDailyBalInCCCrcy,
  Source.Segment AS Segment,
  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,
  Source.WBSElementExternalID AS WBSElementExternalID,
  Source.Project 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,
  Source.WBSElementInternalID AS WBSElementInternalID,
  Source.CreationDateTime AS CreationDateTime,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Source.Company AS Company,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.SubItemCategory AS SubItemCategory,
  Source.SubItem AS SubItem,
  Source.Ledger AS Ledger,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  Source.FiscalYearPeriod AS FiscalYearPeriod,
  Source.SourceLedger AS SourceLedger,
  Source.LedgerGLLineItem AS LedgerGLLineItem,
  Source.AccountingDocument AS AccountingDocument,
  Source.ReferenceFiscalYear AS ReferenceFiscalYear
FROM P_CnsldtnGLAvgDailyBal_01
;