C_Trialbalanceq0002

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_Trialbalanceq0002.
-- 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.
-- Parameters: P_Language : sylangu, P_KeyDate : sydate, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to

CREATE VIEW C_Trialbalanceq0002 AS
SELECT
  lookupEntity: 'I_CalendarDate' AS lookupEntityI_CalendarDate,
  resultElement: 'FirstDayofMonthDate' AS resultElementFirstDayofMonthDate,
  resultElement: 'UserLocalDate' AS resultElementUserLocalDate,
  binding: [ { targetElement : 'UserID' , type : #SYSTEM_FIELD, value : '#USER' AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_ComprnFromPostingDate: $parameters.P_ComprnFromPostingDate AS P_ComprnFromPostingDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  GLAccountHierarchy,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_Language].GLAccountName as fis_racct_hierarchy_name preserving type ) AS GLAccountHierarchyName,
  PostingDate,
  FiscalYear,
  LedgerFiscalYear,
  SourceLedger,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessArea._Text[1:Language = $parameters.P_Language].BusinessAreaName AS BusinessAreaName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  Segment,
  _Segment._Text[1:Language = $parameters.P_Language].SegmentName AS SegmentName,
  PartnerCostCenter,
  _PartnerCostCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterName as SenderCostCenterName AS CostCenterNameasSenderCostCenterName,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  _PartnerFunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  _PartnerBusinessArea._Text[1:Language = $parameters.P_Language].BusinessAreaName AS PartnerBusinessAreaName,
  PartnerCompany,
  PartnerSegment,
  _PartnerSegment._Text[1:Language = $parameters.P_Language].SegmentName AS PartnerSegmentName,
  DebitCreditCode,
  _DebitCreditCode._Text[1:Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  FiscalYearVariant,
  FiscalYearPeriod,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1:Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AssignmentReference,
  PostingKey,
  _PostingKey._PostingKeyText[1:Language = $parameters.P_Language].PostingKeyName AS PostingKeyName,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  AccountingDocCreatedByUser,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  Material,
  Product,
  _Product._Text[1:Language = $parameters.P_Language].ProductName AS MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  FinancialAccountType,
  _FinancialAccountType._Text[1:Language = $parameters.P_Language].FinancialAccountTypeName AS FinancialAccountTypeName,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpclStockWBSElement,
  InvtrySpclStockWBSElmntExtID,
  InventorySpecialStockSupplier,
  _InventorySpecialStockSupplier.SupplierName AS InvtrySpecialStockSupplierName,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerWBSElementExternalID,
  PartnerProject,
  PartnerProjectExternalID,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  ProductGroup,
  _SoldProductGroup_2._ProductGroupText[1:Language = $parameters.P_Language].ProductGroupName AS MaterialGroupName,
  CustomerGroup,
  _CustomerGroup._Text[1:Language = $parameters.P_Language].CustomerGroupName AS CustomerGroupName,
  FinancialManagementArea,
  Fund,
  FundsCenter,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  CostCenter,
  _CostCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElement,
  WBSElementExternalID,
  Project,
  ProjectExternalID,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  ClearingDate,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearQuarter,
  FiscalYearWeek,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CorporateGroupAccount,
  CorporateGroupChartOfAccounts,
  IsBalanceSheetAccount,
  FlowOfFundsLedgerFiscalYear,
  cast( cast( 1 as abap.dec(23,2)) as fis_hsl_ui ) AS AmountInCompanyCodeCurrency,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_hsl_ui ) AS ComprnAmountInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_hsl ) AS DifferenceAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_hsl_ui ) AS CoCodeCrcyDifferencePct,
  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_comprn_start_bal_hsl_ui ) AS ComprnStartingBalInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_hsl ) AS StartingDiffAmtInCoCodeCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_hsl_ui ) AS CoCodeCrcyStartingDiffPct,
  AmountInCompanyCodeCurrency AS IntmdStrtBalAmtInCoCodeCrcy,
  ComprnAmountInCoCodeCrcy AS IntmdComprnStrtBalInCoCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy AS IntmdEndingBalAmtInCoCodeCrcy,
  1 AS EndingBalanceAmtInCoCodeCrcy,
  ComprnEndingBalInCoCodeCrcy AS IntmdOpeningBalAmtInCoCodeCrcy,
  1 AS ComprnEndingBalInCoCodeCrcy,
  ToPostingDate,
  ComprnToPostingDate,
  FiscalPeriodDate,
  ComprnFiscalPeriodDate,
  cast( cast( 1 as abap.dec(23,2)) as fis_ksl_ui ) AS AmountInGlobalCurrency,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_ksl_ui ) AS ComprnAmountInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_ksl ) AS DifferenceAmtInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_ksl_ui ) AS GlobalCrcyDifferencePct,
  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_comprn_start_bal_ksl_ui ) AS ComprnStartingBalInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_ksl ) AS StartingBalDiffAmtInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_ksl_ui ) AS GlobalCrcyStartingDiffPct,
  AmountInGlobalCurrency AS IntmdStrtgBalAmtInGlobalCrcy,
  ComprnAmountInGlobalCrcy AS IntmdComprnStrtgBalInGlobCrcy,
  EndingBalanceAmtInGlobalCrcy AS IntmdEndingBalAmtInGlobalCrcy,
  1 AS EndingBalanceAmtInGlobalCrcy,
  ComprnEndingBalInGlobalCrcy AS IntmdComprnEndBalInGlobalCrcy,
  1 AS ComprnEndingBalInGlobalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_fcsl_ui ) AS AmountInFunctionalCurrency,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_fcsl_ui ) AS ComprnAmountInFunctionalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_fcsl_ui ) AS DifferenceAmtInFunctionalCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_fcsl_ui ) AS FunctionalCrcyDifferencePct,
  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_comprn_start_bal_fcsl_ui ) AS ComprnStartingBalInFuncnlCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_fcsl_ui ) AS StartingBalDiffAmtInFuncnlCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_fcsl_ui ) AS FunctionalCrcyStartingDiffPct,
  AmountInFunctionalCurrency AS IntmdStrtgBalAmtInFuncnlCrcy,
  ComprnAmountInFunctionalCrcy AS IntmdComprnStrtgBalInFCrcy,
  EndingBalanceAmtInFuncnlCrcy AS IntmdEndingBalAmtInFuncnlCrcy,
  1 AS EndingBalanceAmtInFuncnlCrcy,
  ComprnEndingBalInFuncnlCrcy AS IntmdComprnEndBalInFuncnlCrcy,
  1 AS ComprnEndingBalInFuncnlCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_osl_ui ) AS AmountInFreeDefinedCurrency1,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_osl_ui ) AS ComprnAmountInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_osl_ui ) AS FreeDfndCrcy1DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_osl_ui ) AS StartingBalAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_osl_ui ) AS ComprnStrtgBalInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_osl ) AS StrtgBalDiffAmtInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_osl_ui ) AS FreeDfndCrcy1StartingDiffPct,
  AmountInFreeDefinedCurrency1 AS IntmdStrtgBalInFreeDfndCrcy1,
  ComprnAmountInFreeDfndCrcy1 AS IntmdComprnStrtgBalInFDCrcy1,
  EndingBalAmtInFreeDfndCrcy1 AS IntmdEndingBalInFreeDfndCrcy1,
  1 AS EndingBalAmtInFreeDfndCrcy1,
  ComprnEndingBalInFreeDfndCrcy1 AS IntmdComprnEndingBalInFDCrcy1,
  1 AS ComprnEndingBalInFreeDfndCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_vsl_ui ) AS AmountInFreeDefinedCurrency2,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_vsl_ui ) AS ComprnAmountInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_vsl ) AS DifferenceAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_vsl_ui ) AS FreeDfndCrcy2DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_vsl_ui ) AS StartingBalAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_vsl_ui ) AS ComprnStrtgBalInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_vsl ) AS StrtgBalDiffAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_vsl_ui ) AS FreeDfndCrcy2StartingDiffPct,
  AmountInFreeDefinedCurrency2 AS IntmdStrtgBalInFreeDfndCrcy2,
  ComprnAmountInFreeDfndCrcy2 AS IntmdComprnStrtgBalInFDCrcy2,
  EndingBalAmtInFreeDfndCrcy2 AS IntmdEndingBalInFreeDfndCrcy2,
  1 AS EndingBalAmtInFreeDfndCrcy2,
  ComprnEndingBalInFreeDfndCrcy2 AS IntmdComprnEndingBalInFDCrcy2,
  1 AS ComprnEndingBalInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_bsl_ui ) AS AmountInFreeDefinedCurrency3,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_bsl_ui ) AS ComprnAmountInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_bsl ) AS DifferenceAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_bsl ) AS FreeDfndCrcy3DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_bsl_ui ) AS StartingBalAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_bsl_ui ) AS ComprnStrtgBalInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_bsl ) AS StrtgBalDiffAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_bsl ) AS FreeDfndCrcy3StartingDiffPct,
  AmountInFreeDefinedCurrency3 AS IntmdStrtgBalInFreeDfndCrcy3,
  ComprnAmountInFreeDfndCrcy3 AS IntmdComprnStrtgBalInFDCrcy3,
  EndingBalAmtInFreeDfndCrcy3 AS IntmdEndingBalInFreeDfndCrcy3,
  1 AS EndingBalAmtInFreeDfndCrcy3,
  ComprnEndingBalInFreeDfndCrcy3 AS IntmdComprnEndingBalInFDCrcy3,
  1 AS ComprnEndingBalInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_csl_ui ) AS AmountInFreeDefinedCurrency4,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_csl_ui ) AS ComprnAmountInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_csl ) AS DifferenceAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_csl ) AS FreeDfndCrcy4DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_csl ) AS StartingBalAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_csl ) AS ComprnStrtgBalInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_csl ) AS StrtgBalDiffAmtInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_csl ) AS FreeDfndCrcy4StartingDiffPct,
  AmountInFreeDefinedCurrency4 AS IntmdStrtgBalInFreeDfndCrcy4,
  ComprnAmountInFreeDfndCrcy4 AS IntmdComprnStrtgBalInFDCrcy4,
  EndingBalAmtInFreeDfndCrcy4 AS IntmdEndingBalInFreeDfndCrcy4,
  1 AS EndingBalAmtInFreeDfndCrcy4,
  ComprnEndingBalInFreeDfndCrcy4 AS IntmdComprnEndingBalInFDCrcy4,
  1 AS ComprnEndingBalInFreeDfndCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_dsl_ui ) AS AmountInFreeDefinedCurrency5,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_dsl_ui ) AS ComprnAmountInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_dsl ) AS DifferenceAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_dsl ) AS FreeDfndCrcy5DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_dsl ) AS StartingBalAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_dsl ) AS ComprnStrtgBalInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_dsl ) AS StrtgBalDiffAmtInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_dsl ) AS FreeDfndCrcy5StartingDiffPct,
  AmountInFreeDefinedCurrency5 AS IntmdStrtgBalInFreeDfndCrcy5,
  ComprnAmountInFreeDfndCrcy5 AS IntmdComprnStrtgBalInFDCrcy5,
  EndingBalAmtInFreeDfndCrcy5 AS IntmdEndingBalInFreeDfndCrcy5,
  1 AS EndingBalAmtInFreeDfndCrcy5,
  ComprnEndingBalInFreeDfndCrcy5 AS IntmdComprnEndingBalInFDCrcy5,
  1 AS ComprnEndingBalInFreeDfndCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_esl_ui ) AS AmountInFreeDefinedCurrency6,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_esl_ui ) AS ComprnAmountInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_esl ) AS DifferenceAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_esl ) AS FreeDfndCrcy6DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_esl ) AS StartingBalAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_esl ) AS ComprnStrtgBalInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_esl ) AS StrtgBalDiffAmtInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_esl ) AS FreeDfndCrcy6StartingDiffPct,
  AmountInFreeDefinedCurrency6 AS IntmdStrtgBalInFreeDfndCrcy6,
  ComprnAmountInFreeDfndCrcy6 AS IntmdComprnStrtgBalInFDCrcy6,
  EndingBalAmtInFreeDfndCrcy6 AS IntmdEndingBalInFreeDfndCrcy6,
  1 AS EndingBalAmtInFreeDfndCrcy6,
  ComprnEndingBalInFreeDfndCrcy6 AS IntmdComprnEndingBalInFDCrcy6,
  1 AS ComprnEndingBalInFreeDfndCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_fsl_ui ) AS AmountInFreeDefinedCurrency7,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_fsl_ui ) AS ComprnAmountInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_fsl ) AS DifferenceAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_fsl_ui ) AS FreeDfndCrcy7DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_fsl_ui ) AS StartingBalAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_fsl_ui ) AS ComprnStrtgBalInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_fsl ) AS StrtgBalDiffAmtInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_fsl_ui ) AS FreeDfndCrcy7StartingDiffPct,
  AmountInFreeDefinedCurrency7 AS IntmdStrtgBalInFreeDfndCrcy7,
  ComprnAmountInFreeDfndCrcy7 AS IntmdComprnStrtgBalInFDCrcy7,
  EndingBalAmtInFreeDfndCrcy7 AS IntmdEndingBalInFreeDfndCrcy7,
  1 AS EndingBalAmtInFreeDfndCrcy7,
  ComprnEndingBalInFreeDfndCrcy7 AS IntmdComprnEndingBalInFDCrcy7,
  1 AS ComprnEndingBalInFreeDfndCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_gsl_ui ) AS AmountInFreeDefinedCurrency8,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_gsl_ui ) AS ComprnAmountInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_gsl ) AS DifferenceAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_gsl ) AS FreeDfndCrcy8DifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_gsl ) AS StartingBalAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_gsl ) AS ComprnStrtgBalInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_gsl ) AS StrtgBalDiffAmtInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_gsl ) AS FreeDfndCrcy8StartingDiffPct,
  AmountInFreeDefinedCurrency8 AS IntmdStrtgBalInFreeDfndCrcy8,
  ComprnAmountInFreeDfndCrcy8 AS IntmdComprnStrtgBalInFDCrcy8,
  EndingBalAmtInFreeDfndCrcy8 AS IntmdEndingBalInFreeDfndCrcy8,
  1 AS EndingBalAmtInFreeDfndCrcy8,
  ComprnEndingBalInFreeDfndCrcy8 AS IntmdComprnEndingBalInFDCrcy8,
  1 AS ComprnEndingBalInFreeDfndCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_tsl_ui ) AS AmountInBalanceTransacCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_tsl_ui ) AS ComprnAmountInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_tsl ) AS DifferenceAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_tsl_ui ) AS BalTransCrcyDifferencePct,
  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_comprn_start_bal_tsl_ui ) AS ComprnStrtgBalInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_tsl ) AS StrtgBalDiffAmtInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_tsl_ui ) AS BalTransCrcyStartingDiffPct,
  AmountInBalanceTransacCrcy AS IntmdStrtgBalInBalTransCrcy,
  ComprnAmountInBalTransCrcy AS IntmdComprnStrtgBalInBTCrcy,
  EndingBalanceAmtInBalTransCrcy AS IntmdEndingBalInBalTransCrcy,
  1 AS EndingBalanceAmtInBalTransCrcy,
  ComprnEndingBalInBalTransCrcy AS IntmdComprnEndingBalInBTCrcy,
  1 AS ComprnEndingBalInBalTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_wsl_ui ) AS AmountInTransactionCurrency,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_wsl_ui ) AS ComprnAmountInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_wsl ) AS DifferenceAmtInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_pct_wsl_ui ) AS TransCrcyDifferencePct,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_wsl_ui ) AS StartingBalAmtInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_comprn_start_bal_wsl_ui ) AS ComprnStrtgBalInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_bal_diff_wsl ) AS StartingBalDiffAmtInTransCrcy,
  cast( cast( 1 as abap.dec(23,2)) as fis_start_diff_pct_wsl_ui ) AS TransCrcyStartingDiffPct,
  AmountInTransactionCurrency AS IntmdStrtgBalAmtInTransCrcy,
  ComprnAmountInTransCrcy AS IntmdComprnStrtgBalInTransCrcy,
  EndingBalanceAmtInTransCrcy AS IntmdEndingBalInTransCrcy,
  1 AS EndingBalanceAmtInTransCrcy,
  ComprnEndingBalInTransCrcy AS IntmdComprnEndgBalInTransCrcy,
  1 AS ComprnEndingBalInTransCrcy
FROM I_GLAcctBalanceComprnCube
;