P_GLE_ADB_GR_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_GLE_ADB_GR_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: PGLEADBGR_02
-- 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_GLE_ADB_GR_02 AS
SELECT
  I_FSItemMappingAssgmtWithVers.FinancialStatementItem AS FinancialStatementItem,
  I_FSItemMappingAssgmtWithVers.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  coalesce(I_CnsldtnUnit.ConsolidationUnit,'') AS PartnerConsolidationUnit,
  P_GLE_ADB_GR_01.GroupCurrency AS rgcurr,
  I_CnsldtnUnitByTime.ConsolidationUnitLocalCurrency AS rlcurr,
  P_GLE_ADB_GR_01.ConsolidationDimension AS ConsolidationDimension,
  P_GLE_ADB_GR_01.Ledger AS Ledger,
  P_GLE_ADB_GR_01.LedgerGLLineItem AS LedgerGLLineItem,
  P_GLE_ADB_GR_01.CompanyCode AS CompanyCode,
  P_GLE_ADB_GR_01.PartnerCompany AS PartnerCompany,
  P_GLE_ADB_GR_01.ConsolidationVersion AS ConsolidationVersion,
  P_GLE_ADB_GR_01.ConsolidationUnit AS ConsolidationUnit,
  P_GLE_ADB_GR_01.AccountingDocument AS AccountingDocument,
  P_GLE_ADB_GR_01.PartnerBusinessArea AS PartnerBusinessArea,
  P_GLE_ADB_GR_01.ConsolidationLedger AS ConsolidationLedger,
  P_GLE_ADB_GR_01.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_GLE_ADB_GR_01.BaseUnit AS BaseUnit,
  P_GLE_ADB_GR_01.FiscalPeriod AS FiscalPeriod,
  P_GLE_ADB_GR_01.FiscalYear AS FiscalYear,
  P_GLE_ADB_GR_01.FinancialTransactionType AS FinancialTransactionType,
  P_GLE_ADB_GR_01.FunctionalArea AS FunctionalArea,
  P_GLE_ADB_GR_01.CostCenter AS CostCenter,
  P_GLE_ADB_GR_01.ProfitCenter AS ProfitCenter,
  P_GLE_ADB_GR_01.BusinessArea AS BusinessArea,
  P_GLE_ADB_GR_01.AccountingDocumentType AS AccountingDocumentType,
  P_GLE_ADB_GR_01.gjahr AS gjahr,
  P_GLE_ADB_GR_01.GLAccount AS GLAccount,
  P_GLE_ADB_GR_01.tsl_m AS tsl_m,
  P_GLE_ADB_GR_01.tsl_q AS tsl_q,
  P_GLE_ADB_GR_01.tsl_h AS tsl_h,
  P_GLE_ADB_GR_01.tsl_y AS tsl_y,
  P_GLE_ADB_GR_01.hsl_m AS hsl_m,
  P_GLE_ADB_GR_01.hsl_q AS hsl_q,
  P_GLE_ADB_GR_01.hsl_h AS hsl_h,
  P_GLE_ADB_GR_01.hsl_y AS hsl_y,
  P_GLE_ADB_GR_01.ksl_m AS ksl_m,
  P_GLE_ADB_GR_01.ksl_q AS ksl_q,
  P_GLE_ADB_GR_01.ksl_h AS ksl_h,
  P_GLE_ADB_GR_01.ksl_y AS ksl_y,
  P_GLE_ADB_GR_01.osl_m AS osl_m,
  P_GLE_ADB_GR_01.osl_q AS osl_q,
  P_GLE_ADB_GR_01.osl_h AS osl_h,
  P_GLE_ADB_GR_01.osl_y AS osl_y,
  P_GLE_ADB_GR_01.vsl_m AS vsl_m,
  P_GLE_ADB_GR_01.vsl_q AS vsl_q,
  P_GLE_ADB_GR_01.vsl_h AS vsl_h,
  P_GLE_ADB_GR_01.vsl_y AS vsl_y,
  P_GLE_ADB_GR_01.bsl_m AS bsl_m,
  P_GLE_ADB_GR_01.bsl_q AS bsl_q,
  P_GLE_ADB_GR_01.bsl_h AS bsl_h,
  P_GLE_ADB_GR_01.bsl_y AS bsl_y,
  P_GLE_ADB_GR_01.csl_m AS csl_m,
  P_GLE_ADB_GR_01.csl_q AS csl_q,
  P_GLE_ADB_GR_01.csl_h AS csl_h,
  P_GLE_ADB_GR_01.csl_y AS csl_y,
  P_GLE_ADB_GR_01.dsl_m AS dsl_m,
  P_GLE_ADB_GR_01.dsl_q AS dsl_q,
  P_GLE_ADB_GR_01.dsl_h AS dsl_h,
  P_GLE_ADB_GR_01.dsl_y AS dsl_y,
  P_GLE_ADB_GR_01.esl_m AS esl_m,
  P_GLE_ADB_GR_01.esl_q AS esl_q,
  P_GLE_ADB_GR_01.esl_h AS esl_h,
  P_GLE_ADB_GR_01.esl_y AS esl_y,
  P_GLE_ADB_GR_01.fsl_m AS fsl_m,
  P_GLE_ADB_GR_01.fsl_q AS fsl_q,
  P_GLE_ADB_GR_01.fsl_h AS fsl_h,
  P_GLE_ADB_GR_01.fsl_y AS fsl_y,
  P_GLE_ADB_GR_01.gsl_m AS gsl_m,
  P_GLE_ADB_GR_01.gsl_q AS gsl_q,
  P_GLE_ADB_GR_01.gsl_h AS gsl_h,
  P_GLE_ADB_GR_01.gsl_y AS gsl_y,
  P_GLE_ADB_GR_01.ReferenceFiscalYear AS ReferenceFiscalYear,
  P_GLE_ADB_GR_01.CnsldtnUnitGroupCrcySource AS CnsldtnUnitGroupCrcySource,
  P_GLE_ADB_GR_01.GroupCurrency AS GroupCurrency,
  P_GLE_ADB_GR_01.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  P_GLE_ADB_GR_01.Segment AS Segment,
  P_GLE_ADB_GR_01.AssignmentReference AS AssignmentReference,
  P_GLE_ADB_GR_01.ControllingArea AS ControllingArea,
  P_GLE_ADB_GR_01.PartnerCostCenter AS PartnerCostCenter,
  P_GLE_ADB_GR_01.PartnerProfitCenter AS PartnerProfitCenter,
  P_GLE_ADB_GR_01.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_GLE_ADB_GR_01.PartnerSegment AS PartnerSegment,
  P_GLE_ADB_GR_01.OrderID AS OrderID,
  P_GLE_ADB_GR_01.Customer AS Customer,
  P_GLE_ADB_GR_01.Supplier AS Supplier,
  P_GLE_ADB_GR_01.Material AS Material,
  P_GLE_ADB_GR_01.MaterialGroup AS MaterialGroup,
  P_GLE_ADB_GR_01.Plant AS Plant,
  P_GLE_ADB_GR_01.WBSElementExternalID AS WBSElementExternalID,
  P_GLE_ADB_GR_01.Project AS Project,
  P_GLE_ADB_GR_01.BillingDocumentType AS BillingDocumentType,
  P_GLE_ADB_GR_01.SalesOrganization AS SalesOrganization,
  P_GLE_ADB_GR_01.DistributionChannel AS DistributionChannel,
  P_GLE_ADB_GR_01.OrganizationDivision AS OrganizationDivision,
  P_GLE_ADB_GR_01.SoldProduct AS SoldProduct,
  P_GLE_ADB_GR_01.SoldProductGroup AS SoldProductGroup,
  P_GLE_ADB_GR_01.CustomerGroup AS CustomerGroup,
  P_GLE_ADB_GR_01.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLE_ADB_GR_01.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLE_ADB_GR_01.SalesDistrict AS SalesDistrict,
  P_GLE_ADB_GR_01.BillToParty AS BillToParty,
  P_GLE_ADB_GR_01.ShipToParty AS ShipToParty,
  P_GLE_ADB_GR_01.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  P_GLE_ADB_GR_01.WBSElementInternalID AS WBSElementInternalID,
  P_GLE_ADB_GR_01.ChartOfAccounts AS ChartOfAccounts,
  P_GLE_ADB_GR_01.CreationDateTime AS CreationDateTime,
  P_GLE_ADB_GR_01.SourceLedger AS SourceLedger
FROM P_GLE_ADB_GR_01
;