P_GLE_ADB_GR_07

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_07.
-- 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_07
-- 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_07 AS
SELECT
  cast('' as gu_recid) AS ConsolidationRecordNumber,
  cast(' ' as fc_plevl) AS PostingLevel,
  cast(' ' as fc_congr) AS ConsolidationGroup,
  cast(P_GLE_ADB_GR_06.ConsolidationLedger as rldnr) AS ConsolidationLedger,
  cast( cast(P_GLE_ADB_GR_06.ConsolidationVersion as abap.char(3)) as rvers) AS ConsolidationVersion,
  cast(P_GLE_ADB_GR_06.AccountingDocument as belnr_d) AS AccountingDocument,
  P_GLE_ADB_GR_06.Ledger AS Ledger,
  P_GLE_ADB_GR_06.LedgerGLLineItem AS LedgerGLLineItem,
  P_GLE_ADB_GR_06.FiscalYear AS FiscalYear,
  P_GLE_ADB_GR_06.ReferenceFiscalYear AS ReferenceFiscalYear,
  cast(P_GLE_ADB_GR_06.BalanceTransactionCurrency as rtcur) AS TransactionCurrency,
  cast(P_GLE_ADB_GR_06.BaseUnit as meins) AS BaseUnit,
  cast(P_GLE_ADB_GR_06.FiscalPeriod as poper) AS FiscalPeriod,
  cast(P_GLE_ADB_GR_06.ConsolidationDimension as fc_dimen) AS ConsolidationDimension,
  cast(P_GLE_ADB_GR_06.ConsolidationUnit as fincs_consolidationunit) AS ConsolidationUnit,
  cast(P_GLE_ADB_GR_06.ConsolidationChartOfAccounts as fc_itclg) AS ConsolidationChartOfAccounts,
  cast(P_GLE_ADB_GR_06.FinancialStatementItem as fc_item) AS FinancialStatementItem,
  cast(coalesce(P_GLE_ADB_GR_06.PartnerConsolidationUnit,'') as fincs_partnerconsolidationunit) AS PartnerConsolidationUnit,
  cast(P_GLE_ADB_GR_06.CompanyCode as obukr) AS CompanyCode,
  cast(P_GLE_ADB_GR_06.SubItemCategory as fc_sityp) AS SubItemCategory,
  cast(P_GLE_ADB_GR_06.SubItem as fc_sitem) AS SubItem,
  tsl_m,
  tsl_q,
  tsl_h,
  tsl_y,
  hsl_m,
  hsl_q,
  hsl_h,
  hsl_y,
  ksl_m,
  ksl_q,
  ksl_h,
  ksl_y,
  cast(P_GLE_ADB_GR_06.rlcurr as lcurr) AS LocalCurrency,
  cast(P_GLE_ADB_GR_06.rgcurr as gcurr) AS GroupCurrency,
  P_GLE_ADB_GR_06.GLAccount AS GLAccount,
  P_GLE_ADB_GR_06.CostCenter AS CostCenter,
  P_GLE_ADB_GR_06.ProfitCenter AS ProfitCenter,
  P_GLE_ADB_GR_06.FunctionalArea AS FunctionalArea,
  P_GLE_ADB_GR_06.BusinessArea AS BusinessArea,
  P_GLE_ADB_GR_06.Segment AS Segment,
  P_GLE_ADB_GR_06.FinancialTransactionType AS FinancialTransactionType,
  cast('' as xblnr1) AS ReferenceDocumentNumber,
  P_GLE_ADB_GR_06.ChartOfAccounts AS ChartOfAccounts,
  P_GLE_ADB_GR_06.AssignmentReference AS AssignmentReference,
  P_GLE_ADB_GR_06.ControllingArea AS ControllingArea,
  P_GLE_ADB_GR_06.PartnerCostCenter AS PartnerCostCenter,
  P_GLE_ADB_GR_06.PartnerProfitCenter AS PartnerProfitCenter,
  P_GLE_ADB_GR_06.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_GLE_ADB_GR_06.PartnerBusinessArea AS PartnerBusinessArea,
  P_GLE_ADB_GR_06.PartnerCompany AS PartnerCompany,
  P_GLE_ADB_GR_06.PartnerSegment AS PartnerSegment,
  P_GLE_ADB_GR_06.OrderID AS OrderID,
  P_GLE_ADB_GR_06.Customer AS Customer,
  P_GLE_ADB_GR_06.Supplier AS Supplier,
  P_GLE_ADB_GR_06.Material AS Material,
  P_GLE_ADB_GR_06.MaterialGroup AS MaterialGroup,
  P_GLE_ADB_GR_06.Plant AS Plant,
  cast(P_GLE_ADB_GR_06.WBSElementExternalID as fis_wbsext_no_conv) AS WBSElementExternalID,
  cast(P_GLE_ADB_GR_06.Project as fis_project_no_conv) AS Project,
  P_GLE_ADB_GR_06.BillingDocumentType AS BillingDocumentType,
  P_GLE_ADB_GR_06.SalesOrganization AS SalesOrganization,
  P_GLE_ADB_GR_06.DistributionChannel AS DistributionChannel,
  P_GLE_ADB_GR_06.OrganizationDivision AS OrganizationDivision,
  P_GLE_ADB_GR_06.SoldProduct AS SoldProduct,
  P_GLE_ADB_GR_06.SoldProductGroup AS SoldProductGroup,
  P_GLE_ADB_GR_06.CustomerGroup AS CustomerGroup,
  P_GLE_ADB_GR_06.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLE_ADB_GR_06.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLE_ADB_GR_06.SalesDistrict AS SalesDistrict,
  P_GLE_ADB_GR_06.BillToParty AS BillToParty,
  P_GLE_ADB_GR_06.ShipToParty AS ShipToParty,
  P_GLE_ADB_GR_06.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  P_GLE_ADB_GR_06.CreationDateTime AS CreationDateTime,
  cast(P_GLE_ADB_GR_06.WBSElementInternalID as fis_wbsint_no_conv) AS WBSElementInternalID
FROM P_GLE_ADB_GR_06
;