C_PL_StRpCustTrialBalItmQuery

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

CREATE VIEW C_PL_StRpCustTrialBalItmQuery AS
SELECT
  Ledger,
  CompanyCode,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  ItemType,
  Customer,
  _Customer.BPCustomerName AS CustomerName,
  GLAccount,
  GLAccountLongName,
  Supplier,
  FinancialAccountType,
  SpecialGLCode,
  AccountingDocumentType,
  PostingKey,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  DebitCreditCode,
  CompanyCodeCurrency,
  cast( 1 as glo_dr_cfwd_bal_hsl ) AS DebitCarryFwdBalAmtInCCCrcy,
  cast( 1 as glo_cr_cfwd_bal_hsl ) AS CreditCarryFwdBalAmtInCCCrcy,
  DebitPrevPeriodYTDAmtInCCCrcy,
  CreditPrevPeriodYTDAmtInCCCrcy,
  cast( 1 as glo_dr_strt_bal_hsl ) AS DebitStartingBalAmtInCCCrcy,
  cast( 1 as glo_cr_strt_bal_hsl ) AS CreditStartingBalAmtInCCCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  YTDDebitAmtInCoCodeCrcy,
  YTDCrdtAmtInCoCodeCrcy,
  cast( 1 as glo_dr_end_bal_hsl ) AS DebitEndingBalAmtInCCCrcy,
  cast( 1 as glo_cr_end_bal_hsl ) AS CreditEndingBalAmtInCCCrcy,
  AssignmentReference,
  DocumentItemText,
  TransactionCurrency,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM I_StRpTrialBalanceItemCube
;