P_GLE_ADB_GR_01

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_01.
-- 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_01
-- 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_01 AS
SELECT
  P_GLE_ADB_KFC_CAL.Ledger AS Ledger,
  P_GLE_ADB_KFC_CAL.SourceLedger AS SourceLedger,
  P_GLE_ADB_KFC_CAL.LedgerGLLineItem AS LedgerGLLineItem,
  P_GLE_ADB_KFC_CAL.CompanyCode AS CompanyCode,
  P_GLE_ADB_KFC_CAL.PartnerCompany AS PartnerCompany,
  P_GLE_ADB_KFC_CAL.PostingDate AS PostingDate,
  P_GLE_ADB_KFC_CAL.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_GLE_ADB_KFC_CAL.BaseUnit AS BaseUnit,
  P_GLE_ADB_KFC_CAL.FiscalYear AS gjahr,
  P_GLE_ADB_KFC_CAL.AccountingDocument AS AccountingDocument,
  P_GLE_ADB_KFC_CAL.PartnerBusinessArea AS PartnerBusinessArea,
  P_GLE_ADB_KFC_CAL.FinancialTransactionType AS FinancialTransactionType,
  P_GLE_ADB_KFC_CAL.FunctionalArea AS FunctionalArea,
  P_GLE_ADB_KFC_CAL.BusinessArea AS BusinessArea,
  P_GLE_ADB_KFC_CAL.CostCenter AS CostCenter,
  P_GLE_ADB_KFC_CAL.GLAccount AS GLAccount,
  P_GLE_ADB_KFC_CAL.ProfitCenter AS ProfitCenter,
  P_GLE_ADB_KFC_CAL.AccountingDocumentType AS AccountingDocumentType,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_T AS tsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_T AS tsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_T AS tsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_T AS tsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_H AS hsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_H AS hsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_H AS hsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_H AS hsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_K AS ksl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_K AS ksl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_K AS ksl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_K AS ksl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_O AS osl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_O AS osl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_O AS osl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_O AS osl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_V AS vsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_V AS vsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_V AS vsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_V AS vsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_B AS bsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_B AS bsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_B AS bsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_B AS bsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_C AS csl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_C AS csl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_C AS csl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_C AS csl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_D AS dsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_D AS dsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_D AS dsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_D AS dsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_E AS esl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_E AS esl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_E AS esl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_E AS esl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_F AS fsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_F AS fsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_F AS fsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_F AS fsl_y,
  P_GLE_ADB_KFC_CAL.M2DAvgBal_G AS gsl_m,
  P_GLE_ADB_KFC_CAL.Q2DAvgBal_G AS gsl_q,
  P_GLE_ADB_KFC_CAL.HY2DAvgBal_G AS gsl_h,
  P_GLE_ADB_KFC_CAL.Y2DAvgBal_G AS gsl_y,
  P_GLE_ADB_KFC_CAL.FiscalYear AS ReferenceFiscalYear,
  P_GLE_ADB_KFC_CAL.ReferenceDocumentType AS ReferenceDocumentType,
  P_GLE_ADB_KFC_CAL.CreationDateTime AS CreationDateTime,
  P_GLE_ADB_KFC_CAL.Segment AS Segment,
  I_CnsldtnUnit.ConsolidationDimension AS ConsolidationDimension,
  I_CnsldtnUnit.ConsolidationUnit AS ConsolidationUnit,
  I_CnsldtnVersion.ConsolidationVersion AS ConsolidationVersion,
  I_CnsldtnVersion.FSItemMappingVersion AS FSItemMappingVersion,
  I_CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  I_CnsldtnVersion.ConsolidationLedger AS ConsolidationLedger,
  I_CnsldtnUnitByTimeVersion.CnsldtnUnitGroupCrcySource AS CnsldtnUnitGroupCrcySource,
  I_CnsldtnUnitByTimeVersion.CnsldtnUnitLocalCrcySource AS CnsldtnUnitLocalCrcySource,
  I_CnsldtnVersion.GroupCurrency AS GroupCurrency,
  I_FiscalCalendarDate.FiscalPeriod AS FiscalPeriod,
  I_FiscalCalendarDate.FiscalYear AS FiscalYear,
  I_CnsldtnUnitByTimeVersion.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  P_GLE_ADB_KFC_CAL.AssignmentReference AS AssignmentReference,
  P_GLE_ADB_KFC_CAL.ControllingArea AS ControllingArea,
  P_GLE_ADB_KFC_CAL.PartnerCostCenter AS PartnerCostCenter,
  P_GLE_ADB_KFC_CAL.PartnerProfitCenter AS PartnerProfitCenter,
  P_GLE_ADB_KFC_CAL.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_GLE_ADB_KFC_CAL.PartnerSegment AS PartnerSegment,
  P_GLE_ADB_KFC_CAL.OrderID AS OrderID,
  P_GLE_ADB_KFC_CAL.Customer AS Customer,
  P_GLE_ADB_KFC_CAL.Supplier AS Supplier,
  P_GLE_ADB_KFC_CAL.Material AS Material,
  P_GLE_ADB_KFC_CAL.MaterialGroup AS MaterialGroup,
  P_GLE_ADB_KFC_CAL.Plant AS Plant,
  P_GLE_ADB_KFC_CAL.WBSElementExternalID AS WBSElementExternalID,
  P_GLE_ADB_KFC_CAL.Project AS Project,
  P_GLE_ADB_KFC_CAL.BillingDocumentType AS BillingDocumentType,
  P_GLE_ADB_KFC_CAL.SalesOrganization AS SalesOrganization,
  P_GLE_ADB_KFC_CAL.DistributionChannel AS DistributionChannel,
  P_GLE_ADB_KFC_CAL.OrganizationDivision AS OrganizationDivision,
  P_GLE_ADB_KFC_CAL.SoldProduct AS SoldProduct,
  P_GLE_ADB_KFC_CAL.SoldProductGroup AS SoldProductGroup,
  P_GLE_ADB_KFC_CAL.CustomerGroup AS CustomerGroup,
  P_GLE_ADB_KFC_CAL.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLE_ADB_KFC_CAL.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLE_ADB_KFC_CAL.SalesDistrict AS SalesDistrict,
  P_GLE_ADB_KFC_CAL.BillToParty AS BillToParty,
  P_GLE_ADB_KFC_CAL.ShipToParty AS ShipToParty,
  P_GLE_ADB_KFC_CAL.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  P_GLE_ADB_KFC_CAL.WBSElementInternalID AS WBSElementInternalID
FROM P_GLE_ADB_KFC_CAL
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnUnit_3 ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnUnitByTimeVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate ON /* join condition not captured in parsed metadata */
;