I_CnsldtnUnitIntegrationText

DDL: I_CNSLDTNUNITINTEGRATIONTEXT Type: view BASIC Package: FIN_CS_MD_UNIT

Consolidation Unit Integration Text

I_CnsldtnUnitIntegrationText is a Basic CDS View that provides data about "Consolidation Unit Integration Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, CnsldtnDataTransferMethod. It has 2 associations to related views. Part of development package FIN_CS_MD_UNIT.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t _DomainText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_CnsldtnUnitIntegration _CnsldtnUnitIntegration $projection.CnsldtnDataTransferMethod = _CnsldtnUnitIntegration.CnsldtnDataTransferMethod

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICSCUINTEGT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CnsldtnDataTransferMethod view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Consolidation Unit Integration Text view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language dd07t ddlanguage
KEY CnsldtnDataTransferMethod
CnsldtnDataTransferMethodText dd07t ddtext
_Language _Language
_CnsldtnUnitIntegration _CnsldtnUnitIntegration 
@AbapCatalog: {
    sqlViewName: 'ICSCUINTEGT',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #S
  },
  dataCategory: #TEXT,
  representativeKey: 'CnsldtnDataTransferMethod'
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText: {
    label: 'Consolidation Unit Integration Text'
}
@VDM: {
    viewType: #BASIC
}
define view I_CnsldtnUnitIntegrationText
  as select from dd07t as _DomainText

  association [1..1] to I_Language               as _Language               on $projection.Language = _Language.Language

  association [1..1] to I_CnsldtnUnitIntegration as _CnsldtnUnitIntegration on $projection.CnsldtnDataTransferMethod = _CnsldtnUnitIntegration.CnsldtnDataTransferMethod

{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key _DomainText.ddlanguage                                                      as Language,

      @ObjectModel.foreignKey.association: '_CnsldtnUnitIntegration'
  key cast( substring(_DomainText.domvalue_l, 1, 1) as fincs_datatransfermethod ) as CnsldtnDataTransferMethod,

      @Semantics.text
      _DomainText.ddtext                                                          as CnsldtnDataTransferMethodText,

      // association

      _Language, // required for value help retrieval


      _CnsldtnUnitIntegration // required for value help retrieval and navigation

}
where
       _DomainText.domname    = 'FINCS_DATATRANSFERMETHOD'
  and  _DomainText.as4local   = 'A'

Learn More