I_ChgAlertOpActy

DDL: I_CHGALERTOPACTY SQL: ICAOPACTY Type: view BASIC

Operation Activity - Change Alert

I_ChgAlertOpActy is a Basic CDS View that provides data about "Operation Activity - Change Alert" in SAP S/4HANA. It reads from 1 data source (I_OperationActivity) and exposes 12 fields with key fields OperationActivity, OperationActyVersionCounter. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationActivity I_OperationActivity from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OperationActivityText _Text $projection.OperationActivity = _Text.OperationActivity and $projection.OperationActyVersionCounter = _Text.OperationActyVersionCounter and _Text.Language = $session.system_language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICAOPACTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Operation Activity - Change Alert view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity OperationActivity
KEY OperationActyVersionCounter OperationActyVersionCounter
OperationActivityName _Text OperationActivityName
OperationActStsAndActnSchema OperationActStsAndActnSchema
SFIStatusAndActionSchema SFIStatusAndActionSchema
IsReleased IsReleased
OriginalChgAlertCount OriginalChgAlertCount
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
ChangedBy ChangedBy
LastChangeDateTime LastChangeDateTime
_Text _Text 
@AbapCatalog.sqlViewName: 'ICAOPACTY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Operation Activity - Change Alert'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:   #M,
  dataClass:      #MASTER
}
define view I_ChgAlertOpActy as select from I_OperationActivity 
 -- Operation Activity Text
  association [0..1] to I_OperationActivityText       as _Text                        on  $projection.OperationActivity           = _Text.OperationActivity
                                                                                      and $projection.OperationActyVersionCounter = _Text.OperationActyVersionCounter
                                                                                      and _Text.Language = $session.system_language
{  

  key OperationActivity,
  key OperationActyVersionCounter,
      _Text.OperationActivityName,
      OperationActStsAndActnSchema,
      SFIStatusAndActionSchema,
      IsReleased,
      OriginalChgAlertCount,
      @Semantics.user.createdBy: true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      ChangedBy,
      LastChangeDateTime,
      _Text  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONACTIVITY",
"I_OPERATIONACTIVITYTEXT"
],
"ASSOCIATED":
[
"I_OPERATIONACTIVITYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More