TRANS

23 Fields

TRANS is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY FinancialTransaction FinancialTransaction 3
KEY KeyDate KeyDate 3
AmountInTransactionCurrency AmountInTransactionCurrency 1
Counterparty Counterparty 4
FinancialInstrTransactionType FinancialInstrTransactionType 4
FinancialInstrumentProductType FinancialInstrumentProductType 4
FinTransProductGroup FinTransProductGroup 3
OriglTrsyBusinessTransaction OriglTrsyBusinessTransaction 1
Portfolio Portfolio 4
PostingDate PostingDate 1
PostingReversalDate PostingReversalDate 1
SecurityAccount SecurityAccount 2
TransactionCurrency TransactionCurrency 3
TreasuryBusinessTransaction TreasuryBusinessTransaction 1
TreasuryBusinessTransCategory TreasuryBusinessTransCategory 1
TreasuryBusinessTransStatus TreasuryBusinessTransStatus 1
TreasuryUserStatisticsUUID TreasuryUserStatisticsUUID 1
TreasuryValuationArea TreasuryValuationArea 1
TrsyBusTransactionCreationDate TrsyBusTransactionCreationDate 1
TrsyBusTransactionCreationTime TrsyBusTransactionCreationTime 1
TrsyDerivedBusinessTransStatus TrsyDerivedBusinessTransStatus 1
TrsyIntragroupTransacStatus TrsyIntragroupTransacStatus 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRANS (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    KEYDATE,
    AMOUNTINTRANSACTIONCURRENCY,
    COUNTERPARTY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINTRANSPRODUCTGROUP,
    ORIGLTRSYBUSINESSTRANSACTION,
    PORTFOLIO,
    POSTINGDATE,
    POSTINGREVERSALDATE,
    SECURITYACCOUNT,
    TRANSACTIONCURRENCY,
    TREASURYBUSINESSTRANSACTION,
    TREASURYBUSINESSTRANSCATEGORY,
    TREASURYBUSINESSTRANSSTATUS,
    TREASURYUSERSTATISTICSUUID,
    TREASURYVALUATIONAREA,
    TRSYBUSTRANSACTIONCREATIONDATE,
    TRSYBUSTRANSACTIONCREATIONTIME,
    TRSYDERIVEDBUSINESSTRANSSTATUS,
    TRSYINTRAGROUPTRANSACSTATUS,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION, KEYDATE)
);

Learn More