REF1

14 Fields

REF1 is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY Counterparty Counterparty 1
KEY EffectiveDate EffectiveDate 1
KEY FinancialInstrTransactionType FinancialInstrTransactionType 1
KEY FinancialInstrumentProductType FinancialInstrumentProductType 1
KEY ReferenceInterestRate ReferenceInterestRate 3
KEY TransactionCurrency TransactionCurrency 1
_CompanyCode _CompanyCode 1
_Counterparty _Counterparty 1
_FinancialInstrProductType _FinancialInstrProductType 1
_ReferenceInterestRate _ReferenceInterestRate 2
_TransactionCurrency _TransactionCurrency 1
_TransactionType _TransactionType 1
EffectiveInterestRate EffectiveInterestRate 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 REF1 (
    COMPANYCODE,
    COUNTERPARTY,
    EFFECTIVEDATE,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    REFERENCEINTERESTRATE,
    TRANSACTIONCURRENCY,
    _COMPANYCODE,
    _COUNTERPARTY,
    _FINANCIALINSTRPRODUCTTYPE,
    _REFERENCEINTERESTRATE,
    _TRANSACTIONCURRENCY,
    _TRANSACTIONTYPE,
    EFFECTIVEINTERESTRATE,
    PRIMARY KEY (COMPANYCODE, COUNTERPARTY, EFFECTIVEDATE, FINANCIALINSTRTRANSACTIONTYPE, FINANCIALINSTRUMENTPRODUCTTYPE, REFERENCEINTERESTRATE, TRANSACTIONCURRENCY)
);

Learn More