I_GenericPriorityText

DDL: I_GENERICPRIORITYTEXT Type: view BASIC

Generic Priority - Text

I_GenericPriorityText is a Basic CDS View that provides data about "Generic Priority - Text" in SAP S/4HANA. It reads from 1 data source (t356_t) and exposes 7 fields with key fields Language, GenericPriorityType, PriorityCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t356_t t356_t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_GenericPriority _GenericPriority _GenericPriority.GenericPriorityType = $projection.GenericPriorityType and _GenericPriority.PriorityCode = $projection.PriorityCode
[0..1] I_GenericPriorityType _GenericPriorityType _GenericPriorityType.GenericPriorityType = $projection.GenericPriorityType
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (15)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IGENPRIOTEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Generic Priority - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey PriorityCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language t356_t spras
KEY GenericPriorityType t356_t artpr
KEY PriorityCode t356_t priok
GenericPriorityDesc t356_t priokx
_GenericPriority _GenericPriority
_GenericPriorityType _GenericPriorityType
_Language _Language
@AbapCatalog: { preserveKey: true, compiler.compareFilter: true, sqlViewName: 'IGENPRIOTEXT' }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Generic Priority - Text'

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API }

@ObjectModel: {
  dataCategory: #TEXT,
  representativeKey: 'PriorityCode',
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S },
    supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_ASSOCIATION_TARGET],
    modelingPattern: #LANGUAGE_DEPENDENT_TEXT
     }
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations

define view I_GenericPriorityText
  as select from t356_t
  association [0..1] to I_GenericPriority     as _GenericPriority     on  _GenericPriority.GenericPriorityType = $projection.GenericPriorityType
                                                                      and _GenericPriority.PriorityCode        = $projection.PriorityCode

  association [0..1] to I_GenericPriorityType as _GenericPriorityType on  _GenericPriorityType.GenericPriorityType = $projection.GenericPriorityType

  association [0..1] to I_Language            as _Language            on  _Language.Language = $projection.Language
{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key t356_t.spras  as Language,

      @ObjectModel.foreignKey.association: '_GenericPriorityType'
  key t356_t.artpr  as GenericPriorityType,

      @ObjectModel.foreignKey.association: '_GenericPriority'
      @ObjectModel.text.element: ['GenericPriorityDesc']
  key t356_t.priok  as PriorityCode,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 } 
      t356_t.priokx as GenericPriorityDesc,
             
      // Propagate association(s)

      _GenericPriority,
      _GenericPriorityType,
      _Language
}