I_BusinessProcessText

DDL: I_BUSINESSPROCESSTEXT SQL: IFIBUSPROCESST Type: view BASIC

Business Process - Text

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

Data Sources (1)

SourceAliasJoin Type
cbpt cbpt from

Associations (3)

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

Annotations (14)

NameValueLevelField
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey BusinessProcess view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Business Process - Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIBUSPROCESST view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea
KEY BusinessProcess cbpt prznr
KEY Language cbpt spras
KEY ValidityEndDate cbpt datbi
BusinessProcessName cbpt ktext
BusinessProcessDescription cbpt ltext
ValidityStartDate cbpr datab
_Language _Language
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText
@ObjectModel.dataCategory: #TEXT //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'BusinessProcess'
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #M
}
@Search.searchable: true
@Consumption.ranked: true
@EndUserText.label: 'Business Process - Text'
@Analytics: { dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFIBUSPROCESST'
@AccessControl.authorizationCheck: #CHECK //NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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

@ObjectModel.supportedCapabilities:[#EXTRACTION_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET]
@Metadata.ignorePropagatedAnnotations:true
define view I_BusinessProcessText
  as select from cbpt

    left outer to one join   cbpr on  cbpt.kokrs = cbpr.kokrs
                                  and cbpt.prznr = cbpr.prznr
                                  and cbpt.datbi = cbpr.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
{
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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

      @ObjectModel.foreignKey.association: '_ControllingArea'
  key cast( cbpt.kokrs as fis_kokrs ) as ControllingArea,
  key cbpt.prznr                      as BusinessProcess,
      @Semantics.language
      @ObjectModel.foreignKey.association: '_Language' //Inserted by VDM CDS Suite Plugin

  key cbpt.spras                      as Language,
      @Semantics.businessDate.to: true
  key cbpt.datbi                      as ValidityEndDate,
      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      cbpt.ktext                      as BusinessProcessName,
      @Semantics.text
      cbpt.ltext                      as BusinessProcessDescription,
      @Semantics.businessDate.from: true
      cbpr.datab                      as ValidityStartDate,
      _Language,
      _ControllingArea,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

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



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