_CURRENCYROLES

11 Fields

_CURRENCYROLES is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
CompanyCodeCurrencyRole CompanyCodeCurrencyRole 1
FreeDefinedCurrency1Role FreeDefinedCurrency1Role 3
FreeDefinedCurrency2Role FreeDefinedCurrency2Role 1
FreeDefinedCurrency3Role FreeDefinedCurrency3Role 1
FreeDefinedCurrency4Role FreeDefinedCurrency4Role 1
FreeDefinedCurrency5Role FreeDefinedCurrency5Role 1
FreeDefinedCurrency6Role FreeDefinedCurrency6Role 1
FreeDefinedCurrency7Role FreeDefinedCurrency7Role 1
FreeDefinedCurrency8Role FreeDefinedCurrency8Role 1
FunctionalCurrencyRole FunctionalCurrencyRole 1
GlobalCurrencyRole GlobalCurrencyRole 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CURRENCYROLES (
    COMPANYCODECURRENCYROLE,
    FREEDEFINEDCURRENCY1ROLE,
    FREEDEFINEDCURRENCY2ROLE,
    FREEDEFINEDCURRENCY3ROLE,
    FREEDEFINEDCURRENCY4ROLE,
    FREEDEFINEDCURRENCY5ROLE,
    FREEDEFINEDCURRENCY6ROLE,
    FREEDEFINEDCURRENCY7ROLE,
    FREEDEFINEDCURRENCY8ROLE,
    FUNCTIONALCURRENCYROLE,
    GLOBALCURRENCYROLE
);

Learn More