TCURF
Conversion Factors
TCURF is an SAP database table in S/4HANA. Conversion Factors. It contains 9 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ExchangeRateFactorsRawData | view | from | BASIC | Exchange Rate Factors Raw Data |
| P_ExchangeRate1 | view | from | BASIC | |
| P_ExchangeRate2 | view | from | BASIC | |
| P_ExchangeRate3 | view | inner | BASIC | |
| VC_INTEGRATION_TCURF | view | from | Extraction for TCURF |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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_INVV | Valid from | |||
| ffact | FFACT_CURR | Ratio (from) | ||||
| tfact | TFACT_CURR | Ratio (to) | ||||
| abwct | ABWKT_CURR | Alt. E/R Type | ||||
| abwga | ABWGA_CURR | Ex.rate valid from |
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.
-- Conversion Factors
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCURF (
MANDT, -- Client [MANDT]
KURST, -- Exch. Rate Type [KURST_CURR]
FCURR, -- From currency [FCURR_CURR]
TCURR, -- To-currency [TCURR_CURR]
GDATU, -- Valid from [GDATU_INVV]
FFACT, -- Ratio (from) [FFACT_CURR]
TFACT, -- Ratio (to) [TFACT_CURR]
ABWCT, -- Alt. E/R Type [ABWKT_CURR]
ABWGA, -- Ex.rate valid from [ABWGA_CURR]
PRIMARY KEY (MANDT, KURST, FCURR, TCURR, GDATU)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA