P_StRpTrialBalanceItem2

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_StRpTrialBalanceItem2.
-- 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: PTRIALBALITEM2
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW P_StRpTrialBalanceItem2 AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  FiscalYearVariant,
  LedgerFiscalYear,
  IsReversal,
  IsReversed,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  GLAccount,
  ReconciliationAccountType,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  AccountingDocumentType,
  PostingKey,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  DebitCreditCode,
  CashJournalItemType,
  ItemType,
  AssignmentReference,
  DocumentItemText,
  TaxCode,
  JrnlEntryItemMigrationSource,
  ReferenceDocument,
  OffsettingAccount,
  OffsettingAccountType,
  case $parameters.P_FromFiscalPeriod when '000' then 'X' else case when FiscalPeriod <= $parameters.P_ToFiscalPeriod then 'X' else cast( ' ' as abap.char(1)) end end as IsSelected AS char1endendasIsSelected,
  CompanyCodeCurrency,
  TransactionCurrency,
  BalanceTransactionCurrency,
  GlobalCurrency,
  case FiscalPeriod when '000' then cast( '0' as abap.curr( 23,2)) else case $parameters.P_FromFiscalPeriod when '000' then case when PostingDate >= $parameters.P_FromPostingDate and PostingDate <= $parameters.P_ToPostingDate then AmountInGlobalCurrency else cast( '0' as abap.curr( 23,2)) end else case when FiscalPeriod >= $parameters.P_FromFiscalPeriod and FiscalPeriod <= $parameters.P_ToFiscalPeriod then AmountInGlobalCurrency else cast( '0' as abap.curr( 23,2)) end end end as AmountInGlobalCurrency AS curr232endendendasAmountInGlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8
FROM P_StRpTrialBalanceItem1
;