I_TRSYACCOUNTINGITEM

CDS View
17 Fields 1 CDS Views

Treasury Accounting Item

I_TRSYACCOUNTINGITEM is a CDS View in S/4HANA. Treasury Accounting Item. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TrsyPosFlow view_entity left_outer COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
CreditCustomer CreditCustomer 1
CreditGLAccount CreditGLAccount 1
DebitCustomer DebitCustomer 1
DebitGLAccount DebitGLAccount 1
FiscalYear FiscalYear 1
PostingDate PostingDate 1
PostingFiscalPeriod FiscalPeriod,PostingFiscalPeriod 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReversalReferenceDocument ReversalReferenceDocument 1
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 1
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalPeriod ReverseDocumentFiscalPeriod 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
ReverseDocumentPostingDate ReverseDocumentPostingDate 1
TreasuryGLAccountAssignmentRef TreasuryGLAccountAssignmentRef 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Treasury Accounting Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRSYACCOUNTINGITEM (
    ACCOUNTINGDOCUMENT,
    CREDITCUSTOMER,
    CREDITGLACCOUNT,
    DEBITCUSTOMER,
    DEBITGLACCOUNT,
    FISCALYEAR,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALPERIOD,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDOCUMENTPOSTINGDATE,
    TREASURYGLACCOUNTASSIGNMENTREF
);

Learn More