I_ExtProdGrpText

DDL: I_EXTPRODGRPTEXT Type: view BASIC

External Product Group - Text

I_ExtProdGrpText is a Basic CDS View that provides data about "External Product Group - Text" in SAP S/4HANA. It reads from 1 data source (twewt) and exposes 5 fields with key fields ExternalProductGroup, Language. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
twewt twewt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ExtProdGrp _ExternalProductGroup $projection.ExternalProductGroup = _ExternalProductGroup.ExternalProductGroup
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IEXTPRODGRPTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label External Product Group - Text view
ObjectModel.representativeKey ExternalProductGroup view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ExternalProductGroup
KEY Language spras
ExternalProductGroupName
_ExternalProductGroup _ExternalProductGroup
_Language _Language 
@AbapCatalog: {
  sqlViewName: 'IEXTPRODGRPTXT',
  compiler.compareFilter: true,
  preserveKey: true
}

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'External Product Group - Text'
@ObjectModel:{
  representativeKey: 'ExternalProductGroup',
  usageType:{
    serviceQuality: #A,
    sizeCategory : #S,
    dataClass: #MASTER
  },
  dataCategory: #TEXT,
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET,
                           #SEARCHABLE_ENTITY,
                           #LANGUAGE_DEPENDENT_TEXT,
                           #EXTRACTION_DATA_SOURCE
  ]
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations:true
@Analytics:{
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
    }
}
define view I_ExtProdGrpText
  as select from twewt
  association [1..1] to I_ExtProdGrp as _ExternalProductGroup on $projection.ExternalProductGroup = _ExternalProductGroup.ExternalProductGroup
  association [1..1] to I_Language   as _Language             on $projection.Language = _Language.Language
{

      @ObjectModel.foreignKey.association: '_ExternalProductGroup'
  key cast(extwg as externalproductgroup preserving type )     as ExternalProductGroup,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key spras                                                    as Language,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text: true
      cast(ewbez as externalproductgroupname preserving type ) as ExternalProductGroupName,

      _ExternalProductGroup,
      _Language

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TWEWT"
],
"ASSOCIATED":
[
"I_EXTPRODGRP",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More