_TRSYACCTITEMDOCUMENT

_TRSYACCTITEMDOCUMENT is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
FiscalYear FiscalYear 2
PostingDate PostingDate 2
PostingFiscalPeriod PostingFiscalPeriod 2
ReferenceDocument ReferenceDocument 2
ReferenceDocumentContext ReferenceDocumentContext 2
ReversalReferenceDocument ReversalReferenceDocument 2
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 2
ReverseDocumentFiscalPeriod ReverseDocumentFiscalPeriod 2
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 2
ReverseDocumentPostingDate ReverseDocumentPostingDate 2
TreasuryBusinessTransaction TreasuryBusinessTransaction 2
TreasuryValuationArea TreasuryValuationArea 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _TRSYACCTITEMDOCUMENT (
    FISCALYEAR,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSEDOCUMENTFISCALPERIOD,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDOCUMENTPOSTINGDATE,
    TREASURYBUSINESSTRANSACTION,
    TREASURYVALUATIONAREA
);