TCURS

Transparent Table Customizing Table

Kursspannen

TCURS is an SAP database table in S/4HANA. Kursspannen. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExchangeRateSpreadRawData view from BASIC Exchange Rates Spread Raw Data

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kurst kurst_curr Exch. Rate Type
KEY fcurr fcurr_curr From currency
KEY tcurr tcurr_curr To-currency
KEY gdatu gdatu_spr Valid from
spred spred_cur Spread

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.

-- Kursspannen
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCURS (
    MANDT,  -- Client [mandt]
    KURST,  -- Exch. Rate Type [kurst_curr]
    FCURR,  -- From currency [fcurr_curr]
    TCURR,  -- To-currency [tcurr_curr]
    GDATU,  -- Valid from [gdatu_spr]
    SPRED,  -- Spread [spred_cur]
    PRIMARY KEY (MANDT, KURST, FCURR, TCURR, GDATU)
);