_FINANCIALTRANSACTION

23 Fields

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

Fields (23)

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

Learn More