I_ProfitCenterText

DDL: I_PROFITCENTERTEXT SQL: IFIPROFITCENTERT Type: view BASIC

Profit Center - Text

I_ProfitCenterText is a Basic CDS View that provides data about "Profit Center - Text" in SAP S/4HANA. It reads from 1 data source (cepct) and exposes 10 fields with key fields Language, ControllingArea, ProfitCenter, ValidityEndDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
cepct cepct from

Associations (3)

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

Annotations (17)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language cepct spras
KEY ControllingArea cepct kokrs
KEY ProfitCenter cepct prctr
KEY ValidityEndDate cepct datbi
ValidityStartDate datab
ProfitCenterName
ProfitCenterLongName
_ControllingArea _ControllingArea
_Language _Language
_ControllingAreaText _ControllingAreaText
@EndUserText.label: 'Profit Center - Text'
@Analytics:{
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
        automatic: true
        }
    }
}
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFIPROFITCENTERT'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK //NOT_REQUIRED

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ProfitCenter'
@ClientHandling.algorithm: #SESSION_VARIABLE

@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
}

@Metadata.ignorePropagatedAnnotations: true

@Search.searchable: true
//--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

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

@Consumption.filter.businessDate.at: true

define view I_ProfitCenterText
  as select from cepct
    left outer to one join   cepc as _md on  cepct.prctr = _md.prctr
                             and cepct.kokrs = _md.kokrs
                             and cepct.datbi = _md.datbi


  //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

  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 [0..1] to I_ControllingArea as _ControllingArea     on $projection.ControllingArea = _ControllingArea.ControllingArea

{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cepct.spras                                         as Language,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

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

      @ObjectModel.foreignKey.association: '_ControllingArea'
  key cepct.kokrs                                         as ControllingArea,
      @ObjectModel.text.element: ['ProfitCenterLongName', 'ProfitCenterName']
  key cepct.prctr                                         as ProfitCenter,
      @Semantics.businessDate.to: true
  key cepct.datbi                                         as ValidityEndDate,

      @Semantics.businessDate.from: true
      datab                                               as ValidityStartDate,

      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      cast (ktext as fis_prctr_shorttext preserving type) as ProfitCenterName,
      @Semantics.text: true
      cast (ltext as fac_prctr_ltext preserving type )    as ProfitCenterLongName,

      _ControllingArea,
      _Language,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

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


};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CEPC",
"CEPCT"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/