I_CostCenterActivityTypeTextTP

DDL: I_COSTCENTERACTIVITYTYPETEXTTP SQL: ICCACTTYPTXTTP Type: view TRANSACTIONAL

Languages

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

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CostCenterActivityTypeText I_CostCenterActivityTypeText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CostCenterActivityTypeTP _CostCenterActivityTypeTP $projection.ControllingArea = _CostCenterActivityTypeTP.ControllingArea and $projection.CostCtrActivityType = _CostCenterActivityTypeTP.CostCtrActivityType and $projection.ValidityEndDate = _CostCenterActivityTypeTP.ValidityEndDate

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICCACTTYPTXTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CSLT_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 (15)

KeyFieldSource TableSource FieldDescription
KEY Language Language
KEY ControllingArea ControllingArea
KEY CostCtrActivityType CostCtrActivityType
KEY ValidityEndDate ValidityEndDate
LanguageForEdit Language
CostCtrActivityTypeName CostCtrActivityTypeName
CostCtrActivityTypeDesc CostCtrActivityTypeDesc
ValidityStartDate ValidityStartDate
LanguageISOCode _Language LanguageISOCode
LanguageName
CostCtrActyTypeTxtSearchTerm CostCtrActyTypeTxtSearchTerm
UxFcCostCtrActivityTypeDesc
_CostCenterActivityTypeTP _CostCenterActivityTypeTP
_ControllingArea _ControllingArea
_Language _Language 
@AbapCatalog.sqlViewName: 'ICCACTTYPTXTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL

// Draft Related Annotations

@ObjectModel.writeDraftPersistence: 'CSLT_DRAFT'
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.semanticKey: [ 'Language', 'ControllingArea', 'CostCtrActivityType', 'ValidityEndDate' ]

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

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Languages'

define view I_CostCenterActivityTypeTextTP
  as select from I_CostCenterActivityTypeText

  association [1..1] to I_CostCenterActivityTypeTP as _CostCenterActivityTypeTP on  $projection.ControllingArea     = _CostCenterActivityTypeTP.ControllingArea
                                                                                and $projection.CostCtrActivityType = _CostCenterActivityTypeTP.CostCtrActivityType
                                                                                and $projection.ValidityEndDate     = _CostCenterActivityTypeTP.ValidityEndDate

{
  key Language,

  key ControllingArea,

  key CostCtrActivityType,
      @Semantics.businessDate.to: true
  key ValidityEndDate,
  
      @ObjectModel.editableFieldFor: 'Language'
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Language as LanguageForEdit,

      @Semantics.text:true
      CostCtrActivityTypeName,

      CostCtrActivityTypeDesc,

      @Semantics.businessDate.from: true
      ValidityStartDate,

      @ObjectModel.readOnly: true
      _Language.LanguageISOCode,

      @ObjectModel.readOnly: true
      _Language._Text[1:Language=$session.system_language].LanguageName,

      CostCtrActyTypeTxtSearchTerm,
      
      @ObjectModel.readOnly: true
      cast ( '' as fco_long_text_indicator ) as UxFcCostCtrActivityTypeDesc,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _CostCenterActivityTypeTP,
      _ControllingArea,
      _Language

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

Learn More