P_GR_StRpTrialBalanceItem

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

CREATE VIEW P_GR_StRpTrialBalanceItem AS
SELECT
  Item.Ledger AS Ledger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.SourceLedger AS SourceLedger,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.FiscalPeriod AS FiscalPeriod,
  Item.FiscalYearVariant AS FiscalYearVariant,
  Item.LedgerFiscalYear AS LedgerFiscalYear,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.IsReversal AS IsReversal,
  Item.IsReversed AS IsReversed,
  Item.ProfitCenter AS ProfitCenter,
  Item.FunctionalArea AS FunctionalArea,
  Item.BusinessArea AS BusinessArea,
  Item.ControllingArea AS ControllingArea,
  Item.Segment AS Segment,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Item._GLAccountInCompanyCode.ReconciliationAccountType AS ReconciliationAccountType,
  Item.Supplier AS Supplier,
  Item.Customer AS Customer,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.PostingKey AS PostingKey,
  Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.TaxCode AS TaxCode,
  Item.ReferenceDocument AS ReferenceDocument,
  Item._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.AssignmentReference AS AssignmentReference,
  Item.DocumentItemText AS DocumentItemText,
  Item._Supplier AS _Supplier,
  Item._Customer AS _Customer,
  Item._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  Item._ProfitCenter AS _ProfitCenter,
  Item._FunctionalArea AS _FunctionalArea,
  Item._BusinessArea AS _BusinessArea,
  Item._Segment AS _Segment,
  Item._AlternativeGLAccount AS _AlternativeGLAccount,
  Item._ControllingArea AS _ControllingArea,
  Item._CountryChartOfAccounts AS _CountryChartOfAccounts,
  Item._ChartOfAccounts AS _ChartOfAccounts,
  Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Item._Ledger AS _Ledger,
  Item._CompanyCode AS _CompanyCode,
  Item._AccountingDocumentType AS _AccountingDocumentType,
  Item._FiscalYear AS _FiscalYear,
  Item._SourceLedger AS _SourceLedger,
  Item._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  Item._FiscalYearVariant AS _FiscalYearVariant,
  Item._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  Item._FinancialAccountType AS _FinancialAccountType,
  Item._PostingKey AS _PostingKey,
  Item._SpecialGLCode AS _SpecialGLCode,
  Item._AccountingDocumentCategory AS _AccountingDocumentCategory,
  Item._DebitCreditCode AS _DebitCreditCode,
  Item._TaxCode AS _TaxCode,
  Item._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_GLAccountLineItem AS Item
;