_MLCURRENCYINFO

_MLCURRENCYINFO is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CurrencyRole CurrencyRole 2
AccountingValuationView AccountingValuationView 4
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName 4
CurrencyRoleName CurrencyRoleName 7
LedgerName LedgerName 7
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs 8
LegalCurrencyRole LegalCurrencyRole 4
LegalCurrencyRoleName LegalCurrencyRoleName 4

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 _MLCURRENCYINFO (
    CURRENCYROLE,
    ACCOUNTINGVALUATIONVIEW,
    ACCTGVALNVWSUBVIEWCOMBINEDNAME,
    CURRENCYROLENAME,
    LEDGERNAME,
    LEDGERVALNCRCYROLEISUSEDINLOGS,
    LEGALCURRENCYROLE,
    LEGALCURRENCYROLENAME,
    PRIMARY KEY (CURRENCYROLE)
);