I_TrsyAccountingItemDebit

DDL: I_TRSYACCOUNTINGITEMDEBIT SQL: ITRSYACCTITEMDBT Type: view BASIC
24 Fields 1 Data Sources

Treasury Accounting Item Debit

I_TrsyAccountingItemDebit is a Basic CDS View that provides data about "Treasury Accounting Item Debit" in SAP S/4HANA. It reads from 1 data source (I_TrsyAccountingItemBase) and exposes 24 fields with key fields TrsyAccountingDocumentUUID, AccountingDocumentItemRef.

Data Sources (1)

SourceAliasJoin Type
I_TrsyAccountingItemBase I_TrsyAccountingItemBase from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ITRSYACCTITEMDBT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
EndUserText.label Treasury Accounting Item Debit view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY TrsyAccountingDocumentUUID TrsyAccountingDocumentUUID DB Object ID
KEY AccountingDocumentItemRef AccountingDocumentItemRef Position
TrsyPositionContextUUID TrsyPositionContextUUID DB Object ID
TreasuryGLAccountAssignmentRef TreasuryGLAccountAssignmentRef Acct Assignment Ref.
TreasuryPostingCategory TreasuryPostingCategory
DebitGLAccount General Ledger
AmountInPositionCurrency AmountInPositionCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TreasuryTransactionFlow TreasuryTransactionFlow Flow Number
AccountingDocument AccountingDocument Journal Entry
ReverseDocument ReverseDocument Reversed With
DebitCustomer Sold-to Party
TreasuryBusinessTransaction _TrsyAcctItemDocument TreasuryBusinessTransaction
TreasuryValuationArea _TrsyAcctItemDocument TreasuryValuationArea
ReferenceDocument _TrsyAcctItemDocument ReferenceDocument Reference Document
ReferenceDocumentContext _TrsyAcctItemDocument ReferenceDocumentContext Reference Document Context
PostingDate _TrsyAcctItemDocument PostingDate Posting Date for GR
PostingFiscalPeriod _TrsyAcctItemDocument PostingFiscalPeriod Period
FiscalYear _TrsyAcctItemDocument FiscalYear G/L Fiscal Year
ReversalReferenceDocument _TrsyAcctItemDocument ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt _TrsyAcctItemDocument ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReverseDocumentPostingDate _TrsyAcctItemDocument ReverseDocumentPostingDate
ReverseDocumentFiscalPeriod _TrsyAcctItemDocument ReverseDocumentFiscalPeriod
ReverseDocumentFiscalYear _TrsyAcctItemDocument ReverseDocumentFiscalYear Year

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_TrsyAccountingItemDebit.
-- 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: ITRSYACCTITEMDBT

CREATE VIEW I_TrsyAccountingItemDebit AS
SELECT
  TrsyAccountingDocumentUUID,
  AccountingDocumentItemRef,
  TrsyPositionContextUUID,
  TreasuryGLAccountAssignmentRef,
  TreasuryPostingCategory,
  cast (GLAccount as ftr_gen_gl_account_debit preserving type) AS DebitGLAccount,
  AmountInPositionCurrency,
  AmountInCompanyCodeCurrency,
  TreasuryTransactionFlow,
  AccountingDocument,
  ReverseDocument,
  cast (Customer as ftr_gen_customer_debit preserving type) AS DebitCustomer,
  _TrsyAcctItemDocument.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  _TrsyAcctItemDocument.TreasuryValuationArea AS TreasuryValuationArea,
  _TrsyAcctItemDocument.ReferenceDocument AS ReferenceDocument,
  _TrsyAcctItemDocument.ReferenceDocumentContext AS ReferenceDocumentContext,
  _TrsyAcctItemDocument.PostingDate AS PostingDate,
  _TrsyAcctItemDocument.PostingFiscalPeriod AS PostingFiscalPeriod,
  _TrsyAcctItemDocument.FiscalYear AS FiscalYear,
  _TrsyAcctItemDocument.ReversalReferenceDocument AS ReversalReferenceDocument,
  _TrsyAcctItemDocument.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  _TrsyAcctItemDocument.ReverseDocumentPostingDate AS ReverseDocumentPostingDate,
  _TrsyAcctItemDocument.ReverseDocumentFiscalPeriod AS ReverseDocumentFiscalPeriod,
  _TrsyAcctItemDocument.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear
FROM I_TrsyAccountingItemBase
;

Learn More