I_CostCenterLabelTP

DDL: I_COSTCENTERLABELTP SQL: IFICOSTCNTRLBLTP Type: view TRANSACTIONAL

Languages

I_CostCenterLabelTP is a Transactional CDS View that provides data about "Languages" in SAP S/4HANA. It reads from 1 data source (I_CostCenterText) and exposes 12 fields with key fields Language, ControllingArea, CostCenter, ValidityEndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterText I_CostCenterText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CostCenterTP _CostCenter $projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter and $projection.ValidityEndDate = _CostCenter.ValidityEndDate association[0..1] to I_Language as _Language on $projection.LanguageForEdit = _Language.Language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFICOSTCNTRLBLTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeDraftPersistence CSKT_DRAFT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Languages view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Language Language
KEY ControllingArea ControllingArea
KEY CostCenter CostCenter
KEY ValidityEndDate ValidityEndDate
LanguageForEdit Language
CostCenterName CostCenterName
CostCenterDescription
UxFcCostCenterDescription
LanguageISOCode _Language LanguageISOCode
LanguageName
_CostCenter _CostCenter
_Language _Language
@AbapCatalog.sqlViewName: 'IFICOSTCNTRLBLTP'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

// Draft Related Annotations

@ObjectModel.writeDraftPersistence: 'CSKT_DRAFT'
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: [ 'Language', 'ControllingArea', 'CostCenter', 'ValidityEndDate' ]

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

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Languages'

define view I_CostCenterLabelTP
  as select from I_CostCenterText
  
    association [1..1] to I_CostCenterTP       as _CostCenter         on  $projection.ControllingArea    = _CostCenter.ControllingArea
                                                                        and $projection.CostCenter       = _CostCenter.CostCenter
                                                                        and $projection.ValidityEndDate  = _CostCenter.ValidityEndDate
    
    association[0..1] to I_Language as _Language on $projection.LanguageForEdit = _Language.Language
{

  key Language,
  
  key ControllingArea,
  
  key CostCenter,

  key ValidityEndDate,
  
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Language as LanguageForEdit,

      CostCenterName,

      cast( CostCenterDescription as fis_cc_kostl_ltext preserving type ) as CostCenterDescription,
      
      @ObjectModel.readOnly: true
      cast ( '' as fco_long_text_indicator ) as UxFcCostCenterDescription,
      
      @ObjectModel.readOnly: true    
      _Language.LanguageISOCode,
      
      @ObjectModel.readOnly: true    
      _Language._Text[1:Language=$session.system_language].LanguageName,
      
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _CostCenter,
      
      _Language

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTERTEXT",
"I_LANGUAGE",
"I_LANGUAGETEXT"
],
"ASSOCIATED":
[
"I_COSTCENTERTP",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/