I_CostCenterActivityTypeText

DDL: I_COSTCENTERACTIVITYTYPETEXT SQL: IFICCACTTYPT Type: view BASIC

Cost Center Activity Type - Text

I_CostCenterActivityTypeText is a Basic CDS View that provides data about "Cost Center Activity Type - Text" in SAP S/4HANA. It reads from 1 data source (cslt) and exposes 11 fields with key fields ValidityEndDate, ControllingArea, CostCtrActivityType, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
cslt cslt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea
[0..1] I_Language _Language $projection.Language = _Language.Language association[1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (16)

NameValueLevelField
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CostCtrActivityType view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Cost Center Activity Type - Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICCACTTYPT view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ValidityEndDate cslt datbi
KEY ControllingArea
KEY CostCtrActivityType cslt lstar
KEY Language spras
CostCtrActivityTypeName
CostCtrActivityTypeDesc
ValidityStartDate datab
CostCtrActyTypeTxtSearchTerm mctxt
_Language _Language
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'CostCtrActivityType'

@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ]

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #M
}
@EndUserText.label: 'Cost Center Activity Type - Text'
@Analytics: { dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFICCACTTYPT'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK //NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true

@Metadata.ignorePropagatedAnnotations: true

//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

@AccessControl.privilegedAssociations: ['_ControllingAreaText']
// ]--GENERATED

@Consumption.filter.businessDate.at: true

define view I_CostCenterActivityTypeText as select from cslt 
  left outer to one join csla as _md on cslt.lstar = _md.lstar and
                                        cslt.kokrs = _md.kokrs and
                                        cslt.datbi = _md.datbi
  //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

  association [0..1] to I_ControllingArea      as _ControllingAreaText on   $projection.ControllingArea = _ControllingAreaText.ControllingArea
  // ]--GENERATED

  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association[1]      to I_ControllingArea    as _ControllingArea on  $projection.ControllingArea     = _ControllingArea.ControllingArea
{
  @Semantics.businessDate.to: true
  key cslt.datbi as ValidityEndDate,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]
      @ObjectModel.text.association: '_ControllingAreaText'
      // ]--GENERATED

  @ObjectModel.foreignKey.association: '_ControllingArea' 
  key cast( cslt.kokrs as fis_kokrs preserving type ) as ControllingArea,
  key cslt.lstar as CostCtrActivityType,
  @Semantics.language
  @ObjectModel.foreignKey.association: '_Language' //Inserted by VDM CDS Suite Plugin

  key spras as Language,
  
  cast( ktext as fis_costctractivitytypename preserving type ) as CostCtrActivityTypeName,

  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #LOW
  @Semantics.text:true 
  cast( ltext as fis_costctractivitytypedesc preserving type ) as CostCtrActivityTypeDesc,
 
  @Semantics.businessDate.from: true
  datab as ValidityStartDate,

  mctxt as CostCtrActyTypeTxtSearchTerm,
  
  _Language,
  _ControllingArea,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.hidden: true
      _ControllingAreaText
      // ]--GENERATED



};