OPTION

19 Fields

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

Fields (19)

KeyField CDS FieldsUsed in Views
KEY FinancialTransaction FinancialTransaction 1
KEY KeyDate KeyDate 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
Counterparty Counterparty 1
FinancialInstrTransactionType FinancialInstrTransactionType 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FinancialTransactionFromExer FinancialTransactionFromExer 1
FinTransProductGroup FinTransProductGroup 1
OptionExerciseType OptionExerciseType 1
OptionExpirationDate OptionExpirationDate 1
OptionPutCallCode OptionPutCallCode 1
OptionSettlementType OptionSettlementType 1
OptionUnderlyingProductType OptionUnderlyingProductType 1
OptionUnderlyingTermEndDate OptionUnderlyingTermEndDate 1
OptionUnderlyingTermStartDate OptionUnderlyingTermStartDate 1
OptionUndrlgFXStrikeRate OptionUndrlgFXStrikeRate 1
OptionUndrlgTransactionType OptionUndrlgTransactionType 1
Portfolio Portfolio 1
TransactionCurrency TransactionCurrency 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 OPTION (
    FINANCIALTRANSACTION,
    KEYDATE,
    AMOUNTINTRANSACTIONCURRENCY,
    COUNTERPARTY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALTRANSACTIONFROMEXER,
    FINTRANSPRODUCTGROUP,
    OPTIONEXERCISETYPE,
    OPTIONEXPIRATIONDATE,
    OPTIONPUTCALLCODE,
    OPTIONSETTLEMENTTYPE,
    OPTIONUNDERLYINGPRODUCTTYPE,
    OPTIONUNDERLYINGTERMENDDATE,
    OPTIONUNDERLYINGTERMSTARTDATE,
    OPTIONUNDRLGFXSTRIKERATE,
    OPTIONUNDRLGTRANSACTIONTYPE,
    PORTFOLIO,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (FINANCIALTRANSACTION, KEYDATE)
);

Learn More