C_TrialBalance

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 C_TrialBalance.
-- 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: CFITRIALBALANCE
-- Parameters: P_Language : sylangu, P_KeyDate : sydate, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW C_TrialBalance AS
SELECT
  lookupEntity: 'I_CalendarDate' AS lookupEntityI_CalendarDate,
  resultElement: 'FirstDayofMonthDate' AS resultElementFirstDayofMonthDate,
  resultElement: 'CalendarDate' AS resultElementCalendarDate,
  binding: [ { targetElement : 'CalendarDate' , type : #PARAMETER, value : 'P_KeyDate' AS P_FromPostingDate,
  I_GLAcctBalanceCube.CompanyCode AS CompanyCode,
  I_GLAcctBalanceCube._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_GLAcctBalanceCube.GLAccount AS GLAccount,
  cast(I_GLAcctBalanceCube.GLAccountHierarchy as racct) AS GLAccountHierarchy,
  I_GLAcctBalanceCube._GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_Language].GLAccountName AS GLAccountHierarchyName,
  cast( I_GLAcctBalanceCube.PostingDate as budat preserving type ) AS PostingDate,
  I_GLAcctBalanceCube.FiscalYear AS FiscalYear,
  I_GLAcctBalanceCube.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAcctBalanceCube.FinancialTransactionType AS FinancialTransactionType,
  I_GLAcctBalanceCube.BusinessTransactionType AS BusinessTransactionType,
  I_GLAcctBalanceCube.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAcctBalanceCube.LogicalSystem AS LogicalSystem,
  I_GLAcctBalanceCube.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAcctBalanceCube.IsReversal AS IsReversal,
  I_GLAcctBalanceCube.IsReversed AS IsReversed,
  I_GLAcctBalanceCube.IsSettlement AS IsSettlement,
  I_GLAcctBalanceCube.IsSettled AS IsSettled,
  I_GLAcctBalanceCube.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAcctBalanceCube.ProfitCenter AS ProfitCenter,
  I_GLAcctBalanceCube._ProfitCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  I_GLAcctBalanceCube.FunctionalArea AS FunctionalArea,
  I_GLAcctBalanceCube._FunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  I_GLAcctBalanceCube.BusinessArea AS BusinessArea,
  I_GLAcctBalanceCube._BusinessArea._Text[1:Language = $parameters.P_Language].BusinessAreaName AS BusinessAreaName,
  I_GLAcctBalanceCube.ControllingArea AS ControllingArea,
  I_GLAcctBalanceCube._ControllingArea.ControllingAreaName AS ControllingAreaName,
  I_GLAcctBalanceCube.Segment AS Segment,
  I_GLAcctBalanceCube._Segment._Text[1:Language = $parameters.P_Language].SegmentName AS SegmentName,
  I_GLAcctBalanceCube.PartnerCostCenter AS PartnerCostCenter,
  I_GLAcctBalanceCube.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAcctBalanceCube.PartnerFunctionalArea AS PartnerFunctionalArea,
  cast( I_GLAcctBalanceCube._PartnerFunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName as fis_pfkbtx preserving type ) AS PartnerFunctionalAreaName,
  I_GLAcctBalanceCube.PartnerBusinessArea AS PartnerBusinessArea,
  cast( I_GLAcctBalanceCube._PartnerBusinessArea._Text[1:Language = $parameters.P_Language].BusinessAreaName as fis_partner_gtext_vdm preserving type ) AS PartnerBusinessAreaName,
  I_GLAcctBalanceCube.PartnerCompany AS PartnerCompany,
  I_GLAcctBalanceCube.PartnerSegment AS PartnerSegment,
  cast( I_GLAcctBalanceCube._PartnerSegment._Text[1:Language = $parameters.P_Language].SegmentName as fis_partner_segment_name preserving type ) AS PartnerSegmentName,
  I_GLAcctBalanceCube.DebitCreditCode AS DebitCreditCode,
  I_GLAcctBalanceCube._DebitCreditCode._Text[1:Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  I_GLAcctBalanceCube.FiscalYearVariant AS FiscalYearVariant,
  I_GLAcctBalanceCube.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAcctBalanceCube.FiscalPeriod AS FiscalPeriod,
  I_GLAcctBalanceCube.AccountingDocumentType AS AccountingDocumentType,
  I_GLAcctBalanceCube._AccountingDocumentType._Text[1:Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  I_GLAcctBalanceCube.AssignmentReference AS AssignmentReference,
  I_GLAcctBalanceCube.PostingKey AS PostingKey,
  I_GLAcctBalanceCube._PostingKey._PostingKeyText[1:Language = $parameters.P_Language].PostingKeyName AS PostingKeyName,
  I_GLAcctBalanceCube.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAcctBalanceCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAcctBalanceCube.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAcctBalanceCube.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAcctBalanceCube.OriginObjectType AS OriginObjectType,
  I_GLAcctBalanceCube.GLAccountType AS GLAccountType,
  I_GLAcctBalanceCube.ChartOfAccounts AS ChartOfAccounts,
  I_GLAcctBalanceCube.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAcctBalanceCube.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAcctBalanceCube.PurchasingDocument AS PurchasingDocument,
  I_GLAcctBalanceCube.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAcctBalanceCube.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAcctBalanceCube.Material AS Material,
  I_GLAcctBalanceCube.Product AS Product,
  I_GLAcctBalanceCube._Product._Text[1:Language = $parameters.P_Language].ProductName AS MaterialName,
  I_GLAcctBalanceCube.Plant AS Plant,
  I_GLAcctBalanceCube._Plant.PlantName AS PlantName,
  I_GLAcctBalanceCube.Supplier AS Supplier,
  I_GLAcctBalanceCube._Supplier.SupplierName AS SupplierName,
  I_GLAcctBalanceCube.Customer AS Customer,
  I_GLAcctBalanceCube._Customer.CustomerName AS CustomerName,
  I_GLAcctBalanceCube.FinancialAccountType AS FinancialAccountType,
  I_GLAcctBalanceCube._FinancialAccountType._Text[1:Language = $parameters.P_Language].FinancialAccountTypeName AS FinancialAccountTypeName,
  I_GLAcctBalanceCube.SpecialGLCode AS SpecialGLCode,
  I_GLAcctBalanceCube.TaxCode AS TaxCode,
  I_GLAcctBalanceCube.HouseBank AS HouseBank,
  I_GLAcctBalanceCube.HouseBankAccount AS HouseBankAccount,
  I_GLAcctBalanceCube.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAcctBalanceCube.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAcctBalanceCube.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_GLAcctBalanceCube.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAcctBalanceCube.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_GLAcctBalanceCube.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAcctBalanceCube.MasterFixedAsset AS MasterFixedAsset,
  I_GLAcctBalanceCube.FixedAsset AS FixedAsset,
  I_GLAcctBalanceCube.AssetValueDate AS AssetValueDate,
  I_GLAcctBalanceCube.AssetTransactionType AS AssetTransactionType,
  I_GLAcctBalanceCube.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAcctBalanceCube.GroupFixedAsset AS GroupFixedAsset,
  I_GLAcctBalanceCube.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAcctBalanceCube.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  I_GLAcctBalanceCube.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAcctBalanceCube.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAcctBalanceCube.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAcctBalanceCube.InventorySpclStockWBSElement AS InventorySpclStockWBSElement,
  I_GLAcctBalanceCube.InvtrySpclStockWBSElmntExtID AS InvtrySpclStockWBSElmntExtID,
  I_GLAcctBalanceCube.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAcctBalanceCube.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  cast( I_GLAcctBalanceCube._InventorySpecialStockSupplier.SupplierName as fis_mlmat_lifnr_name preserving type ) AS InvtrySpecialStockSupplierName,
  I_GLAcctBalanceCube.InventoryValuationType AS InventoryValuationType,
  I_GLAcctBalanceCube.ValuationArea AS ValuationArea,
  I_GLAcctBalanceCube.SenderGLAccount AS SenderGLAccount,
  I_GLAcctBalanceCube.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAcctBalanceCube.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAcctBalanceCube.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAcctBalanceCube.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAcctBalanceCube.OffsettingAccount AS OffsettingAccount,
  I_GLAcctBalanceCube.OffsettingAccountType AS OffsettingAccountType,
  I_GLAcctBalanceCube.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAcctBalanceCube.PersonnelNumber AS PersonnelNumber,
  I_GLAcctBalanceCube.ControllingObjectClass AS ControllingObjectClass,
  I_GLAcctBalanceCube.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAcctBalanceCube.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAcctBalanceCube.OriginCostCenter AS OriginCostCenter,
  I_GLAcctBalanceCube.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAcctBalanceCube.AccountAssignment AS AccountAssignment,
  I_GLAcctBalanceCube.AccountAssignmentType AS AccountAssignmentType,
  I_GLAcctBalanceCube.ProjectNetwork AS ProjectNetwork,
  I_GLAcctBalanceCube.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAcctBalanceCube.BusinessProcess AS BusinessProcess,
  I_GLAcctBalanceCube.CostObject AS CostObject,
  I_GLAcctBalanceCube.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAcctBalanceCube.OperatingConcern AS OperatingConcern,
  I_GLAcctBalanceCube.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAcctBalanceCube.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAcctBalanceCube.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAcctBalanceCube.PartnerOrder AS PartnerOrder,
  I_GLAcctBalanceCube.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAcctBalanceCube.PartnerWBSElement AS PartnerWBSElement,
  cast( I_GLAcctBalanceCube._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  I_GLAcctBalanceCube.PartnerProject AS PartnerProject,
  cast( I_GLAcctBalanceCube._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  I_GLAcctBalanceCube.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAcctBalanceCube.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAcctBalanceCube.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAcctBalanceCube.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAcctBalanceCube.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAcctBalanceCube.PartnerCostObject AS PartnerCostObject,
  I_GLAcctBalanceCube.BillingDocumentType AS BillingDocumentType,
  I_GLAcctBalanceCube.SalesOrganization AS SalesOrganization,
  I_GLAcctBalanceCube.DistributionChannel AS DistributionChannel,
  I_GLAcctBalanceCube.OrganizationDivision AS OrganizationDivision,
  I_GLAcctBalanceCube.SoldMaterial AS SoldMaterial,
  I_GLAcctBalanceCube.SoldProduct AS SoldProduct,
  I_GLAcctBalanceCube.MaterialGroup AS MaterialGroup,
  I_GLAcctBalanceCube.SoldProductGroup AS SoldProductGroup,
  I_GLAcctBalanceCube.ProductGroup AS ProductGroup,
  I_GLAcctBalanceCube._SoldProductGroup_2._ProductGroupText[1:Language = $parameters.P_Language].ProductGroupName AS MaterialGroupName,
  I_GLAcctBalanceCube.CustomerGroup AS CustomerGroup,
  I_GLAcctBalanceCube._CustomerGroup._Text[1:Language = $parameters.P_Language].CustomerGroupName AS CustomerGroupName,
  I_GLAcctBalanceCube.FinancialManagementArea AS FinancialManagementArea,
  I_GLAcctBalanceCube.Fund AS Fund,
  I_GLAcctBalanceCube.GrantID AS GrantID,
  I_GLAcctBalanceCube.BudgetPeriod AS BudgetPeriod,
  I_GLAcctBalanceCube.PartnerFund AS PartnerFund,
  I_GLAcctBalanceCube.PartnerGrant AS PartnerGrant,
  I_GLAcctBalanceCube.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAcctBalanceCube.JointVenture AS JointVenture,
  I_GLAcctBalanceCube.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAcctBalanceCube.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAcctBalanceCube.JointVentureEquityType AS JointVentureEquityType,
  I_GLAcctBalanceCube.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAcctBalanceCube.CostCenter AS CostCenter,
  I_GLAcctBalanceCube._CostCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  I_GLAcctBalanceCube.CostCtrActivityType AS CostCtrActivityType,
  I_GLAcctBalanceCube.OrderID AS OrderID,
  I_GLAcctBalanceCube.OrderCategory AS OrderCategory,
  I_GLAcctBalanceCube.WBSElement AS WBSElement,
  I_GLAcctBalanceCube.WBSElementExternalID AS WBSElementExternalID,
  I_GLAcctBalanceCube.Project AS Project,
  I_GLAcctBalanceCube.ProjectExternalID AS ProjectExternalID,
  I_GLAcctBalanceCube.SalesOrder AS SalesOrder,
  I_GLAcctBalanceCube.SalesOrderItem AS SalesOrderItem,
  I_GLAcctBalanceCube.SalesDocument AS SalesDocument,
  I_GLAcctBalanceCube.SalesDocumentItem AS SalesDocumentItem,
  I_GLAcctBalanceCube.ClearingDate AS ClearingDate,
  I_GLAcctBalanceCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAcctBalanceCube.GlobalCurrency AS GlobalCurrency,
  I_GLAcctBalanceCube.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAcctBalanceCube.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAcctBalanceCube.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAcctBalanceCube.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAcctBalanceCube.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAcctBalanceCube.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAcctBalanceCube.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAcctBalanceCube.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAcctBalanceCube.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAcctBalanceCube.TransactionCurrency AS TransactionCurrency,
  I_GLAcctBalanceCube.FiscalPeriodDate AS FiscalPeriodDate,
  I_GLAcctBalanceCube.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  I_GLAcctBalanceCube.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  I_GLAcctBalanceCube.CalendarYear AS CalendarYear,
  I_GLAcctBalanceCube.CalendarQuarter AS CalendarQuarter,
  I_GLAcctBalanceCube.CalendarYearQuarter AS CalendarYearQuarter,
  I_GLAcctBalanceCube.CalendarMonth AS CalendarMonth,
  I_GLAcctBalanceCube.CalendarYearMonth AS CalendarYearMonth,
  I_GLAcctBalanceCube.CalendarWeek AS CalendarWeek,
  I_GLAcctBalanceCube.CalendarYearWeek AS CalendarYearWeek,
  I_GLAcctBalanceCube.FiscalQuarter AS FiscalQuarter,
  I_GLAcctBalanceCube.FiscalWeek AS FiscalWeek,
  I_GLAcctBalanceCube.FiscalYearQuarter AS FiscalYearQuarter,
  I_GLAcctBalanceCube.FiscalYearWeek AS FiscalYearWeek,
  I_GLAcctBalanceCube.CorporateGroupAccount AS CorporateGroupAccount,
  I_GLAcctBalanceCube.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  I_GLAcctBalanceCube.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_hsl_ui ) AS StartingBalanceAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_hsl ) AS DebitAmountInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_hsl ) AS CreditAmountInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_hsl_ui ) AS EndingBalanceAmtInCoCodeCrcy,
  I_GLAcctBalanceCube.EndingBalanceAmtInCoCodeCrcy AS IntmdEndingBalAmtInCoCodeCrcy,
  I_GLAcctBalanceCube.DebitAmountInCoCodeCrcy AS GLAcctDebitAmtInCoCodeCrcy,
  I_GLAcctBalanceCube.CreditAmountInCoCodeCrcy AS GLAcctCreditAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_ksl_ui ) AS StartingBalanceAmtInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_ksl ) AS DebitAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_ksl ) AS CreditAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_ksl_ui ) AS EndingBalanceAmtInGlobalCrcy,
  I_GLAcctBalanceCube.EndingBalanceAmtInGlobalCrcy AS IntmdEndingBalAmtInGlobalCrcy,
  I_GLAcctBalanceCube.DebitAmountInGlobalCrcy AS IntmdDebitAmountInGlobalCrcy,
  I_GLAcctBalanceCube.CreditAmountInGlobalCrcy AS IntmdCreditAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_osl_ui ) AS StrtgBalAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_osl ) AS DebitAmountInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_osl ) AS CreditAmountInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_osl_ui ) AS EndingBalAmtInFreeDfndCrcy1,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy1 AS IntmdEndingBalInFreeDfndCrcy1,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy1 AS IntmdDebitAmtInFreeDfndCrcy1,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy1 AS IntmdCreditAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_vsl_ui ) AS StrtgBalAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_vsl ) AS DebitAmountInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_vsl ) AS CreditAmountInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_vsl_ui ) AS EndingBalAmtInFreeDfndCrcy2,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy2 AS IntmdEndingBalInFreeDfndCrcy2,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy2 AS IntmdDebitAmtInFreeDfndCrcy2,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy2 AS IntmdCreditAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_bsl_ui ) AS StrtgBalAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_bsl ) AS DebitAmountInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_bsl ) AS CreditAmountInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_bsl_ui ) AS EndingBalAmtInFreeDfndCrcy3,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy3 AS IntmdEndingBalInFreeDfndCrcy3,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy3 AS IntmdDebitAmtInFreeDfndCrcy3,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy3 AS IntmdCreditAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_csl ) AS StrtgBalAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_csl ) AS DebitAmountInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_csl ) AS CreditAmountInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_csl_ui ) AS EndingBalAmtInFreeDfndCrcy4,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy4 AS IntmdEndingBalInFreeDfndCrcy4,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy4 AS IntmdDebitAmtInFreeDfndCrcy4,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy4 AS IntmdCreditAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_dsl ) AS StrtgBalAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_dsl ) AS DebitAmountInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_dsl ) AS CreditAmountInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_dsl_ui ) AS EndingBalAmtInFreeDfndCrcy5,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy5 AS IntmdEndingBalInFreeDfndCrcy5,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy5 AS IntmdDebitAmtInFreeDfndCrcy5,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy5 AS IntmdCreditAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_esl ) AS StrtgBalAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_esl ) AS DebitAmountInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_esl ) AS CreditAmountInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_esl_ui ) AS EndingBalAmtInFreeDfndCrcy6,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy6 AS IntmdEndingBalInFreeDfndCrcy6,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy6 AS IntmdDebitAmtInFreeDfndCrcy6,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy6 AS IntmdCreditAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_fsl_ui ) AS StrtgBalAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_fsl ) AS DebitAmountInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_fsl ) AS CreditAmountInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_fsl_ui ) AS EndingBalAmtInFreeDfndCrcy7,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy7 AS IntmdEndingBalInFreeDfndCrcy7,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy7 AS IntmdDebitAmtInFreeDfndCrcy7,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy7 AS IntmdCreditAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_gsl ) AS StrtgBalAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_gsl ) AS DebitAmountInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_gsl ) AS CreditAmountInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_gsl_ui ) AS EndingBalAmtInFreeDfndCrcy8,
  I_GLAcctBalanceCube.EndingBalAmtInFreeDfndCrcy8 AS IntmdEndingBalInFreeDfndCrcy8,
  I_GLAcctBalanceCube.DebitAmountInFreeDefinedCrcy8 AS IntmdDebitAmtInFreeDfndCrcy8,
  I_GLAcctBalanceCube.CreditAmountInFreeDefinedCrcy8 AS IntmdCreditAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_tsl_ui ) AS StartingBalAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_tsl ) AS DebitAmountInBalanceTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_tsl ) AS CreditAmountInBalanceTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_tsl_ui ) AS EndingBalanceAmtInBalTransCrcy,
  I_GLAcctBalanceCube.EndingBalanceAmtInBalTransCrcy AS IntmdEndingBalInBalTransCrcy,
  I_GLAcctBalanceCube.DebitAmountInBalanceTransCrcy AS IntmdDebitAmtInBalTransCrcy,
  I_GLAcctBalanceCube.CreditAmountInBalanceTransCrcy AS IntmdCreditAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_wsl_ui ) AS StartingBalanceAmtInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_bal_wsl ) AS DebitAmountInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_wsl ) AS CreditAmountInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_wsl_ui ) AS EndingBalanceAmtInTransCrcy,
  I_GLAcctBalanceCube.EndingBalanceAmtInTransCrcy AS IntmdEndingBalanceInTransCrcy,
  I_GLAcctBalanceCube.DebitAmountInTransCrcy AS IntmdDebitAmtInTransCrcy,
  I_GLAcctBalanceCube.CreditAmountInTransCrcy AS IntmdCreditAmountInTransCrcy,
  I_GLAcctBalanceCube.FunctionalCurrency AS FunctionalCurrency,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_fcsl_ui ) AS StartingBalanceAmtInFuncnlCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_dr_amt_funccrcy ) AS DebitAmountInFunctionalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_amt_funccrcy ) AS CreditAmountInFunctionalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_fcsl_ui ) AS EndingBalanceAmtInFuncnlCrcy,
  I_GLAcctBalanceCube.EndingBalanceAmtInFuncnlCrcy AS IntmdEndingBalAmtInFuncnlCrcy,
  I_GLAcctBalanceCube.DebitAmountInFunctionalCrcy AS IntmdDebitAmountInFuncnlCrcy,
  I_GLAcctBalanceCube.CreditAmountInFunctionalCrcy AS IntmdCreditAmountInFuncnlCrcy
FROM I_GLAcctBalanceCube
;