C_Trialbalanceq0001

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_Trialbalanceq0001.
-- 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

CREATE VIEW C_Trialbalanceq0001 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,
  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,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerWBSElementExternalID,
  PartnerProject,
  PartnerProjectExternalID,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContract,
  ServiceContractType,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  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,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BalanceTransactionCurrency,
  TransactionCurrency,
  FiscalPeriodDate,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearQuarter,
  FiscalYearWeek,
  CorporateGroupAccount,
  CorporateGroupChartOfAccounts,
  IsBalanceSheetAccount,
  FlowOfFundsLedgerFiscalYear,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  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,
  EndingBalanceAmtInCoCodeCrcy AS IntmdEndingBalAmtInCoCodeCrcy,
  DebitAmountInCoCodeCrcy AS GLAcctDebitAmtInCoCodeCrcy,
  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,
  EndingBalanceAmtInGlobalCrcy AS IntmdEndingBalAmtInGlobalCrcy,
  DebitAmountInGlobalCrcy AS IntmdDebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy AS IntmdCreditAmountInGlobalCrcy,
  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,
  EndingBalanceAmtInFuncnlCrcy AS IntmdEndingBalAmtInFuncnlCrcy,
  DebitAmountInFunctionalCrcy AS IntmdDebitAmountInFuncnlCrcy,
  CreditAmountInFunctionalCrcy AS IntmdCreditAmountInFuncnlCrcy,
  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_dr_bal_osl ) AS DebitAmountInFreeDefinedCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_osl ) AS CreditAmountInFreeDefinedCrcy1,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_osl_ui ) AS EndingBalAmtInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy1 AS IntmdEndingBalInFreeDfndCrcy1,
  DebitAmountInFreeDefinedCrcy1 AS IntmdDebitAmtInFreeDfndCrcy1,
  CreditAmountInFreeDefinedCrcy1 AS IntmdCreditAmtInFreeDfndCrcy1,
  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_dr_bal_vsl ) AS DebitAmountInFreeDefinedCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_vsl ) AS CreditAmountInFreeDefinedCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_vsl_ui ) AS EndingBalAmtInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy2 AS IntmdEndingBalInFreeDfndCrcy2,
  DebitAmountInFreeDefinedCrcy2 AS IntmdDebitAmtInFreeDfndCrcy2,
  CreditAmountInFreeDefinedCrcy2 AS IntmdCreditAmtInFreeDfndCrcy2,
  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_dr_bal_bsl ) AS DebitAmountInFreeDefinedCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_bsl ) AS CreditAmountInFreeDefinedCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_bsl_ui ) AS EndingBalAmtInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy3 AS IntmdEndingBalInFreeDfndCrcy3,
  DebitAmountInFreeDefinedCrcy3 AS IntmdDebitAmtInFreeDfndCrcy3,
  CreditAmountInFreeDefinedCrcy3 AS IntmdCreditAmtInFreeDfndCrcy3,
  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_dr_bal_csl ) AS DebitAmountInFreeDefinedCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_csl ) AS CreditAmountInFreeDefinedCrcy4,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_csl_ui ) AS EndingBalAmtInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy4 AS IntmdEndingBalInFreeDfndCrcy4,
  DebitAmountInFreeDefinedCrcy4 AS IntmdDebitAmtInFreeDfndCrcy4,
  CreditAmountInFreeDefinedCrcy4 AS IntmdCreditAmtInFreeDfndCrcy4,
  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_dr_bal_dsl ) AS DebitAmountInFreeDefinedCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_dsl ) AS CreditAmountInFreeDefinedCrcy5,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_dsl_ui ) AS EndingBalAmtInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy5 AS IntmdEndingBalInFreeDfndCrcy5,
  DebitAmountInFreeDefinedCrcy5 AS IntmdDebitAmtInFreeDfndCrcy5,
  CreditAmountInFreeDefinedCrcy5 AS IntmdCreditAmtInFreeDfndCrcy5,
  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_dr_bal_esl ) AS DebitAmountInFreeDefinedCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_esl ) AS CreditAmountInFreeDefinedCrcy6,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_esl_ui ) AS EndingBalAmtInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy6 AS IntmdEndingBalInFreeDfndCrcy6,
  DebitAmountInFreeDefinedCrcy6 AS IntmdDebitAmtInFreeDfndCrcy6,
  CreditAmountInFreeDefinedCrcy6 AS IntmdCreditAmtInFreeDfndCrcy6,
  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_dr_bal_fsl ) AS DebitAmountInFreeDefinedCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_fsl ) AS CreditAmountInFreeDefinedCrcy7,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_fsl_ui ) AS EndingBalAmtInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy7 AS IntmdEndingBalInFreeDfndCrcy7,
  DebitAmountInFreeDefinedCrcy7 AS IntmdDebitAmtInFreeDfndCrcy7,
  CreditAmountInFreeDefinedCrcy7 AS IntmdCreditAmtInFreeDfndCrcy7,
  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_dr_bal_gsl ) AS DebitAmountInFreeDefinedCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_cr_bal_gsl ) AS CreditAmountInFreeDefinedCrcy8,
  cast( cast( 1 as abap.dec(23,2)) as fis_end_bal_gsl_ui ) AS EndingBalAmtInFreeDfndCrcy8,
  EndingBalAmtInFreeDfndCrcy8 AS IntmdEndingBalInFreeDfndCrcy8,
  DebitAmountInFreeDefinedCrcy8 AS IntmdDebitAmtInFreeDfndCrcy8,
  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,
  EndingBalanceAmtInBalTransCrcy AS IntmdEndingBalInBalTransCrcy,
  DebitAmountInBalanceTransCrcy AS IntmdDebitAmtInBalTransCrcy,
  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,
  EndingBalanceAmtInTransCrcy AS IntmdEndingBalanceInTransCrcy,
  DebitAmountInTransCrcy AS IntmdDebitAmtInTransCrcy,
  CreditAmountInTransCrcy AS IntmdCreditAmountInTransCrcy
FROM I_GLAcctBalanceCube
;