I_CAAltvExchangeRateSetCode

DDL: I_CAALTVEXCHANGERATESETCODE Type: view_entity BASIC

Alternative Exchange Rate Set Code

I_CAAltvExchangeRateSetCode is a Basic CDS View that provides data about "Alternative Exchange Rate Set Code" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field CAAltvExchangeRateSetCode. It has 1 association to related views. It is exposed through 1 OData service (UI_CADOCUMENT_MNG).

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CAAltvExchangeRateSetCodeT _Text $projection.CAAltvExchangeRateSetCode = _Text.CAAltvExchangeRateSetCode

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Alternative Exchange Rate Set Code view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey CAAltvExchangeRateSetCode view
ObjectModel.sapObjectNodeType.name ContrAcctgAltvExchRateSetCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CAAltvExchangeRateSetCode
_Text _Text
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Alternative Exchange Rate Set Code'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { modelingPattern: #NONE,
                representativeKey: 'CAAltvExchangeRateSetCode',
                sapObjectNodeType.name: 'ContrAcctgAltvExchRateSetCode',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #SQL_DATA_SOURCE ],
                usageType: { dataClass: #CUSTOMIZING,
                             serviceQuality: #A,
                             sizeCategory: #S } }

@VDM.viewType: #BASIC

define view entity I_CAAltvExchangeRateSetCode 
 as select from dd07l

  association [1..*] to I_CAAltvExchangeRateSetCodeT as _Text on $projection.CAAltvExchangeRateSetCode = _Text.CAAltvExchangeRateSetCode

{
      @ObjectModel.text.association: '_Text'
  key cast ( left( dd07l.domvalue_l, 1 ) as xdexr_kk preserving type ) as CAAltvExchangeRateSetCode,

      _Text
}
where
      domname  = 'XDEXR_KK'
  and as4local = 'A'