I_TrsyAccountingItem

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 I_TrsyAccountingItem.
-- 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: ITRSYACCTITEM

CREATE VIEW I_TrsyAccountingItem AS
SELECT
  debit.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  debit.TreasuryValuationArea AS TreasuryValuationArea,
  debit.TreasuryTransactionFlow AS TreasuryTransactionFlow,
  debit.DebitGLAccount AS DebitGLAccount,
  debit.DebitCustomer AS DebitCustomer,
  debit.AccountingDocument AS AccountingDocument,
  debit.FiscalYear AS FiscalYear,
  debit.PostingDate AS PostingDate,
  debit.PostingFiscalPeriod AS PostingFiscalPeriod,
  debit.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  debit.ReferenceDocument AS ReferenceDocument,
  debit.ReferenceDocumentContext AS ReferenceDocumentContext,
  debit.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  debit.ReverseDocumentPostingDate AS ReverseDocumentPostingDate,
  debit.ReverseDocumentFiscalPeriod AS ReverseDocumentFiscalPeriod,
  cast( debit.ReverseDocument as stblg preserving type ) AS ReverseDocument,
  debit.ReversalReferenceDocument AS ReversalReferenceDocument,
  debit.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  credit.CreditGLAccount AS CreditGLAccount,
  credit.CreditCustomer AS CreditCustomer,
  diff.Fund AS Fund,
  diff.GrantID AS GrantID,
  diff.WBSElementInternalID AS WBSElementInternalID,
  diff.ProfitCenter AS ProfitCenter,
  diff.CostCenter AS CostCenter,
  diff.FunctionalArea AS FunctionalArea,
  diff.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  diff.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  diff.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  diff.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  diff.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  diff.TreasuryValuationClass AS TreasuryValuationClass,
  diff.DifferentiationPortfolio AS DifferentiationPortfolio,
  diff.CompanyCode AS CompanyCode
INNER JOIN I_TrsyAccountingItemCredit AS credit ON /* join condition not captured in parsed metadata */
INNER JOIN I_TrsyAcctItemPositionContext ON /* join condition not captured in parsed metadata */
INNER JOIN I_TreasuryPositionIdentifier AS diff ON /* join condition not captured in parsed metadata */
;