I_GLAcctBalanceCube

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 I_GLAcctBalanceCube.
-- 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: IFIGLBALCUBE
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW I_GLAcctBalanceCube AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountFlowType,
  FiscalPeriodDate,
  LedgerFiscalYear,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  GLAccount,
  GLAccountHierarchy,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  DebitCreditCode,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  AccountingDocumentType,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  Material,
  Product,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InvtrySpclStockWBSElmntExtID,
  cast(_InvtrySpclStockWBSElmntIntID.WBSElement as mlmat_ps_posid preserving type ) AS InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderCompanyCode,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  OriginProduct,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CustomerServiceNotification,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  CostCenter,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  WBSElementExternalID,
  cast( WBSElement as fis_wbs preserving type ) AS WBSElement,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  cast(Project as fis_project preserving type ) AS Project,
  I_GLAcctBalance.ProjectInternalID AS ProjectInternalID,
  I_GLAcctBalance.ProjectExternalID AS ProjectExternalID,
  I_GLAcctBalance.PartnerProjectInternalID AS PartnerProjectInternalID,
  I_GLAcctBalance.PartnerProjectExternalID AS PartnerProjectExternalID,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  ClearingDate,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  FiscalPeriod,
  EndingBalanceAmtInCoCodeCrcy,
  EndingBalanceAmtInTransCrcy,
  EndingBalanceAmtInBalTransCrcy,
  EndingBalanceAmtInGlobalCrcy,
  EndingBalanceAmtInFuncnlCrcy,
  EndingBalAmtInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy8,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualObjectLogicalSystem,
  AccrualReferenceObject,
  AccrualValueDate,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  FlowOfFundsLedgerFiscalYear,
  IsStatisticalCostCenter,
  IsStatisticalOrder,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.YearQuarter AS CalendarYearQuarter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.YearMonth AS CalendarYearMonth,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.YearWeek AS CalendarYearWeek,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  _FiscalPeriodForVariant.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalPeriodForVariant.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType,
  AssetClass
FROM I_GLAcctBalance
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem association[0..1] to I_GLAccountInChartOfAccounts as _CorporateGroupAccount on CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount association[0..1] to I_ChartOfAccounts as _CorporateGroupChartOfAccounts on CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts association[1..1] to I_CalendarMonth as _CalendarMonth on CalendarMonth = _CalendarMonth.CalendarMonth association[1..1] to I_CalendarQuarter as _CalendarQuarter on CalendarQuarter = _CalendarQuarter.CalendarQuarter association[1..1] to I_YearMonth as _CalendarYearMonth on CalendarYearMonth = _CalendarYearMonth.YearMonth association[0..1] to I_WBSElement as _WBSElement on WBSElement = _WBSElement.WBSElement  -- association [1..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElement as _InventorySpclStockWBSElement on InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement association[0..1] to I_Project as _Project on Project = _Project.Project association[0..1] to I_ProjectByInternalKey as _ProjectInternalID on ProjectInternalID = _ProjectInternalID.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant AND LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder = _PartnerOrder_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- association [0..1]
;