_FINANCIALTRANSACTION

24 Fields

_FINANCIALTRANSACTION is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY Counterparty Counterparty 12
KEY TermEndDate ValidityEndDate 1
KEY TermStartDate TermStartDate,ValidityStartDate 2
_Counterparty _Counterparty 1
_FinancialInstrProdCat _FinancialInstrProdCat 1
_FinancialInstrProdType _FinancialInstrProdType 1
_FinancialInstrTransType _FinancialInstrTransType 1
BusinessArea BusinessArea 4
FinancialInstrCharacteristic FinancialInstrCharacteristic 2
FinancialInstrProductCategory FinancialInstrProductCategory 9
FinancialInstrTransactionType FinancialInstrTransactionType 16
FinancialInstrumentAssignment FinancialInstrumentAssignment 2
FinancialInstrumentProductType FinancialInstrumentProductType 6
FinancialInstrumentReference FinancialInstrumentReference 2
FinancialInstrumentStatus FinancialInstrumentStatus 2
FinancialTransaction FinancialTransaction 1
FinancialTransactionQuantity FinancialTransactionQuantity 1
FinInstrTransactionCategory FinInstrTransactionCategory 1
HedgingClassification HedgingClassification 2
Portfolio Portfolio 5
TreasuryFacility TreasuryFacility 1
TreasuryFacilityCompanyCode TreasuryFacilityCompanyCode 1
TreasuryFinanceProject TreasuryFinanceProject 1
TreasuryFinancialObject TreasuryFinancialObject 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 _FINANCIALTRANSACTION (
    COUNTERPARTY,
    TERMENDDATE,
    TERMSTARTDATE,
    _COUNTERPARTY,
    _FINANCIALINSTRPRODCAT,
    _FINANCIALINSTRPRODTYPE,
    _FINANCIALINSTRTRANSTYPE,
    BUSINESSAREA,
    FINANCIALINSTRCHARACTERISTIC,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTASSIGNMENT,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRUMENTREFERENCE,
    FINANCIALINSTRUMENTSTATUS,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONQUANTITY,
    FININSTRTRANSACTIONCATEGORY,
    HEDGINGCLASSIFICATION,
    PORTFOLIO,
    TREASURYFACILITY,
    TREASURYFACILITYCOMPANYCODE,
    TREASURYFINANCEPROJECT,
    TREASURYFINANCIALOBJECT,
    PRIMARY KEY (COUNTERPARTY, TERMENDDATE, TERMSTARTDATE)
);

Learn More