P_GLE_ADB_GR_05

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_05.
-- 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_05
-- 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_05 AS
SELECT
  P_GLE_ADB_GR_04.ConsolidationDimension AS ConsolidationDimension,
  P_GLE_ADB_GR_04.Ledger AS Ledger,
  P_GLE_ADB_GR_04.LedgerGLLineItem AS LedgerGLLineItem,
  P_GLE_ADB_GR_04.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  P_GLE_ADB_GR_04.CompanyCode AS CompanyCode,
  P_GLE_ADB_GR_04.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  P_GLE_ADB_GR_04.ConsolidationVersion AS ConsolidationVersion,
  P_GLE_ADB_GR_04.ConsolidationUnit AS ConsolidationUnit,
  P_GLE_ADB_GR_04.gjahr AS gjahr,
  P_GLE_ADB_GR_04.AccountingDocument AS AccountingDocument,
  P_GLE_ADB_GR_04.ConsolidationLedger AS ConsolidationLedger,
  P_GLE_ADB_GR_04.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_GLE_ADB_GR_04.BaseUnit AS BaseUnit,
  P_GLE_ADB_GR_04.FiscalPeriod AS FiscalPeriod,
  P_GLE_ADB_GR_04.FiscalYear AS FiscalYear,
  P_GLE_ADB_GR_04.FinancialStatementItem AS FinancialStatementItem,
  P_GLE_ADB_GR_04.SubItemCategory AS SubItemCategory,
  P_GLE_ADB_GR_04.SubItem AS SubItem,
  P_GLE_ADB_GR_04.rlcurr AS rlcurr,
  P_GLE_ADB_GR_04.rgcurr AS rgcurr,
  P_GLE_ADB_GR_04.tsl_m AS tsl_m,
  P_GLE_ADB_GR_04.tsl_q AS tsl_q,
  P_GLE_ADB_GR_04.tsl_h AS tsl_h,
  P_GLE_ADB_GR_04.tsl_y AS tsl_y,
  P_GLE_ADB_GR_04.itgrp AS itgrp,
  P_GLE_ADB_GR_04.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  P_GLE_ADB_GR_04.ReferenceFiscalYear AS ReferenceFiscalYear,
  P_GLE_ADB_GR_04.AssignmentReference AS AssignmentReference,
  P_GLE_ADB_GR_04.ControllingArea AS ControllingArea,
  P_GLE_ADB_GR_04.PartnerCostCenter AS PartnerCostCenter,
  P_GLE_ADB_GR_04.PartnerProfitCenter AS PartnerProfitCenter,
  P_GLE_ADB_GR_04.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_GLE_ADB_GR_04.PartnerBusinessArea AS PartnerBusinessArea,
  P_GLE_ADB_GR_04.PartnerCompany AS PartnerCompany,
  P_GLE_ADB_GR_04.PartnerSegment AS PartnerSegment,
  P_GLE_ADB_GR_04.OrderID AS OrderID,
  P_GLE_ADB_GR_04.Customer AS Customer,
  P_GLE_ADB_GR_04.Supplier AS Supplier,
  P_GLE_ADB_GR_04.Material AS Material,
  P_GLE_ADB_GR_04.MaterialGroup AS MaterialGroup,
  P_GLE_ADB_GR_04.Plant AS Plant,
  P_GLE_ADB_GR_04.WBSElementExternalID AS WBSElementExternalID,
  P_GLE_ADB_GR_04.Project AS Project,
  P_GLE_ADB_GR_04.BillingDocumentType AS BillingDocumentType,
  P_GLE_ADB_GR_04.SalesOrganization AS SalesOrganization,
  P_GLE_ADB_GR_04.DistributionChannel AS DistributionChannel,
  P_GLE_ADB_GR_04.OrganizationDivision AS OrganizationDivision,
  P_GLE_ADB_GR_04.SoldProduct AS SoldProduct,
  P_GLE_ADB_GR_04.SoldProductGroup AS SoldProductGroup,
  P_GLE_ADB_GR_04.CustomerGroup AS CustomerGroup,
  P_GLE_ADB_GR_04.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLE_ADB_GR_04.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLE_ADB_GR_04.SalesDistrict AS SalesDistrict,
  P_GLE_ADB_GR_04.BillToParty AS BillToParty,
  P_GLE_ADB_GR_04.ShipToParty AS ShipToParty,
  P_GLE_ADB_GR_04.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  P_GLE_ADB_GR_04.WBSElementInternalID AS WBSElementInternalID,
  P_GLE_ADB_GR_04.ChartOfAccounts AS ChartOfAccounts,
  P_GLE_ADB_GR_04.CreationDateTime AS CreationDateTime,
  P_GLE_ADB_GR_04.SourceLedger AS SourceLedger
FROM P_GLE_ADB_GR_04
;