P_LedgerValuationCrcyRole

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 P_LedgerValuationCrcyRole.
-- 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.
-- SQL view name: PLDGRVALNCURROLE

CREATE VIEW P_LedgerValuationCrcyRole AS
SELECT
  curtype,
  it.rldnr AS Ledger,
  case it.ext_curtype when '' then curtype else it.ext_curtype end as CurrencyRole AS ext_curtypeendasCurrencyRole,
  valutyp,
  it.ext_curtype AS ext_curtype,
  valusubtyp
FROM finsc_curtype AS it
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;