TCURR

Transparent Table Customizing Table
8 Fields 7 CDS Views

Umrechnungskurse

TCURR is an SAP database table in S/4HANA. Umrechnungskurse. It contains 8 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ExchangeRateRawData view from BASIC Exchange Rate Raw Data
P_ExchangeRate1 view inner BASIC Private View for Exchange Rate
P_ExchangeRate2 view inner BASIC Private View for Exchange Rate
P_ExchangeRate3 view from BASIC Private View for P_ExchangeRate3
P_ExchangeRate3 view union_all BASIC Private View for P_ExchangeRate3
SADL_V_AUnit_Viewbld view from Currency for local unit tests
VC_INTEGRATION_TCURR view from Extraction for TCURR

Fields (8)

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_inv Valid from
ukurs ukurs_curr Exchange Rate
ffact ffact_curr Ratio (from)
tfact tfact_curr Ratio (to)

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.

-- Umrechnungskurse
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCURR (
    MANDT,  -- Client [mandt]
    KURST,  -- Exch. Rate Type [kurst_curr]
    FCURR,  -- From currency [fcurr_curr]
    TCURR,  -- To-currency [tcurr_curr]
    GDATU,  -- Valid from [gdatu_inv]
    UKURS,  -- Exchange Rate [ukurs_curr]
    FFACT,  -- Ratio (from) [ffact_curr]
    TFACT,  -- Ratio (to) [tfact_curr]
    PRIMARY KEY (MANDT, KURST, FCURR, TCURR, GDATU)
);

Learn More