R_MatlLedgerValnCrcyRole

DDL: R_MATLLEDGERVALNCRCYROLE Type: view_entity COMPOSITE Package: FINS_ML_VDM
16 Fields 2 Data Sources

ML Valuation and Currency Roles

R_MatlLedgerValnCrcyRole is a Composite CDS View that provides data about "ML Valuation and Currency Roles" in SAP S/4HANA. It reads from 2 data sources (I_MatlLdgrValnCrcyRoleBasic, R_LedgerValuationCrcyRole) and exposes 16 fields with key fields CompanyCode, Ledger, CurrencyRole. Part of development package FINS_ML_VDM.

Data Sources (2)

SourceAliasJoin Type
I_MatlLdgrValnCrcyRoleBasic curtp_ml inner
R_LedgerValuationCrcyRole it from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label ML Valuation and Currency Roles view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_MatlLdgrValnCrcyRoleBasic CompanyCode Receiver Company Code
KEY Ledger I_MatlLdgrValnCrcyRoleBasic Ledger Ledger
KEY CurrencyRole R_LedgerValuationCrcyRole CurrencyRole Curr./Val. Type
AccountingValuationView R_LedgerValuationCrcyRole AccountingValuationView Valuation Views
CurrencyRoleName R_LedgerValuationCrcyRole CurrencyRoleName
LedgerName R_LedgerValuationCrcyRole LedgerName Ledger Name
AcctgValnVwSubviewCombinedName R_LedgerValuationCrcyRole AcctgValnVwSubviewCombinedName
AccountingValuationViewName R_LedgerValuationCrcyRole AccountingValuationViewName Zone name
AccountingValuationSubview R_LedgerValuationCrcyRole AccountingValuationSubview Subtype Val
AccountingValuationSubviewName R_LedgerValuationCrcyRole AccountingValuationSubviewName Zone name
LegalCurrencyRole R_LedgerValuationCrcyRole LegalCurrencyRole
LegalCurrencyRoleName R_LedgerValuationCrcyRole LegalCurrencyRoleName
Currency I_MatlLdgrValnCrcyRoleBasic Currency Valuation Crcy
LedgerValnCrcyRoleIsUsedInLogs I_MatlLdgrValnCrcyRoleBasic LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type
JrnlEntrItemCrcyRolePosition I_MatlLdgrValnCrcyRoleBasic JrnlEntrItemCrcyRolePosition Char01
LedgerValuationCurrencyRole R_LedgerValuationCrcyRole LedgerValuationCurrencyRole Currency Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_MatlLedgerValnCrcyRole.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_MatlLedgerValnCrcyRole AS
SELECT
  curtp_ml.CompanyCode AS CompanyCode,
  curtp_ml.Ledger AS Ledger,
  it.CurrencyRole AS CurrencyRole,
  it.AccountingValuationView AS AccountingValuationView,
  it.CurrencyRoleName AS CurrencyRoleName,
  it.LedgerName AS LedgerName,
  it.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  it.AccountingValuationViewName AS AccountingValuationViewName,
  it.AccountingValuationSubview AS AccountingValuationSubview,
  it.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  it.LegalCurrencyRole AS LegalCurrencyRole,
  it.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  curtp_ml.Currency AS Currency,
  curtp_ml.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs,
  curtp_ml.JrnlEntrItemCrcyRolePosition AS JrnlEntrItemCrcyRolePosition,
  it.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole
FROM R_LedgerValuationCrcyRole AS it
INNER JOIN I_MatlLdgrValnCrcyRoleBasic AS curtp_ml ON /* join condition not captured in parsed metadata */
;

Learn More