I_GenericPriority

DDL: I_GENERICPRIORITY Type: view BASIC

Generic Priority

I_GenericPriority is a Basic CDS View that provides data about "Generic Priority" in SAP S/4HANA. It reads from 1 data source (t356) and exposes 14 fields with key fields GenericPriorityType, PriorityCode. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t356 t356 from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_GenericPriorityType _GenericPriorityType _GenericPriorityType.GenericPriorityType = $projection.GenericPriorityType
[0..*] I_GenericPriorityText _GenericPriorityText _GenericPriorityText.PriorityCode = $projection.PriorityCode and _GenericPriorityText.GenericPriorityType = $projection.GenericPriorityType
[0..1] I_UnitOfMeasure _GenericStrtDateShiftFctrUnit _GenericStrtDateShiftFctrUnit.UnitOfMeasure = $projection.GenericStrtDateShiftFactorUnit
[0..1] I_UnitOfMeasure _GenericEndDateShiftFactorUnit _GenericEndDateShiftFactorUnit.UnitOfMeasure = $projection.GenericEndDateShiftFactorUnit
[0..1] I_UnitOfMeasure _LtstAcceptableCompltnDteUoM _LtstAcceptableCompltnDteUoM.UnitOfMeasure = $projection.LtstAcceptableCompltnDteUoM

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IGENERICPRIORITY view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Generic Priority view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey PriorityCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY GenericPriorityType t356 artpr
KEY PriorityCode t356 priok
GenericStartDateShiftFactor t356 tagbn
GenericStrtDateShiftFactorUnit t356 ehtbg
GenericEndDateShiftFactor t356 tagen
GenericEndDateShiftFactorUnit t356 ehten
GenericPriorityColorCode t356 priocc
LtstAcceptableCompltnDteFactor t356 lacd_unit
LtstAcceptableCompltnDteUoM t356 lacd_uom
_GenericPriorityType _GenericPriorityType
_GenericPriorityText _GenericPriorityText
_GenericStrtDateShiftFctrUnit _GenericStrtDateShiftFctrUnit
_GenericEndDateShiftFactorUnit _GenericEndDateShiftFactorUnit
_LtstAcceptableCompltnDteUoM _LtstAcceptableCompltnDteUoM
@AbapCatalog: { compiler.compareFilter: true, sqlViewName: 'IGENERICPRIORITY' }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Generic Priority'

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

@ObjectModel: {
  representativeKey: 'PriorityCode',
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S } }

@Metadata.ignorePropagatedAnnotations
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]

define view I_GenericPriority
  as select from t356
  association [0..1] to I_GenericPriorityType as _GenericPriorityType           on  _GenericPriorityType.GenericPriorityType = $projection.GenericPriorityType

  association [0..*] to I_GenericPriorityText as _GenericPriorityText           on  _GenericPriorityText.PriorityCode        = $projection.PriorityCode
                                                                                and _GenericPriorityText.GenericPriorityType = $projection.GenericPriorityType

  association [0..1] to I_UnitOfMeasure       as _GenericStrtDateShiftFctrUnit  on  _GenericStrtDateShiftFctrUnit.UnitOfMeasure = $projection.GenericStrtDateShiftFactorUnit

  association [0..1] to I_UnitOfMeasure       as _GenericEndDateShiftFactorUnit on  _GenericEndDateShiftFactorUnit.UnitOfMeasure = $projection.GenericEndDateShiftFactorUnit
  
  association [0..1] to I_UnitOfMeasure       as _LtstAcceptableCompltnDteUoM   on  _LtstAcceptableCompltnDteUoM.UnitOfMeasure = $projection.LtstAcceptableCompltnDteUoM
{
      @ObjectModel.foreignKey.association: '_GenericPriorityType'
  key t356.artpr  as GenericPriorityType,

      @ObjectModel.text.association: '_GenericPriorityText'
  key t356.priok  as PriorityCode,

      t356.tagbn  as GenericStartDateShiftFactor,

      @ObjectModel.foreignKey.association: '_GenericStrtDateShiftFctrUnit'
      t356.ehtbg  as GenericStrtDateShiftFactorUnit,

      t356.tagen  as GenericEndDateShiftFactor,

      @ObjectModel.foreignKey.association: '_GenericEndDateShiftFactorUnit'
      t356.ehten  as GenericEndDateShiftFactorUnit,

      t356.priocc as GenericPriorityColorCode,
      
      t356.lacd_unit as LtstAcceptableCompltnDteFactor,
      
      @ObjectModel.foreignKey.association: '_LtstAcceptableCompltnDteUoM'
      t356.lacd_uom as LtstAcceptableCompltnDteUoM, 

      // Associations

      _GenericPriorityType,
      _GenericPriorityText,
      _GenericStrtDateShiftFctrUnit,
      _GenericEndDateShiftFactorUnit,
      _LtstAcceptableCompltnDteUoM
}