I_CNSLDTNCRCYCNVRSNDIFFTYPET_2

CDS View

Currency Cnvrsns Difference Type - Text

I_CNSLDTNCRCYCNVRSNDIFFTYPET_2 is a CDS View in S/4HANA. Currency Cnvrsns Difference Type - Text. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CnsldtnCrcyCnvrsnDiffTypeT view from BASIC Currency Conversions Difference Type Text 
@AbapCatalog:{
  sqlViewName: 'ICCRTFLGT2',
  compiler.compareFilter: true,
  preserveKey: true
  }
@Analytics: {
  dataExtraction.enabled: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
    usageType: {
        dataClass: #CUSTOMIZING,
        serviceQuality: #A,
        sizeCategory: #S
    },
  dataCategory: #TEXT,
  representativeKey: 'CurrencyConversionsDiffType',
    modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
    supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT,
                            #SQL_DATA_SOURCE,
                            #EXTRACTION_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Search.searchable: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Currency Cnvrsns Difference Type - Text'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ]  } */
define view I_CnsldtnCrcyCnvrsnDiffTypeT_2
  as select from P_CnsldtnDomainText(P_DomainName : 'FC_RTFLG') as _DomainText

  association [1..1] to I_CnsldtnCrcyCnvrsnDiffType as _CrcyCnvrsnDiffType on $projection.CurrencyConversionsDiffType = _CrcyCnvrsnDiffType.CurrencyConversionsDiffType

{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key cast(_DomainText.Language as spras preserving type )                    as Language,

      @ObjectModel.foreignKey.association: '_CrcyCnvrsnDiffType'
  key cast(left(_DomainText.DomainValue, 1) as fincs_currencycnvrsnsdifftype) as CurrencyConversionsDiffType,

      @Semantics.text
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.8
      }
      _DomainText.DomainValueText                                             as CurrencyConversionsDiffTypeTxt,

      @Analytics.hidden: true
      @Consumption.hidden: true
      _DomainText.DomainValue                                                 as DomainValue, // required for optimized join definitions



      @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
      _CrcyCnvrsnDiffType,
      _DomainText._Language
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CNSLDTNDOMAINTEXT"
],
"ASSOCIATED":
[
"I_CNSLDTNCRCYCNVRSNDIFFTYPE",
"I_LANGUAGE"
],
"BASE":
[
"P_CNSLDTNDOMAINTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More