FINSC_CURTYPE

Transparent Table Control Table (SAP+Cust)
7 Fields 16 CDS Views

Currency type

FINSC_CURTYPE is an SAP database table in S/4HANA. Currency type. It contains 7 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
finsv_unique_cvtyps view from Unique CVTYPs
fiscds_curtp_text view from Currency Type Text
fmlv_ckmlct view inner Replacement object for CKMLCT
fmlv_curtp_ml view inner Select ML relevant currencies
I_CurrencyRole view from BASIC Currency Role
I_NonLeadingLedgerCurrencyRole view from BASIC Non Leading Ledger Currency Role
P_Curtptext view from BASIC
P_LedgerValuationCrcyRole view from BASIC
P_MaterialLedger_Name_Curtp view inner BASIC
V_COSP_LVP_2_VIEW view inner COSP totals: all currencies/valuations - 1
V_COSP_PER_2_VIEW view inner COSP totals: all currencies/valuations - 2
V_COSS_LVP_2_VIEW view inner COSS totals: all currencies/valuations - 1
V_COSS_PER_2_VIEW view inner COSS totals: all currencies/valuations - 2
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSS4W09_2_VIEW view inner COSS for WRTTP=09 - part 2
V_COSX_LVP_2_VIEW view inner COSX totals: all currencies/valuations - 1

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY curtype FINS_CURTYPE Curr./Val. Type
valutyp FINS_VALUTYP_WO_COGM Valuation View
valusubtyp FINS_VALUSUBTYP Subtype Val
legal_curtype FINS_PLAIN_CURTYPE Plain Currency Type
ext_curtype FINS_EXT_CURTYPE Crcy Type/Valn View
rldnr FINS_LEDGER Ledger

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 type
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_CURTYPE (
    MANDT,          -- Client [MANDT]
    CURTYPE,        -- Curr./Val. Type [FINS_CURTYPE]
    VALUTYP,        -- Valuation View [FINS_VALUTYP_WO_COGM]
    VALUSUBTYP,     -- Subtype Val [FINS_VALUSUBTYP]
    LEGAL_CURTYPE,  -- Plain Currency Type [FINS_PLAIN_CURTYPE]
    EXT_CURTYPE,    -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    RLDNR,          -- Ledger [FINS_LEDGER]
    PRIMARY KEY (MANDT, CURTYPE)
);

Learn More