P_GLE_ADB_GR_FT_06

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_GLE_ADB_GR_FT_06.
-- 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.
-- Parameters: P_ConsolidationDimension : fc_dimen, P_ConsolidationUnit : fc_bunit, P_ConsolidationVersion : fc_rvers, P_FiscalYearPeriod : fincs_fiscalyearper

CREATE VIEW P_GLE_ADB_GR_FT_06 AS
SELECT
  Source.FinSGLRunUUID AS FinSGLRunUUID,
  Source.FinSGLItemID AS FinSGLItemID,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.Ledger AS Ledger,
  Source.CompanyCode AS CompanyCode,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.SubItem AS SubItem,
  Source.SubItemCategory AS SubItemCategory,
  Source.CnsldtnSubitemSource AS CnsldtnSubitemSource,
  Source.GLAccount AS GLAccount,
  Source.ChartOfAccounts AS ChartOfAccounts,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Source.GroupCurrency AS GroupCurrency,
  Source.LocalCurrency AS LocalCurrency,
  case when tf103a_rtcur.BreakdownType is null then case Source.DocumentEntryIsInGroupCurrency when '' then Source.hsl_m when 'X' then Source.ksl_m end when tf103a_rtcur.BreakdownType = '2' then Source.tsl_m end as MTDAvgDailyBalInBalTransCrcy AS tsl_mendasMTDAvgDailyBalInBalTransCrcy,
  case when tf103a_rtcur.BreakdownType is null then case Source.DocumentEntryIsInGroupCurrency when '' then Source.hsl_q when 'X' then Source.ksl_q end when tf103a_rtcur.BreakdownType = '2' then Source.tsl_q end as QTDAvgDailyBalInBalTransCrcy AS tsl_qendasQTDAvgDailyBalInBalTransCrcy,
  case when tf103a_rtcur.BreakdownType is null then case Source.DocumentEntryIsInGroupCurrency when '' then Source.hsl_y when 'X' then Source.ksl_y end when tf103a_rtcur.BreakdownType = '2' then Source.tsl_y end as YTDAvgDailyBalInBalTransCrcy AS tsl_yendasYTDAvgDailyBalInBalTransCrcy,
  Source.hsl_m AS MTDAvgDailyBalInCCCrcy,
  Source.hsl_q AS QTDAvgDailyBalInCCCrcy,
  Source.hsl_y AS YTDAvgDailyBalInCCCrcy,
  Source.ksl_m AS MTDAvgDailyBalInGlobCrcy,
  Source.ksl_q AS QTDAvgDailyBalInGlobCrcy,
  Source.ksl_y AS YTDAvgDailyBalInGlobCrcy,
  Source.BusinessArea AS BusinessArea,
  Source.PartnerCostCenter AS PartnerCostCenter,
  Source.PartnerBusinessArea AS PartnerBusinessArea,
  Source.PartnerCompany AS PartnerCompany,
  Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  Source.ProfitCenter AS ProfitCenter,
  Source.Segment AS Segment,
  Source.CostCenter AS CostCenter,
  Source.FunctionalArea AS FunctionalArea,
  Source.FinancialTransactionType AS FinancialTransactionType,
  Source.OrderID AS OrderID,
  Source.BillingDocumentType AS BillingDocumentType,
  Source.ControllingArea AS ControllingArea,
  Source.Customer AS Customer,
  Source.Supplier AS Supplier,
  Source.MaterialGroup AS MaterialGroup,
  Source.Material AS Material,
  Source.PartnerProfitCenter AS PartnerProfitCenter,
  Source.WBSElementExternalID AS WBSElementExternalID,
  Source.Project AS Project,
  Source.PartnerSegment AS PartnerSegment,
  Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  Source.Plant AS Plant,
  Source.AssignmentReference AS AssignmentReference,
  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.WBSElementInternalID AS WBSElementInternalID
FROM P_GLE_ADB_GR_FT_05
;