TCURC

Transparent Table Customizing Table
6 Fields 20 CDS Views

Currency Codes

TCURC is an SAP database table in S/4HANA. Currency Codes. It contains 6 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
/PF1/P_TCURC view from Currency
cuan_currency_search view_entity from Currency Search
DEMO_CDS_CURRENCY view_entity from BASIC Currency
FAC_DART_Z3_CURRENCY view from Currency Master Data
I_AmountCurrencyValueHelp view from BASIC
I_CFD_Currency view from
I_Currency view from BASIC Currency
I_Sadl_Draft_CC_VH view from Currency Code Value Help
I_TripCurrencyVH view from BASIC Value Help for Currency Code
I_TripPrcgCrcyCodeVH view from BASIC Currency code value help
I_UN_HCMFamMbrCurrency view_entity from BASIC Currency
P_CurrencyVH view from BASIC
P_GMAVCSetLocCurr view from BASIC
P_GMAVCSetLocCurr view left_outer BASIC
P_GMAVCSetLocCurr view union_all BASIC
Sadl_V_Aunit_Curr view from Currency
SADL_V_CurrencyCode_valueHelp view from Currency Code Value Help
Sadl_V_Perf_Curr view from Currency Codes
SEPM_I_Currency view from EPM Demo: Currency
VC_INTEGRATION_TCURC view from Extraction for TCURC

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY waers WAERS_CURC Currency
isocd ISOCD ISO code
altwr ALTWR Alternative key
gdatu DATUM_CURC Valid until
xprimary XPRIMARY Primary

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.

-- Currency Codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCURC (
    MANDT,     -- Client [MANDT]
    WAERS,     -- Currency [WAERS_CURC]
    ISOCD,     -- ISO code [ISOCD]
    ALTWR,     -- Alternative key [ALTWR]
    GDATU,     -- Valid until [DATUM_CURC]
    XPRIMARY,  -- Primary [XPRIMARY]
    PRIMARY KEY (MANDT, WAERS)
);

Learn More