FXSPOTRATE

5 Fields

FXSPOTRATE is an SAP database table in S/4HANA. It contains 5 fields.

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 2
KEY ExchangeRateType ExchangeRateType 1
KEY MarketDataReportingPeriod MarketDataReportingPeriod 2
EffectiveDate EffectiveDate 2
SpotExchangeRate ExchangeRate 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 FXSPOTRATE (
    CALENDARDATE,
    EXCHANGERATETYPE,
    MARKETDATAREPORTINGPERIOD,
    EFFECTIVEDATE,
    SPOTEXCHANGERATE,
    PRIMARY KEY (CALENDARDATE, EXCHANGERATETYPE, MARKETDATAREPORTINGPERIOD)
);

Learn More