R_MATLLEDGERVALNCRCYROLE

CDS View
14 Fields 10 CDS Views

ML Valuation and Currency Roles

R_MATLLEDGERVALNCRCYROLE is a CDS View in S/4HANA. ML Valuation and Currency Roles. It contains 14 fields. 10 CDS views read from this table.

CDS Views using this table (10)

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
I_MatlValnMngMrkdReldCostEst view_entity inner COMPOSITE Matl Valuations Marked and Reld Cost Est
P_MatVal_By_Period_Types view inner COMPOSITE Prices and values for app Mat. Val. Manage
P_Matval_Manage_Ckml view_entity inner COMPOSITE Base View for Mat.Val., CKML* tables
P_Matval_Manage_Cost view_entity inner COMPOSITE Manage Material Valuations, table of cost estimates
P_Matval_Manage_Cost_Sls_Ord view inner COMPOSITE Manage Material Valuations, table of cost estimates
R_MatlLedgerValnCrcyRoleVH view from COMPOSITE Value Help for ML Valuation and Curreny Roles

Fields (14)

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

-- ML Valuation and Currency 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,
    JRNLENTRITEMCRCYROLEPOSITION,
    LEDGERNAME,
    LEDGERVALNCRCYROLEISUSEDINLOGS,
    LEGALCURRENCYROLE,
    LEGALCURRENCYROLENAME,
    PRIMARY KEY (LEDGER, LEDGERVALUATIONCURRENCYROLE)
);

Learn More