_FINANCIALTRANSACTION

19 Fields

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

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Counterparty Counterparty 10
BusinessArea BusinessArea 4
FinancialInstrCharacteristic FinancialInstrCharacteristic 2
FinancialInstrProductCategory FinancialInstrProductCategory 2
FinancialInstrTransactionType FinancialInstrTransactionType 14
FinancialInstrumentAssignment FinancialInstrumentAssignment 2
FinancialInstrumentProductType FinancialInstrumentProductType 4
FinancialInstrumentReference FinancialInstrumentReference 2
FinancialInstrumentStatus FinancialInstrumentStatus 1
FinancialTransaction FinancialTransaction 1
FinancialTransactionQuantity FinancialTransactionQuantity 1
FinInstrTransactionCategory FinInstrTransactionCategory 1
HedgingClassification HedgingClassification 2
Portfolio Portfolio 5
TermStartDate TermStartDate 1
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,
    BUSINESSAREA,
    FINANCIALINSTRCHARACTERISTIC,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTASSIGNMENT,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRUMENTREFERENCE,
    FINANCIALINSTRUMENTSTATUS,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONQUANTITY,
    FININSTRTRANSACTIONCATEGORY,
    HEDGINGCLASSIFICATION,
    PORTFOLIO,
    TERMSTARTDATE,
    TREASURYFACILITY,
    TREASURYFACILITYCOMPANYCODE,
    TREASURYFINANCEPROJECT,
    TREASURYFINANCIALOBJECT,
    PRIMARY KEY (COUNTERPARTY)
);

Learn More