P_MatlLedgerValnCrcyRole

DDL: P_MATLLEDGERVALNCRCYROLE SQL: PMLVALNCRCYROLE Type: view COMPOSITE Package: FINS_ML_VDM
22 Fields 11 Data Sources

The ML relevant Currency and Valuation Roles

P_MatlLedgerValnCrcyRole is a Composite CDS View that provides data about "The ML relevant Currency and Valuation Roles" in SAP S/4HANA. It reads from 11 data sources and exposes 22 fields with key fields Ledger, CompanyCode. Part of development package FINS_ML_VDM.

Data Sources (11)

SourceAliasJoin Type
I_MatlLedgerValnCrcyRoleName _CurtpB left_outer
I_MatlLedgerValnCrcyRoleName _CurtpC left_outer
I_MatlLedgerValnCrcyRoleName _CurtpD left_outer
I_MatlLedgerValnCrcyRoleName _CurtpE left_outer
I_MatlLedgerValnCrcyRoleName _CurtpF left_outer
I_MatlLedgerValnCrcyRoleName _CurtpG left_outer
I_MatlLedgerValnCrcyRoleName _CurtpH left_outer
I_MatlLedgerValnCrcyRoleName _CurtpK left_outer
I_MatlLedgerValnCrcyRoleName _CurtpO left_outer
I_MatlLedgerValnCrcyRoleName _CurtpV left_outer
I_CoCodeLedgerValnCrcyRole f from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PMLVALNCRCYROLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_CoCodeLedgerValnCrcyRole Ledger Ledger
KEY CompanyCode I_CoCodeLedgerValnCrcyRole CompanyCode Receiver Company Code
CurrencyRoleNameendasCurtpH_name
Ledgerendasrldnrh
CurrencyRoleNameendasCurtpK_name
Ledgerendasrldnrk
CurrencyRoleNameendasCurtpO_name
Ledgerendasrldnro
CurrencyRoleNameendasCurtpV_name
Ledgerendasrldnrv
CurrencyRoleNameendasCurtpB_name
Ledgerendasrldnrb
CurrencyRoleNameendasCurtpC_name
Ledgerendasrldnrc
CurrencyRoleNameendasCurtpD_name
Ledgerendasrldnrd
CurrencyRoleNameendasCurtpE_name
Ledgerendasrldnre
CurrencyRoleNameendasCurtpF_name
Ledgerendasrldnrf
CurrencyRoleNameendasCurtpG_name
Ledgerendasrldnrg

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_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.
-- SQL view name: PMLVALNCRCYROLE

CREATE VIEW P_MatlLedgerValnCrcyRole AS
SELECT
  f.Ledger AS Ledger,
  f.CompanyCode AS CompanyCode,
  case when _CurtpH.CurrencyRole is null then ' ' else _CurtpH.CurrencyRoleName end as CurtpH_name AS CurrencyRoleNameendasCurtpH_name,
  case when _CurtpH.CurrencyRole is null then ' ' else _CurtpH.Ledger end as rldnrh AS Ledgerendasrldnrh,
  case when _CurtpK.CurrencyRole is null then ' ' else _CurtpK.CurrencyRoleName end as CurtpK_name AS CurrencyRoleNameendasCurtpK_name,
  case when _CurtpK.CurrencyRole is null then ' ' else _CurtpK.Ledger end as rldnrk AS Ledgerendasrldnrk,
  case when _CurtpO.CurrencyRole is null then ' ' else _CurtpO.CurrencyRoleName end as CurtpO_name AS CurrencyRoleNameendasCurtpO_name,
  case when _CurtpO.CurrencyRole is null then ' ' else _CurtpO.Ledger end as rldnro AS Ledgerendasrldnro,
  case when _CurtpV.CurrencyRole is null then ' ' else _CurtpV.CurrencyRoleName end as CurtpV_name AS CurrencyRoleNameendasCurtpV_name,
  case when _CurtpV.CurrencyRole is null then ' ' else _CurtpV.Ledger end as rldnrv AS Ledgerendasrldnrv,
  case when _CurtpB.CurrencyRole is null then ' ' else _CurtpB.CurrencyRoleName end as CurtpB_name AS CurrencyRoleNameendasCurtpB_name,
  case when _CurtpB.CurrencyRole is null then ' ' else _CurtpB.Ledger end as rldnrb AS Ledgerendasrldnrb,
  case when _CurtpC.CurrencyRole is null then ' ' else _CurtpC.CurrencyRoleName end as CurtpC_name AS CurrencyRoleNameendasCurtpC_name,
  case when _CurtpC.CurrencyRole is null then ' ' else _CurtpC.Ledger end as rldnrc AS Ledgerendasrldnrc,
  case when _CurtpD.CurrencyRole is null then ' ' else _CurtpD.CurrencyRoleName end as CurtpD_name AS CurrencyRoleNameendasCurtpD_name,
  case when _CurtpD.CurrencyRole is null then ' ' else _CurtpD.Ledger end as rldnrd AS Ledgerendasrldnrd,
  case when _CurtpE.CurrencyRole is null then ' ' else _CurtpE.CurrencyRoleName end as CurtpE_name AS CurrencyRoleNameendasCurtpE_name,
  case when _CurtpE.CurrencyRole is null then ' ' else _CurtpE.Ledger end as rldnre AS Ledgerendasrldnre,
  case when _CurtpF.CurrencyRole is null then ' ' else _CurtpF.CurrencyRoleName end as CurtpF_name AS CurrencyRoleNameendasCurtpF_name,
  case when _CurtpF.CurrencyRole is null then ' ' else _CurtpF.Ledger end as rldnrf AS Ledgerendasrldnrf,
  case when _CurtpG.CurrencyRole is null then ' ' else _CurtpG.CurrencyRoleName end as CurtpG_name AS CurrencyRoleNameendasCurtpG_name,
  case when _CurtpG.CurrencyRole is null then ' ' else _CurtpG.Ledger end as rldnrg AS Ledgerendasrldnrg
FROM I_CoCodeLedgerValnCrcyRole AS f
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpK ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpV ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpB ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpE ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _CurtpG ON /* join condition not captured in parsed metadata */
;

Learn More