R_MATLLEDGERVALNCRCYROLE

CDS View
13 Fields 6 CDS Views

ML Valuation and Curreny Roles

R_MATLLEDGERVALNCRCYROLE is a CDS View in S/4HANA. ML Valuation and Curreny Roles. It contains 13 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_MatlLdgrPrSalesOrderCostEst view inner CONSUMPTION Cost Estimates for Sales Order
C_MatlLdgrPrValnCurrencyRoleVH view_entity from CONSUMPTION Currency Role
C_MatlValnManageCostEst view inner CONSUMPTION Cost Estimates for Material Valuations
I_MaterialValuationsByPeriods view inner COMPOSITE Material Valuations by Currtp/Period
P_Matval_Manage_Cost_Sls_Ord view inner COMPOSITE
R_MatlLedgerValnCrcyRoleVH view from COMPOSITE Value Help for ML Valuation and Curreny Roles

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger 3
KEY LedgerValuationCurrencyRole LedgerValuationCurrencyRole 2
AccountingValuationSubview AccountingValuationSubview 4
AccountingValuationSubviewName AccountingValuationSubviewName 3
AccountingValuationView AccountingValuationView,ControllingValuationType 4
AccountingValuationViewName AccountingValuationViewName 3
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName 3
CurrencyRole CurrencyRole 1
CurrencyRoleName CurrencyRoleName 1
LedgerName LedgerName 3
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs 1
LegalCurrencyRole LegalCurrencyRole 3
LegalCurrencyRoleName LegalCurrencyRoleName 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.

-- ML Valuation and Curreny Roles
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_MATLLEDGERVALNCRCYROLE (
    LEDGER,
    LEDGERVALUATIONCURRENCYROLE,
    ACCOUNTINGVALUATIONSUBVIEW,
    ACCOUNTINGVALUATIONSUBVIEWNAME,
    ACCOUNTINGVALUATIONVIEW,
    ACCOUNTINGVALUATIONVIEWNAME,
    ACCTGVALNVWSUBVIEWCOMBINEDNAME,
    CURRENCYROLE,
    CURRENCYROLENAME,
    LEDGERNAME,
    LEDGERVALNCRCYROLEISUSEDINLOGS,
    LEGALCURRENCYROLE,
    LEGALCURRENCYROLENAME,
    PRIMARY KEY (LEDGER, LEDGERVALUATIONCURRENCYROLE)
);

Learn More