P_StRpTrialBalanceItem1

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

CREATE VIEW P_StRpTrialBalanceItem1 AS
SELECT
  Ledger,
  CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  FiscalYearVariant,
  LedgerFiscalYear,
  PostingDate,
  DocumentDate,
  IsReversal,
  IsReversed,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  GLAccount,
  _GLAccountInCompanyCode.ReconciliationAccountType AS ReconciliationAccountType,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  AccountingDocumentType,
  PostingKey,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  DebitCreditCode,
  TaxCode,
  case FinancialAccountType when 'K' then FinancialAccountType when 'D' then FinancialAccountType when ' ' then case _GLAccountInCompanyCode.ReconciliationAccountType when 'K' then _GLAccountInCompanyCode.ReconciliationAccountType when 'D' then _GLAccountInCompanyCode.ReconciliationAccountType else cast( ' ' as abap.char(1)) end else cast( ' ' as abap.char(1)) end as CashJournalItemType AS char1endasCashJournalItemType,
  cast ( case AccountingDocumentItem when '000' then case AccountingDocumentCategory when 'C' then cast( '3' as abap.char(1)) else cast( '2' as abap.char(1)) end else cast( '1' as abap.char(1)) end as glo_item_type ) as ItemType AS char1endasglo_item_typeasItemType,
  JrnlEntryItemMigrationSource,
  OffsettingAccount,
  OffsettingAccountType,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  AssignmentReference,
  DocumentItemText,
  ReferenceDocument
FROM I_GLAccountLineItem
LEFT OUTER JOIN P_DistinctDatetoFiscalYear ON /* join condition not captured in parsed metadata */
;