I_CorrespncAddlCurrencyRole

DDL: I_CORRESPNCADDLCURRENCYROLE SQL: ICORRADDCURROLE Type: view BASIC

Additional Currency Role for Correspondence

I_CorrespncAddlCurrencyRole is a Basic CDS View that provides data about "Additional Currency Role for Correspondence" in SAP S/4HANA. It reads from 2 data sources (finsc_ld_cmp, I_Ledger) and exposes 6 fields with key fields Ledger, CompanyCode. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
finsc_ld_cmp finsc_ld_cmp from
I_Ledger I_Ledger inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CurrencyRole _AdditionalCurrency1Role _AdditionalCurrency1Role.CurrencyRole = $projection.AdditionalCurrency1Role
[1..1] I_CurrencyRole _AdditionalCurrency2Role _AdditionalCurrency2Role.CurrencyRole = $projection.AdditionalCurrency2Role

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICORRADDCURROLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Additional Currency Role for Correspondence view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Ledger finsc_ld_cmp rldnr
KEY CompanyCode finsc_ld_cmp bukrs
curtpgelseendasAdditionalCurrency1Role
curtpgelseendasAdditionalCurrency2Role
_AdditionalCurrency1Role _AdditionalCurrency1Role
_AdditionalCurrency2Role _AdditionalCurrency2Role 
@AbapCatalog.sqlViewName: 'ICORRADDCURROLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Additional Currency Role for Correspondence'
define view I_CorrespncAddlCurrencyRole

  as select from finsc_ld_cmp
    inner join   I_Ledger on  I_Ledger.IsLeadingLedger = 'X'
                          and I_Ledger.Ledger          = finsc_ld_cmp.rldnr

  association [1..1] to I_CurrencyRole as _AdditionalCurrency1Role on _AdditionalCurrency1Role.CurrencyRole = $projection.AdditionalCurrency1Role
  association [1..1] to I_CurrencyRole as _AdditionalCurrency2Role on _AdditionalCurrency2Role.CurrencyRole = $projection.AdditionalCurrency2Role


{
  key finsc_ld_cmp.rldnr as Ledger,
  key finsc_ld_cmp.bukrs as CompanyCode,

      case
        when finsc_ld_cmp.curposk = '2' then finsc_ld_cmp.curtpk
        when finsc_ld_cmp.curposo = '2' then finsc_ld_cmp.curtpo
        when finsc_ld_cmp.curposv = '2' then finsc_ld_cmp.curtpv
        when finsc_ld_cmp.curposb = '2' then finsc_ld_cmp.curtpb
        when finsc_ld_cmp.curposc = '2' then finsc_ld_cmp.curtpc
        when finsc_ld_cmp.curposd = '2' then finsc_ld_cmp.curtpd
        when finsc_ld_cmp.curpose = '2' then finsc_ld_cmp.curtpe
        when finsc_ld_cmp.curposf = '2' then finsc_ld_cmp.curtpf
        when finsc_ld_cmp.curposg = '2' then finsc_ld_cmp.curtpg
        else ' '
      end                as AdditionalCurrency1Role,

      case
        when finsc_ld_cmp.curposk = '3' then finsc_ld_cmp.curtpk
        when finsc_ld_cmp.curposo = '3' then finsc_ld_cmp.curtpo
        when finsc_ld_cmp.curposv = '3' then finsc_ld_cmp.curtpv
        when finsc_ld_cmp.curposb = '3' then finsc_ld_cmp.curtpb
        when finsc_ld_cmp.curposc = '3' then finsc_ld_cmp.curtpc
        when finsc_ld_cmp.curposd = '3' then finsc_ld_cmp.curtpd
        when finsc_ld_cmp.curpose = '3' then finsc_ld_cmp.curtpe
        when finsc_ld_cmp.curposf = '3' then finsc_ld_cmp.curtpf
        when finsc_ld_cmp.curposg = '3' then finsc_ld_cmp.curtpg
        else ' '
      end                as AdditionalCurrency2Role,

      _AdditionalCurrency1Role,
      _AdditionalCurrency2Role
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"FINSC_LD_CMP"
],
"ASSOCIATED":
[
"I_CURRENCYROLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More