C_CO_UGPPTrialBalanceItemQ

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_CO_UGPPTrialBalanceItemQ.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FinancialStatementVariant : versn_011, P_Ledger : fins_ledger, P_CompanyCode : fis_bukrs, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_CO_UGPPTrialBalanceItemQ AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  HierarchyNode,
  Ledger,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalYear,
  ChartOfAccounts,
  GLAccount,
  CO_UGPPGLAccountCategory,
  ValidityEndDate,
  GLAccountLongName,
  BusinessPartnerName,
  BPTaxNumber,
  CompanyCodeCurrency,
  StartingBalanceAmtInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy,
  TransactionCurrency,
  StartingBalanceAmtInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  EndingBalanceAmtInTransCrcy,
  GlobalCurrency,
  StartingBalanceAmtInGlobalCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  EndingBalanceAmtInGlobalCrcy,
  ReportingCurrency,
  StartingBalanceAmtInRptgCrcy,
  DebitAmountInReportingCurrency,
  CreditAmountInReportingCrcy,
  EndingBalanceAmtInRptgCrcy,
  FreeDefinedCurrency1,
  StrtgBalAmtInFreeDfndCrcy1,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy1,
  FreeDefinedCurrency2,
  StrtgBalAmtInFreeDfndCrcy2,
  DebitAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy2,
  FreeDefinedCurrency3,
  StrtgBalAmtInFreeDfndCrcy3,
  DebitAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy3,
  FreeDefinedCurrency4,
  StrtgBalAmtInFreeDfndCrcy4,
  DebitAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy4,
  FreeDefinedCurrency5,
  StrtgBalAmtInFreeDfndCrcy5,
  DebitAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy5,
  FreeDefinedCurrency6,
  StrtgBalAmtInFreeDfndCrcy6,
  DebitAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy6,
  FreeDefinedCurrency7,
  StrtgBalAmtInFreeDfndCrcy7,
  DebitAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy7,
  FreeDefinedCurrency8,
  StrtgBalAmtInFreeDfndCrcy8,
  DebitAmountInFreeDfndCrcy8,
  CreditAmountInFreeDfndCrcy8,
  EndingBalAmtInFreeDfndCrcy8
FROM C_CO_UGPPTrialBalanceItemC
;