I_CoCodeLedgerValnCrcyRole

DDL: I_COCODELEDGERVALNCRCYROLE SQL: ICMPLDVALNCURTPS Type: view BASIC Package: FINS_ML_VDM
12 Fields 1 Data Sources

Company Code Ledger Valuation Currency Role

I_CoCodeLedgerValnCrcyRole is a Basic CDS View that provides data about "Company Code Ledger Valuation Currency Role" in SAP S/4HANA. It reads from 1 data source (P_CoCodeLedgerValnCrcyRole) and exposes 12 fields with key fields Ledger, CompanyCode. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
P_CoCodeLedgerValnCrcyRole P_CoCodeLedgerValnCrcyRole from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMPLDVALNCURTPS view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Company Code Ledger Valuation Currency Role view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
CompanyCodeCurrencyRole CompanyCodeCurrencyRole Field Name
GlobalCurrencyRole GlobalCurrencyRole Field Name
FreeDefinedCurrency1Role FreeDefinedCurrency1Role FreeDef Crcy 1
FreeDefinedCurrency2Role FreeDefinedCurrency2Role FreeDef Crcy 2
FreeDefinedCurrency3Role FreeDefinedCurrency3Role FreeDef Crcy 3
FreeDefinedCurrency4Role FreeDefinedCurrency4Role FreeDef Crcy 4
FreeDefinedCurrency5Role FreeDefinedCurrency5Role FreeDef Crcy 5
FreeDefinedCurrency6Role FreeDefinedCurrency6Role FreeDef Crcy 6
FreeDefinedCurrency7Role FreeDefinedCurrency7Role FreeDef Crcy 7
FreeDefinedCurrency8Role FreeDefinedCurrency8Role FreeDef Crcy 8

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 I_CoCodeLedgerValnCrcyRole.
-- 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: ICMPLDVALNCURTPS

CREATE VIEW I_CoCodeLedgerValnCrcyRole AS
SELECT
  Ledger,
  CompanyCode,
  CompanyCodeCurrencyRole,
  GlobalCurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role
FROM P_CoCodeLedgerValnCrcyRole
;

Learn More